Thread: problem in pg_hba.conf file
I m getting the following error message when i try to get a connection through a jsp file.
"Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: No pg_hba.conf entry for host 161.58.235.51, user ticket, database theatick "
where '161.58.235.51' is the ip address of my server and theatick is the database name and tikcet is the user Id for that database
whereas pg_hpa.conf file contain two (by default) entries
local all trust
host all 127.0.0.1 255.255.255.255 trust
is there anything else required in pg_hba.conf or what ????
Irfan Qaiser
>>>>> "IQ" == Irfan Qaiser <irfan@appsys.com.pk> writes: IQ> [1 <text/plain; iso-8859-1 (quoted-printable)>] IQ> I m getting the following error message when i try to get a connection through a jsp file. IQ> "Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: Nopg_hba.conf entry for host 161.58.235.51, user ticket, database theatick " IQ> where '161.58.235.51' is the ip address of my server and theatick is the database name and tikcet is the user Id forthat database IQ> whereas pg_hpa.conf file contain two (by default) entries IQ> local all trust IQ> host all 127.0.0.1 255.255.255.255 trust IQ> is there anything else required in pg_hba.conf or what ???? IQ> Irfan Qaiser IQ> [2 <text/html; iso-8859-1 (quoted-printable)>] You have to add following line in pg_hba.conf: host theatick 161.58.235.51 255.255.255.255 trust ^1 ^2 ^3 ^4 ^5 1. Keyword 'host' 2. Database name 3. IP addres you access from 4. Mask for this address 5. Keyword 'trust' All the instruction are in the same file - ~pgsql/data/pg_hba.conf -- Anatoly K. Lasareff Email: tolik@aaanet.ru