>- see footer for list info -< Many thanks, Stephen, particularly the first three paras.
Can't you tell I've never had to deal with this sort of situation before? Cheers Terry ----- Original Message ----- > >- 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 -<
