Обсуждение: 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
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
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
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 > > ............. > > ........"
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