Thread: odbc
hi, i have a postgresql db set up on a linux server
i can access it w/o a problem from that machine, but when i try to access it from odbc, i get an error
it says it cannot find a 'pg_hda.conf' entry for [IP Address], [User], [Database]
i set up the pg_hda.conf to accept a given range of IP's or tried to at least.
what else do i need to do?
thanks
>On 02.07.2002 at 19:59 Roberto Benitez wrote: >hi, i have a postgresql db set up on a linux server >i can access it w/o a problem from that machine, but when i try to access >it from odbc, i get an error >it says it cannot find a 'pg_hda.conf' entry for [IP Address], [User], >[Database] >i set up the pg_hda.conf to accept a given range of IP's or tried to at >least. > >what else do i need to do? First, make sure you're using the correct pg_hba.conf in the postgres data directory! Then restart postgres server to bring changes in effect. Second, you will need to create a data base user using the 'createuser' command. Use your logon name on the remote machine as the user name to create. If you have successfully connected to the database you still can run into trouble if you forgot to allow access to the records in your data base. Use 'GRANT SELECT ON <table> TO <user>' as a minimum access-level. If you have no success with that, please post your pg_hba.conf and the concrete values for "[IP Adress], ..." from above. And specify your odbc client machine (just guessing: Windows, Access ???) Regards Andreas
Please, can anybody help too ??? I've installed Postgres 7.2.1 from RedHat 7.3 and received the same error message below. I have pg_hba.conf in '/usr/share/pgsql/data" and "var/lib/pgsql/data", but this message persists !!! I'm not using odbc !! I use zeos (a connect tool for Delphi) !!! It allways work fine, but with 7.2.1 not !!! thanks Andreas Kretzer wrote: >>On 02.07.2002 at 19:59 Roberto Benitez wrote: >>hi, i have a postgresql db set up on a linux server >>i can access it w/o a problem from that machine, but when i try to access >>it from odbc, i get an error >>it says it cannot find a 'pg_hda.conf' entry for [IP Address], [User], >>[Database] >>i set up the pg_hda.conf to accept a given range of IP's or tried to at >>least. >> >>what else do i need to do? >> > > First, make sure you're using the correct pg_hba.conf in the postgres > data directory! Then restart postgres server to bring changes in effect. > > Second, you will need to create a data base user using the 'createuser' > command. Use your logon name on the remote machine as the user > name to create. > > If you have successfully connected to the database you still can run > into trouble if you forgot to allow access to the records in your > data base. Use 'GRANT SELECT ON <table> TO <user>' as a minimum > access-level. > > If you have no success with that, please post your pg_hba.conf and > the concrete values for "[IP Adress], ..." from above. And specify your > odbc client machine (just guessing: Windows, Access ???) > > Regards > Andreas > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > > >
Did you restart the server after changing the config? And if that does not help post the contents. hth ----- Original Message ----- From: "Roberto Benitez" <RBENITEZ@houston.rr.com> To: <pgsql-interfaces@postgresql.org> Sent: Wednesday, July 03, 2002 2:59 AM Subject: [INTERFACES] odbc hi, i have a postgresql db set up on a linux server i can access it w/o a problem from that machine, but when i try to access it from odbc, i get an error it says it cannot find a 'pg_hda.conf' entry for [IP Address], [User], [Database] i set up the pg_hda.conf to accept a given range of IP's or tried to at least. what else do i need to do? thanks