Skip site navigation (1) Skip section navigation (2)

Postgres User Can Login without a password

From: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Postgres User Can Login without a password
Date: 2008-07-31 19:08:31
Message-ID: 3a0028490807311208m687e37d5k11c7e72bfc1da5d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-08-01 01:39:59
Subject: Re: Postgres User Can Login without a password
Previous:From: Tom LaneDate: 2008-07-31 15:48:32
Subject: Re: restore balloons db size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group