Re: JSP doesn't run under Debian

[Xavier Renard]

I worked on a JSP on my iBook running OS X 10.2, Tomcat 4.1.12, and
PostgreSQL 7.2.3, and Java 1.3.1. The JSP has no problem connecting to
PostgreSQL and displaying the data. So I copied the app over to my
server running Debian 3.0 stable, Tomcat 4.1.12, Blackdown Java 1.3.1
and PostgreSQL 7.2.2. I put the pgjdbc2.jar file in
/usr/share/tomcat4/common/lib. But when I try to bring up the jsp, I get
the following errors:

org.apache.jasper.JasperException: SQLException: Could not connect to
database.

make sure you have 'tcpip_socket=1' somewhere in
/etc/postgresql/postgresql.conf.

I can connect to the database running a java program from the command
line using the pgjdbc2.jar file, so I know thats not it. Is there a
problem with the Blackdown version of Java with regard to JSP's and/or
servlets? Is there anything else that needs installing?

cmd line interfaces often connect with a unix socket which is enabled by
default.

If it is from a java program, I don't think that the connection is done with unix socket but over tcp/ip.
I would have a look at the permission you have on the database("/etc/postgresql/pg_hba.conf")

Regards

Xavier

Cordialement,

--
Vincent RENARDIAS
Directeur Technique
StrongHoldNET / http://www.strongholdnet.com

--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]