Professional Web Applications Themes

Managing virtual e-mails - FreeBSD

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 postfixlocalhost IDENTIFIED BY 'gatNanav'; GRANT CREATE, SELECT, ...

  1. #1

    Default Managing virtual e-mails


    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 postfixlocalhost IDENTIFIED BY 'gatNanav';
    GRANT CREATE, SELECT, INSERT, DELETE, UPDATE ON gtg_mail.* TO postfixlocalhost;
    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

    Fafa Guest

  2. #2

    Default RE: Managing virtual e-mails

    Someone broke the silence:
     

    You can just create any applications that has SQL capabilities. Code
    your own PHP website with administration functions? Python application?
    C application? Ruby application?...the list goes on.

    Chris

    <snip>
    Haulmark, Guest

  3. #3

    Default RE: Managing virtual e-mails


    And if I cannot code?
    .... Will you code one for me?

    ----- Original Message -----
    From: "Haulmark, Chris" <net>
    To: "Fafa Diliha Romanova" <com>, org
    Subject: RE: Managing virtual e-mails
    Date: Sun, 20 Mar 2005 11:53:29 -0500
     
    >
    > You can just create any applications that has SQL capabilities. Code
    > your own PHP website with administration functions? Python application?
    > C application? Ruby application?...the list goes on.
    >
    > Chris
    >
    > <snip>[/ref]

    --
    __________________________________________________ _________
    Sign-up for Ads Free at Mail.com
    http://promo.mail.com/adsfreejump.htm

    Fafa Guest

Similar Threads

  1. ASP E-mails
    By Desperate674 in forum Dreamweaver AppDev
    Replies: 2
    Last Post: August 12th, 07:17 AM
  2. Has everyone here been getting their e-mails o.k.?
    By Dee in forum Adobe Illustrator Macintosh
    Replies: 6
    Last Post: June 21st, 11:35 AM
  3. restructure mails
    By yls177 in forum Linux / Unix Administration
    Replies: 3
    Last Post: May 1st, 08:36 AM
  4. Mails
    By Coen Naninck in forum Macromedia Fireworks
    Replies: 2
    Last Post: September 12th, 01:10 PM
  5. mail() sending mails twice to the e-mails addresses at BCC
    By Maria Garcia Suarez in forum PHP Development
    Replies: 0
    Last Post: July 15th, 12:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139