From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Postgres User Can Login without a password
Date: Thu, 31 Jul 2008 16:08:31 -0300
Message-ID: <3a0028490807311208m687e37d5k11c7e72bfc1da5d@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rafael.domiciano@gmail.com
Subject: Re: Postgres User Can Login without a password
In-Reply-To: <3a0028490807311208m687e37d5k11c7e72bfc1da5d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox