I am new and need help with the server-side of things

Can somebody please explain to me how the server-side of things work? I am new to the this area and lack knowledge of how things work with web servers and what I need to install into my computer n everything. Is it that I need coldfusion to be installed on my own computer, or I just require coldfusion to be supported with the web host? And what about web servers like IIS? Do I need that installed in my computer as well? Any help would be greatly appreciated. Thank you in advance.

If you are going to develop and test your code on your home computer you will need to install IIS and coldfusion.

IIS you can add to a windows PC by going to add remove windows componants and adding web services.

for coldfusion you can download Blue dragon (free CFML server)
http://www.newatlanta.com/corporate..._1_announce.jsp

to get your stuff working on the web you will need a host that supports cold fusion.

hope this helps

(you could always develop on the on your hosted space - as long as they support cfml)

Thanks a lot for the information.

What if I have finished with developing the code at home and is ready to put the whole project up on web? What steps do I need to take to establish everything? Do I still require IIS and Coldfusion on my computer?

No, all you need is to upload your code to your chosen web host, (they should be able to tell you how to do this) and then set up what ever datsource you need.(they should to do this for you)


If you need a web host, do a google search , there are several companies that will host you for free.

Ah now i'm sort of getting the picture. Thank you for your advice. I'll come back if I need anymore help. Thanks once again.

Hi, I downloaded the BlueDragon Server that you referred to me in the link, but I don't know how to setup a MySQL datasource. I tried setting up at datasource named "mysql", but everytime I try to verify connection, an error message pops up saying:

General error, message from server: "Access denied for user: '@%' to database 'mysql'"

If anyone knows how to fix this, or how to setup a mysql datasource with BlueDragon from scratch, can you please teach me? Thanks a lot.

Hiyas, personnaly I dont know about mysql, I would create a new thread on the forum (more likely to get fresh answers.)

have a look her (might help)

http://www.houseoffusion.com/cf_lis...29629&forumid=4

Hi, the cheapest CF hosting I've seen is about $6 a month. If you know of a FREE CF host, please let us know....

Hi, I just finished getting a bluedragon server setup on a debian (testing dist) box.

the error you're getting is most likely a result of your mysql user/password/rights settings in mysql.

you need to create a super-user in mysql (I'd recommend not using root, although the mysql root account is actually separate from your linux root account and you can have a different password).

here's an excerpt from the mysql documentation that covers the process very clearly:

First, use the mysql program to connect to the server as the MySQL root user:

shell> mysql --user=root mysql

If you have assigned a password to the root account, you'll also need to supply a --password or -p option for this mysql command and also for those later in this section.

After connecting to the server as root, you can add new accounts. The following statements use GRANT to set up a super-user called 'monty':

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

the above statements will give 'monty' full privileges on everything, including creating users and assigning rights. Once you've done this, go back to your bluedragon admin interface and use the super-user account for your datasource and see if it will verify. If it does, I'd go back into the mysql> prompt and use the GRANT commands to create a user with specific rights to the database/tables that you're wanting to use in BlueDragon and then changing the datasource in BlueDragon admin to use that user instead of your super-user.

One thing I ran into was that you need both of the GRANT statements, which are identical except for @'localhost' and @'%' (wildcard). mysql is really picky about what you call the server you're trying to connect to and where you're connecting from; using both GRANT statements lets you specify almost any valid name or IP for the server (i.e. localhost, IP address, servername, etc.)

One last suggestion, especially if you have a windows box or an Xwindows interface on your linux box: do yourself a favor and install mysqlcc (mysql command center) and/or mysql Administrator. These are excellent GUI interfaces for managing your mysql server, and they make user administration a breeze. Both are available for free from dev.mysql.com. If you need to import data, try Navicat (not free, but you can use the trial version for 30 days I think).

hope that helps