maildrop nedorucuje pro aliasy v mysql

Petr Pomajbík nexx na securitynet.cz
Středa Prosinec 22 10:51:06 CET 2004



[cyber na mail:~] 09:50:56 # cat /etc/maildrop/maildropmysql.config

> hostname 127.0.0.1
> port 3306
> database postfix
> dbuser *********
> dbpw *********
> dbtable postfix_users
> default_uidnumber 5000
> default_gidnumber 5000
> uid_field email
> uidnumber_field uid
> gidnumber_field gid
> maildir_field maildir
> homedirectory_field homedir
> quota_field quota
> mailstatus_field postfix
> where_clause and postfix='y'
>
>
> mysql> describe postfix_users;
> +----------+------------------+------+-----+---------+----------------+
> | Field    | Type             | Null | Key | Default | Extra          |
> +----------+------------------+------+-----+---------+----------------+
> | id       | int(11) unsigned |      | PRI | NULL    | auto_increment |
> | email    | varchar(128)     |      | UNI |         |                |
> | crypt    | varchar(128)     |      |     |         |                |
> | clear    | varchar(128)     |      |     |         |                |
> | name     | tinytext         |      |     |         |                |
> | uid      | int(11) unsigned |      |     | 5000    |                |
> | gid      | int(11) unsigned |      |     | 5000    |                |
> | homedir  | tinytext         |      |     |         |                |
> | maildir  | tinytext         |      |     |         |                |
> | quota    | tinytext         |      |     |         |                |
> | access   | enum('Y','N')    |      |     | Y       |                |
> | postfix  | enum('Y','N')    | YES  |     | Y       |                |
> | antispam | enum('Y','N')    | YES  |     | Y       |                |
> +----------+------------------+------+-----+---------+----------------+
> 13 rows in set (0.00 sec)
>
> jenze aliasy mam jinde a jak donutit maildrop rozlisovat co je alias a
> co ne ? a co ma potom delat
>
> diky
>     Petr

pokud nedorucuje emaily vubec, tak zkus zmenit v DB :
| postfix  | enum('y','n')  jinak moc nerozumim otazce... pro alias je v 
DB jeste dalsi tabulka, ne..?

...



Další informace o konferenci Linux