| From: | Craig Orsinger <orsingerc(at)epg-gw1(dot)lewis(dot)army(dot)mil> |
|---|---|
| To: | (Ilhuicatzi Cortes J(dot) Henry) <ic94006(at)solar6(dot)ingenieria(dot)uatx(dot)mx> |
| Cc: | pgsql-interfaces(at)postgreSQL(dot)org |
| Subject: | RE: (No subject - Perl CGI PostgreSQL) |
| Date: | 1999-05-12 19:17:42 |
| Message-ID: | XFMail.990512121742.orsingerc@epg-gw1.lewis.army.mil |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)epg(dot)lewis(dot)army(dot)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
----------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeffrey Silberberg | 1999-05-12 19:30:55 | Fw: Lotus Approach/97 and postgreSQL ODBC Driver |
| Previous Message | Ilhuicatzi Cortes J. Henry | 1999-05-12 19:01:18 |