Re:

From: "Fischl Anton" <fischl(at)gmx(dot)de>
To: "Ilhuicatzi Cortes J(dot) Henry" <ic94006(at)solar6(dot)ingenieria(dot)uatx(dot)mx>
Cc: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re:
Date: 1999-05-11 22:51:03
Message-ID: 001401be9c00$bfc8e620$02c8c8c8@dochacker.doc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)solar6(dot)ingenieria(dot)uatx(dot)mx>
An: fischl(at)gmx(dot)de <fischl(at)gmx(dot)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.
>

Browse pgsql-interfaces by date

  From Date Subject
Next Message ALWAR RAJAGOPALAN 1999-05-12 07:25:43
Previous Message Richard Trice 1999-05-11 21:26:54 HELP: DBI and Transactions?