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.
>
