From owner-freebsd-questions@FreeBSD.ORG Sun Mar 20 12:51:38 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3EF4B16A4CE for ; Sun, 20 Mar 2005 12:51:38 +0000 (GMT) Received: from webmail-outgoing.us4.outblaze.com (webmail-outgoing.us4.outblaze.com [205.158.62.67]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0209243D41 for ; Sun, 20 Mar 2005 12:51:38 +0000 (GMT) (envelope-from fteg@london.com) Received: from wfilter.us4.outblaze.com (wfilter.us4.outblaze.com [205.158.62.180])E3E221800135 for ; Sun, 20 Mar 2005 12:51:37 +0000 (GMT) X-OB-Received: from unknown (205.158.62.49) by wfilter.us4.outblaze.com; 20 Mar 2005 12:51:37 -0000 Received: by ws1-1.us4.outblaze.com (Postfix, from userid 1001) id D8F304BE6D; Sun, 20 Mar 2005 12:51:37 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Received: from [213.187.181.70] by ws1-1.us4.outblaze.com with http for fteg@london.com; Sun, 20 Mar 2005 07:51:37 -0500 From: "Fafa Diliha Romanova" To: mysql@lists.mysql.com, questions@freebsd.org Date: Sun, 20 Mar 2005 07:51:37 -0500 X-Originating-Ip: 213.187.181.70 X-Originating-Server: ws1-1.us4.outblaze.com Message-Id: <20050320125137.D8F304BE6D@ws1-1.us4.outblaze.com> Subject: Managing virtual e-mails X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 20 Mar 2005 12:51:38 -0000 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