can't verify mySQL datasource - works in mySQL, but notin CF7

[gullbuy]

I can't verify a local mySQL datasource in ColdFusion 7 admin. I am using
Dreamweaver MX 2004 with the CF7 extensions installed. I am developing locally
and running Apache 2, mySQL 4.1, and ColdFusion 7. In mySQL I can see and
access the local databases at localhost, port 3306, but I cannot verify these
datasources in ColdFusion. I read the technote at
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url] and placed
the mysql-connector-java-3.1.8-bin-g.jar driver in my wwwroot/WEB-INF/lib
folder, then restarted the server, but I get this error:

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

Can anyone offer any guidance? I am at wits end - I've been working on this
many hours.

[alexzive]

I cannot help you because I have the same problem. I tried to verify my
datasources with the technote you posted and get thi error:
[]java.sql.SQLException: No suitable driver available for prova, please check
the driver setting in resources file, error: com.mysql.jdbc.Driver

I hope we will find a solution because I spend a lt of time too for my
database!!!!
keep in touch
Alex
:confused;

[MattatCLC]

I know this was posted almost a month ago, but I too am experiencing the exact
same problem. Did you manage to find the solution.

The problem is not the drivers because if I take them out I get a different
error message about the driver.

If you have found a solution, please post it as I am ready to launch this PC
and monitor out of the window.

[mpwoodward *TMM*]

On 2005-06-14 05:09:52 -0500, "MattatCLC" <webforumsuser@macromedia.com> said:

> I know this was posted almost a month ago, but I too am experiencing
> the exact same problem. Did you manage to find the solution.
>
> The problem is not the drivers because if I take them out I get a
> different error message about the driver.
>
> If you have found a solution, please post it as I am ready to launch
> this PC and monitor out of the window.

The last person that had this problem discovered it was related to
Norton Internet Security blocking traffic to port 3306. Do you have
Norton Internet Security or some other software firewall installed?

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[gullbuy]

The way I solved the problem was by realizing that the
mysql-connector-java-3.1.8-bin-g.jar driver is NOT the correct driver, and
that there is another driver in the distribution with the same name, except no
-g at the end. the -g version is just for debugging. The file name is so long
that it is easy to miss the end of it.

Go into the distribution that you downloaded and find out which driver you are
using. I use McAffee Antivirus and there was no issue with that - it was the
driver.

[surenr]

hai guys,
I am not sure whether the below site will help you to configure
the drivers,but just give a look it might help:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652[/url]

[TallGuy@NES]

I have been trying to configure the JDBC connector or mySQL on our development
envronment (MX6).
I ran into most of the problems listed here -- with one exception. When
attempting to verify the connection I got the following error. And so far I
have not been able find any documentation .... HELP.


Connection verification failed for data source: dsn_ccDATA
[]java.sql.SQLException: Unable to instantiate logger class
'com.mysql.jdbc.log.Log4JLogger', exception in constructor?
The root cause was that: java.sql.SQLException: Unable to instantiate logger
class 'com.mysql.jdbc.log.Log4JLogger', exception in constructor?

What the @#! does that mean?

[mpwoodward *TMM*]

On 2005-06-14 16:25:41 -0500, "TallGuy@NES"
<webforumsuser@macromedia.com> said:

> I have been trying to configure the JDBC connector or mySQL on our
> development envronment (MX6).
> I ran into most of the problems listed here -- with one exception.
> When attempting to verify the connection I got the following error.
> And so far I have not been able find any documentation .... HELP.
>
>
> Connection verification failed for data source: dsn_ccDATA
> []java.sql.SQLException: Unable to instantiate logger class
> 'com.mysql.jdbc.log.Log4JLogger', exception in constructor?
> The root cause was that: java.sql.SQLException: Unable to instantiate
> logger class 'com.mysql.jdbc.log.Log4JLogger', exception in constructor?
>
> What the @#! does that mean?

My guess would be you're using the "debugging" driver the other poster
mentioned. Which specific driver are you using?
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[TallGuy@NES]

Matt
I thought of that too -- but I am not using the 'g' version.
I am using mysql-connector-java-3.1.8-bin.jar.

I could understand an 'unable to connect' error -- but that logger error has
me puzzled.

David

[mpwoodward *TMM*]

On 2005-06-16 08:02:31 -0500, "TallGuy@NES"
<webforumsuser@macromedia.com> said:

> Matt
> I thought of that too -- but I am not using the 'g' version.
> I am using mysql-connector-java-3.1.8-bin.jar.
>
> I could understand an 'unable to connect' error -- but that logger
> error has me puzzled.
>
> David

Have you tried an older driver? Some people have had better luck with
3.1.6 (I believe).

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[Mountain Lover]

I'm using 3.1.7 because of the "logger" problem
HTH

--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]