... - Mailing list pgsql-interfaces

From ic94006@solar6.ingenieria.uatx.mx (Ilhuicatzi Cortes J. Henry)
Subject ...
Date
Msg-id 199905121901.NAA08594@solar6.ingenieria.uatx.mx
Whole thread Raw
Responses RE: (No subject - Perl CGI PostgreSQL)
Re: your mail
List pgsql-interfaces
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.


pgsql-interfaces by date:

Previous
From: Dave Page
Date:
Subject: RE: [INTERFACES] pgAdmin interface on Windows communicating with a PostgreSQL database on Linux.
Next
From: Craig Orsinger
Date:
Subject: RE: (No subject - Perl CGI PostgreSQL)