Creating a data source to an external database...

Report · Sep 03, 2008

Hi folks,

I've built a couple Coldfusion / MySQL sites locally for practice, and now I'm trying to build one for real.

I'm using a GoDaddy hosting plan that comes with 10 MySQL databases. I've got a test database set up on GoDaddy's server, and I've imported three tables worth of data into it. So far so good.

Now it's time to build the site. I figured the easiest thing would be to create a Coldfusion data source connection to my database on the GoDaddy server, instead of using a local copy of my database and then somehow having to change the data source after the site is built.

Well, I can't create a working data source connection. I'm using the correct username and password, the host name I'm getting from my GoDaddy database control panel, and the default port of 3306. The Coldfusion administrator returns a long error that boils down to "connection timed out".

Now, I find this on the GoDaddy support page:
"Unfortunately, we do not allow external connections to our database servers. When connecting to a database in your Shared Hosting account, you must access it through the Database section of the Hosting Control Center."

Could that be my problem? If so... well, dumb question, but how can I create a data source that connects to the remote database, when the remote database won't accept remote connections? And if I have to build the site using a local copy of my database, no problem, but how do I make it work with the remote database when I publish??

Thanks much for any help...

Report · Sep 04, 2008

you can't connect to a remote db if the remote db server does not allow
remote connections.

all you need to do is set up same datasource in cf admin locally and on
godaddy's server. all cfquery tag needs to work is the datasource name.

if you make changes to your database locally, you will then have to
create an sql dump (backup) of it and update the db on godaddy's server
through whichever way they allow you (probably via phpMyAdmin or similar
tool).

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

Report · Sep 06, 2008

Thanks for the reply...

That makes sense, and I set up my local DSN using the same name as the Coldfusion DSN on GoDaddy's server. Unfortunately, I keep getting the error: "Security: The requested template has been denied access to mysqlcf_oldoaks."

I know the DSN name is correct (well, it's what the GoDaddy control panel claims it assigned to my database anyway), but GoDaddy doesn't seem to provide any guidance about a username and password. I tried no username/password, I tried "root" with no password, and I tried the username and password that allow me to log into my database PHPMyAdmin control panel. No dice on any of them. I keep getting the same Security error.

So, I've got a support email into GoDaddy. This is my first experience with their support staff, but I've heard less than stellar reviews, so I thought I'd ask here as well. If anyone has any ideas, I'd love to hear 'em.

Thanks..
Joe

Report · Sep 07, 2008

on your local setup (your computer) you need to use the username and
password of your MySQL server, whichever ones you selected when you set
up MySQL.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

Report · Sep 07, 2008

Thanks... the local setup works though. It's when I publish a CF template to the GoDaddy server that things fall apart.