Re: Can't change password?

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(at)cwazy(dot)co(dot)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