More examples of how the patch provides a better error message: 1) When trying to connect to a database on mysql that doesn't exist:
Connection verification failed for data source: mysql_stonefly []java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: General error: Unknown database 'blah' The root cause was that: java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: General error: Unknown database 'blah' 2) When trying to connect to the database while using an incorrect port (33062 instead of 3306): Connection verification failed for data source: mysql_psgamay []java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: Cannot connect to MySQL server on stonefly.domain.:33062. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException) The root cause was that: java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: Cannot connect to MySQL server on stonefly.domain.com:33062. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException) -----Original Message----- From: Steven Erat [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 1:02 PM To: CF-Linux Subject: RE: MySQL datasource in CF admin error >> "I had mentioned in a reply earlier that I had tried that patch, and >> I got the exact same error." I don't have your message regarding this in my inbox, and I don't see it on the HOF website archive. What message did the CFAdmin display? I just tested the patch and found that it does produce a verbose error message describing exactly what's going on... Here's what I get when trying to verify a mysql datasource from the CFMX Admin when the user is not allowed to the database: Connection verification failed for data source: mysql_on_stonefly []java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) The root cause was that: java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) In this case, the error is telling me that the user 'testuser' is denied access to the database. Without the patch, you'll just get a generic message like you first posted. -----Original Message----- From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2003 10:59 PM To: CF-Linux Subject: Re: MySQL datasource in CF admin error On 3/15/03 8:31 AM, "Steven Erat" <[EMAIL PROTECTED]> spit this out onto my computer screen: > Again... > > Download and install this patch which will allow you to get a more > specific error message from the CFAdmin: > > Diagnostic JAR file for data source connection issues > > http://www.macromedia.com/support/coldfusion/ts/documents/tn18355.htm > > > With this patch, you'll get an exact error message and you can stop > guessing. > > > And as far as CFMX not being supported on Red Hat 8... well, its not. > So while this particular problem is likely not related to actually > running on an unsupported distro, be aware that you may encounter > unexpected results elsewhere. If your application is enterprise > class, then you might want to rethink your configuration. ... Just > fyi. I had mentioned in a reply earlier that I had tried that patch, and I got the exact same error. So I did not have any other info to add on... This is far from an enterprise based server - just learning, etc. I have narrowed it down to a MySQL issue. It seems as though mysql will accept the connection if I start it so that it doesn't need an id. And also - any gui's that are running else where also have this issue - so I am trying to get help here - but would appreciate any contact from some mySQL admin's off list! d ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
