Skip site navigation (1) Skip section navigation (2)

Re: I hava a problem in postgresql!

From: Roland Roberts <roland(at)rlenter(dot)com>
To: "ksp" <ksp(at)ms12(dot)url(dot)com(dot)tw>
Cc: <pgsql-docs(at)postgresql(dot)org>
Subject: Re: I hava a problem in postgresql!
Date: 2000-11-09 17:37:35
Message-ID: m23dh1vyg0.fsf@tycho.rlent.pnet (view raw or flat)
Thread:
Lists: pgsql-docs
>>>>> "ksp" == ksp  <ksp(at)ms12(dot)url(dot)com(dot)tw> writes:
    ksp> I am a tiro in the postgresql,I will use the PHP Function to
    ksp> connection postgresql.  I use the

    ksp> pg_connect ("localhost","5432","","","webmaster")

    ksp> The error message:
    ksp> warning: Unable to connect to PostgresSQL server: 
    ksp> FATAL 1: SetUserId: user 'nobody' is not in 'pg_shadow' in 
    ksp> 	/home/e0001cq/html/memo_postgre/memo_insert.php3 on line 2

You need to either (1) run createuser to add "nobody" to the pg_auth
table, or (2) add signon information to your pg_connect command.

If you are using PHP4, you can replace the above with

    pg_connect ("host=localhost port=5432 user=SOMEBODY password=PASSWD dbname=webmaster")

where SOMEBODY and PASSWD are appropriate for your installation.  If
you are not using password authentication, just omit that parameter.

roland
-- 
		       PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland(at)rlenter(dot)com                     76-15 113th Street, Apt 3B
rbroberts(at)acm(dot)org                          Forest Hills, NY 11375

In response to

Responses

pgsql-docs by date

Next:From: Christopher FarleyDate: 2000-11-09 19:38:36
Subject: JDBC Documentation
Previous:From: Oliver ElphickDate: 2000-11-09 17:19:41
Subject: Re: I hava a problem in postgresql!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group