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

siokpeng Wed, 23 Aug 2006 21:32:54 -0700

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

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

Reply via email to