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: [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
|
-------------------------------------------------------------------------
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
