ru.unix.bsd

 
 - RU.UNIX.BSD ------------------------------------------------------------------
 From : Andrey Lykhin                        2:5020/400     21 Sep 2006  05:06:39
 To : Alexander Kriventsov
 Subject : Re: postfix
 -------------------------------------------------------------------------------- 
 

 Thu Sep 21 2006 03:37, Alexander Kriventsov wrote to Andrey Lykhin:
 
  >> Hе могу понять, что не правильно настроено:
  AK> Скорее всего проблема где-то здесь:
  AK> virtual_mailbox_maps =
  AK> mysql:/usr/local/etc/postfix/mysql_virtual_mailbox_maps.cf
  AK> Покажи конфиг и пример из базы.
 
 user = postfixuser
 password = superpassword
 hosts = localhost
 dbname = postfix
 table = mailbox
 select_field = maildir
 where_field = username
 additional_conditions = and active = 1
 
 mysql> desc mailbox;
 
 +-------------+--------------+------+-----+---------------------+-------+
 | Field       | Type         | Null | Key | Default             | Extra |
 +-------------+--------------+------+-----+---------------------+-------+
 | username    | varchar(255) |      | PRI |                     |       |
 | password    | varchar(255) |      |     |                     |       |
 | name        | varchar(255) |      |     |                     |       |
 | maildir     | varchar(255) |      |     |                     |       |
 | quota       | varchar(255) |      |     |                     |       |
 | domain      | varchar(255) |      |     |                     |       |
 | create_date | datetime     |      |     | 0000-00-00 00:00:00 |       |
 | change_date | datetime     |      |     | 0000-00-00 00:00:00 |       |
 | active      | tinyint(4)   |      |     | 1                   |       |
 | enabled     | tinyint(4)   |      |     | 1                   |       |
 +-------------+--------------+------+-----+---------------------+-------+
 10 rows in set (0.00 sec)
 
 mysql> select * from mailbox where username='user@my.ru';
 
 +-------------+---------------+---------------------------+--------------+-----
 -----+--------+---------------------+---------------------+--------+---------+
 | username    | password      | name                      | maildir      |
 quota    | domain | create_date         | change_date         | active |
 enabled |
 +-------------+---------------+---------------------------+--------------+-----
 -----+--------+---------------------+---------------------+--------+---------+
 | user@my.ru  | rDrfGtEdgHft. | Supermailbox              | user@my.ru/  |
 50000000 |        | 0000-00-00 00:00:00 | 2006-09-21 08:20:09 |      1 |      
 1 |
 +-------------+---------------+---------------------------+--------------+-----
 -----+--------+---------------------+---------------------+--------+---------+
 1 row in set (0.00 sec)
 
 --- ifmail v.2.15dev5.3
  * Origin: FidoNet Online - http://www.fido-online.com (2:5020/400)
 
 

Вернуться к списку тем, сортированных по: возрастание даты  уменьшение даты  тема  автор 

Тема:    Автор:    Дата:    postfix   Andrey Lykhin   20 Sep 2006 09:52:36   Re: postfix   Alexander Kriventsov   21 Sep 2006 03:37:14   Re: postfix   Andrey Lykhin   21 Sep 2006 05:06:39   Re: postfix   Alexander Kriventsov   21 Sep 2006 16:08:16   Re: postfix   Andrey Lykhin   27 Sep 2006 13:38:40