THanks Hugh, I did mistake the ODBC DSN for "dsn". thx Dbpedia_install.sh calls "virtuoso-t -c dbpeida.ini +wait" inside and this is the first place coming up error (cannot start virtuoso). I am guessing this is a problem related to Cygwin. Cygwin may not resolve the windows environment variable. btw, i feel sorry to say i still didnot find any post about using Cygwin to install dbpedia :(
Thanks Kenny On Tue, Sep 29, 2009 at 7:03 PM, Hugh Williams <hwilli...@openlinksw.com>wrote: > 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® 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-12, 2009. Register >>> now! >>> >>> 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® 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-12, 2009. Register >> now! >> http://p.sf.net/sfu/devconf_______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> >> >> > >
