Received: from astrofoto.org (roland-0.dsl.speakeasy.net [216.254.9.145]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA9MIls80455 for ; Thu, 9 Nov 2000 17:18:47 -0500 (EST) (envelope-from roland@astrofoto.org) Received: (from roland@localhost) by astrofoto.org (8.11.0/8.11.0) id eA9HbaA31996; Thu, 9 Nov 2000 12:37:36 -0500 To: "ksp" Cc: Subject: Re: I hava a problem in postgresql! References: <004b01c04a6b$f2cdbee0$b401019b@marine> Reply-To: roland@rlenter.com From: Roland Roberts Date: 09 Nov 2000 12:37:35 -0500 In-Reply-To: "ksp"'s message of "Fri, 10 Nov 2000 00:41:44 +0800" Message-ID: Lines: 27 X-Mailer: Gnus v5.7/Emacs 20.7 X-Archive-Number: 200011/16 X-Sequence-Number: 19 >>>>> "ksp" == ksp 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