Hi all,
I'm new here, so please be gentle :-)
I'm trying to use Virtuoso to publish some RDF files. I'm studying the
tool. I'm trying to follow some Virtuoso guides/tutorials, and so I need
to install ODF framework. But the installation fails, with the attached log.
I've saw in the mailing list archive other user having the same problem
recently. I'm showing my log file, and also sharing my installation
procedure, because I may have missed something in the installation.
Install Virtuoso:
git clone git://github.com/openlink/virtuoso-opensource.git
cd virtuoso-opensource/
./autogen.sh
./configure
make
sudo make install
Run Virtuoso:
cd /usr/local/virtuoso-opensource/var/lib/virtuoso/db
sudo ../../../../bin/virtuoso-t -f
Connect to Virtuoso DB (command line): ok!
/usr/local/virtuoso-opensource/bin/isql 1111 dba dba
SQL> select * from DB.DBA.SYS_USERS;
SQL> EXIT;
Connect to Virtuoso (web): ok!
http://localhost:8890/
Reported version:
Version: 07.10.3211
Build: Oct 18 2014
Check if ODF Framework is suitable to install:
(cd /usr/local/virtuoso-opensource/var/lib/virtuoso/db)
sudo wget
http://s3.amazonaws.com/opldownload/uda/vad-vos-packages/7.1/ods_framework_dav.vad
/usr/local/virtuoso-opensource/bin/isql 1111 dba dba
SQL>
DB.DBA.VAD_CHECK('/usr/local/virtuoso-opensource/var/lib/virtuoso/db/ods_framework_dav.vad');
*** Error 42VAD: [Virtuoso Driver][Virtuoso Server]The package
"/usr/local/virtuoso-opensource/var/lib/virtuoso/db/ods_framework_dav.vad"
has incorrect name or version
at line 1 of Top-Level:
DB.DBA.VAD_CHECK('/usr/local/virtuoso-opensource/var/lib/virtuoso/db/ods_framework_dav.vad')
SQL>
Install ODF Framework; (ignoring the previous error of VAD_CHECK)
SQL>
VAD_INSTALL('/usr/local/virtuoso-opensource/var/lib/virtuoso/db/ods_framework_dav.vad',0)
Error log attached.
The fist error is seems related to missing table sn_person.
I would appreciate help with:
i) What I should install before ODS framework?
ii) Why VAD_CHECK is failing? Is there any problem with the VAD package
itself?
Thanks in advance,
J. Gustavo
--
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor
"I would love to change the world, but they won't give me the source
code" -- Unknown Geek
Sat Oct 18 2014
18:39:08 { Loading plugin 1: Type `plain', file `wikiv' in `/usr/local/virtuoso-opensource/lib/virtuoso/hosting'
18:39:08 FAILED plugin 1: Unable to locate file }
18:39:08 { Loading plugin 2: Type `plain', file `mediawiki' in `/usr/local/virtuoso-opensource/lib/virtuoso/hosting'
18:39:08 FAILED plugin 2: Unable to locate file }
18:39:08 { Loading plugin 3: Type `plain', file `creolewiki' in `/usr/local/virtuoso-opensource/lib/virtuoso/hosting'
18:39:08 FAILED plugin 3: Unable to locate file }
18:39:08 { Loading plugin 4: Type `plain', file `im' in `/usr/local/virtuoso-opensource/lib/virtuoso/hosting'
18:39:08 IM version 0.6 from OpenLink Software
18:39:08 Support functions for Image Magick 6.6.9
18:39:08 SUCCESS plugin 4: loaded from /usr/local/virtuoso-opensource/lib/virtuoso/hosting/im.so }
18:39:08 OpenLink Virtuoso Universal Server
18:39:08 Version 07.10.3211-pthreads for Linux as of Oct 18 2014
18:39:08 uses parts of OpenSSL, PCRE, Html Tidy
18:39:09 SQL Optimizer enabled (max 1000 layouts)
18:39:09 Compiler unit is timed at 0.000901 msec
18:39:12 built-in procedure "repl_undot_name" overruled by the RDBMS
18:39:15 Checkpoint started
18:39:15 Roll forward started
18:39:15 Roll forward complete
18:39:15 Checkpoint started
18:39:15 Checkpoint finished, log reused
18:39:15 Checkpoint started
18:39:15 Checkpoint finished, log reused
18:39:16 Checkpoint started
18:39:16 Checkpoint finished, log reused
18:39:17 Checkpoint started
18:39:17 Checkpoint finished, log reused
18:39:17 Checkpoint started
18:39:17 Checkpoint finished, log reused
18:39:17 PL LOG: Installing Virtuoso Conductor version 1.00.8738 (DAV)
18:39:17 Checkpoint started
18:39:17 Checkpoint finished, log reused
18:39:21 Checkpoint started
18:39:21 Checkpoint finished, log reused
18:39:21 Checkpoint started
18:39:21 Checkpoint finished, log reused
18:39:22 HTTP/WebDAV server online at 8890
18:39:22 Server online at 1111 (pid 30238)
18:56:26 Checkpoint started
18:56:26 Checkpoint finished, log reused
18:56:31 PL LOG: SQ200: No table sn_person
while executing the following statement:
--no_c_escapes-
create procedure wa_sn_user_ent_set ()
{
if (registry_get ('__wa_sn_user_ent_set_done') = 'done_2')
return;
18:56:31 PL LOG: SR185: Undefined procedure DB.DBA.wa_sn_user_ent_set.
while executing the following statement:
--no_c_escapes-
wa_sn_user_ent_set ()
in file:
/DAV/VAD/wa/sn.sql
18:56:31 PL LOG: SQ200: No table sn_person
while executing the following statement:
--no_c_escapes-
create procedure wa_sn_user_ent_set ()
{
if (registry_get ('__wa_sn_user_ent_set_done2') = 'done_3')
return;
18:56:31 PL LOG: SR185: Undefined procedure DB.DBA.wa_sn_user_ent_set.
while executing the following statement:
--no_c_escapes-
wa_sn_user_ent_set ()
in file:
/DAV/VAD/wa/sn.sql
18:56:35 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
create procedure invitationsGet (in sid varchar:='',in realm varchar :='wa', in extraFields varchar :='') __S
18:56:35 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
create procedure connectionsGet (in sid varchar:='',in realm varchar :='wa', in userId any := null, in extraF
18:56:35 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
create procedure connectionSet (in sid varchar:='',in realm varchar :='wa', in connectionId integer, in actio
18:56:35 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
create procedure connections_get(in sneID integer)
{
declare res any;
res:=vector();
for select top 10
18:56:35 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
create procedure invitations_get(in userName varchar)
{
declare res any;
res:=vector();
declare sne_ma
18:56:35 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
create procedure invited_get(in user_identity any)
{
declare res any;
res:=vector();
declare _sneid in
18:56:35 PL LOG: SQ096: No table sn_person.
while executing the following statement:
--no_c_escapes-
create procedure ODS_CREATE_USER (
in _username varchar,
in _passwd varchar,
in _email varchar,
in _host va
18:56:35 PL LOG: SQ111: No table DB.DBA.sn_person.
while executing the following statement:
--no_c_escapes-
-- This procedure is called inside trigger SYS_USERS_ON_DELETE_WA_FK on SYS_USERS;
create procedure ODS_DELE
18:56:36 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
-- Social Network activity
--!
-- \brief Invite someone to join the user's social network.
--
-- ODS allows
18:56:36 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
--!
-- \brief Approve an invitation from another user.
--
-- ODS allows users to be connected in a social net
18:56:36 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
--!
-- \brief Delete a connection to another user.
--
-- ODS allows users to be connected in a social network
18:56:37 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
create view SIOC_KNOWS as
select f.sne_name as FROM_NAME, t.sne_name as TO_NAME from DB.DBA.sn_related, DB.D
18:56:37 PL LOG: SR136: Bad table name in GRANT / REVOKE SIOC_KNOWS.
while executing the following statement:
--no_c_escapes-
grant select on SIOC_KNOWS to SPARQL_SELECT
in file:
/DAV/VAD/wa/sql_rdf.sql
18:56:37 PL LOG: SQ200: No table DB.DBA.sn_person
while executing the following statement:
--no_c_escapes-
create procedure people (in uid varchar, in friends varchar := null) __SOAP_HTTP 'application/atom+xml'
{
d
18:56:37 PL LOG: Errors where detected during installation of "ODS Framework".
18:56:37 PL LOG: The installation of this VAD package has failed.
18:56:37 PL LOG: Please delete the transaction file
18:56:37 PL LOG: /usr/local/virtuoso-opensource/var/lib/virtuoso/db//usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.trx
18:56:37 PL LOG: and then restart your database server.
18:56:37 PL LOG: Note: Your database will be in its pre VAD installation
18:56:37 PL LOG: state after you restart.
18:56:40 Server shutdown complete
Sat Oct 18 2014
19:08:34 { Loading plugin 1: Type `plain', file `wikiv' in `/usr/local/virtuoso-opensource/lib/virtuoso/hosting'
19:08:34 FAILED plugin 1: Unable to locate file }
19:08:34 { Loading plugin 2: Type `plain', file `mediawiki' in `/usr/local/virtuoso-opensource/lib/virtuoso/hosting'
19:08:34 FAILED plugin 2: Unable to locate file }
19:08:34 { Loading plugin 3: Type `plain', file `creolewiki' in `/usr/local/virtuoso-opensource/lib/virtuoso/hosting'
19:08:34 FAILED plugin 3: Unable to locate file }
19:08:34 { Loading plugin 4: Type `plain', file `im' in `/usr/local/virtuoso-opensource/lib/virtuoso/hosting'
19:08:34 IM version 0.6 from OpenLink Software
19:08:34 Support functions for Image Magick 6.6.9
19:08:34 SUCCESS plugin 4: loaded from /usr/local/virtuoso-opensource/lib/virtuoso/hosting/im.so }
19:08:34 OpenLink Virtuoso Universal Server
19:08:34 Version 07.10.3211-pthreads for Linux as of Oct 18 2014
19:08:34 uses parts of OpenSSL, PCRE, Html Tidy
19:08:35 Database version 3126
19:08:35 SQL Optimizer enabled (max 1000 layouts)
19:08:36 Compiler unit is timed at 0.000267 msec
19:08:37 built-in procedure "repl_undot_name" overruled by the RDBMS
19:08:37 Roll forward started
19:08:38 Key without parts WA_USER_RELATED_RES_IX1.
19:08:38 Key without parts WA_USER_RELATED_RES.
19:08:38 SQL Error: 42000 : SR146: No user with id 110
19:08:38 SQL Error: 42000 : SR146: No user with id 110
19:08:38 SQL Error: 42000 : SR146: No user with id 113
19:08:38 SQL Error: 42000 : SR146: No user with id 113
19:08:38 212 transactions, 258909 bytes replayed (100 %)
19:08:38 Roll forward complete
19:08:39 Checkpoint started
19:08:39 Checkpoint finished, log reused
19:08:39 HTTP/WebDAV server online at 8890
19:08:39 Server online at 1111 (pid 30712)
19:14:49 Server received signal 2
19:14:49 Initiating normal shutdown
19:14:49 Checkpoint started
19:14:49 Checkpoint finished, log reused
19:14:49 Server shutdown complete
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
