From: Yandong.Yao@emc.com
To: pgsql-admin@postgresql.org
To: pgsql-general@postgresql.org
Subject: What does error "psql: Kerberos 5 authentication not supported" means?
Date: Wed, 23 Mar 2011 12:44:16 -0400
Message-ID: <C9B04362.21EE%Yandong.Yao@EMC.COM> (raw)
Hi Guys,
I tried to setup kerberos authentication with postgresql 8.4.7 on Ubuntu 10.10.
When I use:
$ psql –h ubuntu.server –U gavin dbname
I get following error:
psql: Kerberos 5 authentication not supported.
And from the server side of postgresql, I could see following log:
2011-03-23 09:14:17 PDT LOCATION: proc_exit_prepare, ipc.c:183
2011-03-23 09:14:17 PDT DEBUG: 00000: exit(0)
2011-03-23 09:14:17 PDT LOCATION: proc_exit, ipc.c:135
2011-03-23 09:14:17 PDT DEBUG: 00000: shmem_exit(-1): 0 callbacks to make
2011-03-23 09:14:17 PDT LOCATION: shmem_exit, ipc.c:211
2011-03-23 09:14:17 PDT DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2011-03-23 09:14:17 PDT LOCATION: proc_exit_prepare, ipc.c:183
2011-03-23 09:14:17 PDT DEBUG: 00000: reaping dead processes
2011-03-23 09:14:17 PDT LOCATION: reaper, postmaster.c:2243
2011-03-23 09:14:17 PDT DEBUG: 00000: server process (PID 4592) exited with exit code 0
2011-03-23 09:14:17 PDT LOCATION: LogChildExit, postmaster.c:2725
2011-03-23 09:14:24 PDT LOG: 00000: Kerberos recvauth returned error 103
2011-03-23 09:14:24 PDT LOCATION: pg_krb5_recvauth, auth.c:721
postgres: Software caused connection abort from krb5_recvauth
2011-03-23 09:14:24 PDT FATAL: 28000: Kerberos 5 authentication failed for user "gavin"
2011-03-23 09:14:24 PDT LOCATION: auth_failed, auth.c:273
2011-03-23 09:14:24 PDT DEBUG: 00000: shmem_exit(1): 0 callbacks to make
2011-03-23 09:14:24 PDT LOCATION: shmem_exit, ipc.c:211
2011-03-23 09:14:24 PDT DEBUG: 00000: proc_exit(1): 1 callbacks to make
2011-03-23 09:14:24 PDT LOCATION: proc_exit_prepare, ipc.c:183
2011-03-23 09:14:24 PDT DEBUG: 00000: exit(1)
2011-03-23 09:14:24 PDT LOCATION: proc_exit, ipc.c:135
2011-03-23 09:14:24 PDT DEBUG: 00000: shmem_exit(-1): 0 callbacks to make
2011-03-23 09:14:24 PDT LOCATION: shmem_exit, ipc.c:211
2011-03-23 09:14:24 PDT DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2011-03-23 09:14:24 PDT LOCATION: proc_exit_prepare, ipc.c:183
2011-03-23 09:14:24 PDT DEBUG: 00000: reaping dead processes
What does this means and how could I get more verbose logs?
Besides, is there any more howto/doc on integrate kerberos and postgresql besides the official documentation at http://www.postgresql.org/docs/9.0/interactive/client-authentication.html?
Thanks very much in advance!
Regards,
Yandong
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Yandong.Yao@emc.com, pgsql-general@postgresql.org
Subject: Re: What does error "psql: Kerberos 5 authentication not supported" means?
In-Reply-To: <C9B04362.21EE%Yandong.Yao@EMC.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox