SobekCM Repository Community Help
SobekCM Repository

Database Installation and Configuration

 

Database Engine

As of version 5.0, your choices for the database has really opened up. You can use:

  • Any recent version of MS SQL, such as Express, Developer, or Web
  • PostgresSQL database
  • Any flavor of these on the cloud

The database must be accessible from the web server and the server running the builder/bulk loader service.

SobekCM Database Creation

Manually create the database from scripts

Scripts are provided for MS SQL and PostgresSQL to create a new database from scratch. The scripts are located in the Github Repository:

  • PostgresSQL scripts are here: SobekCM-Web-Application\Database\PostgresSQL\Version 5.0.0
  • SQL scripts are here: SobekCM-Web-Application\Database\SQL\Version 5.0.0

You will find scripts to both create a brand new database, and one to upgrade from the previous version. Version 5.0.0 won't have any upgrade scripts for PostgresSQL since this is the first release that supports PostgresSQL.

The scripts to create new databases includes all the tables, keys, indexes, roles, and stored procedures used by both the web application and sobekcm builder. In addition, seed data will also be added to the database, so generally the databases should be ready to go after running those creation scripts.

You will need to add users to the correct roles. Add all service accounts (used in the IIS setup and in the scheduled task setup for the builder/bulk loader) to the 'sobek_user' and 'sobek_builder' roles.

This completes the configuration of the database server.

 

Testing connectivity to your database from your web server

Below is a link to an (older) MSDN article that gives a very simple way to test connectivity from your web server to your database server. Simple add an empty file names test.udl (or anything ending in .udl actually) on your web server. Clicking on it should bring up a small screen that will allow you to test connectivity from that computer to any database server, using whatever credentials or security type you want. Very helpful!

http://blogs.msdn.com/b/steverac/archive/2010/12/14/test-remote-sql-connectivity-easily.aspx

In addition, once you connect to the database, the connection string to use will now be in the UDL file, so you can cut and paste it into the appropriate SobekCM configuration files.