...
If you want to change the database for the JobScheduler then follow these steps.:
- Create the new database
- Stop the JobScheduler
- Configure the new database connection data in the following files:
- ./config/factory.ini (For JobScheduler tables like SCHEDULER_HISTORY. See factory.ini)
- ./config/hibernate.cfg.xml (Used by JID and some JITL jobs)
- ./config/sos_settings.ini (Used by the script ./install/scheduler_install_tables.(sh|cmd) and some JITL jobs)
Call the script ./install/scheduler_install_tables.sh (for Unix) or ./install/scheduler_install_tables.cmd (for Windows).
This script executes the sql files in ./db/[dbms]/ to create the database tables.
- Start the JobScheduler
If you are using the Managed Jobs then you have to configer as well the file ./web/custom/custom_inc.php have to configure too.
See here.
Examples for the Configuration of factory.ini, hibernate.cfg.xml and sos_settings.ini
MySQL
factory.ini:
| Code Block |
|---|
[spooler] ... db = jdbc -class=com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/scheduler -user=scheduler -password=scheduler db_class = SOSMySQLConnection ... |
...
| Code Block |
|---|
[configuration] class = SOSMySQLConnection driver = com.mysql.jdbc.Driver url = jdbc:mysql://localhost:3306/scheduler user = scheduler password = scheduler compatibility = normal |
MySQL via
...
MariaDB
factory.ini:
| Code Block |
|---|
[spooler] ... db = jdbc -class=org.mariadb.jdbc.Driver jdbc:mysql://localhost:3306/scheduler -user=scheduler -password=scheduler db_class = SOSMySQLConnection ... |
...
| Code Block |
|---|
[configuration] class = SOSMySQLConnection driver = org.mariadb.jdbc.Driver url = jdbc:mysql://localhost:3306/scheduler user = scheduler password = scheduler compatibility = normal |
Oracle
factory.ini:
| Code Block |
|---|
[spooler] ... db = jdbc -class=oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@localhost:1521:scheduler -user=scheduler -password=scheduler db_class = SOSOracleConnection ... |
...
| Code Block |
|---|
[configuration] class = SOSOracleConnection driver = oracle.jdbc.driver.OracleDriver url = jdbc:oracle:thin:@localhost:1521:scheduler user = scheduler password = scheduler compatibility = normal |
Microsoft SQL Server
factory.ini:
| Code Block |
|---|
[spooler] ... 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 ... |
...
| Code Block |
|---|
[configuration] class = SOSMSSQLConnection driver = com.microsoft.sqlserver.jdbc.SQLServerDriver url = jdbc:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler user = scheduler password = scheduler compatibility = normal |
Microsoft SQL Server via jTDS
factory.ini:
| Code Block |
|---|
[spooler] ... 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 ... |
...
| Code Block |
|---|
[configuration] class = SOSMSSQLConnection driver = net.sourceforge.jtds.jdbc.Driver url = jdbc:jtds:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler user = scheduler password = scheduler compatibility = normal |
PostgreSQL
factory.ini:
| Code Block |
|---|
[spooler] ... db = jdbc -class=org.postgresql.Driver jdbc:postgresql://localhost:5432/scheduler -user=scheduler -password=scheduler db_class = SOSPgSQLConnection ... |
...
| Code Block |
|---|
[configuration] class = SOSPgSQLConnection driver = org.postgresql.Driver url = jdbc:postgresql://localhost:5432/scheduler user = scheduler password = scheduler compatibility = normal |
DB2
factory.ini:
| Code Block |
|---|
[spooler] ... db = jdbc -class=com.ibm.db2.jcc.DB2Driver jdbc:db2://localhost:50000/scheduler:driverType=2;retrieveMessagesFromServerOnGetMessage=true; -user=scheduler -password=scheduler db_class = SOSDB2Connection ... |
...
| Code Block |
|---|
[configuration] class = SOSDB2Connection driver = com.ibm.db2.jcc.DB2Driver url = jdbc:db2://localhost:50000/scheduler:driverType=2;retrieveMessagesFromServerOnGetMessage=true; user = scheduler password = scheduler compatibility = normal |
Sybase
factory.ini:
| Code Block |
|---|
[spooler] ... db = jdbc -class=com.sybase.jdbc3.jdbc.SybDriver jdbc:sybase:Tds:localhost:5000/scheduler -user=scheduler -password=scheduler db_class = SOSSybaseConnection ... |
...
| Code Block |
|---|
[configuration] class = SOSSybaseConnection driver = com.sybase.jdbc3.jdbc.SybDriver url = jdbc:sybase:Tds:localhost:5000/scheduler user = scheduler password = scheduler compatibility = normal |
Sybase via jTDS
factory.ini:
| Code Block |
|---|
[spooler] ... db = jdbc -class=net.sourceforge.jtds.jdbc.Driver jdbc:jtds:sybase://localhost:5000/scheduler -user=scheduler -password=scheduler db_class = SOSSybaseConnection ... |
...
| Code Block |
|---|
[configuration] class = SOSSybaseConnection driver = net.sourceforge.jtds.jdbc.Driver url = jdbc:jtds:sybase://localhost:5000/scheduler user = scheduler password = scheduler compatibility = normal |
Firebird
factory.ini:
| Code Block |
|---|
[spooler] ... db = jdbc -class=org.firebirdsql.jdbc.FBDriver jdbc:firebirdsql://localhost:3050/scheduler -user=scheduler -password=scheduler db_class = SOSFbSQLConnection ... |
...