Josh wrote: > > ***If I use (local) as the server: > []java.sql.SQLException: SQLException occurred in JDBCPool while attempting > to connect: java.sql.SQLException: Cannot connect to MySQL server on > (local):3306. Is there a MySQL server running on the machine/port you are > trying to connect to? (java.net.UnknownHostException).
This is a problem with (local) not being translateable to an IP. > ***If I use localhost 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. > The root cause was that: java.sql.SQLException: SQLException occurred in > JDBCPool while attempting to connect: java.sql.SQLException: Server > configuration denies access to data source. Can you telnet to the server on port 3306? I don't know how the communications startup for MySQL should look, but you should be able to see the difference between MySQL not listening and MySQL denying access because you don't follow the communications protocol. > ***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 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
