Database Setup

If you have chosen to use PostgreSQL or MySQL, you will need to define a database user, create the gold database, and configure the database server to support transactions and connections from the Gold server host. No setup is needed if you are using SQLite.

Configure trusted connections

For PostgreSQL, add the IP ADDRESS of the host where the Gold server will run (even if it is the same host as the database server).

[postgres]$ vi /etc/postgresql/8.4/main/pg_hba.conf

host all all 192.168.1.99/16 trust

For PostgreSQL, configure postgres to accept connections from your host.

[postgres]$ vi /etc/postgresql/8.4/main/postgresql.conf

listen_addresses = 'mygoldserver,localhost' # what IP address(es) to listen;

Enable support for transactions

If you are using the MySQL database you will need to configure the server to support transactions (MySQL 5.5.5 and later supports transactions by default).

[root]$ vi /etc/mysql/my.cnf

default-storage-engine = INNODB # Place under the [mysqld] section

Add the "gold" user as a database administrator

For PostgreSQL database:

postgres$ createuser gold

Shall the new role be a superuser? (y/n) y

For MySQL database:

[mysql]$ mysql

create user gold;
grant all on *.* to 'gold'@'localhost';

Create the gold database (as the gold user)

For PostgreSQL database:

[gold]$ createdb gold

For MySQL database:

[gold]$ mysql
create database gold;