Hi Hugh,
My computer reports Windows XP Professional Version 2002 Service
Pack 3.
To clarify, the strange thing about my situation is that I had
installed the service following the steps listed in the Virtuoso
wiki and it was starting correctly before. Because of the database
corruption I experienced I attempted a fresh reinstall out of the
Virtuoso Windows zip file.
The steps I followed (I tried these steps multiple times in
slightly different order trying to figure out my own problem):
1) Unregistered the service using the line:
virtuoso-t +service delete +instance "virt1"
2) Removed the Virtuoso System DSN entry from the ODBC driver.
3) Unregistered the virtuoso ODBC driver
regsvr32 /u
virtodbc.dll
4) Renamed the previous virtuoso home folder.
5) Copied into a folder with the same name the contents of the
Virtuoso zip file.
6) Register the new service from the database directory:
virtuoso-t +service create +instance "virt2"
7) Check that it is listed.
virtuoso-t +service list
8) Start the service
virtuoso-t -I "virt2" +service start
(the virt2 service is started)
9) List the service to confirm that it is running (but it reports
the service is stopped)
virt2 stopped
From: Hugh Williams <hwilli...@openlinksw.com>
To: Marco Ocana <marco.oc...@balboasystems.com>
Cc: Ted Thibodeau Jr <tthibod...@openlinksw.com>; virtuoso-
us...@lists.sourceforge.net
Sent: Saturday, April 11, 2009 6:48:07 AM
Subject: Re: [Virtuoso-users] Cannot reinstall Virtuoso on Windows
Hi Macro,
What Windows OS ( XP, Vista, Server etc) are you using and what
user are you performing this operation as ? I have tested on a
Windows 2003 Server just now (XP, Vista, Windows 2000 in the past)
and service registration and start works fine for me:
C:\Hugh\vos\virtuoso-opensource-5.10\database>set VIRTUOSO_HOME=C:
\Hugh\vos\virt
uoso-opensource-5.10
C:\Hugh\vos\virtuoso-opensource-5.10\database>cd %VIRTUOSO_HOME%
C:\Hugh\vos\virtuoso-opensource-5.10>cd %VIRTUOSO_HOME%\database
C:\Hugh\vos\virtuoso-opensource-5.10\database>SET PATH=%PATH%;%
VIRTUOSO_HOME%\bi
n;%VIRTUOSO_HOME%\lib
C:\Hugh\vos\virtuoso-opensource-5.10\database>virtuoso-t -?
Virtuoso Open Source Edition (multi threaded)
Version 5.0.10.3037-threads as of Feb 13 2009
Compiled for 32 Bit Windows Operating Environments
Copyright (C) 1999-2009 OpenLink Software
.
.
.
C:\Hugh\vos\virtuoso-opensource-5.10\database>virtuoso-t +service
screate +instance "VOS5_10" +configfile virtuoso.ini
[Using virtuoso.ini in C:\Hugh\vos\virtuoso-opensource-5.10\database]
The Virtuoso_VOS5_10 service has been registered
and is associated with the executable c:\hugh\vos\virtuoso-
opensource-5.10\bin
\virtuoso-t.exe
C:\Hugh\vos\virtuoso-opensource-5.10\database>virtuoso-t +service list
VOS5_10 Stopped
C:\Hugh\vos\virtuoso-opensource-5.10\database>virtuoso-t -I
"VOS5_10" +service start
The Virtuoso_VOS5_10 service is being started
C:\Hugh\vos\virtuoso-opensource-5.10\database>virtuoso-t +service list
VOS5_10 Starting
C:\Hugh\vos\virtuoso-opensource-5.10\database>virtuoso-t +service list
VOS5_10 Running
C:\Hugh\vos\virtuoso-opensource-5.10\database>..\bin\isql 1114
Connected to OpenLink Virtuoso
Driver: 05.09.3037 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> tables;
Showing SQLTables of tables like 'NULL.NULL.NULL', tabletype/
colname like 'NULL'
TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE
REMARKS
VARCHAR VARCHAR VARCHAR VARCHAR
VARCHAR
______________________________________________________________________
_________
DB DBA ADMIN_SESSION SYSTEM TABLE
NULL
DB DBA ADM_OPT_ARRAY_TO_RS_PVIEW SYSTEM
TABLE NU
LL
DB DBA ADM_XML_VIEWS SYSTEM TABLE
NULL
DB DBA ALL_COL_HIST SYSTEM TABLE
NULL
.
.
.
When you start your server from command line the output below shows
it starts successfully, so the issue must be with your service
registration.
If you edit the service you created in the services control manager
what is the "Path to executable" setting as on my installation it is:
c:\hugh\vos\virtuoso-opensource-5.10\bin\virtuoso-t.exe -I
"Virtuoso_VOS5_10" -c "C:\Hugh\vos\virtuoso-opensource-5.10\database
\virtuoso.ini"
What does the services control manager report when you attempt to
start your service with it as opposed to using our command line
options ?
Does the Windows system event log report any reason for the service
failing to start ?
Can you provide a copy of your virtuoso.log file ?
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 11 Apr 2009, at 02:27, Marco Ocana wrote:
Hi Ted,
Thanks for your help.
It looks like the key argument for me is the -f or +foreground. If
I include it in the command line, Virtuoso will start and write
out some nice logging info to the console. If I don't include it,
the command line says the service is being started, but when you
list it or look at the list of processes, it is not running.
So the question then becomes: what would I have to do to run
virtuoso as a service in Windows?
Below are the commands I typed in the command window, in sequence,
and the responses.
Thanks
Marco
C:\javatools\virtuoso\virtuoso-opensource\database>c:\javatools
\virtuoso\virtuoso-opensource\bin\virtuoso-t.exe -I "virt1" -c "C:
\javatools\virtuoso\virtuoso-opensource\database\virtuoso.ini"
The Virtuoso_virt1 service is being started
C:\javatools\virtuoso\virtuoso-opensource\database>virtuoso-t
+service list
virt1 Stopped
C:\javatools\virtuoso\virtuoso-opensource\database>c:\javatools
\virtuoso\virtuoso-opensource\bin\virtuoso-t.exe -I "virt1" -f -c
"C:\javatools\virtuoso\virtuoso-opensource\database\virtuoso.ini"
Fri Apr 10 2009
21:16:47 [Using virtuoso.ini in C:\javatools\virtuoso\virtuoso-
opensource\databa
se]
21:16:47 { Loading plugin 1: Type `plain', file `wikiv' in `../
hosting'
21:16:47 WikiV version 0.6 from OpenLink Software
21:16:47 Support functions for WikiV collaboration tool
21:16:47 SUCCESS plugin 1: loaded from ..\hosting\wikiv.dll }
21:16:47 { Loading plugin 2: Type `plain', file `mediawiki' in `../
hosting'
21:16:47 MediaWiki version 0.1 from OpenLink Software
21:16:47 Support functions for MediaWiki collaboration tool
21:16:47 SUCCESS plugin 2: loaded from ..\hosting\mediawiki.dll }
21:16:47 { Loading plugin 3: Type `plain', file `creolewiki' in
`../hosting'
21:16:47 CreoleWiki version 0.1 from OpenLink Software
21:16:47 Support functions for CreoleWiki collaboration tool
21:16:47 SUCCESS plugin 3: loaded from ..\hosting\creolewiki.dll }
21:16:47 { Loading plugin 4: Type `plain', file `im' in `../hosting'
21:16:47 IM version 0.5 from OpenLink Software
21:16:47 Support functions for Image Magick 6.2.4
21:16:47 SUCCESS plugin 4: loaded from ..\hosting\im.dll }
21:16:47 { Loading plugin 5: Type `plain', file `wbxml2' in `../
hosting'
21:16:47 WBXML2 version 0.9 from OpenLink Software
21:16:47 Support functions for WBXML2 0.9.2 Library
21:16:47 SUCCESS plugin 5: loaded from ..\hosting\wbxml2.dll }
21:16:47 { Loading plugin 6: Type `plain', file `hslookup' in `../
hosting'
21:16:47 HSLOOKUP version 0.1 from OpenLink Software
21:16:47 Support functions for Handle System 5.3.3
21:16:47 SUCCESS plugin 6: loaded from ..\hosting\hslookup.dll }
21:16:47 { Loading plugin 7: Type `Hosting', file
`hosting_php.dll' in `../hosti
ng'
21:16:47 Hosting version 3037 from OpenLink Software
21:16:47 PHP engine version 5.2.4
21:16:47 SUCCESS plugin 7: loaded from ../hosting/hosting_php.dll }
21:16:47 OpenLink Virtuoso Universal Server
21:16:47 Version 05.09.3037-threads for Win32 as of Feb 13 2009
21:16:47 uses parts of OpenSSL, PCRE, Html Tidy
21:16:47 Database version 3016
21:16:47 SQL Optimizer enabled (max 1000 layouts)
21:16:49 Compiler unit is timed at 0.000698 msec
21:16:51 Roll forward started
21:16:51 Roll forward complete
21:16:53 Checkpoint made, log reused
21:16:53 HTTP/WebDAV server online at 8890
21:16:53 Server online at 1111 (pid 5976)
From: Ted Thibodeau Jr <tthibod...@openlinksw.com>
To: Marco Ocana <marco.oc...@balboasystems.com>
Cc: virtuoso-users@lists.sourceforge.net
Sent: Friday, April 10, 2009 3:17:42 PM
Subject: Re: [Virtuoso-users] Cannot reinstall Virtuoso on Windows
Hi, Marco --
On Apr 10, 2009, at 02:40 PM, Marco Ocana wrote:
> I have tried multiple times reinstalling Virtuoso Version
5.0.10.3037 on Windows XP 32-bit, but cannot get the service started.
> I have removed the services, unregistered the Odbc drivers and
walk through the steps described in the open source web page, but
everytime I try to start the service, it reports the status of the
instance as "stopped".
>
> Are there log files I could take a look at? The only indication
that I have found is in the windows event log. Every time there
are two entries back to back. One saying that it is starting, and
another saying it is stopping.
> Other things I checked based on googling and scouring the docs:
There is no .lck file in the directory structure for virtuoso and
all the administrative utilities where closed during setup and
startup.
>
> Any other things I should check?
First thing is to try getting a version string from the binary.
Start
a CMD window, navigate to the Virtuoso installation's \bin\
subdirectory,
and execute the command --
.\virtuoso.exe -?
This may reveal a missing library (probably just need to adjust
your PATH
or other environment variable(s).)
(Note - your Virtuoso executable may be named differently. Any/
all that
start with "virtuoso" should produce version strings.)
If that succeeds, try starting the server in +foreground mode, and
see if
any errors appear. Either of these equivalent commands may be
used --
.\virtuoso.exe +foreground
.\virtuoso.exe -f
For best results, copy the start command for the OpenLink Virtuoso
service
from the Services control panel, and add `+foreground` or `-f` to
that
string. The above short string may be used if the long command
fails.
Let us know how it goes...
Ted
--A: Yes. http://www.guckes.net/faq/
attribution.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?
Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Evangelism & Support //
mailto:tthibod...@openlinksw.com
OpenLink Software, Inc. // http://
www.openlinksw.com/
http://www.openlinksw.com/weblogs/
uda/
OpenLink Blogs http://www.openlinksw.com/weblogs/
virtuoso/
http://www.openlinksw.com/blog/
~kidehen/
Universal Data Access and Virtual Database Technology Providers
---------------------------------------------------------------------
---------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-
com_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
