Re: Struts to Postgresql db connection refused
On 9/13/05, David G. Friedman [EMAIL PROTECTED] wrote:
Raj,
Have you double checked that you can reach it from the command line on the
server BEFORE trying it in Tomcat? I've encountered problems where a slight
mistake in the MySQL configuration often causes this problem, not usually
the web server. From the information you provided, try this at a command
line (should work for a UNIX shell or Windows CMD.EXE, not sure about Macs):
mysql -upostgres -ppostgresq -h192.168.1.22 -P5432 omsdb
Connecting to PostgreSQL using the mysql command line tool ??!!?!!
This will never work
The right suggestion is to try connecting with :
psql -h 192.168.1.22 -U postgres omsdb
If connecting this way does not work , you need to :
1. configure postgres to allow TCP/IP connections (postgresql.conf)
2. add the ip adresses/networks that are allowed to connect (pg_hba.conf)
The two files (pg_hba.conf and postgresql.conf) are located in the
PostgreSQL's data directory .
Cheers,
Adrian Maier
Regards,
David
-Original Message-
From: R Rajendran [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 8:00 AM
To: user@struts.apache.org
Subject: Struts to Postgresql db connection refused
Hi,
When I connect Struts to Postgresql 8.0 database using DataSource object I
get the following error messages:
Source:
DataSource dataSource = null;
try {
dataSource = getDataSource(request);
conn = dataSource.getConnection();
stmt = conn.createStatement();
String sql = select * from stocks where
+ symbol =' + symbol + ';
rs = stmt.executeQuery(select * from stocks where
+ symbol =' + symbol + ');
}catch(){..}
*
struts-config.xml:
data-source type=org.postgresql.jdbc2.optional.SimpleDataSource
set-property property=driverClassName
value=org.postgresql.Driver /
set-property property=url
value=jdbc:postgresql://192.168.1.22:5432/omsdb /
set-property property=username
value=postgres /
set-property property=password
value=postgres /
/data-source
*
I am getting the following error message while running the struts
application:
INFO: Failed to create a non-pooled connection for null at
jdbc:postgresql://localhost/null?prepareThreshold=0:
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting TCP/IP
connections.
Connection refused. Check that the hostname and port are correct and that
the postmaster is accepting TCP/IP connections.
Tried starting Postmaser with -i option still not responding.
Could anyone tell me how to resolve this issue.
Thanks
Raj
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: Struts to Postgresql db connection refused
It works fine with command line. I could connect to the db and query.
Thanks
Raj
From: David G. Friedman [mailto:[EMAIL PROTECTED]
Sent: Tue 9/13/2005 5:00 AM
To: Struts Users Mailing List
Subject: RE: Struts to Postgresql db connection refused
Raj,
Have you double checked that you can reach it from the command line on the
server BEFORE trying it in Tomcat? I've encountered problems where a slight
mistake in the MySQL configuration often causes this problem, not usually
the web server. From the information you provided, try this at a command
line (should work for a UNIX shell or Windows CMD.EXE, not sure about Macs):
mysql -upostgres -ppostgresq -h192.168.1.22 -P5432 omsdb
Regards,
David
-Original Message-
From: R Rajendran [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 8:00 AM
To: user@struts.apache.org
Subject: Struts to Postgresql db connection refused
Hi,
When I connect Struts to Postgresql 8.0 database using DataSource object I
get the following error messages:
Source:
DataSource dataSource = null;
try {
dataSource = getDataSource(request);
conn = dataSource.getConnection();
stmt = conn.createStatement();
String sql = select * from stocks where
+ symbol =' + symbol + ';
rs = stmt.executeQuery(select * from stocks where
+ symbol =' + symbol + ');
}catch(){..}
*
struts-config.xml:
data-source type=org.postgresql.jdbc2.optional.SimpleDataSource
set-property property=driverClassName
value=org.postgresql.Driver /
set-property property=url
value=jdbc:postgresql://192.168.1.22:5432/omsdb /
set-property property=username
value=postgres /
set-property property=password
value=postgres /
/data-source
*
I am getting the following error message while running the struts
application:
INFO: Failed to create a non-pooled connection for null at
jdbc:postgresql://localhost/null?prepareThreshold=0:
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting TCP/IP
connections.
Connection refused. Check that the hostname and port are correct and that
the postmaster is accepting TCP/IP connections.
Tried starting Postmaser with -i option still not responding.
Could anyone tell me how to resolve this issue.
Thanks
Raj
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: Struts to Postgresql db connection refused
I tried this command it works:
psql -Upostgres -d omsdb -h 192.168.1.22 -p 5432
Thanks
Raj
From: Adrian Maier [mailto:[EMAIL PROTECTED]
Sent: Tue 9/13/2005 5:24 AM
To: Struts Users Mailing List
Subject: Re: Struts to Postgresql db connection refused
On 9/13/05, David G. Friedman [EMAIL PROTECTED] wrote:
Raj,
Have you double checked that you can reach it from the command line on the
server BEFORE trying it in Tomcat? I've encountered problems where a slight
mistake in the MySQL configuration often causes this problem, not usually
the web server. From the information you provided, try this at a command
line (should work for a UNIX shell or Windows CMD.EXE, not sure about Macs):
mysql -upostgres -ppostgresq -h192.168.1.22 -P5432 omsdb
Connecting to PostgreSQL using the mysql command line tool ??!!?!!
This will never work
The right suggestion is to try connecting with :
psql -h 192.168.1.22 -U postgres omsdb
If connecting this way does not work , you need to :
1. configure postgres to allow TCP/IP connections (postgresql.conf)
2. add the ip adresses/networks that are allowed to connect (pg_hba.conf)
The two files (pg_hba.conf and postgresql.conf) are located in the
PostgreSQL's data directory .
Cheers,
Adrian Maier
Regards,
David
-Original Message-
From: R Rajendran [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 8:00 AM
To: user@struts.apache.org
Subject: Struts to Postgresql db connection refused
Hi,
When I connect Struts to Postgresql 8.0 database using DataSource object I
get the following error messages:
Source:
DataSource dataSource = null;
try {
dataSource = getDataSource(request);
conn = dataSource.getConnection();
stmt = conn.createStatement();
String sql = select * from stocks where
+ symbol =' + symbol + ';
rs = stmt.executeQuery(select * from stocks where
+ symbol =' + symbol + ');
}catch(){..}
*
struts-config.xml:
data-source type=org.postgresql.jdbc2.optional.SimpleDataSource
set-property property=driverClassName
value=org.postgresql.Driver /
set-property property=url
value=jdbc:postgresql://192.168.1.22:5432/omsdb /
set-property property=username
value=postgres /
set-property property=password
value=postgres /
/data-source
*
I am getting the following error message while running the struts
application:
INFO: Failed to create a non-pooled connection for null at
jdbc:postgresql://localhost/null?prepareThreshold=0:
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting TCP/IP
connections.
Connection refused. Check that the hostname and port are correct and that
the postmaster is accepting TCP/IP connections.
Tried starting Postmaser with -i option still not responding.
Could anyone tell me how to resolve this issue.
Thanks
Raj
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Struts to Postgresql db connection refused
The problem is most certainly a problem with access right (ref. pg_hba.conf)...
So this problem is not really a Struts problem; you should learn how to use the
PostgreSQL
server before you try to use it from Struts
BTJ
R Rajendran wrote:
I tried this command it works:
psql -Upostgres -d omsdb -h 192.168.1.22 -p 5432
Thanks
Raj
From: Adrian Maier [mailto:[EMAIL PROTECTED]
Sent: Tue 9/13/2005 5:24 AM
To: Struts Users Mailing List
Subject: Re: Struts to Postgresql db connection refused
On 9/13/05, David G. Friedman [EMAIL PROTECTED] wrote:
Raj,
Have you double checked that you can reach it from the command line on the
server BEFORE trying it in Tomcat? I've encountered problems where a slight
mistake in the MySQL configuration often causes this problem, not usually
the web server. From the information you provided, try this at a command
line (should work for a UNIX shell or Windows CMD.EXE, not sure about Macs):
mysql -upostgres -ppostgresq -h192.168.1.22 -P5432 omsdb
Connecting to PostgreSQL using the mysql command line tool ??!!?!!
This will never work
The right suggestion is to try connecting with :
psql -h 192.168.1.22 -U postgres omsdb
If connecting this way does not work , you need to :
1. configure postgres to allow TCP/IP connections (postgresql.conf)
2. add the ip adresses/networks that are allowed to connect (pg_hba.conf)
The two files (pg_hba.conf and postgresql.conf) are located in the
PostgreSQL's data directory .
Cheers,
Adrian Maier
Regards,
David
-Original Message-
From: R Rajendran [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 8:00 AM
To: user@struts.apache.org
Subject: Struts to Postgresql db connection refused
Hi,
When I connect Struts to Postgresql 8.0 database using DataSource object I
get the following error messages:
Source:
DataSource dataSource = null;
try {
dataSource = getDataSource(request);
conn = dataSource.getConnection();
stmt = conn.createStatement();
String sql = select * from stocks where
+ symbol =' + symbol + ';
rs = stmt.executeQuery(select * from stocks where
+ symbol =' + symbol + ');
}catch(){..}
*
struts-config.xml:
data-source type=org.postgresql.jdbc2.optional.SimpleDataSource
set-property property=driverClassName
value=org.postgresql.Driver /
set-property property=url
value=jdbc:postgresql://192.168.1.22:5432/omsdb /
set-property property=username
value=postgres /
set-property property=password
value=postgres /
/data-source
*
I am getting the following error message while running the struts
application:
INFO: Failed to create a non-pooled connection for null at
jdbc:postgresql://localhost/null?prepareThreshold=0:
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting TCP/IP
connections.
Connection refused. Check that the hostname and port are correct and that
the postmaster is accepting TCP/IP connections.
Tried starting Postmaser with -i option still not responding.
Could anyone tell me how to resolve this issue.
Thanks
Raj
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Struts to Postgresql db connection refused
On 9/13/05, David G. Friedman [EMAIL PROTECTED] wrote:
Raj,
Have you double checked that you can reach it from the command line on the
server BEFORE trying it in Tomcat? I've encountered problems where a slight
mistake in the MySQL configuration often causes this problem, not usually
the web server. From the information you provided, try this at a command
line (should work for a UNIX shell or Windows CMD.EXE, not sure about Macs):
mysql -upostgres -ppostgresq -h192.168.1.22 -P5432 omsdb
Connecting to PostgreSQL using the mysql command line tool ??!!?!!
This will never work
The right suggestion is to try connecting with :
psql -h 192.168.1.22 -U postgres omsdb
If connecting this way does not work , you need to :
1. configure postgres to allow TCP/IP connections (postgresql.conf)
2. add the ip adresses/networks that are allowed to connect (pg_hba.conf)
The two files (pg_hba.conf and postgresql.conf) are located in the
PostgreSQL's data directory .
Cheers,
Adrian Maier
Regards,
David
-Original Message-
From: R Rajendran [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 8:00 AM
To: user@struts.apache.org
Subject: Struts to Postgresql db connection refused
Hi,
When I connect Struts to Postgresql 8.0 database using DataSource object I
get the following error messages:
Source:
DataSource dataSource = null;
try {
dataSource = getDataSource(request);
conn = dataSource.getConnection();
stmt = conn.createStatement();
String sql = select * from stocks where
+ symbol =' + symbol + ';
rs = stmt.executeQuery(select * from stocks where
+ symbol =' + symbol + ');
}catch(){..}
*
struts-config.xml:
data-source type=org.postgresql.jdbc2.optional.SimpleDataSource
set-property property=driverClassName
value=org.postgresql.Driver /
set-property property=url
value=jdbc:postgresql://192.168.1.22:5432/omsdb /
set-property property=username
value=postgres /
set-property property=password
value=postgres /
/data-source
*
I am getting the following error message while running the struts
application:
INFO: Failed to create a non-pooled connection for null at
jdbc:postgresql://localhost/null?prepareThreshold=0:
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting TCP/IP
connections.
Connection refused. Check that the hostname and port are correct and that
the postmaster is accepting TCP/IP connections.
Tried starting Postmaser with -i option still not responding.
Could anyone tell me how to resolve this issue.
Thanks
Raj
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: Struts to Postgresql db connection refused
Yep. Shoot me. DUH! That's what I get for getting
up early and reading my e-mail first thing in the
morning.
Do I win the 'dork of the day award' if I say 'DOH! ?
Regards,
David
-Original Message-
From: Adrian Maier [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 8:24 AM
To: Struts Users Mailing List
Subject: Re: Struts to Postgresql db connection refused
On 9/13/05, David G. Friedman [EMAIL PROTECTED] wrote:
Raj,
Have you double checked that you can reach it from the command line on the
server BEFORE trying it in Tomcat? I've encountered problems where a
slight
mistake in the MySQL configuration often causes this problem, not usually
the web server. From the information you provided, try this at a command
line (should work for a UNIX shell or Windows CMD.EXE, not sure about
Macs):
mysql -upostgres -ppostgresq -h192.168.1.22 -P5432 omsdb
Connecting to PostgreSQL using the mysql command line tool ??!!?!!
This will never work
The right suggestion is to try connecting with :
psql -h 192.168.1.22 -U postgres omsdb
If connecting this way does not work , you need to :
1. configure postgres to allow TCP/IP connections (postgresql.conf)
2. add the ip adresses/networks that are allowed to connect (pg_hba.conf)
The two files (pg_hba.conf and postgresql.conf) are located in the
PostgreSQL's data directory .
Cheers,
Adrian Maier
Regards,
David
-Original Message-
From: R Rajendran [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 8:00 AM
To: user@struts.apache.org
Subject: Struts to Postgresql db connection refused
Hi,
When I connect Struts to Postgresql 8.0 database using DataSource object I
get the following error messages:
Source:
DataSource dataSource = null;
try {
dataSource = getDataSource(request);
conn = dataSource.getConnection();
stmt = conn.createStatement();
String sql = select * from stocks where
+ symbol =' + symbol + ';
rs = stmt.executeQuery(select * from stocks where
+ symbol =' + symbol + ');
}catch(){..}
*
struts-config.xml:
data-source type=org.postgresql.jdbc2.optional.SimpleDataSource
set-property property=driverClassName
value=org.postgresql.Driver /
set-property property=url
value=jdbc:postgresql://192.168.1.22:5432/omsdb /
set-property property=username
value=postgres /
set-property property=password
value=postgres /
/data-source
*
I am getting the following error message while running the struts
application:
INFO: Failed to create a non-pooled connection for null at
jdbc:postgresql://localhost/null?prepareThreshold=0:
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting TCP/IP
connections.
Connection refused. Check that the hostname and port are correct and that
the postmaster is accepting TCP/IP connections.
Tried starting Postmaser with -i option still not responding.
Could anyone tell me how to resolve this issue.
Thanks
Raj
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Struts to Postgresql db connection refused
You need to add the -i switch to postmaster (-o -i to pg_ctl I
think) to enable tcp/ip connections. Please see the PostgreSQL
documentation.
2005/9/8, R Rajendran [EMAIL PROTECTED]:
Hi,
When I connect Struts to Postgresql 8.0 database using DataSource object I
get the following error messages:
Source:
DataSource dataSource = null;
try {
dataSource = getDataSource(request);
conn = dataSource.getConnection();
/* working
Class.forName(org.postgresql.Driver);
conn =
DriverManager.getConnection(jdbc:postgresql://192.168.1.22:5432/omsdb,postgres,postgres);
*/
stmt = conn.createStatement();
String sql = select * from stocks where
+ symbol =' + symbol + ';
rs = stmt.executeQuery(select * from stocks where
+ symbol =' + symbol + ');
}catch(){..}
*
struts-config.xml:
data-source type=org.postgresql.jdbc2.optional.SimpleDataSource
set-property property=driverClassName
value=org.postgresql.Driver /
set-property property=url
value=jdbc:postgresql://192.168.1.22:5432/omsdb /
set-property property=username
value=postgres /
set-property property=password
value=postgres /
/data-source
*
I am getting the following error message while running the struts application:
INFO: Failed to create a non-pooled connection for null at
jdbc:postgresql://localhost/null?prepareThreshold=0:
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting TCP/IP
connections.
Connection refused. Check that the hostname and port are correct and that the
postmaster is accepting TCP/IP connections.
Could anyone tell me how to resolve this issue.
Thanks
Raj
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Struts to Postgresql db connection refused
Hi Raj
While I'm not using Postgresql (MySQL instead) there were a couple of things I
noticed
that you might need to check:
1. You have specified the data source entry in your Struts-config.xml - on my
Tomcat
5.0 I need to enter this in the META-INF/context.xml (I have more on this if
you need
it, Tomcat 5.0 and 5.5 differ in where they look for the Data Source parameters)
2. The other thing is to ensure you have your Postgresql JDBC jar file added to
your
Tomcat common/lib
Kind regards
mc
On 8 Sep 2005 at 4:11, R Rajendran wrote:
Hi,
When I connect Struts to Postgresql 8.0 database using DataSource object I
get the
following error messages:
Source:
DataSource dataSource = null;
try {
dataSource = getDataSource(request);
conn = dataSource.getConnection();
/* working
Class.forName(org.postgresql.Driver);
conn =
DriverManager.getConnection(jdbc:postgresql://192.168.1.22:5432/omsdb,postgres,
postgres);
*/
stmt = conn.createStatement();
String sql = select * from stocks where
+ symbol =' + symbol + ';
rs = stmt.executeQuery(select * from stocks where
+ symbol =' + symbol + ');
}catch(){..}
*
struts-config.xml:
data-source type=org.postgresql.jdbc2.optional.SimpleDataSource
set-property property=driverClassName
value=org.postgresql.Driver /
set-property property=url
value=jdbc:postgresql://192.168.1.22:5432/omsdb /
set-property property=username
value=postgres /
set-property property=password
value=postgres /
/data-source
*
I am getting the following error message while running the struts application:
INFO: Failed to create a non-pooled connection for null at
jdbc:postgresql://localhost/null?prepareThreshold=0:
org.postgresql.util.PSQLException: Connection refused. Check that the hostname
and
port are correct and that the postmaster is accepting TCP/IP connections.
Connection refused. Check that the hostname and port are correct and that the
postmaster is accepting TCP/IP connections.
Could anyone tell me how to resolve this issue.
Thanks
Raj
FOCUS Computing
Mob: 0415 24 26 24
[EMAIL PROTECTED]
http://www.focus-computing.com.au
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.19/93 - Release Date: 8/09/2005
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
