I'm running RH 7.3...That was the exact same problem I had until I added a user through the grant command. You might try limiting the access to a specific table and user like in the example I sent (I'm grasping for straws here).
Maybe nmap your system through the hostname and through the IP and make sure 3306 appears for each. Just to make sure that it's not going outside the system and coming back. It's more of a JRun and JDBC problem. -Derrick On Fri, 2002-07-12 at 15:43, [EMAIL PROTECTED] wrote: > Derrick, > > Already been down that path. I called him up personally and asked him. ;) > > ~Todd > > p.s. I'm the guy that has it running on RH7.2 with no problems. > > > On 12 Jul 2002, Derrick Shoemake wrote: > > > Dennis, > > > > It probably is a permissions problem, create a new user using the grant > > command a test would be the following: > > > > grant all privileges on testdb.* to testuser@'%' identified by > > 'testpassword'; > > > > You would of coarse want to revoke that after the test.... then apply > > the proper host where the '%' was. > > > > The mysql reference to this is > > > > http://www.mysql.com/doc/G/R/GRANT.html > > > > > > > > On Fri, 2002-07-12 at 14:17, dennis baldwin wrote: > > > Is anyone running Red Hat 7.3 with CF MX and MySQL? I keep getting the > > > following error when creating a DSN: > > > > > > "Connection verification failed for data source: testing > > > []java.sql.SQLException: SQLException occurred in JDBCPool while attempting > > > to connect, please check your username, password, URL, and other > > > connectivity info. > > > The root cause was that: java.sql.SQLException: SQLException occurred in > > > JDBCPool while attempting to connect, please check your username, password, > > > URL, and other connectivity info." > > > > > > I've verified that it isn't a permissions issue because I'm able to connect > > > via the MySQL command line tool. A friend of mine is running CF MX with > > > MySQL on 7.2 with no problems. I'd greatly appreciate any feedback or > > > suggestions you may have. > > > > > > Thanks, > > > Dennis > > > > > > ps. this didn't help much > > > http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10&threadid > > > =357509&highlight_key=y&keyword1=mysql > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
