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
Lonni J Friedman
Date:
Increase logging, and check the log for errors.


On Thu, 30 Dec 2004 23:44:51 -0600, Eric Scott <scottishbug@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


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       http://netllama.linux-sxs.org