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: > > > > > value="org.postgresql.Driver" /> > > > value="jdbc:postgresql://192.168.1.22:5432/omsdb" /> > > > value="postgres" /> > > > value="postgres" /> > > > > * > > 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
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: > > > > > value="org.postgresql.Driver" /> > > > value="jdbc:postgresql://192.168.1.22:5432/omsdb" /> > > > value="postgres" /> > > > value="postgres" /> > > > > * > > 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
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: >> >> >> >>> >>value="org.postgresql.Driver" /> >> >>> >>value="jdbc:postgresql://192.168.1.22:5432/omsdb" /> >> >>> >>value="postgres" /> >> >>> >>value="postgres" /> >> >> >> >>* >> >>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
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: > > > > > value="org.postgresql.Driver" /> > > > value="jdbc:postgresql://192.168.1.22:5432/omsdb" /> > > > value="postgres" /> > > > value="postgres" /> > > > > * > > 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
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: * 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
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: > > > > > value="org.postgresql.Driver" /> > > > value="jdbc:postgresql://192.168.1.22:5432/omsdb" /> > > > value="postgres" /> > > > value="postgres" /> > > > > * > > 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
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: * 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]
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: * 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
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: > > > > > value="org.postgresql.Driver" /> > > > value="jdbc:postgresql://192.168.1.22:5432/omsdb" /> > > > value="postgres" /> > > > value="postgres" /> > > > > * > > > > 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]
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: > > > > > value="org.postgresql.Driver" /> > > > value="jdbc:postgresql://192.168.1.22:5432/omsdb" /> > > > value="postgres" /> > > > value="postgres" /> > > > > * > > > > 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]
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(); /* 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: * 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]