login error - Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "kamik"
| От | Jaromír Kamler |
|---|---|
| Тема | login error - Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "kamik" |
| Дата | |
| Msg-id | 1289595757.291891.10263.nullmailer@mail1002.cent обсуждение исходный текст |
| Ответы |
Re: login error - Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "kamik"
Re: login error - Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "kamik" |
| Список | pgsql-novice |
Hi guys, I am trying connect to Postgres by PHP. I have this PHP code: But web browser writes this error: Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "***" FATAL: password authentication failed for user "***" in /var/www/test/index.php on line 6 Warning: pg_last_error(): No PostgreSQLlink opened yet in /var/www/test/index.php on line 7 Could not connect: Main problem is that I have bad authentication for my user. In my pg_hba.conf is this: # Database administrative login by UNIX sockets local all postgres ident # 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 0.0.0.0/0 md5 hostssl all all 0.0.0.0/0 md5 hostnossl all all 0.0.0.0/0 md5 # IPv6 local connections: host all all ::1/128 md5 And in postgresql.conf I set listen_addresses = "*" When I delete in PHP script in pg_connect host="localhost", then all works fine, because I use UNIX domain socket (I am thinging...), but when I use "normal" connection, it is wrong. Interesting is that phppgadmin works fine ... . So, question is what I do wrong. I thing that I have mistake in pg_hba.conf, but I am blind. I have postgresql-8.4 Best regards J.K.
В списке pgsql-novice по дате отправления: