MySQL Not Working WIth ColdFusion

[Guest]

Hi Everyone,

Originally I'd posted this as a reply to someone else's post, but though it'd be better as it's own. I'm hoping someone can please help me with a tricky problem I've ran into. We've just got a new server and I'm trying to set up ColdFusion MX 7 to run on it. It's a linux server running Redhat AS4, mySQL 4.1.12.

We'll we've gotten ColdFusion installed just fine, but we can't get it to work with MySQL to work with ColdFusion. We've already read and followed the Tech Note about Configuring a JDBC Driver for MySQL 4.1 or 5 for use with ColdFusion MX but it didn't help.

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=6ef0253


No mater what we've tried, we keep getting the error shown below. We've tried upgrading the database to MySQL 4.1.22. No luck. We've tried running it with MySQL Connector/J 3.1.10 and then MySQL Connector/J 5.0. No luck. We have of course restarted the server between each attempt.

Could it possible be a permissions problem or something. Also, and I don't know if this could have any effect, but we have ColdFusion running as the user "Apache". Thanks so much for your help, as we're sort of desperate to get this working. Right now I'm trying somethings suggested in another post, but appreciate any help you can give.




================================
Error Message:


Error Executing Database Query.
Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream ** BEGIN NESTED EXCEPTION ** java.io.IOException MESSAGE: Unexpected end of input stream STACKTRACE: java.io.IOException: Unexpected end of input stream at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1455) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1826) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1153) at com.mysql.jdbc.Connection.execSQL(Connection.java:2048) at com.mysql.jdbc.Connection.execSQL(Connection.java:2005) at com.mysql.jdbc.Statement.execute(Statement.java:900) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212) at coldfusion.sql.Executive.executeQuery(Executive.java:753) at coldfusion.sql.Executive.executeQuery(Executive.java:675) at coldfusion.sql.Executive.executeQuery(Executive.java:636) at coldfusion.sql.SqlImpl...

Resources:

* Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.
* Check the ColdFusion documentation to verify that you are using the correct syntax.
* Search the Knowledge Base to find a solution to your problem.

Browser Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.0.10) Gecko/20070216 Firefox/1.5.0.10
Remote Address 68.3.98.159
Referrer http://www.load-pilot.com/main.cfm
Date/Time 02-Mar-07 04:06 PM

[Newsgroup_User]

does MySQL work by itself? did you try connecting to your databases with
phpMyAdmin or alike?

also, make sure you do not have several mysql-connector-xxxxxx.jap.bin
(whatever their names are, you know, the jdbc driver files) of different
versions - make sure there is only ONE, preferably the latest one,
anywhere on your server. remove any other ones.

if i remember correctly, the exception you get in the error is usually
caused by incorrect/old mysql connector drivers...


--
Azadi Saryev
Sabai-dee.com
Vientiane, Laos
http://www.sabai-dee.com

[Guest]

I can connect to the MySQL server using NaviCat just fine. I even uploaded a test database to be sure. I'll check to be sure we only have one mysql-connector driver in the folder.

[Guest]

Almost forgot to mention, attached is the error message we get from the various logs.

[Guest]

We checked and there are no other mysql connector drivers. Do you have any other ideas??

[Newsgroup_User]

i am sorry i could not help more... one other thing i can suggest is
looking up the issue on the MySQL forums - there are gazillions postings
there about similar issues - maybe you will find an answer there...

i will keep looking, too...

--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

[fabio_cf]

see
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=1248292
I hope you resolve the problem

[Guest]

Thanks I'll also take a look around the MySQL forms. We've tried 4 or 5 different connector J versions and nothing works. Still keep on geting the same error. Does Adobe offer any kind of paid tech support? We're getting desperate.

Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION **

[BKBK]

You possibly have not deleted previously installed MySQL drivers. What to look for are MySQL jar files. The places to look are the lib directories. If old, or even renamed, drivers are still there, Coldfusion will take them up in the classpath.