Managing virtual e-mails

From: Fafa Diliha Romanova (fteg_at_london.com)
Date: 03/20/05

  • Next message: J. Seth Henry: "Having problems booting when attempting to mounting /dev from another filesystem on 4.11-REL" 
    To: mysql@lists.mysql.com, questions@freebsd.org
Date: Sun, 20 Mar 2005 07:51:37 -0500

    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@localhost;
    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=MyISAM COMMENT='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=MyISAM COMMENT='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=MyISAM COMMENT='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=MyISAM COMMENT='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=MyISAM COMMENT='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=MyISAM COMMENT='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=MyISAM COMMENT='Postfix: log'; 

    -- 
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
  • Next message: J. Seth Henry: "Having problems booting when attempting to mounting /dev from another filesystem on 4.11-REL"

    Relevant Pages

    • Re: updating all rows within same field that have same values from separate table
      ... both tables have a field for username. ... it would have a foreign key field containing the primary key ... Some database systems do not provide a Cascade Update ...
      (microsoft.public.access.formscoding)
    • Re: how to get users details
      ... Well Im using email address instead of username for a few reasons, ... is already the memid field there. ... UserID, at least for login purposes, rather than as a separate entity ... ... usually it is not a good idea to have something like that (primary key ...
      (microsoft.public.dotnet.framework.aspnet)
    • Postfix: unable to deliver this message after 4 days
      ... CREATE TABLE IF NOT EXISTS alias ( ... goto text NOT NULL, ... PRIMARY KEY, ... username varcharNOT NULL default '', ...
      (freebsd-questions)
    • Postfix inside a jail
      ... PRIMARY KEY, ... username varcharNOT NULL default '', ... mydomain = lalaladomain.com ... I've used this setup on other boxes where they've worked just fine. ...
      (freebsd-questions)
    • Re: different windows user accounts same email account
      ... They are indeed aliases but as it's Freeserve, ... Then, in fred's Outlook Profile, or Outlook in his windows login, in the box ... and in Bill's username box, ...
      (microsoft.public.outlook)
    Loading