Обсуждение: ODBC - User Authentication Failed
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? Thanks in advance, Matt
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@retep.org.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