In Postfix+Postfixadmin+Dovecot+SASL+MySQL case what is the best and
compact MySQL database structure for storing all configuration? What
will you suggest me guys? I've already installed postfixadmin and I'm
confusing (actually my experience is not enough) extending and
organizing my database for postfix+dovecot. Please give me some quick tips.
--

In /etc/dovecot/dovecot-sql.conf you can see the sample structure with the minimum required fields:

# CREATE TABLE users (
#     userid VARCHAR(128) NOT NULL,
#     password VARCHAR(64) NOT NULL,
#     home VARCHAR(255) NOT NULL,
#     uid INTEGER NOT NULL,
#     gid INTEGER NOT NULL,
#     active CHAR(1) DEFAULT 'Y' NOT NULL
# );

In my case I changed to use always the same userid and groupid, so that fields are not needed,  and if you plan to use virtual domains, you will need to split userid to separate into id and domain.

Cheers


Best regards,

Erdenebat Guntomor/                   /mailto:RkLogin@gmail.com