yep...I am using the exact same username / password combo as the CF5 datasource which works fine...db name is corect, everything is the same as on CF5, yet it will not work on MX...
-----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 1:13 PM To: CF-Talk Subject: RE: MySQL / MX datasource woes Hmmm. Strange. I've got mySQL and CFMX and CF 4.5 running fine on two dev servers. try 127.0.0.1 this time. I just went in and created a dsn that successfully used that and 'localhost' both just fine. The fact that it works implies you have something else going on. Are you sure you have username and password set up properly? Are you using the default port or another? Got the db name right? Just trying to cover all the bases. --------------------------------------- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --------------------------------------- ---------- Original Message ---------------------------------- from: "Josh" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Thu, 26 Dec 2002 12:36:29 -0700 >I tried the actual ip and it didn't work..thanks though... > >-----Original Message----- >From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] >Sent: Thursday, December 26, 2002 12:25 PM >To: CF-Talk >Subject: RE: MySQL / MX datasource woes > > >I think having CF5 and CFMX on the same box is a recipe for disaster. As >for the mySQL thing, I would look into the "(local)" part. Try putting >in the actual IP. > >Adam Wayne Lehman >Web Systems Developer >Johns Hopkins Bloomberg School of Public Health >Distance Education Division > > >-----Original Message----- >From: Josh [mailto:[EMAIL PROTECTED]] >Sent: Thursday, December 26, 2002 2:21 PM >To: CF-Talk >Subject: MySQL / MX datasource woes > >Can't get the MySQL connection to work... > >I am running CF5 on the smae server along side the MX standalone, until >I >get MX working properly. > >I downloaded the jrpatch.jar to get more info on the errors and now get >the >following error: > >***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). >The root cause was that: 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). > >***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. > > > >***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. >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. > > >I am using the exact same configuration options as I am in CF5 (which >works). MX doesn't accept these options... > >Any Help would be appreciated! > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
