| 1 |
# $Id: hsqldb-1.73.0-standard.cfg,v 1.1 2004/12/23 22:21:08 fnasser Exp $ |
| 2 |
|
| 3 |
# Sample configuration file for HSQLDB database server. |
| 4 |
# See the "UNIX Quick Start" chapter of the Hsqldb User Guide. |
| 5 |
|
| 6 |
# N.b.!!!! You must place this in the right location for your type of UNIX. |
| 7 |
# See the init script "hsqldb" to see where this must be placed and |
| 8 |
# what it should be renamed to. |
| 9 |
|
| 10 |
# This file is "sourced" by a Bourne shell, so use Bourne shell syntax. |
| 11 |
|
| 12 |
# This file WILL NOT WORK until you set (at least) the non-commented |
| 13 |
# variables to the appropriate values for your system. |
| 14 |
# Life will be easier if you avoid all filepaths with spaces or any other |
| 15 |
# funny characters. Don't ask for support if you ignore this advice. |
| 16 |
|
| 17 |
# Thanks to Meikel Bisping for his contributions. -- Blaine |
| 18 |
|
| 19 |
# JPackage hsqldb home is /var/lib/hsqldb |
| 20 |
|
| 21 |
HSQLDB_HOME=/var/lib/hsqldb |
| 22 |
|
| 23 |
# JPackage source Java config |
| 24 |
|
| 25 |
. /etc/java/java.conf |
| 26 |
|
| 27 |
JAVA_HOME=${JAVA_HOME:-/usr/lib/jvm/jre} |
| 28 |
JAVA_EXECUTABLE=${JAVA_HOME}/bin/java |
| 29 |
|
| 30 |
# Unless you copied a hsqldb.jar file from another system, this typically |
| 31 |
# resides at $HSQLDB_HOME/lib/hsqldb.jar, where $HSQLDB_HOME is your HSQLDB |
| 32 |
# software base directory. |
| 33 |
HSQLDB_JAR_PATH=${HSQLDB_HOME}/lib/hsqldb.jar |
| 34 |
|
| 35 |
# Where the file "server.properties" (or "webserver.properties") resides. |
| 36 |
SERVER_HOME=${HSQLDB_HOME} |
| 37 |
|
| 38 |
# What UNIX user the Server/WebServer process will run as. |
| 39 |
# (The shutdown client is always run as root or the invoker of the init script). |
| 40 |
# Runs as root by default, but you should take the time to set database file |
| 41 |
# ownerships to another user and set that user name here. |
| 42 |
# You do need to run as root if your Server/WebServer will run on a privileged |
| 43 |
# (< 1024) port. |
| 44 |
# If you really do want to run as root, comment out the HSQLDB_OWNER setting |
| 45 |
# completely. I.e., do not set it to root. This will run Server/Webserver |
| 46 |
# without any "su" at all. |
| 47 |
HSQLDB_OWNER=hsqldb |
| 48 |
|
| 49 |
# We require all Server/WebServer instances to be accessible within |
| 50 |
# $MAX_START_SECS from when the Server/WebServer is started. |
| 51 |
# Defaults to 60. |
| 52 |
# Raise this is you are running lots of DB instances or have a slow server. |
| 53 |
#MAX_START_SECS=200 |
| 54 |
# Ditto for this one |
| 55 |
#SU_ECHO_SECS=1 |
| 56 |
|
| 57 |
# Time to allow for JVM to die after all HSQLDB instances stopped. |
| 58 |
# Defaults to 1. |
| 59 |
#MAX_TERMINATE_SECS=0 |
| 60 |
|
| 61 |
# These are "urlid" values from a SqlTool authentication file |
| 62 |
# ** IN ADDITION TO THOSE IN YOUR server.properties OR webserver.properties ** |
| 63 |
# file. All server.urlid.X values from your properties file will automatically |
| 64 |
# be started/stopped/tested. $SHUTDOWN_URLIDS is for additional urlids which |
| 65 |
# will stopped. (Therefore, most users will not set this at all). |
| 66 |
# Separate multiple values with white space. NO OTHER SPECIAL CHARACTERS! |
| 67 |
# Make sure to quote the entire value if it contains white space separator(s). |
| 68 |
# Defaults to none (i.e., only urlids set in properties file will be stopped). |
| 69 |
#SHUTDOWN_URLIDS='sa mygms' |
| 70 |
|
| 71 |
# SqlTool authentication file used only for shutdown. |
| 72 |
# The default value will be sqltool.rc in root's home directory, since it is |
| 73 |
# root who runs the init script. |
| 74 |
# (See the SqlTool chapter of the HSQLDB User Guide if you don't understand |
| 75 |
# this). |
| 76 |
AUTH_FILE=${HSQLDB_HOME}/sqltool.rc |
| 77 |
|
| 78 |
# Set to 'WebServer' to start a HSQLDB WebServer instead of a Server. |
| 79 |
# Defaults to 'Server'. |
| 80 |
#TARGET_CLASS=WebServer |
| 81 |
|
| 82 |
# Server-side classpath IN ADDITION TO the HSQLDB_JAR_PATH set above. |
| 83 |
# The classpath here is *earlier* than HSQLDB_JAR_PATH, to allow you |
| 84 |
# override classes in the HSQLDB_JAR_PATH jar file. |
| 85 |
# In particular, you will want to add classpath elements to give access of |
| 86 |
# all of your store procedures (store procedures are documented in the |
| 87 |
# HSQLDB User Guide in the SQL Syntax chapter. |
| 88 |
# |
| 89 |
# N.B.! |
| 90 |
# If you're adding files to the classpath in order to be able to call them |
| 91 |
# from SQL queries, you will be unable to access them unless you adjust the |
| 92 |
# value of the system property hsqldb.method_class_names. Please see the |
| 93 |
# comments on SERVER_JVMARGS, at the end of this file. |
| 94 |
# SERVER_ADDL_CLASSPATH=/home/blaine/storedprocs.jar:/usr/dev/dbutil/classes |
| 95 |
|
| 96 |
# For TLS encryption for your Server, set these two variables. |
| 97 |
# N.b.: If you set these, then make this file unreadable to non-root users!!!! |
| 98 |
# See the TLS chapter of the HSQLDB User Guide, paying attention to the |
| 99 |
# security warning(s). |
| 100 |
# If you are running with a private server cert, then you will also need to |
| 101 |
# set "truststore" in the your SqlTool config file (location is set by the |
| 102 |
# AUTH_FILE variable in this file, or it must be at the default location for |
| 103 |
# HSQLDB_OWNER). |
| 104 |
#TLS_KEYSTORE=/path/to/jks/server.store |
| 105 |
#TLS_PASSWORD=password |
| 106 |
|
| 107 |
# Any JVM args for the invocation of the JDBC client used to verify DB |
| 108 |
# instances and to shut them down (SqlToolSprayer). |
| 109 |
# For multiple args, put quotes around entire value. |
| 110 |
#CLIENT_JVMARGS=-Djavax.net.debug=ssl |
| 111 |
|
| 112 |
# Any JVM args for the server. |
| 113 |
# For multiple args, put quotes around entire value. |
| 114 |
# |
| 115 |
# N.B.! |
| 116 |
# The default value of SERVER_JVMARGS sets the system property |
| 117 |
# hsqldb.method_class_names to be empty. This is in order to lessen the |
| 118 |
# security risk posed by HSQLDB allowing Java method calls in SQL statements. |
| 119 |
# The implications of changing this value (as explained by the authors of |
| 120 |
# HSQLDB) are as follows: |
| 121 |
# If [it] is not set, then static methods of all available Java classes |
| 122 |
# can be accessed as functions in HSQLDB. If the property is set, then |
| 123 |
# only the list of semicolon seperated method names becomes accessible. |
| 124 |
# An empty property value means no class is accessible. |
| 125 |
# Regardless of the value of hsqldb.method_class_names, methods in |
| 126 |
# org.hsqldb.Library will be accessible. |
| 127 |
# Before making changes to the value below, please be advised of the possible |
| 128 |
# dangers involved in allowing SQL queries to contain Java method calls. |
| 129 |
SERVER_JVMARGS=-Dhsqldb.method_class_names=\"\" |