RE: (No subject - Perl CGI PostgreSQL) - Mailing list pgsql-interfaces

From Craig Orsinger
Subject RE: (No subject - Perl CGI PostgreSQL)
Date
Msg-id XFMail.990512121742.orsingerc@epg-gw1.lewis.army.mil
Whole thread Raw
In response to ...  (ic94006@solar6.ingenieria.uatx.mx (Ilhuicatzi Cortes J. Henry))
List pgsql-interfaces
On 12-May-99 Ilhuicatzi Cortes J. Henry wrote:
> 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' 
       Looks like you need to run the PostgreSQL "createuser"
utility to create an entry for "nobody". Then you'll have to
give "nobody" read access to the data the web page is accessing.

> 
> 
>   What's wrong?
> 
> 
>  Im using Pg in the new Style.
> 
> 
> Atte.
> Henry Ilhuicatzi Cortes
> Departamento de Ingenieria y Tecnologia
> Universidad Autonoma de Tlaxcala
> Mexico.
> 

----------------------------------
Date: 12-May-99  Time: 12:12:01

Craig Orsinger                  (email: <orsingerc@epg.lewis.army.mil>)
Logicon RDA
Bldg. 8B28                      "Just another megalomaniac with ideas above his
6th & F Streets                 station. The Universe is full of them."
Ft. Lewis, WA   98433                   - The Doctor
----------------------------------


pgsql-interfaces by date:

Previous
From: ic94006@solar6.ingenieria.uatx.mx (Ilhuicatzi Cortes J. Henry)
Date:
Subject: ...
Next
From: "Jeffrey Silberberg"
Date:
Subject: Fw: Lotus Approach/97 and postgreSQL ODBC Driver