On 3/17/03 10:02 AM, "Steven Erat" <[EMAIL PROTECTED]> spit this out onto my computer screen:
>>> "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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
