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: [EMAIL PROTECTED] >>>>> [mailto:[EMAIL PROTECTED] On Behalf Of >>>>> siokpeng >>>>> Sent: Wednesday, August 23, 2006 3:52 AM >>>>> To: [EMAIL PROTECTED]; hsqldb-developers@lists.sourceforge.net >>>>> 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 >> hsqldb-developers@lists.sourceforge.net >> 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 > hsqldb-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hsqldb-developers > -- Cell: 703-944-9317 ------------------------------------------------------------------------- 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 hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
