Re: ident authentication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Friday 21 November 2008 00:56:53 Shilpa Sudhakar wrote:
> Hi,
>
> I am trying to test different kinds of authentication in postgres.
>
> I'm to find a efficient way to link the OS user with the postgres user.
> This is to help for auditing purpose. This is similar to the query
> raised by another postgres user.
>
> As suggested by Tom to use ident, i tried setting up ident but it isn't
> working.
>
> In the hba.conf file, i add the below entry
>
> local     all     all      ident       sameuser
>

did you reload the file after modifying it? 

> The user logged in at OS level is "abc".  I created a user "abc" in
> postgres but when i do "psql -U abc -d dbname", i get the below error:
>
> FATAL: Ident authentication failed for user "abc"
>

What error do you get if you do "psql -d dbname" ? 

> Should i put an entry in pg_ident.conf file?
>
> Is using ident still the right way to go? Is LDAP a better option
> because when we login to the server, we login with our LDAP username and
> password.
>
> Thanks and Regards,
> Shilpa

-- 
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux