looks like MySQL is up on that port...this is what I get:
[root@exciteworks root]# telnet 127.0.0.1 3306 Trying 127.0.0.1... Connected to 127.0.0.1. Escape character is '^]'. NHost 'localhost.localdomain' is not allowed to connect to this MySQL serverConnection closed by foreign host. I have DSNs in cf5 working fine on the server, but MX cannot connect. Thanks, Josh -----Original Message----- From: Mike Chambers [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 3:24 PM To: CF-Talk Subject: RE: CFMX Server, MySQL woes you should be able to ssh in and then run the telnet command from the server: telnet 127.0.0.1 3306 mike chambers [EMAIL PROTECTED] > -----Original Message----- > From: Josh [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 30, 2002 5:15 PM > To: CF-Talk > Subject: RE: CFMX Server, MySQL woes > > > I am running redhat 7.2...telnet is shut off, I use SSH to > connect...if I > try to telnet, the server itself refuses the connection...if > I try via SSH, > I get the following error: > > bind: Address already in use > channel_setup_fwd_listener: cannot listen to port: 3306 > Could not request local forwarding. > > -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 30, 2002 2:54 PM > To: CF-Talk > Subject: Re: CFMX Server, MySQL woes > > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
