GUI Administration for Postfix

* Line 30: Replace the user 'postfix' with 'postfixserver', and remember 
that the password 'postfixserver' should be something unique to your 
installation.
* Line 31: Replace the Db 'postfix' with 'mail' and the User 'postfix' to 
be 'postfixserver'
* Line 33: Replace the password for 'postfixadmin' with something unique 
for your installation.
* Line 34: Replace the Db 'postfix' with 'mail'
* Line 36: Replace  postfix.* with mail.* and replace 
postfix@localhost with <a href="mailto:postfixserver@localhost">
postfixserver@localhost</a> 
* Line 37: Replace postfix.* with mail.*
* Line 38: Replace postfix.* with mail.*
* Line 39: Replace postfix.* with mail.*
* Line 40: Replace postfix; with mail;
* Line 41: Replace postfix; with mail;

* Line 146: Replace 'admin@domain.tld' with 'admin'
* Line 147: Replace 'admin@domain.tld' with 'admin'. Replace password with 
new password.

# mysql -u root -p < ./DATABASE_MYSQL.TXT

* drop/delete the database mail and or postfix
* delete user postfix
* delete user postfixadmin
* delete user postfixserver
* delete database privileges (db) for postfix
* delete database privileges (db) for postfixadmin
* delete database privileges (db) for postfixserver
* flush the privileges

$ mysql -u root -p

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 5.0.24a-log
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> drop database mail;

Query OK, 7 rows affected (0.05 sec)

mysql> drop database postfix;

ERROR 1008 (HY000): Can't drop database 'postfix'; 
database doesn't exist

mysql> use mysql;

Database changed

mysql> delete from user where user='postfix';

Query OK, 0 rows affected (0.00 sec)

mysql> delete from user where user='postfixadmin';

Query OK, 1 row affected (0.00 sec)

mysql> delete from user where user='postfixserver';

Query OK, 1 row affected (0.00 sec)

mysql> delete from db where user='postfix';

Query OK, 0 rows affected (0.01 sec)

mysql> delete from db where user='postfixserver';

Query OK, 1 row affected (0.00 sec)

mysql> delete from db where user='postfixadmin';

Query OK, 1 row affected (0.00 sec)

mysql> flush privileges;

* Set the correct permissions
* Change config.inc.php

# cd /var/www/htdocs/postfixadmin

# find . -type f -exec chmod 640 "{}" ";"

# find . -exec chown www:www "{}" ";"

$CONF['postfix_admin_url'] = 'http://PRIVATE_IP/postfixadmin/';
$CONF['postfix_admin_path'] = '/admin/';
$CONF['database_host'] = '127.0.0.1';
$CONF['database_name'] = 'mail';
$CONF['admin_email'] = 'postmaster@example.org';
$CONF['smtp_server'] = '127.0.0.1';
$CONF['encrypt'] = 'system';
 $CONF['default_aliases'] = array (
 'abuse' => 'abuse@example.org',
 'hostmaster' => 'hostmaster@example.org',
 'postmaster' => 'postmaster@example.org',
 'webmaster' => 'webmaster@example.org'
);
$CONF['domain_path'] = 'YES';
$CONF['vacation_domain'] = 'autoreply.example.org';
$CONF['footer_text'] = 'Return to MYHOST';
$CONF['footer_link'] = 'http://PRIVATE_IP';

$ lynx http://PRIVATE_IP/postfixadmin/

#
# Postfix Admin
# by Mischa Peters <mischa at high5 dot net>
# Copyright (c) 2002 - 2005 High5!
# Licensed under GPL for more info check GPL-LICENSE.TXT
# 
# This is the complete MySQL database structure for Postfix Admin.
# If you are installing from scratch you can use this file otherwise you
# need to use the TABLE_CHANGES.TXT or TABLE_BACKUP_MX.TXT that comes with 
Postfix Admin.
# You can find these in DOCUMENTS/ 
#
# There are 2 entries for a database user in the file.
# One you can use for Postfix and one for Postfix Admin.
#
# If you run this file twice (2x) you will get an error on the user creation in 
MySQL.
# To go around this you can either comment the lines below "USE MySQL" until 
"USE postfix".
# Or you can remove the users from the database and run it again.
#
# You can create the database from the shell with:
#
# mysql -u root [-p] < DATABASE_MYSQL.TXT 
#
# Postfix / MySQL
#
USE mysql;
# Postfix user & password
INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixserver',password('postfixserver'));
INSERT INTO db (Host, Db, User, Select_priv) VALUES ('localhost','mail','postfixserver','Y');
# Postfix Admin user & password
INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixadmin',password('postfixadmin'));
INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, 
Delete_priv) VALUES ('localhost', 'mail', 'postfixadmin', 'Y', 'Y', 'Y', 'Y');
FLUSH PRIVILEGES;
GRANT USAGE ON mail.* TO postfixserver@localhost;
GRANT SELECT, INSERT, DELETE, UPDATE ON mail.* TO postfixserver@localhost;
GRANT USAGE ON mail.* TO postfixadmin@localhost;
GRANT SELECT, INSERT, DELETE, UPDATE ON mail.* TO postfixadmin@localhost;
CREATE DATABASE mail;
USE mail;
#
# Table structure for table admin
#
CREATE TABLE `admin` (
`username` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`username`),
KEY username (`username`)
) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Admins'; 
#
# Table structure for table alias
#
CREATE TABLE `alias` (
`address` varchar(255) NOT NULL default '',
`goto` text NOT NULL,
`domain` varchar(255) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`address`),
KEY address (`address`)
) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Aliases'; 
#
# Table structure for table domain
#
CREATE TABLE `domain` (
`domain` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`aliases` int(10) NOT NULL default '0',
`mailboxes` int(10) NOT NULL default '0',
`maxquota` int(10) NOT NULL default '0',
`quota` int(10) NOT NULL default '0',
`transport` varchar(255) default NULL,
`backupmx` tinyint(1) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`domain`),
KEY domain (`domain`)
) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Domains'; 
#
# Table structure for table domain_admins
#
CREATE TABLE `domain_admins` (
`username` varchar(255) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
KEY username (`username`)
) TYPE=MyISAM COMMENT='Postfix Admin - Domain Admins'; 
#
# Table structure for table log
#
CREATE TABLE `log` (
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`username` varchar(255) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`action` varchar(255) NOT NULL default '',
`data` varchar(255) NOT NULL default '',
KEY timestamp (`timestamp`)
) TYPE=MyISAM COMMENT='Postfix Admin - Log'; 
#
# Table structure for table mailbox
#
CREATE TABLE `mailbox` (
`username` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`maildir` varchar(255) NOT NULL default '',
`quota` int(10) NOT NULL default '0',
`domain` varchar(255) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`username`),
KEY username (`username`)
) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Mailboxes'; 
#
# Table structure for table vacation
#
CREATE TABLE `vacation` (
`email` varchar(255) NOT NULL default '',
`subject` varchar(255) NOT NULL default '',
`body` text NOT NULL default '',
`cache` text NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`email`),
KEY email (`email`)
) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Vacation'; 
# superadmin user & password (login: admin@domain.tld, password: admin)
INSERT INTO domain_admins (username, domain, active) VALUES ('admin','ALL','1');
INSERT INTO admin (username, password, active) VALUES 
('admin','6dwLx9NTxhTjU','1');