... - Mailing list pgsql-interfaces

From Henry Ilhuicatzi Cortes
Subject ...
Date
Msg-id Pine.GSO.4.05.9905101331500.5651-100000@iris1.ingenieria.uatx.mx
Whole thread Raw
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: Craig Orsinger
Date:
Subject: RE: [INTERFACES] error insert
Next
From: leif@danmos.dk
Date:
Subject: [INTERFACES] ForeignKey trigger problems