From: | "rob" <rob(at)cabrion(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org>, "Cam Turner" <cam(at)we-create(dot)com> |
Subject: | Re: Creating New User? |
Date: | 2001-01-13 14:27:13 |
Message-ID: | 002301c07d6c$ec4e5370$4100fd0a@cabrion.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'm not positive, but the problem appears to be phpPgAdmin or it's configuration. 'password=' is almost certainly not a valid username. Perhaps you just need to review the config file(s)? Have you tried logging in on the local database machine with psql?
--rob
----- Original Message -----
From: Cam Turner
To: pgsql-novice(at)postgresql(dot)org
Sent: Friday, January 12, 2001 5:09 PM
Subject: Creating New User?
Hi All,
Well the List archives search isn't returning results for me so I've got a quick question:
I've got pgsql installed on a debian linux system and I'm trying to add a user so that I can login with phpPgAdmin and begin playing with it. But phpPgAdmin keeps saying:
Warning: Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password=' is not in 'pg_shadow' in /var/www/phpPgAdmin/lib.inc.php on line 130
Error - /var/www/phpPgAdmin/index.php
PostgreSQL said: Unable to connect to server
I turned off Advanced Auth in phpPgAdmin and logged in (as the postgres user?) I created a user and it seemed to work fine. When I output the contents of the pg_shadow file (via cat) it listed data that I had put in.
But I'm not able to log in as any of the users i create... I think I'm creating users incorrectly (passwords in pg_shadow are stored plain text). Help.
Thanks in advance,
Cam
Cameron Turner, Developer & Systems Support
We-Create Inc
Internet & Multimedia
Cell: 519.897.4409
Office: 519.745.7374
Fax: 519.745.9963
Toll Free: 888.615.7374
Web: www.we-create.com
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2001-01-13 15:58:18 | Re: Creating New User? |
Previous Message | Rudy | 2001-01-12 23:05:35 | ECPGconnect Error |