Issues with CF 8

[Guest]

I am a web developer, I have no Idea how to setup a CF Server, I know the syntax of CF when developing but the server side of things has always been done for me, I have recently downloaded CF8 by can't get it to form a dns with MySQL, I keep getting this error "java.sql.SQLException" is there anyone who can help me solve this problem?

[BKBK]

http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=6&threadid=1412704

[Guest]

That didn't change anything, I guess I need Step-by-step instructions on how to set up a dns

[Newsgroup_User]

> I am a web developer, I have no Idea how to setup a CF Server, I know the
> syntax of CF when developing but the server side of things has always been done
> for me, I have recently downloaded CF8 by can't get it to form a dns with
> MySQL, I keep getting this error "java.sql.SQLException" is there anyone who
> can help me solve this problem?

Have you done anything as obvious as googling the error message, or
googling how to set up a MySQL datasource (for the purposes of searching,
it's "DSN" not "DNS", btw).

I'm loath to help someone who doesn't seem to have invested much time in
trying to help themselves, before expecting people here to do it for them.

Have a hunt around the place for pre-existing docs (trust me, this has all
been covered and covered again already), and when and if you find some, do
what it says and then still have problems: come back to us.

If you show some evidence of having trying to sort it out yourself and are
still having problems, I'm happy to help. I'll keep an eye on this
thread...

--
Adam

[Guest]

I have been trying for the last month and a half to get this thing set up. I have tryed to find any and all Documentation that I could find, I started out with half a dozen error messages and have worked my way down to one and still have not found any way to get rid of it. I understand having people find it for themselfs and I can respect that stand, I however need to know how to do this and can't seem to figure out how to do so.

[Newsgroup_User]

> I have been trying for the last month and a half to get this thing set up. I
> have tryed to find any and all Documentation that I could find, I started out
> with half a dozen error messages and have worked my way down to one and still
> have not found any way to get rid of it. I understand having people find it
> for themselfs and I can respect that stand, I however need to know how to do
> this and can't seem to figure out how to do so.

Is there anything more to the error message than you posted?

--
Adam

[Dan_Bracuk]

So what is that last remaining error message and what are you trying to do when you encounter it?

[Kronin555]

http://www.cfscreencast.com/screencast/episod2/index.html

This came up when googling for: "coldfusion setting up a mysql datasource"

[Guest]

If you have a firewall, make sure to add exception to the MySQL port. Also, you can turn off your firewall then try to create a datasource. Make sure the service for MySQL is running and you can telnet.

Good Luck
Mamdoh

[BKBK]

Greensquid wrote:
> That didn't change anything, I guess I need Step-by-step
> instructions on how to set up a dns

Setting up MySQL in the Administrator is easy. I think it would save a lot of time if you let us know the steps you followed.

> I keep getting this error "java.sql.SQLException"
Very likely due to the wrong combination of username and password. You should use a valid MySQL username and password.

[Guest]

after installig MySQL and trying to set up a DSN and failing, I found a MySQL Workbench which allowed me yo save a Database as a .MWB file I have never liked using a command line input and not being able to figure out where things were being savedthis gave ma a GUI inveronment and the ability to save where I wanted, it also got rid of most of my error messages, I have not found anywhere to add a user name or password but I have been using the username and password I used when installing MySQL, That got rid of every error except the one I'm looking for help with.

This is how I have it setup currently, so as to preserve my clients Anonymity the name of the DB has been changed, but that shouldn't matter.

Data Source Name: ABC
Driver: MySQL(4/5)

Press Add button. It takes you to the next page.

CF Data Source Name:ABC
Database: E:/ABC/ABC.mwb
Server:Localhost:8500
Port:3306
Username: Root Login
Password:Root Password

[Kronin555]

> That got rid of every error except the one I'm looking for help with.

Which you still haven't given us enough information to help you with. When is this error occurring? What line of code? In the Coldfusion Administrator, can you verify the MySQL datasource you set up? Does that verification come back successful?

[Guest]

The only error I get is this "java.sql.SQLException" that is all it says, I have no idea what else I can put here.

[Kronin555]

Well, you can start with the basics. What are you doing when this error shows up? Are you simply starting up Coldfusion? are you trying to visit a CF page in your web browser? That information is helpful...

I'm assuming it's throwing the error when you're visiting a CF page. If so, do this...

Go into the Coldfusion Administrator and enable Robust Exception Information, General Debug Information, and Database Activity (on the Debug Output Settings page under Debugging and Logging). Save that page by clicking the "Submit Changes" button. Then go to the "Debugging IP Addresses" page and ensure your IP address is in there. If in doubt, click the "Add Current" button.

Now re-visit the page that was throwing the error, and you can see much more helpful information about what happened. What line in your code is throwing the error? What is the detail of the error message?

[Guest]

I have no pages made using this Datasource simply because the error pops up when I'm trying to set it up. I won't create any pages that use the DB until I can access the DB.

[Kronin555]

quote:

---

Originally posted by: Greensquid
CF Data Source Name:ABC
Database: E:/ABC/ABC.mwb
Server:Localhost:8500
Port:3306
Username: Root Login
Password:Root Password

---

OK, I see you edited one of your posts with some more information...

The Database here can't be an .mwb file. That's not a database, that's a file that describes your database. What CF is asking for here is the NAME of the database you created in MySQL, plain and simple. A text name, not a filename. When you installed MySQL, did you create a database? What did you name it? That is what you put in this box.

Server, change this to just "localhost" or "127.0.0.1". You don't want a port number here.

[Kronin555]

"simply because the error pops up when I'm trying to set it up."

Very clearly and distinctly, explain exactly what you are doing when this error pops up. That's what I'm trying to get out of you. Are you in the Coldfusion Administrator? What page? What are you entering in each field?

Let me speak plainly. The more information you give us on how you're seeing this error, the easier it is for us to help you and not simply get frustrated and give up. Post back with as much detailed information as possible about how exactly you are getting the error. What are you doing when it comes up? What are you clicking on? What page are you on in your browser?

[Guest]

Yes I'm in the Admin. This is how I have it setup currently, so as to preserve my clients Anonymity the name of the DB has been changed, but that shouldn't matter.

Data Source Name: ABC
Driver: MySQL(4/5)

Press Add button. It takes you to the next page.

CF Data Source Name:ABC
Database: E:/ABC/ABC.mwb
Server:Localhost:8500
Port:3306
Username: Root Login
Password:Root Password

Once I leave the screen with the password and go back to the Datasource page, the error is there it is there if I have a login or password or not.

[Kronin555]

Did you follow a how-to or a walkthrough when you installed MySQL and set it up? If so, please post the link you used. That'll help.

[Kronin555]

http://dev.mysql.com/doc/refman/5.1/en/database-use.html

You can't have this line:
Database: E:/ABC/ABC.mwb

It should be something like:
Database: MyDB

Where MyDB corresponds to a database in MySQL (matches one of the names that you get from a SHOW DATABASES; command), NOT A FILE ON YOUR HARD DRIVE!!!!!

If you haven't actually created a database in MySQL, read this:
http://dev.mysql.com/doc/refman/5.1/en/creating-database.html

[BKBK]

Greensquid,

Let's cut the chase. MySQL installs by default a database called 'test'. Use it to test your settings.

For example, on my machine, MySQL databases are installed by default in the folder C:\Program Files\MySQL\MySQL Server 5.1\data\. Databases are represented as directories within the data folder.

I have verified that there is indeed a folder named 'test' in the data directory. The corresponding settings would therefore be

CF Data Source Name:ABC
Database: test
Server:127.0.0.1
Port:3306
Username: Root Login
Password:Root Password

[BKBK]

Greensquid wrote:
> Database: E:/ABC/ABC.mwb

No, Coldfusion wont look in any arbitrary folder. As I said above, it will only look in the directory {MySQL_HOME}\data\.

> Server:Localhost:8500
> Port:3306

No, you wrongly use 2 ports. Here you need just MySQL's port, not Coldfusion's. It usually is 3306. Therefore enter

Server: localhost
(or Server: 127.0.0.1)

and

Port: 3306

[Guest · Accepted solution]

Thank you all for your help, using all the suggestions I have been able to connect and am working on my site now, thank you again