[Web-cyradm] Password length and max # of MySQL connections

[Robo Kupka]

Thank you for help.
Just one note:  I use mysql-canonical, mysql-virtual and
mysql-mydestination maps from MySQL. I don´t use mysql-transport map.

I tried to add all these 3 maps into proxy configuration but postfix
failet to start.

I switched mysql-mydestination back to old behavior (without proxy) and
Postfix now works OK, olny canonical and virtual maps are proxied.
Does it matter if the line "proxy_read_maps= proxy:unix:passwd.byname" is
somewhere after "my_destination" line in main.cf ?

Robert

>> 2. I had to set max-connections parameter for MySQL startup, because
>> default value "100" caused a lot unsuccessful logins into
>> IMAP and POP3
>> daemons (PAM logger reported this: "MySQL:too many
>> connections"). IS there
>> a better workaround of this ?
>
> I don't know about the rest but this worked for me on too many
> connections error configure proxymap
> http://www.postfix.org/proxymap.8.html
> 	To consolidate the number of open lookup tables  by
>     sharing  one  open  table among multiple processes.
>     For example, making mysql  connections  from  every
>     Postfix daemon process results in "too many connec-
>     tions" errors. The solution:
>
> proxy_read_maps= proxy:unix:passwd.byname
>         proxy:mysql:/etc/postfix/mysql-virtual.cf
>         proxy:mysql:/etc/postfix/mysql-transport.cf
> virtual_maps = proxy:mysql:/etc/postfix/mysql-virtual.cf
> transport_maps = proxy:mysql:/etc/postfix/mysql-transport.cf


-- 
Robert Kupka