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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])