OK...I still cannot get the MySQL DSN to work...I can connect in phpMyAdmin, I can connect from CF5, but I cannot connect from MX.
The user in MX is the same user that has permissions in CF5 and in phpMyAdmin... I have CF running as 'apache'...do I need to allow apache to connect to MySQL? Any other ideas? -- Josh Trefethen :::::[ Exciteworks, Inc ]::[ http://exciteworks.com ]:::::. ::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::. -----Original Message----- From: Mike Chambers [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 5:07 PM To: CF-Talk Subject: RE: CFMX Server, MySQL woes ok. now we are getting somewhere. it sounds like a permission issue on MySQL. make sure that the user that CFMX is connecting as has permission from MySQL to connect. mike chambers [EMAIL PROTECTED] > -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] > > ***If I use 127.0.0.1 as the server I get: > > []java.sql.SQLException: SQLException occurred in JDBCPool > while attempting > > to connect: java.sql.SQLException: Server configuration > denies access to > > data source. > > How about telnet here? > > > > I am using the exact same configuration options as I am in > CF5 (which > > works). MX doesn't accept these options... > > Maybe CF5 uses Unix sockets and JDBC uses IP. > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
