mouss wrote: > J. Bakshi wrote: >> Hello all, >> >> Hope you all are well. >> >> I have found a problem with my 1+1/2 months old mail server here. Some >> times I get an error as below during sending email to an account as >> "temporary lookup problem" >> >> ~~~~~~~~~~~~~~~`` >> postfix/trivial-rewrite[13203]: fatal: >> mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf(0,lock|fold_fix): >> table lookup problem >> ~~~~~~~~~~~~~~~~~~~ >> >> After waiting a min. or so the problem fixed automatically and I can >> send email to that particular account. >> >> what is actually going inside my server or Mysql ? Any clue >> > > too many mysql conections? use proxymap: > > foo_maps = proxy:mysql:/etc/.... > >
Hello mouss, hope you are well, thanks for your kind response. shall I use proxy in all the maps option. I like to be confirmed as it is a production server. The settings for virtual user and domains where you suggestion fits is ######################################### ## virtual domain setting ######################################### virtual_alias_domains = hash:/etc/postfix/virtual virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf,mysql:/etc/postfix/mysql-email2email.cf virtual_gid_maps = static:5000 virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf virtual_transport = dovecot virtual_uid_maps = static:5000 ~~~~~~~~~~~~~~~~~~~~~~~~~ shall I add the proxy in the maps options ? Thanks once again. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Joydeep Bakshi, Linux System Admin Kolkatainfoservices Pvt Ltd, 23A Royd Street, Kolkata 700016, India Work Phone 91 033 40014784 http://infoservices.in/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~