Re: [Virtuoso-users] [Dbpedia-discussion] run dbpedia on local windows machine

Tue, 29 Sep 2009 11:03:46 +0000 

Hi Kenny,
The script is probably slightly miss leading, what the usage option refers to as "dsn" is not the traditional ODBC DSN, but rather the hostname:port name for the Virtuoso server instance, so you should run the installer with something like: 

        sh dbpedia_install.sh localhost:1111 dba dba hwilli...@openlinksw.com


Their are some version of isql that do support ODBC as well which is  
probably when that term came from ...


Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support



On 28 Sep 2009, at 13:29, Kenny Guan wrote:


Hi Hugh,


I have shut done all instance service through cmd and then run the  
script in Cgywin. Still, I cannot start Virtuoso server. AND, the  
dbpedia.log file, as the dbpedia_install.sh.log indicated, cannot be  
found. here is the message from Cgywin:



$ ./dbpedia_install.sh LocalVirtuoso 1111 dba dba gz1986@...
===============================
  Install started
  Mon Sep 28 20:16:19 CST 2009
===============================
Checking for VOS setup
Starting Virtuoso server, please wait ...
Virtuoso Open Source Edition (multi threaded)
Version 5.0.11.3039-threads as of Apr 21 2009
Compiled for 32 Bit Windows Operating Environments
Copyright (C) 1999-2009 OpenLink Software

Usage:
  virtuoso-t [-fcnCbDARMKrBdSIm] [+foreground] [+configfile arg]

             [+no-checkpoint] [+checkpoint-only] [+backup-dump]  
[+crash-dump]
             [+crash-dump-data-ini arg] [+restore-crash-dump] [+mode  
arg]
             [+dumpkeys arg] [+restore-backup arg] [+backup-dirs  
arg] [+debug]

             [+pwdold arg] [+pwddba arg] [+pwddav arg] [+service arg]
             [+instance arg] [+manual]
  +foreground            run in the foreground

  +configfile            specify an alternate configuration file to  
use,

                        or a directory where virtuoso.ini can be found
  +no-checkpoint         do not checkpoint on startup

  +checkpoint-only       exit as soon as checkpoint on startup is  
complete
  +backup-dump           dump database into the transaction log,  
then exit
  +crash-dump            dump inconsistent database into the  
transaction log,

                        then exit

  +crash-dump-data-ini   specify the DB ini to use for reading the  
data to dump

  +restore-crash-dump    restore from a crash-dump

  +mode                  specify mode options for server startup  
(onbalr)
  +dumpkeys              specify key id(s) to dump on crash dump  
(default : all)


  +restore-backup        restore from online backup
$
  +debug                 allocate a debugging console
  +pwdold                Old DBA password
  +pwddba                New DBA password
  +pwddav                New DAV password
  +service               specify a service action to perform

  +instance              specify a service instance to start/stop/ 
create/delete
  +manual                when creating a service, disable automatic  
startup



The argument to the +service option can be one of the following  
options:

  start         start a service instance
  stop          stop a service instance
  create        create a service instance

  screate       create a service instance without deleting the  
existing one

  delete        delete a service instance
  list          list all service instances


To create a windows service 'MyService' using the configuration file  
c:\database

\virtuoso.ini:

  virtuoso-t +service create +instance MyService +configfile c: 
\database\virtuos

o.ini

To start this service, use 'sc start MyService' or:
  virtuoso-t +service start +instance MyService
Cannot start Virtuoso server, please consult dbpedia.log file
Started.

The function gethostbyname returned error 11001 for host  
"LocalVirtuoso".

Checking files
load_nt.sh : present
dbpedia_dav.vad : present
dbpedia_post.sql : present
dbpedia-ontology.owl : present
umbel_class_hierarchy_v071.n3 : present
umbel_abstract_concepts.n3 : present
umbel_external_ontologies_linkage.n3 : present
yago-class-hierarchy_en.nt : present
umbel_subject_concepts.n3 : present
opencyc-2008-06-10.owl : present
opencyc-2008-06-10-readable.owl : present
Installing dbpedia_dav.vad

The function gethostbyname returned error 11001 for host  
"LocalVirtuoso".

./load_nt.sh: line 2: $'\r': command not found
./load_nt.sh: line 9: $'\r': command not found
./load_nt.sh: line 28: syntax error near unexpected token `$'\r''
'/load_nt.sh: line 28: `DOSQL ()
cat: load_nt.sh.log: No such file or directory
Running post-install scripts

The function gethostbyname returned error 11001 for host  
"LocalVirtuoso".

===============================
  Install finished.
  Mon Sep 28 20:16:41 CST 2009
===============================

The function gethostbyname returned error 11001 for host  
"LocalVirtuoso".



forgive my endless bother.

thanks
Kenny



On Mon, Sep 28, 2009 at 6:09 PM, Hugh Williams <hwilli...@openlinksw.com 
> wrote:

Hi Kenny,


From your log it would appear that the Virtuoso server failed to  
start:



Checking for VOS setup
Starting Virtuoso server, please wait ...
Cannot start Virtuoso server, please consult dbpedia.log file




Thus please check the dbpedia.log to see why the server failed to  
start, resolve reason why and try again or provide the dbpedia.log  
file and we can advise on why it is failing to start and how to  
remedy it. One point of not is to ensure their are no other Virtuoso  
servers running particularly on the 1111 and 8889 port used for this  
dbpedia installation, and also that their is no dbpedia.lck file in  
the installation directory which would also cause the servers  
failure to start.



You can search the mailing list to see posts from others on using  
the dbpedia install script as indicated in the URL below:


http://sourceforge.net/search/index.php?group_id=161622&search_subject=1&search_body=1&type_of_search=mlists&all_words=dbpedia_load.tar.gz&exact_phrase=&some_word=&without_words=&ml_name[]=virtuoso-announce&ml_name[]=virtuoso-devel&ml_name[]=virtuoso-users&posted_date_start=&posted_date_end=&form_submit=Search

Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support



On 28 Sep 2009, at 09:33, Kenny Guan wrote:


thanks Hugh,

Before your reply, I only tried the command here: 
http://wikis.openlinksw.com/dataspace/owiki/wiki/VirtuosoWikiWeb/LoadingDBpediaIntoVirtuoso


and now, I know I am supposed to follow the README.text in 
http://s3.amazonaws.com/dbpedia-data/dbpedia_load.tar.gz
to run dbpedia_install.sh.


I tried and some problems came up. I think they are originally due  
to the Cygwin environment. Seems, i have to do more settings before  
I directly run dbpedia_install.sh.



Could you give some tips? or direct me to some posts about  
installation of dbpedia on Windows?



here is messages from dbpedia_install.sh.log:

===============================
  Install started
  Mon Sep 28 16:05:50 CST 2009
===============================
Checking for VOS setup
Starting Virtuoso server, please wait ...
Cannot start Virtuoso server, please consult dbpedia.log file
Started.
Checking files
load_nt.sh : present
dbpedia_dav.vad : present
dbpedia_post.sql : present
dbpedia-ontology.owl : present
umbel_class_hierarchy_v071.n3 : present
umbel_abstract_concepts.n3 : present
umbel_external_ontologies_linkage.n3 : present
yago-class-hierarchy_en.nt : present
umbel_subject_concepts.n3 : present
opencyc-2008-06-10.owl : present
opencyc-2008-06-10-readable.owl : present
Installing dbpedia_dav.vad


*** Error S2801: [OpenLink][Virtuoso ODBC Driver]CL033: Connect  
failed to LocalVirtuoso = LocalVirtuoso:1111.

at line 0 of Top-Level:

Running post-install scripts


*** Error S2801: [OpenLink][Virtuoso ODBC Driver]CL033: Connect  
failed to LocalVirtuoso = LocalVirtuoso:1111.

at line 0 of Top-Level:

===============================
  Install finished.
  Mon Sep 28 16:06:07 CST 2009
===============================


thank you
Kenny



On Sun, Sep 27, 2009 at 11:12 PM, Hugh Williams <hwilli...@openlinksw.com 
> wrote:

Hi Kenny/Zheng ???,


Firstly I would suggest you subscribe to and also post your  
questions on the Virtuoso open source mailing list as I presume you  
are using the dbpedia_install.tar.gz installation archive from  
OpenLink Software:


        http://s3.amazonaws.com/dbpedia-data/dbpedia_load.tar.gz

You can subscribe to the Virtuoso mailing list as detailed at:

        http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSMailingLists


If you search on the mailing list their you will see their are  
posts their from users who have installed on Windows using cygwin.  
Although one point of note is that you need to ensure you are  
installing on a suitably resourced machine, preferably a windows  
server variant with at least 8GB of memory, otherwise you will have  
problems loading all the data sets and running the service itself.



Can you provide the output of the following two log files which  
should give some indication as to the progress of the installation  
you have attempted:


        dbpedia_install.sh.log
        load_nt.sh.log

Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support



On 27 Sep 2009, at 10:23, Kenny Guan wrote:


Hi,


I am trying to use Virtuoso (open source edition) to host dbpedia  
data on Windows. The Virtuoso service has worked well, but I am  
wondering how to run the load_nt.sh file, which as you know is for  
dbpedia data loading.




I have tried this way: I runned the script in Cygwin and the  
running ended with no error coming up. All .nt files were first  
loading and then loaded from the console message. But the time for  
loading is not that long as someone mentioned like several hours,  
it is just several minutes. Seems something wrong, And it is true,  
when I wrote some sparql queries to verify, each query returned  
nothing. Nothing is loaded!



This is the command I used in Cygwin:


sh    load_nt.sh      localhost:1111       dba           
dba          /cygdrive/d/dbpedia/data          "<http:// 
dbpedia.org>"




I am not sure the way I used is right or not? Or, the parameters  
(graph IRI) of the command is wrong?



Thanks in advance J



Zheng

------------------------------------------------------------------------------

Come build with us! The BlackBerry&reg; Developer Conference in  
SF, CA
is the only developer event you need to attend this year.  
Jumpstart your
developing skills, take BlackBerry mobile applications to market  
and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register  
now&#33;

http://p.sf.net/sfu/devconf_______________________________________________
Dbpedia-discussion mailing list
dbpedia-discuss...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion



------------------------------------------------------------------------------

Come build with us! The BlackBerry&reg; Developer Conference in SF,  
CA
is the only developer event you need to attend this year. Jumpstart  
your
developing skills, take BlackBerry mobile applications to market  
and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register  
now&#33;

http://p.sf.net/sfu/devconf_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users



























					Reply via email to