Thread: 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
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.
> 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