CFMX to MySQL 4.1 connection

[Lingodude]

:confused;
Has anyone an idea on why CF administrator would fail when attemping to
connect to a new Data Source?
CFMX and MySQL installed on the same test machine.
CFMX templates running fine, connecting to other datasources like MS Access
and Oracle.
Brand new install of MySQL from the MySQL Site. The CFMX Admin gives me

--------------------------------------------------------------------------------
---------------------------------
Connection verification failed for data source: MySQL
[]java.sql.SQLException: Communication failure during handshake. Is there a
server running on 'myIPnumber:portnumber(3306)'?
The root cause was that: java.sql.SQLException: Communication failure during
handshake. Is there a server running on MyIP:3306?

--------------------------------------------------------------------------------
---------------------------------
Tried the Macromedia tech note
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170[/url]
but this made no difference in the error message.

I've ensured that the MySQL server is up and running on the port 3306, and use
an IP instead of localhost.
I can open the DB from a command line and show the current db's; create users;
change permissions; etc.
A quick check in the Windows Services dialog shows MySQL up and running as a
service (I'm on win 2000)
But I can not get past the error shown above.
Any ideas? I'll try anything at this point. (Normally its quite simple to
connect to DB's from within CFMX Admin)
thanks in advance for any reply post,

[Lingodude]

Tried Tech Note:
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?
---------------------------
* Have placed
"C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.1.10-bin.jar," in the
Class path after coping the jar file to the lib directory.
* Restarted the CFMX server after these changes.
Not sure what to do next.
Have installed latest Driver from MySQL and used Macromedia Tech notes to
update the Admin fields.
Can any one point me in the right direction ??

[feiloiram]

Hi Lingdude,

did you eventually find the answer.
I can't get my CF7.0 connected to MySQL5.0 although I get another
error-message.
If you found the answer to your question than please post it here!

Mario

[mxstu]

Originally posted by: feiloiram
I can't get my CF7.0 connected to MySQL5.0 although I get another
error-message.
If you found the answer to your question than please post it here!
Mario

Mario,

Glad to see you solved your mySQL5.0 problem on your other thread.

I was also receiving the "Unable to instantiate logger class" error but
solved the problem by using a different version of the mySql jar. I used
mysql-connector-java-3.0.17-ga-bin.jar .... instead of ...
mysql-connector-java-3.1.10-bin.jar

[esch]

[BUMP]

Having issues with newer MySQL jdbc's. Anyone come up with a solution for the Logger Class?

Unable to instantiate logger class 'com.mysql.jdbc.log.Log4JLogger'

[mxstu]

What version of the jar are you using?

[esch]

Driver: 3.1.10-bin

I believe all of the 3.1 drivers have this issue. I therefore swiched up to
the 3.2.0-alpha driver. It is currently in development and haven't had any
issues. Believe I will wait for ga version of 3.2 before production move.

[mxstu]

Well, it's a bit older, but I used mysql-connector-java-3.0.17-ga-bin.jar with no problems.

[J-Quest]

Thanks for this thread! I had just upgraded to mysql 4.1 and hit a wall with CF
MX not connecting. I was trying to use the mysql-connector-java-3.1.10-bin.jar
with the same issues above. The older mysql-connector-java-3.0.17-ga-bin.jar
ended up working (Thankfully! I have a project due in 2 weeks ;) )

Cheers!

[Evil-Devil82]

Due to the UTF-8 issues, i also had some problems with it and solved via adding
useUnicode=true&characterEncoding=UTF8
to the connection string. Hope that helps some ppl.

Benny

[mxstu]

Originally posted by: esch
Driver: 3.1.10-bin

I believe all of the 3.1 drivers have this issue. I therefore swiched up to
the 3.2.0-alpha driver. It is currently in development and haven't had any
issues. Believe I will wait for ga version of 3.2 before production move.

esch,

Just an update. I was able to use mySQL 4.1 |
mysql-connector-java-3.1.7-bin.jar | MX7 and it seems to work fine so far.

[drmaves]

Where did you find mysql-connector-java-3.1.7-bin.jar? I can only find 3.1.10 on the mysql.com site.
3.1.10 doesn't seem to work with CFMX7.

[mxstu]

Just look through the ftp directory of one of the mirror sites. They have most
versions. For example:

[url]ftp://ftp.orst.edu/pub/mysql/Downloads/Connector-J/[/url]
[url]ftp://mirror.services.wisc.edu/mirrors/mysql/Downloads/Connector-J/[/url]

[smika]

Dont know why, but this works. Set your root users password to NONE and then connect through CF admin using root and empty pass.

[smika]

Dont know why, but this works. Set your root users password to NONE and then connect through CF admin using root and empty pass.