phppgadmin not working under v. 8.1
От | barbara figueirido |
---|---|
Тема | phppgadmin not working under v. 8.1 |
Дата | |
Msg-id | 44EE5952.3040307@bariloche.com.ar обсуждение исходный текст |
Ответы |
Re: phppgadmin not working under v. 8.1
("Phillip Smith" <phillips@weatherbeeta.com.au>)
Re: phppgadmin not working under v. 8.1 ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>) |
Список | pgsql-novice |
Hello! I am running a debian sarge system, which originally had postgresql 7.4.7-6; I removed that installation of postgresql and compiled version 8.1, without problems. Now, the issue is, I cannot connect from phppgadmin (which I didn't touch, so it's sarge's original 3.5.2-5), it returns each time "login failed" ; php and phppgadmin are working properly, or at least they were when I was still running the older postgres version, user / password are also the same as before. I looked through this list, and the only hints I found pointed towards the line "tcpip_socket" in postgresql.conf; but it seems that that line has been replaced by a more general one "listen_addresses" ( http://www.postgresql.org/docs/8.1/interactive/release-8-0.html ) I modified the postgresql.conf file uncommenting the port number and giving the (private) network address number as argument to "listen_addresses", so: #--------------------------------------------------------------------------- # CONNECTIONS AND AUTHENTICATION #--------------------------------------------------------------------------- # - Connection Settings - listen_addresses = '192.168.1.0' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost', '*' = all port = 5432 max_connections = 100 ......................... and the pg_hba.conf file to listen to all local connections and all connections coming from the local network, so # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust host all all 192.168.1.0/24 trust # IPv6 local connections: host all all ::1/128 trust -------------- restarting thereafter the postmaster, but nonetheless it is still impossible to authenticate to it via phppg admin (it may be obvious, but the psql client connects perfectly) I am sorry if I am skipping something obvious, and apologize in advance for it if this were the case; anyway, I would be very grateful if somebody could give me some hint where to look for, since I need the visual interface for daily work. Thank you all very much for the continuous feedback, Bárbara Figueirido S.C. de Bariloche
В списке pgsql-novice по дате отправления: