Timed out trying to establish connection

[ladybug]

cool! i will give that a try next time it happens. we try to restart the
service through the services console on windows but even the service hangs up
when you stop it. VERY frustrating! maybe this will work better!

thanks!

[webdr7]

I have had a problem stopping the server from the services console and
executing this code forced the stop and start so I didn't have to reboot the
server.
Let me know if you find anything on the forums in response to our problem that
quite a few people seem to be having.
Thanks!

[JuvenTF]

Hi,
sorry for my english. Is very bad.

We have the same issue in our Win2003 server and CFMX 7. Before, in CFMX 6.1,
the problem was the same too.
Would be CF 6 the solution? We are thinking about this posibility...

Oh...Macromedia...we are you???????????

Juven

[JuvenTF]

Hi,
sorry for my english. Is very bad.

We have the same issue in our Win2003 server and CFMX 7. Before, in CFMX 6.1,
the problem was the same too.
Would be CF 6 the solution? We are thinking about this posibility...

Oh...Macromedia...we are you???????????

Juven

[Scooby Doobie Doo]

No kidding, I have not touched my box or code and I'm getting

Connection verification failed for data source: ENROLL
[]java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish
connection

I'm running 6.1 and my entire site is down now due to this issue that there
seems to be no fix for. ARGH.

[wadudu]

This is pretty nuts. I have two CF servers running on different boxes both of
them are Version: 6,1,0,63958. Recetly one of my servers has been misbehaving
and atleast once to a day I am getting this error:

"java.sql.SQLException: Timed out trying to establish connection at
coldfusion.server.j2ee.sql.pool.JDBCPool.requestCo nnection"

Once this happens I have to restart the CF MX ODBC Server which hangs but
finally stops after about 5 minutes. Is there any news from Macromedia about
comming up with a fix? Is the MX 6.1 build I am running the most current (i.e
with the supposed fixes)? This is pretty annoying. Aarrrrrgggh!!

[ICND]

How did you set up this file to fire when the service goes down?

<cfset cfAdmin=createObject("component", "cfide.adminapi.administrator")>
<cfset isLoggedIn=cfAdmin.login("YOUR CF ADMIN PASSWORD HERE")>

<cfset setDSN=createObject("component","CFIDE.adminapi.da tasource")>
<cfinvoke component="#setDSN#" method="stopOdbcService">

<cfinvoke component="#setDSN#" method="startOdbcService">

[Scooby Doobie Doo]

Do you really want to have to kill your ODBC connections? What about other
users on the site, they'll have to relogin and lose all their settings each
time, this doesn't seem like a viable solution to me.

[webdr7]

You have to stop and restart the ODBC service killing all ODBC connections.
When the service hangs all the sites go down that are using the ODBC driver so
the service is useless until restared anyway. Would be nice if we could get
some kind of response from Macromedia since there are so many people having
this problem with 7.0

[webdr7]

I have a script running on another server that does an http request every few
minutes to see if the website it up and running. If it is not I send another
http request to the script that has the code I posted to stop and restart the
ODBC service which ends up getting things back up and running everytime.
Problem is when it happens the sites are still down for a minute or 2 while the
stop and start happens. The problem is very intermittent and the logs show
nothing so this is very difficult to try to find a permanent solution for.

[ChuckInAtl]

It appears that I am connecting to MySQL (following Matts directions) now I
receive this

Connection verification failed for data source: cucar.DSN
[]java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish
connection

This is my JDBC URL

jdbc:mysql://localhost:3306/cucar

Thanks

[Neculai Macarie]

> It appears that I am connecting to MySQL (following Matts directions) now
I

> receive this
>
> Connection verification failed for data source: cucar.DSN
> []java.sql.SQLException: Timed out trying to establish connection
> The root cause was that: java.sql.SQLException: Timed out trying to

establish

> connection
>
> This is my JDBC URL
>
> jdbc:mysql://localhost:3306/cucar

Check to see if the connection is allowed from from the firewall.

--
<mack />

[ChuckInAtl]

Thanks for the reply..

I saw in previous post NOT to have the firewall up, so I don't...???

Chuck

[Jackiex]

Can you share the script that does an http request every few minutes to see if the website it up and running? Thanks.

[webdr7]

Just a simple <cfhttp> request within a <cftry> <cfcatch> block
<cftry>
<cfhttp url="http://www.YourWebsite.com" method="GET">
<cfcatch>
Run the code you want to run if the site throws an error here............
</cfcatch>
</cftry>

[Unregistered]

We ran into this funny problem. no event log or windows event to tell us what happened. The server would give error timeout. Why? no idea. Should we restrict connections, should we increase timeout, should we maintain connections across clients? should we reduce simultaneoius templates count...what? The CFADMIN page and adobe is so silent on this.

Trying to restart ODBC is a technically beautiful solution but not good for running e-commerce.
We are contemplating moving our site from CFM to PHP or ASP.