OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: POSTFIX+MySQL+VIRTUAL+MAPS

From: Matt (elitescripts2000yahoo.com)
Date: Mon Aug 01 2005 - 15:28:52 CDT


I suggest making the gid and uid static since they will most likely be postfix
users uid anyways. That way it makes less mysql query look ups. postfix/mysql
mkes a lot of queries per email processed.

--- Stefan Stoyanov <stefbnt.bg> wrote:

> Hi Everybody
>
> I need your help about Postfix with mysql+sasl+virtual+maps support under
> OpenBSD 3.7. first I download virtual patch from
> http://web.onda.com.br/nadal/postfix/VDA/postfix-2.2.5-vda.patch.gz
> then I successfully patch my source and compile install postfix from
> /usr/ports with this command:
> cd /usr/ports/mail/postfix/stable && env FLAVOR="sasl2 mysql" make install
> clean
>
> in /etc/postfix/main.cf I have this
> local_transport = virtual
> virtual_mailbox_base = /mail
> virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-maps.cf
> virtual_uid_maps = mysql:/etc/postfix/mysql-virtual-uid.cf
> virtual_gid_maps = mysql:/etc/postfix/mysql-virtual-gid.cf
> alias_maps = mysql:/etc/postfix/mysql-aliases.cf
> relocated_maps = mysql:/etc/postfix/mysql-relocated.cf
> transport_maps = mysql:/etc/postfix/mysql-transport.cf
> virtual_maps = mysql:/etc/postfix/mysql-virtual.cf
> check_helo_access = mysql:/etc/postfix/mysql-client.cf
>
>
> when i start postfix in my maillog file i see this
>
>
> postfix/virtual[2413]: fatal: open /etc/postfix/mysql-virtual-maps.cf: No
> such file or directory
> postfix/master[1809]: warning: process /usr/lib/postfix/virtual pid 29619
> exit status 1
> postfix/master[1809]: warning: /usr/lib/postfix/virtual: bad command
> startup -- throttling
>
>
> this file mysql-virtual-maps.cf already exist in /etc/postfix directory
>
> can anybody help me to resolv this problem
>
>
> sorry for my bad english
>