Re: [gentoo-user] problem with mail server

[Marcin Niskiewicz <mniskiewicz@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 2160 bytes --]

2009/2/3 kashani <kashani-list@badapple.net>

>
>>
> I think you've got a couple of problems, but none of them individually jump
> at as the cause of your problems. However making these three changes
> together might help.
>
> 1. Turn your max_user_connections in Mysql down to something sane. Default
> is 100 which is fine unless you're also running a web app against the same
> Mysql instance.
>
> 2. Use proxy in your Mysql connections from Postfix.
> Postfix can be configured to open a connection to Mysql and keep it open.
> Basically acts a connection pool and keep Postfix from opening hundreds of
> connections to Mysql on a very busy server. I recommend *always* using the
> proxy: statement anytime you're connecting to Mysql from Postfix. Your new
> transport_map statement will look like this.
>
> transport_maps =  proxy:mysql:/etc/mail/sql/mysql-transport.cf
>
> Generally you shouldn't be running into connection issues because you're
> hitting Mysql on localhost which means it'll default to a socket connection.
> It's possible that opening a new session is taking to too long occasionally
> and using proxy should alleviate that.
>
> 3. You're using Postfix 2.1 or earlier query syntax.
> Hell it might even be Postfix 1.x syntax. This is the new syntax for
> Postfix 2.2 or better. This really isn't a problem, but the new syntax is
> far more powerful and suspect bugs that creep into the parser around old
> syntax aren't noticed or getting fixed.
>
> user = postfix
> password = password
> hosts = localhost
> dbname = maildb
> query = SELECT destination FROM domain WHERE domain='%s'
>
> I'm not sure what how-to you've been using, but I'd look at a few others to
> see some of the other options available. The one you're using seems to be
> pretty far out of date. While not wrong in any way it isn't taking full
> advantage of the last seven years of updates in Postfix.
>
> kashani
>
> thank You for Your response
I switch all of mysql connections to proxy and I'll be watching if it helps.
You're right - syntax of my configs were ancient - so I set them right.

thank You again
I hope it's solutions to my problems

regards
nichu

[-- Attachment #2: Type: text/html, Size: 2825 bytes --]