Hi Kenny,

Yes, but what is in the dbpedia_install.log, load_nt.log and dbpedia.log file, as one or more of these should give the reason the server is not starting ?

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 29 Sep 2009, at 13:01, Kenny Guan wrote:

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&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




------------------------------------------------------------------------------
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