Creating New User?

From: Cam Turner <cam(at)we-create(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Creating New User?
Date: 2001-01-12 21:59:56
Message-ID: 5.0.2.1.2.20010112164348.00ade870@mail.we-create.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<html>
Hi All,<br>
<br>
Well the List archives search isn't returning results for me so I've got
a quick question:<br>
<br>
I've got pgsql installed on a debian linux&nbsp; 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:<br>
<br>
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<br>
Error - /var/www/phpPgAdmin/index.php<br>
PostgreSQL said: Unable to connect to server<br>
<br>
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.<br>
<br>
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.<br>
<br>
Thanks in advance,<br>
<br>
Cam<br>
<br>
<br>
<br>
<x-sigsep><p></x-sigsep>
<font color="#000080"><b>Cameron Turner, Developer &amp; Systems
Support<br>
</font>We-Create Inc <br>
</b>Internet &amp; Multimedia<br>
<br>
<font size=2 color="#000080">Cell:</font><font size=2 color="#0000FF">
</font><font size=2 color="#800000">519.897.4409<br>
</font><font size=2 color="#000080">Office:</font><font size=2 color="#0000FF"> </font><font size=2 color="#800000">519.745.7374<br>
</font><font size=2 color="#000080">Fax:</font><font size=2 color="#0000FF"> </font><font size=2 color="#800000">519.745.9963<br>
</font><font size=2 color="#000080">Toll Free:</font><font size=2 color="#0000FF"> </font><font size=2 color="#800000">888.615.7374<br>
</font><font size=2 color="#000080">Web:</font><font size=2 color="#0000FF"> </font><a href="http://www.we-create.com/" eudora="autourl"><font size=2 color="#800080"><u>www.we-create.</a><a href="http://www.we-create.com/" eudora="autourl">com</a></u></font> <br>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.9 KB

Browse pgsql-novice by date

  From Date Subject
Next Message Cam Turner 2001-01-12 22:09:22 Creating New User?
Previous Message Ken Corey 2001-01-12 18:08:49 Syntax highlighting for plpgsql (in VIM, even)?