>> "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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
