Re: autentication problem

Information contained on page 51:

pg_connect(host=localhost port=5432 dbname=prototipo user=postgres
password=13177337)

this is the route i used on windows to run queries on postgre trough php.
This does not work on linux, and result in an autentication error

What the problem could be?
thanks for your answers in advance..

>From: <operationsengineer1@yahoo.com>
>To: pgsql-php@postgresql.org
>Subject: Re: [PHP] autentication problem
>Date: Fri, 14 Oct 2005 09:32:08 -0700 (PDT)
>
>--- JUAN ERNESTO FLORES BELTRAN
><juanernestof@hotmail.com> wrote:
>
> > Hi everyone
> >
> > i am working on php and posgresql, i designed a
> > database system web oriented
> > on windows at first on template1 default database.
>
>did you copy template1 and then create your db from
>the template?  i always understood that template1
>itself was to be left alone and left as template.
>
> > I
> > used a password and a
> > loggin
> > loggin=postgres
> > password=13177337
> > this info is requested when installing postgresql on
> > windows.
> > Know i trying  to migrate to suse linux...i moved my
> > scripts to
> > srv/www/htdocs/prototipo as root. I installed
> > apache2 server, and i
> > configured both apache and posgtresql to start
> > running when starting the
> > computer.
> >
> > The problem is, i have not been able tu run properly
> > the system on linux...i
> > receive the following message when conecting to
> > postgresql:
> >
> > "Warning: pg_connect(): Unable to connect to
> > PostgreSQL server: FATAL: la
> > autentificación Ident falló para el usuario
> > «jufl» in
> > /srv/www/htdocs/Prototipo/opciones.php on line 51"
>
>i've never administered pgsql on linux before, so i
>don't have direct experience.  what does opciones.php
>line 51 say?  is tcp/ip enabled?  are you using the
>same username and password?
>
> > I didnt create any user when installing postgres, it
> > didnt request during
> > installation...so i wonder....how can i manage this?
> > the extrange thing is
> > that  i can modify tables from console as follows;
> >
> >

>...............................................................................................................................................................
> > su root
> > enter password
> > su postgres
> > psql prototipo
> > Bienvenido a psql 8.0.3, el terminal interactivo de
> > PostgreSQL.
> >
> > Digite:  \copyright para ver los términos de
> > distribución
> >          \h para obtener ayuda sobre comandos SQL
> >          \? para obtener ayuda sobre comandos
> > internos
> >          \g o punto y coma (;) para ejecutar
> > consulta
> >          \q para salir
> >
> > prototipo=#
> >
> >

>.....................................................................................................................................................................................
> >
> >
> > so i dont understand what the problem is.....
> >
> > Thaks for your help...
>
>not sure i can help, but if you post line 51 it will
>likely help those who can help.
>
>best of luck.
>
>ps - a guy on the pgsql novice mailint list was
>recently asking how to install pgsql onto suse.  if
>you had any instructions or could point to a tutorial
>that you used, he would like appreciate it.
>
>
>
>
>__________________________________
>Yahoo! Mail - PC Magazine Editors' Choice 2005
>http://mail.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: don't forget to increase your free space map settings