From: | tolik(at)aaanet(dot)ru (Anatoly K(dot) Lasareff) |
---|---|
To: | "Irfan Qaiser" <irfan(at)appsys(dot)com(dot)pk> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: problem in pg_hba.conf file |
Date: | 2000-06-30 07:10:43 |
Message-ID: | 87ya3nsky4.fsf@tolikus.hq.aaanet.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
>>>>> "IQ" == Irfan Qaiser <irfan(at)appsys(dot)com(dot)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: No pg_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 for that 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(at)aaanet(dot)ru
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Sargent | 2000-06-30 10:59:05 | ecpg conversion from oracle |
Previous Message | Irfan Qaiser | 2000-06-30 06:55:27 | problem in pg_hba.conf file |