Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (CentOS 6.2 x

Discussion in 'HOWTO-Related Questions' started by dexterd, Mar 1, 2012.

  1. dexterd

    dexterd New Member

    Hello,
    Thank you for a really useful guide!

    I'm wondering what changes would be needed to use ViMbAdmin(PostfixAdmin replacement) to administrate mail server created in this guide?

    On https://github.com/opensolutions/ViMbAdmin/wiki/Postfix-and-MySQL-Integration I've found general instructions for the integration.

    I suppose in ViMbAdmin integration guide that mail store is Maildir or mbox, not the mysql database. Correct?

    Finally, is ISPConfig3 better solution than ViMbAdmin in this case?
     
    Last edited: Mar 1, 2012
  2. falko

    falko Super Moderator Howtoforge Staff

    I can't say anything about ViMbAdmin, but ISPConfig won't work with this setup. You must set up your server according to one of these guides: http://www.ispconfig.org/ispconfig-3/documentation/
     
  3. dexterd

    dexterd New Member

    Since there's similar guide with PostfixAdmin, do you maybe plan one with ViMbAdmin? I'll be happy to help.

    In ViMbAdmin there are only those MySQL mappings:

    virtual_alias_maps = mysql:/etc/postfix/mysql/virtual_alias_maps.cf
    virtual_mailbox_domains = mysql:/etc/postfix/mysql/virtual_domains_maps.cf
    virtual_mailbox_maps = mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf

    Database is created during installation, and differs slightly from one in your guide:

    +---------------------+
    | Tables_in_vimbadmin |
    +---------------------+
    | admin |
    | alias |
    | config |
    | domain |
    | domain_admin |
    | log |
    | mailbox |
    | token |
    +---------------------+

    i.e.

    domains -> domain
    forwardings -> alias
    users -> mailbox

    You noted transport table is optional, so we can ignore it.

    For mysql-virtual_mailbox_limit_maps.cf there is 'quota' in mailbox table.

    Looks like it's only mappings file names and postfix configuration part(postconf -e) change needed.

    What do you think?
     

Share This Page