Received: from elch.de.uu.net (elch.de.uu.net [192.76.144.55])
	by hub.org (8.9.3/8.9.3) with ESMTP id SAA54651
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 12 May 1999 18:54:05 -0400 (EDT) (envelope-from fischl@gmx.de)
Received: from sw.doc (pec-5-239.tnt1.m2.uunet.de [149.225.5.239]:1873)
	by elch.de.uu.net with ESMTP (5.65+:003/3.0.2)
	id AAA15440; Thu, 13 May 1999 00:52:27 +0200 (MET DST)
Received: from dochacker.doc (dochacker.doc [200.200.200.2])
	by sw.doc (8.8.8/8.8.8) with SMTP id AAA02040;
	Thu, 13 May 1999 00:57:09 +0200
Message-ID: <001401be9c00$bfc8e620$02c8c8c8@dochacker.doc>
Reply-To: "Fischl Anton" <fischl@gmx.de>
From: "Fischl Anton" <fischl@gmx.de>
To: "Ilhuicatzi Cortes J. Henry" <ic94006@solar6.ingenieria.uatx.mx>
Cc: <pgsql-interfaces@postgreSQL.org>
Subject: Re: 
Date: Wed, 12 May 1999 00:51:03 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4

The Problem is, that your WEB-Server (executing the Perl-script) tries to
connect to the Postgres-Server with his Username ("nobody").

Under Postgres, create the user "nobody", give him all the rights he need
and it should work.

-----Ursprüngliche Nachricht-----
Von: Ilhuicatzi Cortes J. Henry <ic94006@solar6.ingenieria.uatx.mx>
An: fischl@gmx.de <fischl@gmx.de>
Datum: Donnerstag, 13. Mai 1999 00:06


>Hi :
>
>  Im trying to run this CGI.
>
>#!/usr/bin/perl -w
>
>use Pg;
>
>
>print "Content-type: text/html\n\n";
>
>$database = "henric";
>$server = "iris1.ingenieria.uatx.mx";
>$conn = Pg::setdb($server,5432,'','',$database);
>$namedb = $conn->db;
>$error = $conn->errorMessage;
>
>print <<EOF;
><html>
><head><title>Resultados de Postgres</title></head>
><body>
><h1>Hola mundo</h1>
> Conectado a la base de datos: $namedb<br>
>EOF
>
>if ($error ne '') {
>   print "ERROR: ", $error;
>   print "</body></html>\n";
>   exit 1;
>  }
>
>print"Hasta aqui todo esta bien!!";
>print qq (
></body>
></html>);
>
>
> When type perl conexion.cgi <enter> i get the next result.
>
>iris1% perl conexion.cgi
>Content-type: text/html
>
><html>
><head><title>Resultados de Postgres</title></head>
><body>
> Conectado a la base de datos: henric<br>
>Hasta aqui todo esta bien!!
></body>
></html>iris1%
>
> I think that all it's O.K and then i try to run it in a browser and i
>get the next result.
>
>Conectado a la base de datos: henric
>ERROR: FATAL 1: SetUserId: user 'nobody' is not in 'pg_shadow'
>
>
>  What's wrong?
>
>
> Im using Pg in the new Style.
>
>
>Atte.
>Henry Ilhuicatzi Cortes
>Departamento de Ingenieria y Tecnologia
>Universidad Autonoma de Tlaxcala
>Mexico.
>