Skip site navigation (1)Skip section navigation (2) 
Date:      Sun, 20 Mar 2005 07:51:37 -0500
From:      "Fafa Diliha Romanova" <fteg@london.com>
To:        mysql@lists.mysql.com, questions@freebsd.org
Subject:   Managing virtual e-mails
Message-ID:  <20050320125137.D8F304BE6D@ws1-1.us4.outblaze.com>
next in thread | raw e-mail | index | archive | help 

Hello.

I am running the Postfix+Courier on MySQL setup found on:

http://www.high5.net/howto

I am wondering how to add and delete users, as well as adding
and deleting aliases -- and managing my virtual e-mail database
in general -- using a pure, clean and efficient approach,
rather than having to use Postfixadmin, which I find to be sort
of unprofessional and bloated with bad design.

For instance, I managed to avoid using the PHPMyAdmin, and
instead got all my setup recorded in clean text:

USE mysql;
CREATE DATABASE gtg_mail;
GRANT USAGE ON gtg_mail.* TO postfix@localhost IDENTIFIED BY 'gatNanav';
GRANT CREATE, SELECT, INSERT, DELETE, UPDATE ON gtg_mail.* TO postfix@local=
host;
FLUSH PRIVILEGES;

USE gtg_mail;
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=3DMyISAM COMMENT=3D'Postfix: virtual admins';

USE gtg_mail;
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=3DMyISAM COMMENT=3D'Postfix: virtual aliases';

USE gtg_mail;
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',
  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=3DMyISAM COMMENT=3D'Postfix: virtual domains';

USE gtg_mail;
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=3DMyISAM COMMENT=3D'Postfix: virtual domain admins';

USE gtg_mail;
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=3DMyISAM COMMENT=3D'Postfix: virtual mailboxes';

USE gtg_mail;
CREATE TABLE vacation (
  email varchar(255) NOT NULL default '',
  subject varchar(255) NOT NULL default '',
  body text NOT NULL,
  cache text NOT NULL,
  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=3DMyISAM COMMENT=3D'Postfix: virtual vacation';

USE gtg_mail;
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=3DMyISAM COMMENT=3D'Postfix: log';

--=20
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050320125137.D8F304BE6D>