Re: [Hsqldb-developers] Problem Running Hsqldb as a System Daemon

[siokpeng <sio...@se...>]

Hi,
   I had successful running the hsqldb database server. But, I am facing another problem, that is, how to automatic run the hsqldb server when my linux machine is boot up? What should I added in the /etc/rc.local file?

Thanks for your help...

Regards,
Siok Peng


Blaine Simpson wrote:

>It looks like you have been trying to fix the init script yourself
>because it is hacked up.  Please repeat the test run with the exact init
>script that is in your HSQLDB distribution.
>
>
>siokpeng wrote:
>  
>
>>Hi,
>>Here is the file being generated using "Troubleshooting
>>the Init Script". Could you please help me analysis where is going wrong?
>>
>>Regards,
>>Siok Peng
>>
>>
>>
>>siokpeng wrote:
>>
>>
>>Blaine Simpson wrote:
>>    
>>
>>>Please read and follow the instructions in the section "Troubleshooting
>>>the Init Script".
>>>
>>>siokpeng wrote:
>>>  
>>>      
>>>
>>>>Hi,
>>>>  I had set the variable HSQLDB_JAR_PATH to the exact path of my hsqldb.jar (HSQLDB_JAR_PATH=$HSQLDB_HOME/lib/hsqldb.jar). But, I still encounter same problem.
>>>>My config file is like;
>>>>
>>>>	JAVA_EXECUTABLE=$JAVA_HOME/bin/java
>>>>	HSQLDB_JAR_PATH=$HSQLDB_HOME/lib/hsqldb.jar
>>>>	SERVER_HOME=/opt/hsqldb/data
>>>>	HSQLDB_OWNER=hsqldb
>>>>
>>>>Anything else did I missing?
>>>>
>>>>Thanks,
>>>>Siok Peng
>>>>  
>>>>
>>>>
>>>>Blaine Simpson wrote:
>>>>    
>>>>        
>>>>
>>>>>Correct, that the HSQLDB classes are not being found in the CLASSPATH.  
>>>>>Wrong that you set it manually in the init script.  In your config file, 
>>>>>set the variable HSQLDB_JAR_PATH to the exact path to your hsqldb.jar 
>>>>>file.  The location of the config file is explained in step 2 of the 
>>>>>UNIX chapter.
>>>>>
>>>>>
>>>>>Pankaj Mandal -X (pmandal - Ahura Inc. at Cisco) wrote:
>>>>>  
>>>>>      
>>>>>          
>>>>>
>>>>>>Hi,
>>>>>>
>>>>>>When you run it through init.d, it is not finding the CLASSPATH, you
>>>>>>would most probably need to set it in the init.d script before executing
>>>>>>the java class/database server
>>>>>>
>>>>>>Thanks
>>>>>>Pankaj 
>>>>>>
>>>>>>-----Original Message-----
>>>>>>From: hsq...@li...
>>>>>>[mailto:hsq...@li...] On Behalf Of
>>>>>>siokpeng
>>>>>>Sent: Wednesday, August 23, 2006 3:52 AM
>>>>>>To: bla...@ad...; hsq...@li...
>>>>>>Subject: [Hsqldb-developers] Problem Running Hsqldb as a System Daemon
>>>>>>
>>>>>>Hi,
>>>>>>    I just starting using hsqldb as my database server. I am using
>>>>>>hsqldb version 1.8.0 on Linux machine. I was using provided
>>>>>>documentation (http://hsqldb.org/web/hsqlDocsFrame.html) to start up my
>>>>>>database. Everything work fine. But, when I configure it to running as a
>>>>>>system daemon, it got failed on when I tried run using
>>>>>>"/etc/init.d/hsqldb start". The log file return error - "Exception in
>>>>>>thread "main" java.lang.NoClassDefFoundError: 
>>>>>>org/hsqldb/util/MainInvoker". Did anyone know why it happen? The
>>>>>>database server can run if using "nohup java org.hsqldb.Server &"...
>>>>>>
>>>>>>    Please help me. Thanks...
>>>>>>
>>>>>>
>>>>>>Regards,
>>>>>>Siok Peng
>>>>>>
>>>>>>      
>>>>>>        
>>>>>>            
>>>>>>
>>>-------------------------------------------------------------------------
>>>Using Tomcat but need to do more? Need to support web services, security?
>>>Get stuff done quickly with pre-integrated technology to make your job easier
>>>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>>>_______________________________________________
>>>hsqldb-developers mailing list
>>>hsq...@li...
>>>https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
>>>
>>>  
>>>      
>>>
>>------------------------------------------------------------------------
>>
>>+ set +u
>>++ dirname /etc/init.d/hsqldb
>>+ INVOC_PATH=/etc/init.d
>>+ '[' -n /etc/init.d ']'
>>+ INVOC_PATH=/etc/init.d/
>>+ SYNTAX_MSG='SYNTAX:  /etc/init.d/hsqldb start|stop|stopcompact|restart|restartcmpacted|status'
>>+ SU_ECHO_SECS=1
>>+ PIDCHECKER_FLAGFILE=/tmp/pidchecker.run
>>+ MAX_TERMINATE_SECS=1
>>+ MAX_START_SECS=60
>>+ TARGET_CLASS=Server
>>+ CLIENT_JVMARGS=
>>+ SERVER_JVMARGS=
>>+ TLS_KEYSTORE=
>>+ TLS_PASSWORD=
>>+ CFGFILE=
>>+ LOGFILE=
>>+ PIDFILE=
>>+ BASEDIR=
>>+ AUTH_FILE=
>>+ SHUTDOWN_OPTION=
>>+ SERVER_ADDL_CLASSPATH=
>>+ INVOC_ADDL_ARGS=
>>+ case "`uname`" in
>>++ uname
>>+ LOGFILE=/var/log/hsqldb.log
>>+ PIDFILE=/var/run/hsqldb.pid
>>+ for candidate in /etc/sysconfig/hsqldb /etc/hsqldb.conf /etc/hsqldb.cfg /usr/local/etc/hsqldb.cfg
>>+ '[' -f /etc/sysconfig/hsqldb ']'
>>+ CFGFILE=/etc/sysconfig/hsqldb
>>+ break
>>+ '[' -n /etc/sysconfig/hsqldb ']'
>>+ '[' -n /var/log/hsqldb.log ']'
>>+ '[' -n /var/run/hsqldb.pid ']'
>>+ '[' 1 -eq 1 ']'
>>+ '[' -w / ']'
>>+ BSDCFG=
>>+ '[' -r /etc/rc.conf ']'
>>+ '[' -r /etc/rc.conf.local ']'
>>+ '[' -n '' ']'
>>+ COMMAND=start
>>+ shift
>>+ '[' -r /etc/sysconfig/hsqldb ']'
>>+ '[' -f /etc/sysconfig/hsqldb ']'
>>+ HSQLDB_OWNER=
>>+ JAVA_EXECUTABLE=
>>+ HSQLDB_JAR_PATH=
>>+ SERVER_HOME=
>>+ SHUTDOWN_URLIDS=
>>+ . /etc/sysconfig/hsqldb
>>++ JAVA_EXECUTABLE=/usr/java/jdk1.5.0_01/bin/java
>>++ HSQLDB_JAR_PATH=/home/demo1/hsqldb/lib/hsqldb.jar
>>++ SERVER_HOME=/opt/hsqldb/data
>>++ HSQLDB_OWNER=hsqldb
>>+ '[' -n '' ']'
>>+ '[' -n /usr/java/jdk1.5.0_01/bin/java ']'
>>+ '[' -n /home/demo1/hsqldb/lib/hsqldb.jar ']'
>>+ '[' -n /opt/hsqldb/data ']'
>>+ '[' -d /opt/hsqldb/data ']'
>>+ '[' -f /usr/java/jdk1.5.0_01/bin/java ']'
>>+ '[' -f /home/demo1/hsqldb/lib/hsqldb.jar ']'
>>+ case "$TARGET_CLASS" in
>>+ PROPERTY_FILE=/opt/hsqldb/data/server.properties
>>+ '[' -f /opt/hsqldb/data/server.properties ']'
>>+ '[' -r /opt/hsqldb/data/server.properties ']'
>>+ '[' -r /home/demo1/hsqldb/lib/hsqldb.jar ']'
>>+ '[' -x /usr/java/jdk1.5.0_01/bin/java ']'
>>+ PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/java/jdk1.5.0_01/bin:/usr/local/ant/bin:/root/bin:/usr/sbin
>>+ '[' -z '' ']'
>>+ '[' -z /root ']'
>>+ _AUTH_TEST_PATH=
>>+ '[' -n '' ']'
>>+ _AUTH_TEST_PATH=/root/sqltool.rc
>>+ '[' -f /root/sqltool.rc ']'
>>+ '[' -r /root/sqltool.rc ']'
>>+ ls -ld /root/sqltool.rc
>>+ grep '^-..------'
>>+ HSQLDB_PID=
>>+ '[' -r /var/run/hsqldb.pid ']'
>>+ case "$COMMAND" in
>>+ '[' -n '' ']'
>>+ TLS_SWITCHES=
>>+ '[' -n '' ']'
>>+ '[' -n hsqldb ']'
>>+ touch /var/run/hsqldb.pid
>>+ chown hsqldb /var/run/hsqldb.pid
>>+ sleep 1
>>+ nohup su hsqldb -c 'cd '\''/opt/hsqldb/data'\'' && echo $$ > '\''/var/run/hsqldb.pid'\'' && exec '\''/usr/java/jdk1.5.0_01/bin/java'\''   -classpath '\''/home/demo1/hsqldb/lib/hsqldb.jar'\'' org.hsqldb.util.MainInvoker org.hsqldb.Server '
>>+ AUTH_FILE_SWITCH=
>>+ '[' -n '' ']'
>>+ CLASSPATH=/home/demo1/hsqldb/lib/hsqldb.jar
>>+ export CLASSPATH
>>+ export PATH
>>+ touch /tmp/pidchecker.run
>>+ export PIDCHECKER_FLAGFILE
>>+ export PIDFILE
>>+ true
>>+ '[' -f /tmp/pidchecker.run ']'
>>++ cat /var/run/hsqldb.pid
>>+ kill -0 3232
>>+ rm -f /var/run/hsqldb.pid /tmp/pidchecker.run
>>+ exit 1
>>+ /usr/java/jdk1.5.0_01/bin/java -Dsqltoolsprayer.propfile=/opt/hsqldb/data/server.properties -Dsqltoolsprayer.monfile=/var/run/hsqldb.pid -Dsqltoolsprayer.maxtime=60000 org.hsqldb.util.SqlToolSprayer --
>>Required file is gone:  /var/run/hsqldb.pid
>>+ rm -f /tmp/pidchecker.run
>>+ echo 'Failed to start org.hsqldb.Server.
>>See log file '\''/var/log/hsqldb.log'\''.'
>>Failed to start org.hsqldb.Server.
>>See log file '/var/log/hsqldb.log'.
>>+ exit 1
>>  
>>------------------------------------------------------------------------
>>
>>-------------------------------------------------------------------------
>>Using Tomcat but need to do more? Need to support web services, security?
>>Get stuff done quickly with pre-integrated technology to make your job easier
>>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>>------------------------------------------------------------------------
>>
>>_______________________________________________
>>hsqldb-developers mailing list
>>hsq...@li...
>>https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
>>  
>>    
>>
>
>  
>