pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gavin M. Roy <gmr@ehpg.net>
To: JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com>
Cc: operationsengineer1@yahoo.com
Cc: pgsql-php@postgresql.org
Subject: Re: autentication problem
Date: Fri, 14 Oct 2005 12:16:42 -0700
Message-ID: <1EEA0DF5-57C5-42D5-96A4-DAD19FBD9D53@ehpg.net> (raw)
In-Reply-To: <BAY14-F125D85CB72B316220148AACD7D0@phx.gbl>
References: <BAY14-F125D85CB72B316220148AACD7D0@phx.gbl>

I would guess your pg_hba.conf is not configured correctly.  It  
appears to be an ident matching issue (best I can tell from the  
spanish error messages, sorry).

Gavin

On Oct 14, 2005, at 12:06 PM, JUAN ERNESTO FLORES BELTRAN wrote:

> 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
>>
>
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>

Gavin M. Roy
800 Pound Gorilla
gmr@ehpg.net





view thread (9+ messages)  latest in thread

Message-ID: <1EEA0DF5-57C5-42D5-96A4-DAD19FBD9D53@ehpg.net>
Permalink:  ../1EEA0DF5-57C5-42D5-96A4-DAD19FBD9D53@ehpg.net/
Also on:    postgresql.org/message-id/1EEA0DF5-57C5-42D5-96A4-DAD19FBD9D53@ehpg.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: gmr@ehpg.net, juanernestof@hotmail.com, operationsengineer1@yahoo.com
  Subject: Re: autentication problem
  In-Reply-To: <1EEA0DF5-57C5-42D5-96A4-DAD19FBD9D53@ehpg.net>
  References: <BAY14-F125D85CB72B316220148AACD7D0@phx.gbl> <1EEA0DF5-57C5-42D5-96A4-DAD19FBD9D53@ehpg.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox