Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C0F7C64FD32 for ; Thu, 31 Jul 2008 16:08:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87433-04 for ; Thu, 31 Jul 2008 16:08:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.157]) by postgresql.org (Postfix) with ESMTP id 5270C64FCCA for ; Thu, 31 Jul 2008 16:08:33 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so490667fgg.23 for ; Thu, 31 Jul 2008 12:08:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=DcQiUWnk5xto1qisbY9QU5GDIm6KbNd4ZVvWH0G2nN4=; b=syTv1fo97fDnDcqZVSx+si+u+uVf/JYKoA22KPugZM0FIte+wNz1ouJxQJq6vrjGzi TCiOT1dkfOUswMrG2tFGl/p6U7lZLXEeNAOdgUYU2V6DIGpGnMO7hy8I3stJFbJbFoG3 ep2w4yuU1aBq9jfs1t8PDW5ewvvza330EeOtk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=vQk1LKU30E6VT/Z4QNKnPxZ9A3gmyjXCKvpoBHCQHB59jcdEdipi36n7CV2tuXmYdZ efIExZRpEUOJpGPxg6oMFAhFWkmI2YbaiKOpVLLV8MOD8ogvJqEQUat68z4S8K7cZlVh AE06U+yrbCt0ENcM0aWk6KGWJWN0unTWYqu/k= Received: by 10.86.66.11 with SMTP id o11mr6441402fga.25.1217531311252; Thu, 31 Jul 2008 12:08:31 -0700 (PDT) Received: by 10.86.36.13 with HTTP; Thu, 31 Jul 2008 12:08:31 -0700 (PDT) Message-ID: <3a0028490807311208m687e37d5k11c7e72bfc1da5d@mail.gmail.com> Date: Thu, 31 Jul 2008 16:08:31 -0300 From: "Rafael Domiciano" To: "pgsql-admin@postgresql.org" Subject: Postgres User Can Login without a password MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_81106_19996902.1217531311249" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/234 X-Sequence-Number: 29844 ------=_Part_81106_19996902.1217531311249 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi there, I have a situation that is a bit strange. I discovered today that I can login in programs like EMS SQL Manager and in the internal software (via ODBC) without using the password for the user. Example: Configuration on the ODBC: datasource: postgres database: Postgres server: "IP" user: 123456 password: 123456 The software connect to the ODBC getting the configs of the data source. And when I clear the password in the ODBC the software continues to work, without a passwd error. I certified with the programers, and the software doesn't pass the password. So, reading a little bit, I discovered that possibly my pg_hba.conf is wrong. I tried to change the "auth-method", but or I couldn't connect to the base (if I pass the user and the passwd) or I connected without the passwd. If someone get a ideia of what to do in this case, would be greatful. Tnhks all, Rafael ------=_Part_81106_19996902.1217531311249 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi there,

I have a situation that is a bit strange.
I discovered today that I can login in programs like EMS SQL Manager and in the internal software (via ODBC) without using the password for the user.

Example:
Configuration on the ODBC:
datasource: postgres
database: Postgres
server: "IP"
user: 123456
password: 123456

The software connect to the ODBC getting the configs of the data source.
And when I clear the password in the ODBC the software continues to work, without a passwd error.
I certified with the programers, and the software doesn't pass the password.

So, reading a little bit, I discovered that possibly my pg_hba.conf is wrong.
I tried to change the "auth-method", but or I couldn't connect to the base (if I pass the user and the passwd) or I connected without the passwd.

If someone get a ideia of what to do in this case, would be greatful.

Tnhks all,

Rafael
------=_Part_81106_19996902.1217531311249--