Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] ODBC - User Authentication Failed

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Matthew <matt(at)ctlno(dot)com>
Cc: pgsql-interfaces(at)hub(dot)org
Subject: Re: [INTERFACES] ODBC - User Authentication Failed
Date: 1998-12-28 23:42:13
Message-ID: Pine.LNX.4.04.9812282340100.8386-100000@maidast.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Mon, 28 Dec 1998, Matthew wrote:

> Hello, I think I am doing something stupid here so hopefully there is a
> simple answer. 
> 
> I just installed RedHat5.2 on a new PC.  It works fine.  I installed all
> the PosgreSQL packages.  I performed a createuser so that my account can
> access psql.  That worked, I was able to create a new database 'foo' and
> connect to it with psql.  I tried from pgaccess and it failed asking if
> the -i option was used.  I fixed that, and now I can connect to my
> database from pgaccess.  I then went to Windows PC, and tried to connect
> using ODBC and the postdrv 6.4.001.  It fails with an error of 'User
> Authentication Failed' and that's it.  I have tried granting permissions
> and such but nothing seems to make it work.  Is there something that I'm
> missing in the setup, or some reason my Windows PC can't connect?

You'll need to enter either the Windows PC's TCP/IP address (or a subnet
containing that PC) into the pg_hba.conf file located in the PG_DATA
directory. I think RedHat put's that in the /var/lib/pgsql directory (from
memory, a RH5.2 box at work has it there).

Something like:

host all 192.168.4.0 255.255.255.0 password

should do the trick.

-- 
       Peter T Mount peter(at)retep(dot)org(dot)uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf


In response to

pgsql-interfaces by date

Next:From: Peter T MountDate: 1998-12-28 23:53:08
Subject: Update on getting JDBC2 working with PostgreSQL
Previous:From: MatthewDate: 1998-12-28 21:15:29
Subject: ODBC - User Authentication Failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group