2007/3/11, Erdenebat Gantomor <rklogin at
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 at gmail.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20070312/223f8eb0/attachment-0002.html>