In order to setup a production system you have to prepare a MySQL database where the application will store all data.
To perform this step, make sure to have a MySQL up and running, if this is not the case install it: http://dev.mysql.com/downloads/mysql/
Once your MySQL instance is up and running, please open a terminal and execute this command:
$ sudo su
Type your password as requested in order to login as the root user.
LogicalDOC requires you to configure your MySQL installation to best fit the needs of a professional DMS, so we need to edit the file /etc/my.cnf in this way:
$ vi /etc/mysql/my.cnf
Now edit your current my.cnf configuration file, and make sure to have the following settings in the [mysql] and [mysqld] sections:
default-character-set = utf8
character-set-server = utf8
collation-server = utf8_bin
default-storage-engine = INNODB
This sets the encoding to UTF-8 and the default storage engine to the INNODB with transactions support.
Setting Password for MySQL Root User
Execute the following command at a shell prompt:
$ mysqladmin -u root password 'password'
Creating the database
Connect to mysql prompt typing the command:
$ mysql -u root -ppassword
Execute the following command at the mysql prompt:
CREATE DATABASE logicaldoc;
Now we have an empty database called logicaldoc with a user root that can access it using password password.
You can exit the mysql prompt(command \q) and go ahead.