The database connection is configured in the following files:
- appdata_path/config/factory.ini
For JobScheduler tables like SCHEDULER_HISTORY. See [factory.ini|http://www.sos-berlin.com/doc/en/scheduler.doc/factory_ini_spooler.xml#setting_db]
Example for MySQL
db = jdbc -class=com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/scheduler -user=scheduler -password=scheduler db_class = SOSMySQLConnection
Example for MySQL via mariaDB
db = jdbc -class=org.mariadb.jdbc.Driver jdbc:mysql://localhost:3306/scheduler -user=scheduler -password=scheduler db_class = SOSMySQLConnection
Example for Oracle
db = jdbc -class=oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@localhost:1521:scheduler -user=scheduler -password=scheduler db_class = SOSOracleConnection
Example for Microsoft SQL Server
db = jdbc -class=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler -user=scheduler -password=scheduler db_class = SOSMSSQLConnection
Example for Microsoft SQL Server via jTDS
db = jdbc -class=net.sourceforge.jtds.jdbc.Driver jdbc:jtds:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler -user=scheduler -password=scheduler db_class = SOSMSSQLConnection
Example for PostgreSQL
db = jdbc -class=org.postgresql.Driver jdbc:postgresql://localhost:5432/scheduler -user=scheduler -password=scheduler db_class = SOSPgSQLConnection
Example for Firebird
db = jdbc -class=org.firebirdsql.jdbc.FBDriver jdbc:firebirdsql://localhost:3050/scheduler -user=scheduler -password=scheduler db_class = SOSFbSQLConnection
Example for DB2
db = jdbc -class=com.ibm.db2.jcc.DB2Driver jdbc:db2://localhost:50000/scheduler:driverType=2;retrieveMessagesFromServerOnGetMessage=true; -user=scheduler -password=scheduler db_class = SOSDB2Connection
Example for Sybase
db = jdbc -class=com.sybase.jdbc3.jdbc.SybDriver jdbc:sybase:Tds:localhost:5000/scheduler -user=scheduler -password=scheduler db_class = SOSSybaseConnection
Example for Sybase via jTDS
db = jdbc -class=net.sourceforge.jtds.jdbc.Driver jdbc:jtds:sybase://localhost:5000/scheduler -user=scheduler -password=scheduler db_class = SOSSybaseConnection
- appdata_path/config/sos_settings.ini
Used by some Java jobs.
[configuration] class = SOSOracleConnection driver = oracle.jdbc.driver.OracleDriver url = jdbc:oracle:thin:@dbServer:1521:dbName user = dbUser password = dbPwd compatibility = normal
- install_path/web/custom/custom_inc.php
If you are using the "managed job interface". See Chapter 4.
// database authorization if(!defined('APP_CONNECTION_AUTH')) \{ define ( 'APP_CONNECTION_AUTH', '-db=test -user=scheduler -password=scheduler -host=8of9' ); \}