Thread: Passwords problems

Hi :)

I have funny problem, which i don't understand. I'm adding new users to
PostgreSQL with some password (for example : "aaaaaa") and i can't log
in any database. But after that i change password to "bbbbbb" and i can
log in. Some passwords are good, and some are bad. And it depends on
user too (for one user "aaaaaa" is good, and for another it is not).

I'm working on ubuntu on version postgres8.0.3-15ubuntu2.2

Can anyone help me? :)

Michael

On Jul 11, 2006, at 7:43 AM, zordax wrote:

> I have funny problem, which i don't understand. I'm adding new
> users to PostgreSQL with some password (for example : "aaaaaa") and
> i can't log in any database. But after that i change password to
> "bbbbbb" and i can log in. Some passwords are good, and some are
> bad. And it depends on user too (for one user "aaaaaa" is good, and
> for another it is not).

What tool are you using to create users/passwords? If you are using a
GUI tool, have you tried to replicate the problem using psql?


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

On Jul 12, 2006, at 4:24 AM, zordax wrote:

>>
>> What tool are you using to create users/passwords? If you are
>> using a GUI tool, have you tried to replicate the problem using psql?
>
>
> After a while i think it might be a problem of tool. Because i can
> login by psql. But i have this effect with psycopg.


Maybe it is an issue with uncommitted transactions. Have you checked
that there is no active transaction after you make your changes?


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL