The Business Rules Engine

Installation

Unpack the Server

To install CodaServer, simply unzip the CodaServer ZIP file into the desired location on your system. You should have a directory structure that looks like this:

/conf/
      coda.conf
/lib/
     ...
/log/
CodaServer.jar
README.txt
start.sh
startserver.bat
format.sh
format.bat

Create the CodaServer Schema

Open up conf/coda.conf. Scroll down to the section labeled databaseConfiguration. Enter in the correct connection information for the new CodaServer schema. The schema and user do not already have to exist; they will be created if they need to be. Save and close the file.

Open format.sh (or format.bat on Windows). Enter in the required information. The database user specified will be used to create the new schema and user, so it must have sufficient permissions in the database to do so. The "root" password will be the password of the root account on the new CodaServer. Use something that is difficult to guess. Save and exit.

Now run format.sh from the command line. The formatter will tell you what it is doing. The following is the expected output.

Formatting Config Database...
...Schema created
...Connected as new user
...Formatting
...Creating table 'users'
...Creating table 'groups'
...Creating table 'user_groups'
...Creating table 'datasources'
...Creating table 'datasource_options'
...Creating table 'applications'
...Creating table 'group_applications'
...Creating table 'server_permissions'
...Creating table 'application_permissions'
...Creating table 'user_server_permissions'
...Creating table 'user_application_permissions'
...Creating table 'transactions'
...Creating table 'types'
...Creating table 'sessions'
...Creating table 'cluster'
...Creating table 'coda_system_information'
...Creating indexes and keys
...Inserting base data
...Types
...Server Permissions
...Application Permissions
...Root User
...Root User Permissions
...Formatting complete!

Note: MySQL sometimes has problems with its connection host strings. While CodaServer creates a user that can connect from any host (%) sometimes a MySQL server will still not let the created user connect from localhost. If the format process stalls for you, please explicitly add 'localhost' to the new user's connection hosts from within MySQL and flush the database privileges. Then try again with the format.

You should now have a properly formatted CodaServer database.

Start Up the Server

Now comes the easy part. Run start.sh, or startserver.bat on Windows.

It's alive!