Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
MySQL 5 and ColdFusion MX 7 (New Problem)
Author: Casey Dougall
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231382
Eeegadds My bad. I quickly went down the lsit and just wasn't paying
attention to what I copied and pasted. I blame this on not enough
coffee or too much coffee.
Yes mysql-connector-java-3.1.12-bin.jar is the connector your looking
for. MySQL Connector/J 3.1
Sorry about that.
Casey
----- Excess quoted text cut - see Original Post for more -----
Author: John Paul Ashenfelter
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231365
> Mysql5, CF7, Win2003 all work together when using
>
> I recomend Connector/ODBC 3.51
This is awful advice. To use the ODBC drivers for MySQL, you have to
install the ODBC services and go through the JDBC-ODBC bridge.
> I would say the 5.0 beta drivers are causing the issue.
They're alpha (Connector J/5.0), so rolling back to the production
Connector J/3.1 drivers should be your first choice, unless there's
something very specific you need from the 5.0 drivers.
>
> Casey
Author: Casey Dougall
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231347
Mysql5, CF7, Win2003 all work together when using
I recomend Connector/ODBC 3.51
I would say the 5.0 beta drivers are causing the issue.
Casey
Author: ColdFusion
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231335
I have CFMX7, MySQL 5.0 and NaviCat all running locally
Localhost is where the MySQL Database is at.
It is all one machine
In your users table do have your machine or sub-net entered to accept a
connection from your machine/user that is having trouble connecting?
Is MySQL installed on the same machine as CF? If not then
jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to
use the mysql boxes ip instead of local host.
Sorry if I'm stating the obvious and not helping.
The error basically says it cant connect to the port. Which doesn't sound
like a CF issue but a network issue. Is the machine that you are using
Navicat to connect with also the machine you have CF installed on?
The only other thing I would suggest is check the cf and mysql logs to see
if the provide any lower lever details/clues.
Dave
On Feb 3, 2006, at 6:26 PM, ColdFusion wrote:
----- Excess quoted text cut - see Original Post for more -----
Author: ColdFusion
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231334
Localhost is where the MySQL Database is at.
It is all one machine
In your users table do have your machine or sub-net entered to accept a
connection from your machine/user that is having trouble connecting?
Is MySQL installed on the same machine as CF? If not then
jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to
use the mysql boxes ip instead of local host.
Sorry if I'm stating the obvious and not helping.
The error basically says it cant connect to the port. Which doesn't sound
like a CF issue but a network issue. Is the machine that you are using
Navicat to connect with also the machine you have CF installed on?
The only other thing I would suggest is check the cf and mysql logs to see
if the provide any lower lever details/clues.
Dave
On Feb 3, 2006, at 6:26 PM, ColdFusion wrote:
----- Excess quoted text cut - see Original Post for more -----
Author: David Livingston
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231329
In your users table do have your machine or sub-net entered to accept
a connection from your machine/user that is having trouble connecting?
Is MySQL installed on the same machine as CF? If not then
jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would
need to use the mysql boxes ip instead of local host.
Sorry if I'm stating the obvious and not helping.
The error basically says it cant connect to the port. Which doesn't
sound like a CF issue but a network issue. Is the machine that you
are using Navicat to connect with also the machine you have CF
installed on?
The only other thing I would suggest is check the cf and mysql logs
to see if the provide any lower lever details/clues.
Dave
On Feb 3, 2006, at 6:26 PM, ColdFusion wrote:
----- Excess quoted text cut - see Original Post for more -----
Author: ColdFusion
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231327
Yes, it is displayed under System Information in
CF Admin
Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path?
You have to restart CF after you add it so that the jdbc driver gets loaded
in.
Here is a link to how to install the postgress driver. The mysql setup
should be similar.
http://cfguru.daemon.com.au/archives/000082.html
Dave
Author: David Livingston
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231323
Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class
path?
You have to restart CF after you add it so that the jdbc driver gets
loaded in.
Here is a link to how to install the postgress driver. The mysql
setup should be similar.
http://cfguru.daemon.com.au/archives/000082.html
Dave
Author: ColdFusion
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231322
Guess that would help
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to
establish connection
what error?
----- Excess quoted text cut - see Original Post for more -----
Author: Casey Dougall
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231321
what error?
----- Excess quoted text cut - see Original Post for more -----
Author: ColdFusion
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44483#231320
Now I removed MySQL 5 and ran regClean to clean
the registries. Then re-installed MySQL 5.
Downloaded the Connectors/J for 5.0 from MySQL
copied the mysql-connector-java-5.0.0-beta-bin.jar
into CfusionMX7 \ wwwroot \ web-inf\ lib folder.
Restarted ColdFusion.
Added the datasource using Other:
jdbc:mysql://localhost:3306/myTest
com.mysql.jdbc.Driver
and now I have this error.
Yes... MySQL is running on Port 3306
Yes... I can connect to MySQL 5.0 using NaviCat using
Localhost:3306
Any ideas?
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
