Обсуждение:
subscribe
The Problem is, that your WEB-Server (executing the Perl-script) tries to connect to the Postgres-Server with his Username ("nobody"). Under Postgres, create the user "nobody", give him all the rights he need and it should work. -----Ursprüngliche Nachricht----- Von: Ilhuicatzi Cortes J. Henry <ic94006@solar6.ingenieria.uatx.mx> An: fischl@gmx.de <fischl@gmx.de> Datum: Donnerstag, 13. Mai 1999 00:06 >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. >