Postgres Pro
Downloads
Home   >   mailing lists

Thread: Regression Test Fails

Regression Test Fails

From
"Julio Cuz, Jr."
Date:
Hi--

This is my first e-mail to this list :)

I just installed Postgresql on Red Hat Linux 7 and when I try to run the
'Regression Test', I get this error:

psql:  FATAL 1:  SetUserId: user 'username' is not in 'pg_shadow'
createdb failed...

Help !

Julio Cuz, Jr.
Riverside Community College
jcuz@rccd.cc.ca.us

Re: Regression Test Fails

From
Steve Bern
Date:
1) you need to set the regression test to use a username that's defined to
postgres.  It looks like it's currently using user 'username'.  Out of the
box, you can set this to postgres if you did the default RPM install, or
installed right from RH7.  Postgres is, of course, the superuser of the
database.  So you'll need to edit the regression test and replace
'username' with 'postgres' and possibly add a password, depending on how
your pg_hba is set up.

2) do a man on pg_passwd to see how to setup users for postgresql -- note
particularly how the pg_hba.conf file is used.

3) You'll need to familiarize yourself with how authentication is done
to the database.  Read/edit /var/lib/pgsql/data/pg_hba.conf.  There are
instructions on how to do this in the file itself.  Then restart postgres
(/etc/rc.d/init.d/postgresql restart) (not sure if actually need to do
this, but won't hurt anything).  This is how you set up access.

On Thu, 4 Jan 2001, Julio Cuz, Jr. wrote:

> Hi--
>
> This is my first e-mail to this list :)
>
> I just installed Postgresql on Red Hat Linux 7 and when I try to run the
> 'Regression Test', I get this error:
>
> psql:  FATAL 1:  SetUserId: user 'username' is not in 'pg_shadow'
> createdb failed...
>
> Help !
>
> Julio Cuz, Jr.
> Riverside Community College
> jcuz@rccd.cc.ca.us
>

pg_shadow???

From
"Julio Cuz, Jr."
Date:
Hi--

I'm getting this error:

"Warning: Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password=' is not in 'pg_shadow' in /usr/local/apache/htdocs/phpPgAdmin/lib.inc.php on line 130
Error - /usr/local/apache/htdocs/phpPgAdmin/index.php
PostgreSQL said: Unable to connect to server"

Any ideas?

Julio Cuz, Jr.
Riverside Community College
jcuz@rccd.cc.ca.us

Re: pg_shadow???

From
Louis Bertrand
Date:
Looks like a syntax problem with your call to pg_connect().
What your source look like?

Ciao
 --Louis  <louis@bertrandtech.on.ca>

Louis Bertrand       http://www.bertrandtech.on.ca/
Bertrand Technical Services, Bowmanville, ON, Canada
Tel: +1.905.623.1500  Fax: +1.905.623.3852

OpenBSD: Secure by default.  http://www.openbsd.org/

On Thu, 4 Jan 2001, Julio Cuz, Jr. wrote:

> Hi--
>
> I'm getting this error:
>
> "Warning: Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user
> 'password=' is not in 'pg_shadow' in
> /usr/local/apache/htdocs/phpPgAdmin/lib.inc.php on line 130
> Error - /usr/local/apache/htdocs/phpPgAdmin/index.php
> PostgreSQL said: Unable to connect to server"
>
> Any ideas?
>
> Julio Cuz, Jr.
> Riverside Community College
> jcuz@rccd.cc.ca.us

Re: pg_shadow???

From
Steve Bern
Date:
Read the install directions, specifically bullet point 2.

On Thu, 4 Jan 2001, Julio
Cuz, Jr. wrote:

> Hi--
>
> I'm getting this error:
>
> "Warning: Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user
> 'password=' is not in 'pg_shadow' in
> /usr/local/apache/htdocs/phpPgAdmin/lib.inc.php on line 130
> Error - /usr/local/apache/htdocs/phpPgAdmin/index.php
> PostgreSQL said: Unable to connect to server"
>
> Any ideas?
>
> Julio Cuz, Jr.
> Riverside Community College
> jcuz@rccd.cc.ca.us

Re: pg_shadow???

From
"Julio Cuz, Jr."
Date:
Fixed!  Thanks anyway!

At 10:04 PM 1/4/2001 -0500, Louis Bertrand wrote:
>Looks like a syntax problem with your call to pg_connect().
>What your source look like?
>
>Ciao
>  --Louis  <louis@bertrandtech.on.ca>
>
>Louis Bertrand       http://www.bertrandtech.on.ca/
>Bertrand Technical Services, Bowmanville, ON, Canada
>Tel: +1.905.623.1500  Fax: +1.905.623.3852
>
>OpenBSD: Secure by default.  http://www.openbsd.org/
>
>On Thu, 4 Jan 2001, Julio Cuz, Jr. wrote:
>
> > Hi--
> >
> > I'm getting this error:
> >
> > "Warning: Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user
> > 'password=' is not in 'pg_shadow' in
> > /usr/local/apache/htdocs/phpPgAdmin/lib.inc.php on line 130
> > Error - /usr/local/apache/htdocs/phpPgAdmin/index.php
> > PostgreSQL said: Unable to connect to server"
> >
> > Any ideas?
> >
> > Julio Cuz, Jr.
> > Riverside Community College
> > jcuz@rccd.cc.ca.us


Julio Cuz, Jr.
Riverside Community College
jcuz@rccd.cc.ca.us