Creating New User? - Mailing list pgsql-novice

From Cam Turner
Subject Creating New User?
Date
Msg-id 5.0.2.1.2.20010112170919.00b11b48@mail.we-create.com
Whole thread Raw
Responses Re: Creating New User?
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Ken Corey
Date:
Subject: Syntax highlighting for plpgsql (in VIM, even)?
Next
From: Rudy
Date:
Subject: ECPGconnect Error