Re: problem to connect to database

I can't use telnet. If I try [telnet localhost:5432] it always return
the same error message "Connecting To host:5432...Could not open a
connection to host on port 23 : Connect failed" but if I do [netstat
-an], it returns :
...
TCP 0.0.0.0:5432 0.0.0.0:0 LISTENING
...

Any idea?

Melanie Bergeron wrote:

> No, I can't :
> Connecting To host:5432...Could not open a connection to host on port
> 23 : Connect failed
>
> What does that mean?
>
> Melanie
>
> Dave Cramer wrote:
>
>> Melanie,
>>
>> Can you telnet into the connection ?
>>
>> telnet host:5432
>>
>> Dave
>> On Thu, 2004-01-15 at 10:49, Melanie Bergeron wrote:
>>
>>
>>> Hi all!
>>>
>>> I really need your help for this. I installed the JDBC driver on my
>>> machine by copying the jar file in C:\Program Files\Apache Software
>>> Foundation\Tomcat 5.0\common\lib\pg73jdbc3.jar and set environment
>>> variable CLASSPATH to this path. I create a JSP page (code
>>> below). The first time I launched this JSP page, all was ok. I
>>> don't use it since last week but when I try to launched it
>>> yesterday, I got an error to connecting database :
>>>
>>> Error establishing the connection : Something unusual has occured to
>>> cause the driver to fail. Please report this exception: Exception: {0}
>>>
>>> So, I don't think the error come from my code because it already
>>> work with the same code but I don't know what I do to cause this
>>> error now. Any help will be greatly appreciated.
>>>
>>> Melanie
>>>
>>>
>>> -------code for jsp page---------
>>> <%
>>> /* Load the JDBC Driver */
>>> try {
>>> Class.forName("org.postgresql.Driver");
>>> }catch(ClassNotFoundException cnfe) {
>>> out.println("<BR>Error loading driver " + cnfe + "<BR>");
>>> }
>>> /* Define the connection URL */
>>> String dbName = "gec_test";
>>> String host = "localhost";
>>> String postgresqlUrl = "jdbc:postgresql://" + host + "/" + dbName;
>>> /* Establish the connection */
>>> String username = "bergeron.melanie";
>>> String password = "*****";
>>> try{
>>> Connection connection =
>>> DriverManager.getConnection(postgresqlUrl, username, password);
>>> ...
>>> }
>>> connection.close();
>>> }catch(SQLException e){
>>> out.println("<BR>Error establishing the connection : " + e +
>>> "<BR>");
>>> }
>>>
>>>
>>>
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 1: subscribe and unsubscribe commands go to
>>> majordomo(at)postgresql(dot)org
>>>
>>>
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
> .
>