X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DB9739FA0EC for ; Thu, 6 Jul 2006 18:27:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 75632-03 for ; Thu, 6 Jul 2006 18:27:43 -0300 (ADT) X-Greylist: delayed 00:13:14.474257 by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id DDAF99F94F3 for ; Thu, 6 Jul 2006 18:27:42 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id l37so3065nfc for ; Thu, 06 Jul 2006 14:27:38 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=googlemail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=D7QYg+GtTjS1IAskhEme6Or2Ji2bNhMdSoypTWSMhaY26GkckUrnMIpxApVGuB4nYA2QSy+jaPsx3nbRX80CRfP6Rpr0/fZjB9Aa8luIzUI6T72bKxXVnTno1HZ5F0nV5GPt4ZHuYC1PwXZzJEcWxcx3GJ8H5o6kCPT0PvmR6x8= Received: by 10.78.185.7 with SMTP id i7mr406477huf; Thu, 06 Jul 2006 14:14:26 -0700 (PDT) Received: by 10.78.35.18 with HTTP; Thu, 6 Jul 2006 14:14:25 -0700 (PDT) Message-ID: Date: Thu, 6 Jul 2006 23:14:25 +0200 From: "Moritz Bayer" To: pgsql-admin@postgresql.org Subject: Need Help with Logfile Entry MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_44424_826329.1152220465933" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/37 X-Sequence-Number: 22283 ------=_Part_44424_826329.1152220465933 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello List, I've installed postgres 8.1 and using a cluster which holds a database db_mail. It suppose to work with postfix and sasl-auth, but for some reason it doesn't work. I think Sasl-auth is trying to connect to the db, the logfile shows the following entry after a postfix-sasl-auth connection attempt: 2006-07-06 23:07:50 CESTLOG: connection received: host=127.0.0.1 port=51228 2006-07-06 23:07:50 CESTDEBUG: forked new backend, pid=4309 socket=6 2006-07-06 23:07:50 CESTLOG: connection received: host=127.0.0.1 port=51229 2006-07-06 23:07:50 CESTDEBUG: forked new backend, pid=4310 socket=6 2006-07-06 23:07:50 CESTLOG: connection received: host=127.0.0.1 port=51230 2006-07-06 23:07:50 CESTDEBUG: forked new backend, pid=4311 socket=6 2006-07-06 23:07:50 CESTLOG: connection received: host=127.0.0.1 port=51231 2006-07-06 23:07:50 CESTDEBUG: forked new backend, pid=4312 socket=6 2006-07-06 23:07:50 CESTLOG: connection received: host=127.0.0.1 port=51232 2006-07-06 23:07:50 CESTDEBUG: forked new backend, pid=4313 socket=6 2006-07-06 23:07:50 CESTLOG: connection received: host=127.0.0.1 port=51233 2006-07-06 23:07:50 CESTDEBUG: forked new backend, pid=4314 socket=6 2006-07-06 23:07:50 CESTLOG: connection received: host=127.0.0.1 port=51234 2006-07-06 23:07:50 CESTDEBUG: forked new backend, pid=4315 socket=6 2006-07-06 23:07:50 CESTLOG: connection received: host=127.0.0.1 port=51235 2006-07-06 23:07:50 CESTDEBUG: forked new backend, pid=4316 socket=6 2006-07-06 23:07:50 CESTLOG: connection received: host=127.0.0.1 port=51236 2006-07-06 23:07:50 CESTDEBUG: forked new backend, pid=4317 socket=6 Does anyone know, if the received connection is established? I have set the log level high enough, that there should be an entry of the query asking for the users password. But there is none. Can anybody tell me why the connections aren't used? Thanks in advance, Mo ------=_Part_44424_826329.1152220465933 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hello List,


I've installed postgres 8.1 and using a cluster which holds a database db_mail. It suppose to work with postfix and sasl-auth, but for some reason it doesn't work.
I think Sasl-auth is trying to connect to the db, the logfile shows the following entry after a postfix-sasl-auth connection attempt:

2006-07-06 23:07:50 CESTLOG:  connection received: host=127.0.0.1 port=51228
2006-07-06 23:07:50 CESTDEBUG:  forked new backend, pid=4309 socket=6
2006-07-06 23:07:50 CESTLOG:  connection received: host= 127.0.0.1 port=51229
2006-07-06 23:07:50 CESTDEBUG:  forked new backend, pid=4310 socket=6
2006-07-06 23:07:50 CESTLOG:  connection received: host=127.0.0.1 port=51230
2006-07-06 23:07:50 CESTDEBUG:  forked new backend, pid=4311 socket=6
2006-07-06 23:07:50 CESTLOG:  connection received: host=127.0.0.1 port=51231
2006-07-06 23:07:50 CESTDEBUG:  forked new backend, pid=4312 socket=6
2006-07-06 23:07:50 CESTLOG:  connection received: host=127.0.0.1 port=51232
2006-07-06 23:07:50 CESTDEBUG:  forked new backend, pid=4313 socket=6
2006-07-06 23:07:50 CESTLOG:  connection received: host= 127.0.0.1 port=51233
2006-07-06 23:07:50 CESTDEBUG:  forked new backend, pid=4314 socket=6
2006-07-06 23:07:50 CESTLOG:  connection received: host=127.0.0.1 port=51234
2006-07-06 23:07:50 CESTDEBUG:  forked new backend, pid=4315 socket=6
2006-07-06 23:07:50 CESTLOG:  connection received: host=127.0.0.1 port=51235
2006-07-06 23:07:50 CESTDEBUG:  forked new backend, pid=4316 socket=6
2006-07-06 23:07:50 CESTLOG:  connection received: host=127.0.0.1 port=51236
2006-07-06 23:07:50 CESTDEBUG:  forked new backend, pid=4317 socket=6


Does anyone know, if the received connection is established?  I have set the log level high enough, that there should be an entry of the query asking for the users password. But there is none. Can anybody tell me why the connections aren't used?

Thanks in advance,
Mo
------=_Part_44424_826329.1152220465933--