Thread: Urgent :Query - Please help

Urgent :Query - Please help

From
"sanjay"
Date:
Dear Sir,
                  I am using Linux RedHat 7.2 with jakarta-tomcat-4.0.1 and Postgresql 7.1.3. I m getting following error when I run a servlet with the database named "test" having user "nobody". I m running this servlet from one of the client m/c. The servlet is using jdbc connection, select some records from a table and display it.
 
"Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLException: No pg_hba.conf entry for host 192.168.1.50, user nobody, database test Stack Trace: java.sql.SQLException: No pg_hba.conf entry for host 192.168.1.50, user nobody, database test at org.postgresql.Connection.openConnection(Connection.java:170) at org.postgresql.Driver.connect(Driver.java:122) at java.sql.DriverManager.getConnection(DriverManager.java:517
.............
........"
Could you plese guide me to solve this problem,
 
Thanks ,
Sanjay Amin
Software Engineer
Arraycom(India) Ltd.,
B13,13/1 & 14 , Electronic Estate,
GIDC,Sector:25,Gandhinagar,
Gujarat-382 044
Phone:079-3229011-13
Fax:079-3229014
E-mail : sanjay@pmelgroup.com

Re: Urgent :Query - Please help

From
Dave Cramer
Date:
Sanjay,

There is a file called pg_hba.conf that needs an entry in it to allow
access into the db

Dave


On Wed, 2002-04-03 at 00:29, sanjay wrote:
> Dear Sir,
>                   I am using Linux RedHat 7.2 with jakarta-tomcat-4.0.1 and Postgresql 7.1.3. I m getting following
errorwhen I run a servlet with the database named "test" having user "nobody". I m running this servlet from one of the
clientm/c. The servlet is using jdbc connection, select some records from a table and display it. 
>
> "Something unusual has occured to cause the driver to fail. Please report this exception: Exception:
java.sql.SQLException:No pg_hba.conf entry for host 192.168.1.50, user nobody, database test Stack Trace:
java.sql.SQLException:No pg_hba.conf entry for host 192.168.1.50, user nobody, database test at
org.postgresql.Connection.openConnection(Connection.java:170)at org.postgresql.Driver.connect(Driver.java:122) at
java.sql.DriverManager.getConnection(DriverManager.java:517
> .............
> ........"
> Could you plese guide me to solve this problem,
>
> Thanks ,
> Sanjay Amin
> Software Engineer
> Arraycom(India) Ltd.,
> B13,13/1 & 14 , Electronic Estate,
> GIDC,Sector:25,Gandhinagar,
> Gujarat-382 044
> Phone:079-3229011-13
> Fax:079-3229014
> E-mail: sanjay@pmelgroup.com




Re: Urgent :Query - Please help

From
Auri Mason
Date:
yes, that file is usually located under DATA dir.
You've to restart the postmaster to enable your changes.

Auri

On 4 Apr 2002, Dave Cramer wrote:

> Sanjay,
>
> There is a file called pg_hba.conf that needs an entry in it to allow
> access into the db
>
> Dave
>
>
> On Wed, 2002-04-03 at 00:29, sanjay wrote:
> > Dear Sir,
> >                   I am using Linux RedHat 7.2 with jakarta-tomcat-4.0.1 and Postgresql 7.1.3. I m getting following
errorwhen I run a servlet with the database named "test" having user "nobody". I m running this servlet from one of the
clientm/c. The servlet is using jdbc connection, select some records from a table and display it. 
> >
> > "Something unusual has occured to cause the driver to fail. Please report this exception: Exception:
java.sql.SQLException:No pg_hba.conf entry for host 192.168.1.50, user nobody, database test Stack Trace:
java.sql.SQLException:No pg_hba.conf entry for host 192.168.1.50, user nobody, database test at
org.postgresql.Connection.openConnection(Connection.java:170)at org.postgresql.Driver.connect(Driver.java:122) at
java.sql.DriverManager.getConnection(DriverManager.java:517
> > .............
> > ........"


Re: Urgent :Query - Please help

From
"Nick Fankhauser"
Date:
Sanjay-

You can find some information on this subject here:

http://www.fankhausers.com/postgresql/jdbc/#tcpip

and here:

http://www.postgresql.org/idocs/index.php?client-authentication.html#PG-HBA.
CONF

-Nick
---------------------------------------------------------------------
Nick Fankhauser

    nickf@ontko.com  Phone 1.765.935.4283 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/




-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of sanjay
Sent: Wednesday, April 03, 2002 12:30 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Urgent :Query - Please help


Dear Sir,
                  I am using Linux RedHat 7.2 with jakarta-tomcat-4.0.1 and
Postgresql 7.1.3. I m getting following error when I run a servlet with the
database named "test" having user "nobody". I m running this servlet from
one of the client m/c. The servlet is using jdbc connection, select some
records from a table and display it.

"Something unusual has occured to cause the driver to fail. Please report
this exception: Exception: java.sql.SQLException: No pg_hba.conf entry for
host 192.168.1.50, user nobody, database test Stack Trace:
java.sql.SQLException: No pg_hba.conf entry for host 192.168.1.50, user
nobody, database test at
org.postgresql.Connection.openConnection(Connection.java:170) at
org.postgresql.Driver.connect(Driver.java:122) at
java.sql.DriverManager.getConnection(DriverManager.java:517
.............
........"
Could you plese guide me to solve this problem,

Thanks ,
Sanjay Amin
Software Engineer
Arraycom(India) Ltd.,
B13,13/1 & 14 , Electronic Estate,
GIDC,Sector:25,Gandhinagar,
Gujarat-382 044
Phone:079-3229011-13
Fax:079-3229014
E-mail : sanjay@pmelgroup.com