Re: [ADMIN] ident authentication over tcp

2009-12-10 Thread Peter Koczan
On Wed, Dec 9, 2009 at 3:29 PM, Adam Tauno Williams wrote: > On Wed, 2009-12-09 at 15:18 -0600, Peter Koczan wrote: >> I found the packages. I'm still confused why local ident >> authentication works even without a running ident server, though. Does >> anyone know why that is? > > Does "local" rea

Re: [ADMIN] ident authentication over tcp

2009-12-09 Thread Milen A. Radev
Peter Koczan написа: On Wed, Dec 9, 2009 at 1:25 PM, wrote: This looks like you have no ident server running... I guess you must install it first in recent distros, as there is not much use of ident anymore. So you have to search the packages for your OS. I found the packages. I'm still con

Re: [ADMIN] ident authentication over tcp

2009-12-09 Thread Adam Tauno Williams
On Wed, 2009-12-09 at 15:18 -0600, Peter Koczan wrote: > On Wed, Dec 9, 2009 at 1:25 PM, wrote: > > This looks like you have no ident server running... > > > > I guess you must install it first in recent distros, as there is not much > > use of ident anymore. So you have to search the packages fo

Re: [ADMIN] ident authentication over tcp

2009-12-09 Thread Peter Koczan
On Wed, Dec 9, 2009 at 1:25 PM, wrote: > This looks like you have no ident server running... > > I guess you must install it first in recent distros, as there is not much > use of ident anymore. So you have to search the packages for your OS. I found the packages. I'm still confused why local id

Re: [ADMIN] ident authentication over tcp

2009-12-09 Thread lst_hoe02
Zitat von Peter Koczan : Hi all, I'm having some trouble configuring ident authentication for TCP connections. I can get it to work fine for local connections, but I can't Local connection: $ psql postgres ... postgres=> Server Log: Dec 9 11:06:59 mitchell postgres[27482]: [4-1] LOG: conne

[ADMIN] ident authentication over tcp

2009-12-09 Thread Peter Koczan
Hi all, I'm having some trouble configuring ident authentication for TCP connections. I can get it to work fine for local connections, but I can't Local connection: $ psql postgres ... postgres=> Server Log: Dec 9 11:06:59 mitchell postgres[27482]: [4-1] LOG: connection received: host=[local]

Re: [ADMIN] ident authentication

2008-11-29 Thread Robert Treat
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 anothe

[ADMIN] ident authentication

2008-11-20 Thread Shilpa Sudhakar
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

Re: [ADMIN] ident authentication problem

2008-03-04 Thread Joshua D. Drake
On Wed, 5 Mar 2008 10:01:46 +0530 <[EMAIL PROTECTED]> wrote: > > Hello > I am newbie to postgresql I have to make project using > this . I am learning it but at every step i am getting error . now I > am stuck with the error > >-bash-3.2$ psql -d xnat -f sql/xnat.sql -U xnat >

[ADMIN] ident authentication problem

2008-03-04 Thread madhu.harchandani
Hello I am newbie to postgresql I have to make project using this . I am learning it but at every step i am getting error . now I am stuck with the error -bash-3.2$ psql -d xnat -f sql/xnat.sql -U xnat psql: FATAL: Ident authentication failed for user "xnat"

[ADMIN] IDENT authentication with md5 fallback

2007-01-10 Thread Dustin C. Hatch
Hello, I was wondering if there is a way I can set up my pg_hba.conf to allow "ident sameuser" authentication, but fall back to "md5" if it fails. I would like users to be able to login to their databases (which correspond to their usernames and ident responses), however when they need to us

Re: [ADMIN] "IDENT authentication failed" but I'm not using ident

2004-05-19 Thread Nico De Ranter
On Wed, 2004-05-19 at 02:19, Tom Lane wrote: > Nico De Ranter <[EMAIL PROTECTED]> writes: > > \connect: FATAL: IDENT authentication failed for user "nico" > > > I changed /etc/postgresql/pg_hba.conf so it only contains > > localall all trust=20 > > and restarted postgres but I still g

Re: [ADMIN] "IDENT authentication failed" but I'm not using ident

2004-05-18 Thread Tom Lane
Nico De Ranter <[EMAIL PROTECTED]> writes: > \connect: FATAL: IDENT authentication failed for user "nico" > I changed /etc/postgresql/pg_hba.conf so it only contains > localall all trust=20 > and restarted postgres but I still get the same error message. > Any idea why the import comp

[ADMIN] "IDENT authentication failed" but I'm not using ident

2004-05-18 Thread Nico De Ranter
Hi, I'm trying to upgrade postgres to 7.4.2. I've dumped the database on 7.2.1 but when I try to recreate it by doing psql -e template1 (SELECT datdba FROM pg_database WHERE datname = 'template0'); DELETE 15 CREATE USER "ids" WITH SYSID 103 PASSWORD 'Yil8t8Wq1yFth' NOCREATEDB NOCREATEUSER; CR

Re: [ADMIN] ident authentication not working over loopback adapter

2002-12-20 Thread Ian Pilcher
Tom Lane wrote: Check to see if ident traffic is being filtered by kernel-level packet filtering. IIRC, RHL ships with mighty tight packet filtering, even on the loopback connection (which is a tad silly, but...). One easy way to investigate this is to see if you can telnet to the ident daemon:

Re: [ADMIN] ident authentication not working over loopback adapter

2002-12-20 Thread Tom Lane
Ian Pilcher <[EMAIL PROTECTED]> writes: > This is a bit backwards. ident authentication is working for me over > Unix domain sockets, but it isn't working over the loopback adapter. > Notes: This is Red Hat Linux 8.0. Password authentication works over > Unix domain sockets or the loopb

[ADMIN] ident authentication not working over loopback adapter

2002-12-20 Thread Ian Pilcher
This is a bit backwards. ident authentication is working for me over Unix domain sockets, but it isn't working over the loopback adapter. Here is my /var/lib/pgsql/data/pg_hba.conf: # Allow local and loopback users to connect to self-named databases # local sameuser iden

[ADMIN] Ident authentication problem

2002-07-18 Thread shreedhar
Hi all, I installed Postgresql from RHLinux7.3. I modified pg_hba.conf as local alltrust host all 192.168.0.0 255.255.0.0 trust I have crated a user 'sreedhar' with password 'sreedhar' If tried to install dat