From: ic94006(at)solar6(dot)ingenieria(dot)uatx(dot)mx (Ilhuicatzi Cortes J(dot) Henry)
To:
Subject:
Date: 1999-05-12 19:01:18
Message-ID: 199905121901.NAA08594@solar6.ingenieria.uatx.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-interfaces by date

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