more cfmx6.1 to mysql 4.1.10

[jas5on]

i'm attempting to connect mx6.1 on w2k server to mysql 4.1.10. using the jdbc
connector. i followed the instructions in
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url] but still
get the following error message when i attempt to create a datasource. he root
cause was that: java.sql.SQLException: Communications link failure due to
underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection timed out:
connect at
com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.java:151) at
com.mysql.jdbc.MysqlIO.(MysqlIO.java:280) at
com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1765) at
com.mysql.jdbc.Connection.(Connection.java:430) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:268) at
coldfusion.server.j2ee.sql.pool.JDBCPool.createPhy sicalConnection(JDBCPool.java:
511) at
coldfusion.server.j2ee.sql.pool.ConnectionRunner$R unnableConnection.run(Connecti
onRunner.java:64) at java.lang.Thread.run(Thread.java:534) ** END NESTED
EXCEPTION ** any help would be greatly appreciated

[vkunirs]

Hi

Have you created the DSN? is there itself are you failing to create the
DSN.
can you post your data? means what are the details you are giving for this.
Because i am connecting to the mysql successfull.
if you post your configuration..we can help you out.

[jas5on]

yes, i have set up the dsn. i entered the jdbc url as
jdbc:mysql://servername:3306/butler and the driver class as
com.mysql.jdbc.Driver and then the username and password. when i submit this
config to verify the connection i get the orginally posted error. at this
time i'm using the root user to remove any user issues on the db side. i can
connect to the db with admin tools successfully so i'm pretty confident the
issue is with cf and not the db. i should note that cf is running on a w2k
server box and mysql is on an xp sp2 machine. this same setup has been running
with mysql 4.0 via odbc without issue for over a year. thanks

[vkunirs]

Hi

you said that you have created DSN successfully... where you have created this
DSN? in CF admin or in ODBC.

if it is in CF admin then you can use that dsn name directly in the cfquery
tag. then whats your problem.

you need to create DSN in CF admin and i think we dont require any jdbc url
or something else. by default it will take.
as i have done for the checking i have not given like that and the dSN is
created successfully

[jas5on]

thanks for your response. i guess i should clarify. i'm attempting to set up
a dsn in cf admin using jdbc to connect to mysql 4.1. prior to mysql 4.1 i had
an odbc connection to mysql which worked fine. mysql 4.1 doesn't work with
odbc so i'm attempting to use the jdbc. i installed the jdbc according to the
instructions in mm knowledge base article
([url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]) but i
get the error in the original post.

[vkunirs]

Hi

I think we need to create the DSN in CF admin compulsary.
first try to create the DSN ..then let me the whats the error you are getting.

[jas5on]

once again, i appreciate you help. i did try to set up the dsn and i get the
following error: the root cause was that: java.sql.SQLException:
Communications link failure due to underlying exception: ** BEGIN NESTED
EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException:
Connection timed out: connect STACKTRACE: java.net.SocketException:
java.net.ConnectException: Connection timed out: connect at
com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.java:151) at
com.mysql.jdbc.MysqlIO.(MysqlIO.java:280) at
com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1765) at
com.mysql.jdbc.Connection.(Connection.java:430) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:268) at
coldfusion.server.j2ee.sql.pool.JDBCPool.createPhy sicalConnection(JDBCPool.java:
511) at
coldfusion.server.j2ee.sql.pool.ConnectionRunner$R unnableConnection.run(Connecti
onRunner.java:64) at java.lang.Thread.run(Thread.java:534) ** END NESTED
EXCEPTION **

[Abinidi]

Jason, I had this same issue , and the fix was to run MYSQL 4.1 with
old_passwords flag on. This allowed the DSN to connect using the old hash
method. Try this: [url]http://dev.mysql.com/doc/mysql/en/old-client.html[/url]

[jas5on]

thanks for your help guys. i solved the problem. i'm a little embarrassed to
admit it but the issue was the firewall on the xp machine. sp2 installs and
runs it by default and i negelected to allow traffic on my own network.