I am sorry William but you lost me. I haven't disabled anything have I? On 6/27/07, William Leite Araújo <william.bh@xxxxxxxxx> wrote:
2007/6/27, Danyelle Gragsone <ladynikon@xxxxxxxxx>: > Greetings, > > I am trying to setup postgres and postfix using webmin. I am > following this guide: > http://gentoo-wiki.com/HOWTO_Email:_A_Complete_Virtual_System_-_Postfix_to_Postgres > > I received the following in the postgres db section of webmin: > select * from pg_database order by datname failed : no pg_hba.conf > entry for host "[local]", user "postgres", database "template1", SSL > off > > I sadly have no clue on how to go by fixing this. Please help :) It > talks about this error in the guide. But it really does not tell you > how to fix it specifically. I don't even see a section in the area > specified for the authentication they are suggesting. > > Operating system Gentoo Linux > Webmin version 1.350 > > I believe the problem is in this section. > # "local" is for Unix domain socket connections only # DO NOT DISABLE! # If you change this first entry you will need to make sure that the # database # super user can access the database using some other method. # Noninteractive # access to all databases is required during automatic maintenance # (autovacuum, daily cronjob, replication, and similar tasks). # # Database administrative login by UNIX sockets local all postgres ident sameuser > host all all 10.2.0.202 255.255.255.255 trust > # IPv4 local connections: > host all all 127.0.0.1/32 trust > # IPv6 local connections: > host all all ::1/128 trust > > I could be wrong. Please help the newb. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- William Leite Araújo Estudante de paternidade - 13a semana
