Execute the following SQL script as database user root (e.g. via MySQL Workbench):
-- create schema goco;
create schema goco;
create user goco identified by 'goco';
REVOKE ALL PRIVILEGES,GRANT OPTION from goco;
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, SHOW VIEW, CREATE, ALTER, INDEX, DROP, REFERENCES ON goco.* TO 'goco';
-- create schema quartz
create schema quartz;
create user quartz identified by 'quartz';
REVOKE ALL PRIVILEGES,GRANT OPTION from quartz;
GRANT SELECT, INSERT, UPDATE, DELETE ON quartz.* TO 'quartz';
Leave the passwords for the users goco and quartz for the moment, until the initial installation is performed and verified. After that you can change the passwords as described in Wie kann ich das Datenbank-Passwort ändern?
Execute the following script (it creates tables for schema "quartz", which does the nightly batch job scheduling:
To configure the database connection on the Application Server, open the file context.xml (in <Tomcat-Directory>/conf). Add the following lines directly after the element <context>. This creates the database data-sources for schemas "goco" and "quartz":
<Resource
name="gocoTenantDs"
factory="com.gocompliant.encryptedDs.EncryptedDataSourceFactory"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/goco?allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=Europe/Zurich"
username="goco"
password="922f591c101ab822305be286a532c196"
maxActive="20"
minIdle="0"
maxIdle="0"
minEvictableIdleTimeMillis="14400000"
maxWait="-1" />
<Resource
name="quartz"
factory="com.gocompliant.encryptedDs.EncryptedDataSourceFactory"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/quartz?allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=Europe/Zurich"
username="quartz"
password="2259b33c5588618ee0742b2ced9998e6"
maxActive="20"
minIdle="0"
maxIdle="0"
minEvictableIdleTimeMillis="14400000"
maxWait="-1" />
Download the following scripts (right click → Save Link As...) that we have provided in the download area, and execute them. You can execute the scripts either with a DBA role user or as user "goco". The scripts are UTF-8 encoded, in order to treat German/French/Italian special characters correctly. Make sure that the DB server and client are using UTF-8 encoding before executing the script 05_goco_insert_init_data.sql.
Usually we provide some initially preconfigured users (corresponding to your windows user ids) via script 06_goco_insert_customer_data.sql, so you will be able to access the application via Active Directory Single Sign-On. If this is not the case (we will mention it in the delivery mail), you need to replace the "initialuser" User ID with your Windows User ID. Replace in the following script YOUR_WINDOWS_USER_ID with your User ID and execute it:
update goco.co_employee set user_id = 'YOUR_WINDOWS_USER_ID' where user_id = 'initialuser';
commit;
To configure the database connections on the Application Server to, open the file context.xml (in <Tomcat-Directory>/conf). Add the following lines directly after the element <context>.
IMPORTANT: Replace YOUR_SID both times by your Oracle SID.
<Resource
name="gocoTenantDs"
factory="com.gocompliant.encryptedDs.EncryptedDataSourceFactory"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:YOUR_SID"
username="goco"
password="922f591c101ab822305be286a532c196"
maxActive="20"
minIdle="0"
maxIdle="0"
minEvictableIdleTimeMillis="14400000"
maxWait="-1" />
<Resource
name="quartz"
factory="com.gocompliant.encryptedDs.EncryptedDataSourceFactory"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:YOUR_SID"
username="quartz"
password="2259b33c5588618ee0742b2ced9998e6"
maxActive="20"
minIdle="0"
maxIdle="0"
minEvictableIdleTimeMillis="14400000"
maxWait="-1" />
Before officially rolling out the application you should configure the most important system parameters. A descriptino of these parameters can be found in section Systemparameter.
If you would like to use the LDAP (Active Directory) synchronisation, you will find a description of the relevant parameters in section LDAP (Active Directory) Systemparameter.
If you want to run your application via https and have a corresponding certificate, please follow these instructions: Wie kann ich HTTPS einrichten bzw. erzwingen?
Verwandte Seiten |
|