HSQL Server on Linux

Hi,

I have some databases I used to use with Ubuntu 16.4, LibreOffice and
HSQL 2.3.4 in /home/andreas/hsql/database/ and now I'd like to implement
a service with only one of these databases.

I copied the hsqldb.init script from the samples to /etc/init.d and left
it unchanged.

I copied the hsqldb.service from the samples to /etc and left it unchanged.

/etc/hsqldb.conf looks like this (I grepped out all uncommented lines):
JAVA_EXECUTABLE=/usr/bin/java
SQLTOOL_JAR_PATH=/home/andreas/hsql/driver/sqltool.jar
SERVER_HOME=/home/andreas/hsql/
HSQLDB_OWNER=andreas
URLIDS=test
AUTH_FILE=/home/andreas/hsql/sqltool.rc

/home/andreas/hsql/sqltool.rc looks like this:
urlid test
url jdbc:hsqldb:hsql://localhost
username SA
password

And finally the server.properties:
server.address=127.0.0.1
server.acl=/home/andreas/hsql/acl.txt
server.database.0=/home/andreas/hsql/database/Meera;ifexists=true
server.dbname.0=test

Oh, and the acl.txt:
allow 127.0.0.1
allow 192.168.15.0/24

$ sudo service hsqldb start
> Job for hsqldb.init.service failed because the control process exited with error code. See "systemctl status hsqldb.init.service" and "journalctl -xe" for details.

times out with the above error message but the service is availlable
anyway. I can connect my client (a LibreOffice Base doc) to
jdbc:hsqldb:hsql://localhost/test and use the database.

$ journalctl -xe
> -- 
> -- A new session with the ID c19 has been created for the user andreas.
> -- 
> -- The leading process of the session is 16930.
> Dez 31 17:08:30 andreas-ThinkPad-W510 systemd[1]: Started Session c19 of user andreas.
> -- Subject: Unit session-c19.scope has finished start-up
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> -- 
> -- Unit session-c19.scope has finished starting up.
> -- 
> -- The start-up result is done.
> Dez 31 17:09:31 andreas-ThinkPad-W510 hsqldb.init[16922]: Failed instances:   [test]
> Dez 31 17:09:31 andreas-ThinkPad-W510 hsqldb.init[16922]: Failed to start org.hsqldb.server.Server.
> Dez 31 17:09:31 andreas-ThinkPad-W510 hsqldb.init[16922]: See log file '/var/log/hsqldb.log'.
> Dez 31 17:09:31 andreas-ThinkPad-W510 systemd[1]: hsqldb.init.service: Control process exited, code=exited status=1
> Dez 31 17:09:31 andreas-ThinkPad-W510 systemd[1]: Failed to start LSB: HyperSQL Database Server.
> -- Subject: Unit hsqldb.init.service has failed
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> -- 
> -- Unit hsqldb.init.service has failed.
> -- 
> -- The result is failed.
> Dez 31 17:09:31 andreas-ThinkPad-W510 systemd[1]: hsqldb.init.service: Unit entered failed state.
> Dez 31 17:09:31 andreas-ThinkPad-W510 systemd[1]: hsqldb.init.service: Failed with result 'exit-code'.
> Dez 31 17:09:31 andreas-ThinkPad-W510 sudo[16893]: pam_unix(sudo:session): session closed for user root
> Dez 31 17:10:44 andreas-ThinkPad-W510 sudo[17372]:  andreas : TTY=pts/0 ; PWD=/home/andreas/hsql ; USER=root ; COMMAND=/usr/sbin/service hsqldb st
> Dez 31 17:10:44 andreas-ThinkPad-W510 sudo[17372]: pam_unix(sudo:session): session opened for user root by (uid=0)
> Dez 31 17:10:45 andreas-ThinkPad-W510 systemd[1]: Stopped LSB: HyperSQL Database Server.
> -- Subject: Unit hsqldb.init.service has finished shutting down
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> -- 
> -- Unit hsqldb.init.service has finished shutting down.
> Dez 31 17:10:45 andreas-ThinkPad-W510 sudo[17372]: pam_unix(sudo:session): session closed for user root
> Dez 31 17:10:55 andreas-ThinkPad-W510 su[16930]: pam_unix(su:session): session closed for user andreas
> Dez 31 17:10:56 andreas-ThinkPad-W510 systemd-logind[1015]: Removed session c19.
> -- Subject: Session c19 has been terminated
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> -- Documentation: http://www.freedesktop.org/wiki/Software/systemd/multiseat
> -- 
> -- A session with the ID c19 has been terminated.
> Dez 31 17:16:19 andreas-ThinkPad-W510 wpa_supplicant[1257]: wlp3s0: WPA: Group rekeying completed with 34:81:c4:06:3e:a3 [GTK=CCMP]
> Dez 31 17:17:01 andreas-ThinkPad-W510 CRON[17477]: pam_unix(cron:session): session opened for user root by (uid=0)
> Dez 31 17:17:01 andreas-ThinkPad-W510 CRON[17478]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
> Dez 31 17:17:01 andreas-ThinkPad-W510 CRON[17477]: pam_unix(cron:session): session closed for user root


$ systemctl status hsqldb.init.service
> ● hsqldb.init.service - LSB: HyperSQL Database Server
>    Loaded: loaded (/etc/init.d/hsqldb.init; bad; vendor preset: enabled)
>    Active: failed (Result: exit-code) since So 2017-12-31 17:31:38 CET; 1min 3s ago
>      Docs: man:systemd-sysv-generator(8)
>   Process: 17706 ExecStart=/etc/init.d/hsqldb.init start (code=exited, status=1/FAILURE)
> 
> Dez 31 17:30:37 andreas-ThinkPad-W510 su[17714]: Successful su for andreas by root
> Dez 31 17:30:37 andreas-ThinkPad-W510 su[17714]: + ??? root:andreas
> Dez 31 17:30:37 andreas-ThinkPad-W510 su[17714]: pam_unix(su:session): session opened for user andreas by (uid=0)
> Dez 31 17:31:38 andreas-ThinkPad-W510 hsqldb.init[17706]: Failed instances:   [test]
> Dez 31 17:31:38 andreas-ThinkPad-W510 hsqldb.init[17706]: Failed to start org.hsqldb.server.Server.
> Dez 31 17:31:38 andreas-ThinkPad-W510 hsqldb.init[17706]: See log file '/var/log/hsqldb.log'.
> Dez 31 17:31:38 andreas-ThinkPad-W510 systemd[1]: hsqldb.init.service: Control process exited, code=exited status=1
> Dez 31 17:31:38 andreas-ThinkPad-W510 systemd[1]: Failed to start LSB: HyperSQL Database Server.
> Dez 31 17:31:38 andreas-ThinkPad-W510 systemd[1]: hsqldb.init.service: Unit entered failed state.
> Dez 31 17:31:38 andreas-ThinkPad-W510 systemd[1]: hsqldb.init.service: Failed with result 'exit-code'.

$ tail /var/log/hsqldb.log
> [Server@27716f4]: [Thread[HSQLDB Connection @33ff808a,5,HSQLDB Connections @27716f4]]: database alias= does not exist
> [Server@27716f4]: [Thread[HSQLDB Connection @9df418c,5,HSQLDB Connections @27716f4]]: database alias= does not exist
> [Server@27716f4]: [Thread[HSQLDB Connection @1c9d289f,5,HSQLDB Connections @27716f4]]: database alias= does not exist
> [Server@27716f4]: [Thread[HSQLDB Connection @23ba22c1,5,HSQLDB Connections @27716f4]]: database alias= does not exist
> [Server@27716f4]: [Thread[HSQLDB Connection @6c0e1dec,5,HSQLDB Connections @27716f4]]: database alias= does not exist
> [Server@27716f4]: [Thread[HSQLDB Connection @1f2ef2c0,5,HSQLDB Connections @27716f4]]: database alias= does not exist
> [Server@27716f4]: [Thread[HSQLDB Connection @6a02f86a,5,HSQLDB Connections @27716f4]]: database alias= does not exist
> [Server@27716f4]: [Thread[HSQLDB Connection @18dc63c1,5,HSQLDB Connections @27716f4]]: database alias= does not exist
> [Server@27716f4]: [Thread[HSQLDB Connection @4a1ec4b,5,HSQLDB Connections @27716f4]]: database alias= does not exist
> [Server@27716f4]: [Thread[HSQLDB Connection @6c71a6ed,5,HSQLDB Connections @27716f4]]: database alias= does not exist

Where did I define a blank alias?

Happy new year,
Andreas Säger


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user