2.3. Database

LiveConfig contains an integrated SQLite database and thus doesn't need an external database. Load tests have shown that even a large number of customers (about 2000 customers with 5000 domains) can easily be handled by the internal database.

Buf of course you can also use another backend database. Currently MySQL is supported as external database.

LiveConfig can be configured to use MySQL as backend database. Please note:

Log on to the MySQL console as root user and create a new database for LiveConfig. You can use any name for it:

mysql> create database LIVECONFIG;

Then create a new database user with an arbitrary and safe (!) password:

mysql> grant all on LIVECONFIG.* to "liveconfig"@"localhost"
       identified by "SaFePaSsWoRd";

If LiveConfig is running on another server than MySQL, just use the corresponding IP address instead of localhost.

Now import the table dump for LiveConfig. It's available as compressed SQL dump file at /usr/share/doc/liveconfig/:

Please note that any existing data will be overwritten when importing the database dump! If you've already used LiveConfig with your MySQL database consider creating a backup.

$> cd /usr/share/doc/liveconfig
$> gunzip db-mysql.sql.gz
$> mysql -u liveconfig -p -h localhost LIVECONFIG < db-mysql.sql
Enter password: ************

Finally open the configuration file /etc/liveconfig/liveconfig.conf and edit the database settings, e.g.:

db_driver   = mysql
db_host     = localhost
db_name     = LIVECONFIG
db_user     = liveconfig
db_password = SaFePaSsWoRd

Restart LiveConfig (/etc/init.d/liveconfig restart) - and everything should work.

If LiveConfig won't start, just have a look at the log file (/var/log/liveconfig/liveconfig.log).

Prev   Next   Up   Home