Re: configuring postgresql on the browser

I'm trying to get pgsql to work on my browser but I can't connect. It works
great on the shell and the psql webmin module works great but when it comes
to phppgadmin or connecting my php application I get a :

"Warning: pg_connect() unable to connect to PostgreSQL server: FATAL: IDENT
authentication failed for user "joe""
do i need to add a new user such as localhost or something? I don't why my
webmin module is working while my phppgadmin is not.

this is what's on my pg_hba.conf file maybe there's something wrong with it:

local all all ident
sameu\
ser
host all all 127.0.0.1 255.255.255.255 ident
sameu\
ser
host all all 0.0.0.0 255.255.255.255 reject
\

thanx in advance

> I'm trying to get pgsql to work on my browser but I can't connect. It works
> great on the shell and the psql webmin module works great but when it comes
> to phppgadmin or connecting my php application I get a :
>
> "Warning: pg_connect() unable to connect to PostgreSQL server: FATAL: IDENT
> authentication failed for user "joe""

Ident maps other than sameuser are defined in the file pg_ident.conf in
the data directory, which contains lines of the general form:

map-name ident-username database-username

So you might require to have appropriate entries in pg_ident.conf file.

Rather you can also change the authentication method to trust or password
or md5.

regards,
bhuvaneswaran

> Ident maps other than sameuser are defined in the file pg_ident.conf in
> the data directory, which contains lines of the general form:
>
> map-name ident-username database-username
>
> So you might require to have appropriate entries in pg_ident.conf file.
>
> Rather you can also change the authentication method to trust or password
> or md5.

if I want to connect user 'joe' to db 'mydb', knowing that joe has the same
rights than postgres. what do I need to add to pg_ident.conf file? and how
come my webmin works great while my phppgadmin and my php apps don't?

thanx in advance

On Saturday 05 April 2003 06:52, you wrote:
> Ident maps other than sameuser are defined in the file pg_ident.conf in
> the data directory, which contains lines of the general form:
>
> map-name ident-username database-username
>
> So you might require to have appropriate entries in pg_ident.conf file.
>
> Rather you can also change the authentication method to trust or password
> or md5.

if I want to connect user 'joe' to db 'mydb', knowing that joe has the same
rights than postgres. what do I need to add to pg_ident.conf file? and how
come my webmin works great while my phppgadmin and my php apps don't?

thanx in advance

On Fri, Apr 04, 2003 at 11:18:41PM +0200, Don Patou wrote......

> I'm trying to get pgsql to work on my browser but I can't connect. It works
> great on the shell and the psql webmin module works great but when it comes
> to phppgadmin or connecting my php application I get a :
<snip>
> this is what's on my pg_hba.conf file maybe there's something wrong with it:
>
> local all all ident sameuser
> host all all 127.0.0.1 255.255.255.255 ident sameuser
> host all all 0.0.0.0 255.255.255.255 reject

I struggled with this for a while too, especially in terms of getting
phppgadmin to work.

I've got the following in my pg_hba.conf

local all all trust
host all all 127.0.0.1 255.255.255.0 md5

Also, in your postgresql.conf make sure you have tcpip_socket = 1 as
shown below.

# Connection Parameters
#
# TCP/IP access is allowed by default, but the default access given in
# pg_hba.conf will permit it only from localhost, not other machines.
tcpip_socket = 1

I think these were the only changes I had to make to get phppgadmin to
work on the localhost.

HTH.

Kevin

> local all all trust
> host all all 127.0.0.1 255.255.255.0 md5
>
>
ok thanx a lot it worked just great.