The error message:

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

Can you help me to solve the=20 problem?

May I use the right function = or right=20 syntax?

Thanks.

------=_NextPart_000_0048_01C04AAE.FFCC06E0-- From olly@lfix.co.uk Thu Nov 9 17:23:21 2000 Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA9HNLs65295 for ; Thu, 9 Nov 2000 12:23:21 -0500 (EST) (envelope-from olly@lfix.co.uk) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-31.mail.demon.net with esmtp (Exim 2.12 #1) id 13tvP0-0004uI-0V; Thu, 9 Nov 2000 17:22:18 +0000 Received: from lfix.co.uk (olly@localhost [127.0.0.1]) by linda.lfix.co.uk (8.11.1/8.11.1/Debian 8.11.0-6) with ESMTP id eA9HJg531162; Thu, 9 Nov 2000 17:19:43 GMT Message-Id: <200011091719.eA9HJg531162@linda.lfix.co.uk> X-Authentication-Warning: linda.lfix.co.uk: Host olly@localhost [127.0.0.1] claimed to be lfix.co.uk X-Mailer: exmh version 2.2 06/23/2000 (debian 2.2-1) with nmh-1.0.4+dev X-URL: http://www.lfix.co.uk/oliver X-face: "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F- KMLl*!h}B)u@TW|B}6 cc: pgsql-docs@postgresql.org Subject: Re: I hava a problem in postgresql! In-reply-to: Message from "ksp" of Fri, 10 Nov 2000 00:41:44 +0800. <004b01c04a6b$f2cdbee0$b401019b@marine> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Thu, 09 Nov 2000 17:19:41 +0000 From: "Oliver Elphick" X-Archive-Number: 200011/13 X-Sequence-Number: 16 "ksp" wrote: >I am a tiro in the postgresql,I will use the PHP Function to connection pos= >tgresql.I use the=20 >pg_connect("localhost","5432","","","webmaster") > >The error message: >warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId: user = >'nobody' is not in 'pg_shadow' in /home/e0001cq/html/memo_postgre/memo_inse= >rt.php3 on line 2 PostgreSQL users are not the same as system users. You have to create the user `nobody' in PostgreSQL (or tell PHP to connect as a different user). As user postgres, do: `createuser nobody' at the shell prompt and answer the questions. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "O death, where is thy sting? O grave, where is thy victory?" 1 Corinthians 15:55 From roland@rlenter.com Thu Nov 9 22:18:47 2000 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 From abhanja@cal.vsnl.net.in Sat Nov 11 08:34:03 2000 Received: from railmale.caltiger.com ([202.86.135.22]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAB8Y1s72942 for ; Sat, 11 Nov 2000 03:34:03 -0500 (EST) (envelope-from abhanja@cal.vsnl.net.in) Received: from cal.vsnl.net.in (dial879.caltiger.com [202.86.131.117]) by railmale.caltiger.com (8.11.1/8.11.1) with ESMTP id eAB8K1P25733 for ; Sat, 11 Nov 2000 13:50:02 +0530 (IST) Message-ID: <3A0CE640.67A29331@cal.vsnl.net.in> Date: Sat, 11 Nov 2000 11:55:04 +0530 From: Arup Bhanja Organization: nibbles|inter@ctive X-Mailer: Mozilla 4.74 [en] (Win95; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: Re: I hava a problem in postgresql! References: <004b01c04a6b$f2cdbee0$b401019b@marine> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/25 X-Sequence-Number: 28 > 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 In addition to Roland's suggestion : You will have to grant access to nobody after you create it as a user like: grant ALL on to nobody; type \h grant; in your pgsql monitor for the syntax Regards, Arup Bhanja - nibbles|inter@ctive Calcutta, INDIA. - nibbles@caltiger.com GRASP MixMedia Ad server demo: http://www.mystical-stuff.com/grasp/