 |
|
| MailAdmin 1.5.1 | ||
|---|---|---|
| <<< Previous | Next >>> | |
Mailadmin has a transaction log, that runs in Postgres. There are two tables transaction_log and account_information in the database.
First, you must create the database. For puroses of this documentation, we'll call it mailadmin. You can issue the following command, as a user that has permissions to create databases.
createdb mailadmin
Next we'll create a user that owns the database, and can access the database. This must be done by someone with the proper permissions, usually the postgres user.
su - postgres
createuser mailadmin
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
Now we need to give the proper permissions to the user we created, to be able to create the tables and populate the database.
GRANT ALL ON mailadmin TO mailadmin
Now log into the database as the mailadmin user, and create the tables.
$ psql -d mailadmin -h localhost -U mailadmin
\i /var/www/html/mailadmin-1.5.1/sql/mailadmin-pg.sql