[opensuse] Succeed Login on pgAdmin3 but Failed via psql Command
Hi all, I have postgresql-server and pgadmin installed on openSUSE Leap 42.1: postgresql-devel-9.4-1.1.noarch postgresql-init-9.4-9.1.noarch postgresql94-9.4.6-4.1.x86_64 postgresql94-devel-9.4.6-4.1.x86_64 postgresql94-server-9.4.6-4.1.x86_64 Using "md5" Method at: host all all 127.0.0.1/32 md5 in "/var/lib/pgsql/data/pg_hba.conf" file. A role user (named: "ovie") is able to login to DB via pgAdmin3* but failed via psql Command: $ psql -p 5432 -h localhost -U ovie -W Password for user ovie: psql: FATAL: Ident authentication failed for user "ovie" Any suggestions? *) http://goo.gl/erhDy6 Thanks in advance. -- Andi Sugandi. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Hi, What is the authentication method for the local connections type ? Ident ? Change it to md5, restart postgres and try again. Regards. ------------------------------------------------------------------------------ On Thursday, 11 August, 2016 16:16:58 Andi Sugandi wrote:
Hi all,
I have postgresql-server and pgadmin installed on openSUSE Leap 42.1:
postgresql-devel-9.4-1.1.noarch postgresql-init-9.4-9.1.noarch postgresql94-9.4.6-4.1.x86_64 postgresql94-devel-9.4.6-4.1.x86_64 postgresql94-server-9.4.6-4.1.x86_64
Using "md5" Method at: host all all 127.0.0.1/32 md5
in "/var/lib/pgsql/data/pg_hba.conf" file.
A role user (named: "ovie") is able to login to DB via pgAdmin3* but failed via psql Command:
$ psql -p 5432 -h localhost -U ovie -W Password for user ovie: psql: FATAL: Ident authentication failed for user "ovie"
Any suggestions?
Thanks in advance.
Hi, On Fri, Aug 12, 2016 at 12:49 AM, Ico Petrov <ico@tyro.homenet.org> wrote:
What is the authentication method for the local connections type ? Ident ? Change it to md5, restart postgres and try again.
Did you mean this one?
Using "md5" Method at: host all all 127.0.0.1/32 md5
in "/var/lib/pgsql/data/pg_hba.conf" file.
The result is still (of course after running systemcl restart postgresql.service):
$ psql -p 5432 -h localhost -U ovie -W Password for user ovie: psql: FATAL: Ident authentication failed for user "ovie"
Best regards, -- Andi Sugandi. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Hi, No, I mean this one: local all all md5 Regards. ------------------------------------------------------------------------------ On Friday, 12 August, 2016 13:00:59 Andi Sugandi wrote:
Hi,
On Fri, Aug 12, 2016 at 12:49 AM, Ico Petrov <ico@tyro.homenet.org> wrote:
What is the authentication method for the local connections type ? Ident ? Change it to md5, restart postgres and try again.
Did you mean this one?
Using "md5" Method at: host all all 127.0.0.1/32 md5
in "/var/lib/pgsql/data/pg_hba.conf" file.
The result is still (of course after running systemcl restart
postgresql.service):
$ psql -p 5432 -h localhost -U ovie -W Password for user ovie: psql: FATAL: Ident authentication failed for user "ovie"
Best regards, -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (2)
-
Andi Sugandi -
Ico Petrov