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