OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: sql plugin could not connect to host localhost (occassional error)

From: Adhish Vyas (postfixeinfotek.com)
Date: Sat May 21 2005 - 17:22:54 CDT

mouss wrote:

> Adhish Vyas wrote:
>
>> mouss wrote:
>>
>>> Adhish Vyas wrote:
>>>
>>>> Occasionally, my server will send me mails from "Mail Delivery
>>>> System" with the subject "Postfix SMTP server: errors from
>>>> localhost.localdomain[127.0.0.1 <http://127.0.0.1>]"
>>>>
>>>> The body of the mail begin
>>>> Transcript of session follows.
>>>>
>>>> Out: 220 mail.someserver.com <http://mail.someserver.com> ESMTP
>>>> Postfix
>>>> In: EHLO localhost
>>>> Out: 250-mail.someserver.com <http://250-mail.someserver.com>
>>>> Out: 250-PIPELINING
>>>> Out: 250-SIZE 10240000
>>>> Out: 250-ETRN
>>>> Out: 250-AUTH LOGIN PLAIN
>>>> Out: 250-AUTH=3DLOGIN PLAIN
>>>> Out: 250 8BITMIME
>>>> In: MAIL FROM:<sp,epmesomeserver.com <mailto:epmesomeserver.com>>
>>>
>>>
>>>
>>>
>>> what's these addresses. use rfc821 syntax instead.
>>>
>>>> Out: 250 Ok
>>>> In: RCPT TO:<someonesomwhere.com <mailto:someonesomwhere.com>>
>>>>
>>>> At the same time, in my messages (log file..not maillog) I see the
>>>> following entries...
>>>>
>>>> sql plugin could not connect to host localhost
>>>> sql plugin could not connect to any host.
>>>
>>>
>>>
>>>
>>> replace localhost by 127.0.0.1 in your mysql config files and see if
>>> the problem persists.
>>>
>>>>
>>>> Any suggestions on why this is happening
>>>>
>>>
>>
>> Thanks for the reply....All the funky stuff in the mailserver name
>> and email address was added when i copy/pasted the email from
>> somwehere else. My fault for not checking the stuff.. Let me change
>> the localhost to 127.0.0.1 and see.
>
>
> you can also use
> hosts = localhost 127.0.0.1
> so that postfix first starts the unix socket and fallbacks to tcp in
> case of failure.
>
>>
>> Why should the problem only occur intermittently though? Shouldn't it
>> occur all the time if there was some problem b/w localhost & 127.0.0.1
>>
>
> some guesses:
>
> - your system has a broken implementation of unix sockets
>
> - your mysql stops responding under heavy load.
>
> - something restarts the mysql server from time to time (so you get
> the error when it is being started)
>

Mouss

Thanks for the suggestions. Will check on the Mysql load problem. That
seems to be the issue to me.

Adhish