Problem connecting to PostgreSQL on Debian Linux
От | Jeff Self |
---|---|
Тема | Problem connecting to PostgreSQL on Debian Linux |
Дата | |
Msg-id | 1035559362.12741.48.camel@jselfpc обсуждение исходный текст |
Ответы |
Re: Problem connecting to PostgreSQL on Debian Linux
Re: Problem connecting to PostgreSQL on Debian Linux |
Список | pgsql-jdbc |
I've written a JSP that extracts data from a PostgreSQL database and displays it in a web browser. I tested this on my iBook which is running OS X 10.2, PostgreSQL 7.2.3, Tomcat 4.1.12, and Java 1.3.1. It runs fine. So I copied the app over to my server which is running Debian Linux 3.0, PostgreSQL 7.2.2, Tomcat 4.1.12, and Blackdown Java 1.3.1. But I can't connect to the database on the Debian box. Here's some of my settings on the Debian box: Postgresql.conf tcpip_socket=1 Pg_hba.conf host all 127.0.0.1 255.255.255.255 ident sameuser I've tried to connect writing a little java app to run from the command line, but it fails: IDENT authentication failed for user "jself" Here's some of my code: Class.forName("org.postgresql.Driver"); Connection conn = DriverManager.getConnection( "jdbc:postgresql:jobdescriptions", "jself" "" ); I've downloaded the pgjdbc2.jar file from jdbc.postgresql.org and put it in /usr/share/tomcat4/common/lib. I run my java app the following way: java -classpath /usr/share/tomcat4/common/lib/pgjdbc2.jar:. QueryJobDescriptions Is my pg_hba.conf file wrong? jself is the owner of the jobdescriptions database and has no password -- Jeff Self Information Technology Analyst City of Newport News Personnel Department Suite 200 700 Town Center Drive Newport News, VA 23606 757-926-1810
В списке pgsql-jdbc по дате отправления: