Re: phppgadmin not working under v. 8.1 - Mailing list pgsql-novice

If you completely wiped the previous install, including the data directory
then you would have lost your pg_hba.conf

Have a look and check it. More details:
http://www.postgresql.org/docs/8.1/static/client-authentication.html#AUTH-PG
-HBA-CONF

Cheers,
-p

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of barbara figueirido
Sent: Friday, 25 August 2006 11:59
To: pgsql-novice@postgresql.org
Subject: [NOVICE] phppgadmin not working under v. 8.1

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

---------------------------(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


*******************Confidentiality and Privilege Notice*******************

The material contained in this message is privileged and confidential to
the addressee.  If you are not the addressee indicated in this message or
responsible for delivery of the message to such person, you may not copy
or deliver this message to anyone, and you should destroy it and kindly
notify the sender by reply email.

Information in this message that does not relate to the official business
of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta.
Weatherbeeta, its employees, contractors or associates shall not be liable
for direct, indirect or consequential loss arising from transmission of this
message or any attachments