Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can't change password?

Can't change password?

From
Eric Scott
Date:
Heya;
I have PostGreSQL 7.3.4 on Mandrake Linux 9.2.  For some reason Webmin,
when I tell it to change the password of a pgsql user, acts like it's
working, but still leaves "requires password" set to "no."  I've tried
running psql and executing "ALTER USER [username] WITH PASSWORD
'[password]'" with the same results.  It gives no error messages... but
apparently the user still has no password.
I'm writing a C# program that accesses the database, and authentication
fails basically no matter what I try.

Any help?  I'm stumped.
       Thanx in advance,
             Sigma

--
Registered Linux Freak #: 366,862

Red Hat Linux Fedora 2 x86/Athlon (Primary Workstation, this comp)
Debian GNU/Linux 3.1 PPC/604e (Secondary Workstation)
Mandrake Linux 9.2 x86/AthlonXP (Server)
Spyro's Linux port ARM/XScale (PDA)

'For the eyes of the Lord range throughout the earth to strengthen those whose hearts are fully commited to him.'
    2 Chronicles 16:9a

Re: Can't change password?

From
Pierre-Frédéric Caillaud
Date:
    Is your authentication set to "Trust" in the config files ?

On Fri, 31 Dec 2004 08:45:34 -0600, Eric Scott <scottclansman@cwazy.co.uk>
wrote:

> Heya;
> I have PostGreSQL 7.3.4 on Mandrake Linux 9.2.  For some reason Webmin,
> when I tell it to change the password of a pgsql user, acts like it's
> working, but still leaves "requires password" set to "no."  I've tried
> running psql and executing "ALTER USER [username] WITH PASSWORD
> '[password]'" with the same results.  It gives no error messages... but
> apparently the user still has no password.
> I'm writing a C# program that accesses the database, and authentication
> fails basically no matter what I try.
>
> Any help?  I'm stumped.
>        Thanx in advance,
>              Sigma
>

Re: Can't change password?

From
Eric Scott
Date:
Pierre-Frédéric Caillaud wrote:

>
>     Is your authentication set to "Trust" in the config files ?
>
> On Fri, 31 Dec 2004 08:45:34 -0600, Eric Scott
> <scottclansman@cwazy.co.uk>  wrote:
>
>> Heya;
>> I have PostGreSQL 7.3.4 on Mandrake Linux 9.2.  For some reason
>> Webmin,  when I tell it to change the password of a pgsql user, acts
>> like it's  working, but still leaves "requires password" set to
>> "no."  I've tried  running psql and executing "ALTER USER [username]
>> WITH PASSWORD  '[password]'" with the same results.  It gives no
>> error messages... but  apparently the user still has no password.
>> I'm writing a C# program that accesses the database, and
>> authentication  fails basically no matter what I try.
>>
>> Any help?  I'm stumped.
>>        Thanx in advance,
>>              Sigma
>>

Yes.  I have the same pg_hba.conf setup for host permissions as on my
Fedora 2 box, which doesn't have the same problem.
Help!

Sigma

--
Registered Linux Freak #: 366,862

Red Hat Linux Fedora 2 x86/Athlon (Primary Workstation, this comp)
Debian GNU/Linux 3.1 PPC/604e (Secondary Workstation)
Mandrake Linux 9.2 x86/AthlonXP (Server)
Spyro's Linux port ARM/XScale (PDA)

'For the eyes of the Lord range throughout the earth to strengthen those whose hearts are fully commited to him.'
    2 Chronicles 16:9a