CFMX + mySQL

[sacal]

Hello there,

I have just installed CFMX 7 developer edition + mySQL 4.1.12a on my local
winXP pro machine. I also downloaded the JDBC for mySQL.
This download gave me two .jar files:
mysql-connector-java-3.1.10-bin.jar
mysql-connector-java-3.1.10-bin-g.jar

I saved them both to: C:\CFusionMX7\runtime\servers\lib (based on an
article I found)

I'm trying to create my first data source in CF to connect to the mySQL
data base... then implement it all with a nice Flash interface. But that's
for the future, for now ? just want to get coldFusion and mySQL to talk to
each other, but it's not working.

Here's what I did: (CF admin)
- selected Data Sources in Data & Services
- named my new Data Source: dbusertracking
- used the driver option Other

- in the data source specs:
- Added the JDBC URL: jdbc:mysql://localhost:3306/dbusertracking
- Driver class: com.mysql.jdbc.Driver
- Not sure what to enter for Drive name. Can it be anything? Like
JDBC-mySQL?

Anyway, after all that, when I submit my data source, the cold fusion
server returns a error:

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

My Timeout (min) is set to 20 with Interval (min) set to 7

What am I doing wrong?

Why is it so difficult to find good mySQL+coldFusion+Flash help online, or
even just good coldfusion help online? I can find a lot more Flash and
mySQL with PHP help and tutorials. :-(

Thanks for your help!
Marcia




:(

[cf_menace]

1. Is the MySQL server running?
2. Instead of "localhost", try 127.0.0.1
3. The "Driver Name" field is optional, so leave it blank.

Can't see anything wrong with what you've setup.

[sacal]

Thanks for your help. I changed the localhost to the IP address, and still got
the time out message.

You asked:
1. Is the MySQL server running?
Yes. I see the mysqld-nt.exe running in the windows task manager. And I can
also login to the mySQL terminal just fine.

2. Instead of "localhost", try 127.0.0.1
Tried that, made no difference.

Where, physically on the hard drive, does my database have to be? I have the
JDBC URL pointing to:
jdbc:mysql://127.0.0.1:3306/dbusertracking

But this is the actual path on the HD:
C:\Program Files\mySQL\MySQL Server 4.1\data\dbusertracking
Where dbusertracking is the directory name, which contains 3 files:
db.opt
tb_session.frm
tb_user.frm

Do I have to move my DB directory somewhere inside the CF server?
Thanks again for your help!

[mpwoodward *TMM*]

On 2005-07-11 08:37:19 -0500, "sacal" <webforumsuser@macromedia.com> said:

> Thanks for your help. I changed the localhost to the IP address, and
> still got the time out message.
>
> You asked:
> 1. Is the MySQL server running? Yes. I see the mysqld-nt.exe running
> in the windows task manager. And I can also login to the mySQL terminal
> just fine.
>
> 2. Instead of "localhost", try 127.0.0.1
> Tried that, made no difference.
>
> Where, physically on the hard drive, does my database have to be? I
> have the JDBC URL pointing to:
> jdbc:mysql://127.0.0.1:3306/dbusertracking
>
> But this is the actual path on the HD:
> C:\Program Files\mySQL\MySQL Server 4.1\data\dbusertracking
> Where dbusertracking is the directory name, which contains 3 files:
> db.opt
> tb_session.frm
> tb_user.frm
>
> Do I have to move my DB directory somewhere inside the CF server?
> Thanks again for your help!

No, the path on the hard drive where the database is actually stored
has nothing to do with how CF connects. The jdbc URL you are using
should be correct as long as your database is called dbusertracking.

Do a search on this forum and you'll find lots of discussions about
this--you might have to try using a different version of the driver, it
might be related to firewall software you have running (particularly if
you're running Norton Internet Security), and there have been several
other suggestions posted.

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

[sacal]

Thanks for the links.

I downloaded the Java connector 3.0.17 instead of 3.1 that I had, and that did the trick.