Adam Wayne Lehman wrote: >or a limit as to how many connections can be made to mySQL.
If there is, its a good-sized limit. I've got over 50 connections on my live server. Gotta trim some of the chaff out when I find the time; someday... :) --------------------------------------- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --------------------------------------- ---------- Original Message ---------------------------------- from: "Adrocknaphobia Jones" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Thu, 26 Dec 2002 14:40:44 -0500 >Well it looks like when you actually use the IP it's a security issue. >(sorry bout not reading all the way down) Have you tried shutting down > >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:36 PM >To: CF-Talk >Subject: RE: MySQL / MX datasource woes > >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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
