Re: [Dovecot] MySQL database structure

2007/3/11, Erdenebat Gantomor rklogin@gmail.com:

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