From: Roland Roberts <roland@rlenter.com>
To: ksp <ksp@ms12.url.com.tw>
Cc: pgsql-docs@postgresql.org
Subject: Re: I hava a problem in postgresql!
Date: 09 Nov 2000 12:37:35 -0500
Message-ID: <m23dh1vyg0.fsf@tycho.rlent.pnet> (raw)
References: <004b01c04a6b$f2cdbee0$b401019b@marine>
>>>>> "ksp" == ksp <ksp@ms12.url.com.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@rlenter.com 76-15 113th Street, Apt 3B
rbroberts@acm.org Forest Hills, NY 11375
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: roland@rlenter.com, ksp@ms12.url.com.tw
Subject: Re: I hava a problem in postgresql!
In-Reply-To: <m23dh1vyg0.fsf@tycho.rlent.pnet>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox