Connecting Blue Dragon server to Mysql on Ubuntu
Apr 03 2008 - By George Webster
After installing Blue Dragon server cfml (ColdFusion) is up and running for free, now the only problem is due to licensing issues Blue Dragon's beautifull free server does not ship with connectors to MySql. This needless to say is a problem in our free developement paradigm. After much reading on the New Atlanta and Mysql sites the simpliest solution seems to be to install the MySQL Driver for Server JX and J2EE editions even though I am running the standard server distribution. The other option is entire too complicated in my humble opinion.
So the steps were simply to download the connector here.
Next we unpack the file with:
sudo tar xvf FILENAME.tar.gz
Now I downloaded the source and the binary, since I only need the binar the '.jar' file, I need to copy it to the blue dragon lib directory and then rename it to mysql.jar. Now this is directly from the New Atlanta instuctions so I blindly follow and assume the 'rename' command will work... only to run into this beautifull error:
Bareword "mysql" not allowed while "strict subs" in use at (eval 1) line 1.
After much googling I discover that in unix systems 'rename' is only used for bulk renaming of files with perl. So you simply need to move the file as a new name and this essentially renames the file:
mv -R oldname newname
Finally armed with the correct commands the folling should get us rolling again with mysql:
sudo mv /PATH_TO_BINARY_FILE/mysql-connector-java-5.1.6-bin.jar mysql.jar
Sure enough I restarted the Blue Dragon server, logged into the administrator and verified the mysql datasource with out any problems.