- see footer for list info -<
Terry Riley wrote:
My main concern is that we may not be able to use the native CF MySQL JDBC drivers and have to return to MySQL ODBC. Can anyone who may have done something similar confirm/deny this before I try and stick my neck into a noose?Well I don't see there being any reason why you can't use the JDBC drivers to connect to mySQL. I use them on my laptop install to connect to mySQL 4.1.19, so that I can keep the number of services running down to a minimum. Besides, the ODBC connectors don't work for mySQL 4.1.x, because of the change in the password encryption/connection protocol/whatever it is thats changed. (http://snipurl.com/mysql_oldclient)
The JDBC connection takes a URI to the database (probably best to use the server's IP address, just in case your server loses access to a DNS), so you should be able to just change the address the JDBC connection string on the main server to point at the new server.
You're gonna need to make sure that you can actually get a connection between the two servers on your chosen mySQL port (probably not a bad plan to change it from the default given that the db is "open" to the outside world) and that the port isn't firewalled. If you can, firewall the connection, so that only the main server can actually access the mySQL server from the outside world. And block every other port that you don't need open.
You definately need to be using strong password and not using the root user to connect to the database. Make sure the connection user only has the access rights to the database and tables it needs and nothing more. If you have an admin system that requires more access than is required on the front, then make sure that you have different users for the different levels of access required.
The users you set up for the site in mySQL should be restricted, so that they can only connect from your main server and no where else, as well as the port being firewalled against everything except the main server.
Please excuse anything that you already know/do - this is just my sunday afternoon stream of thought on what I would check/do with an external datasource. I hope some of the above is of assistance.
Regards
Stephen
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
-- CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -< - Forum provided by www.fusetalk.com -< - DHTML Menus provided by www.APYCOM.com -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
