MySQL Railo connection error; driver update needed

G’day,

Having an issue with a MySQL connecting to Railo: http://local.evolutionkarate.com.au/

I’ve ensured Allow multiple Queries is ticked and permissions are correct in MySQL but just can’t seem to get this one started. Any ideas?

What is the error being reported? Does the datasource verify in Railo admin?

PS. all the cool kids are using http://lucee.org :smile:

Yep, datasource verifies and I can run the same site on RDS and it works fine but then won’t run on a local version of the same database so it might be something in DB connection?

You can see the error in full here: http://local.evolutionkarate.com.au/ but the CFE message is;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=3' at line 1

in for Farcry setup, have you set it as mySQL (and not ms-sql)?

Yep, dbType = “mysql”. It runs on RDS as MySQL.

BTW that seems to be a local address only you have there.

It’s not a local address, contrary to the description, it is an external IP address. You should be able to see it.

This is the error anyway, I think it’s going to be something in server’s database connection, but I’m not sure.

You must have a host entry or local DNS

The server at local.evolutionkarate.com.au
http://local.evolutionkarate.com.au
can’t be found because the DNS
look-up failed. DNS is the network service that translates a website’s name
to its Internet address. This error is most often caused by having no
connection to the Internet or a misconfigured network. It can also be
caused by an unresponsive DNS server or a firewall preventing Google
Chrome from
accessing the network.

OMG, I’m such a moron some times. I had initially setup as a hosts change but forgot that I hadn’t created it as an A-Record. Assumed I had done that, just added the A-record now so will be visible in a bit. IP is 54.253.156.155. Having said that and resolved that one, it doesn’t fix the DB issue of course…

I think it’s a compatibility issue between the driver that ships with Railo and the deprecated “SET OPTION” statements in MySQL 5.6. Whereas on MySQL 5.5 it would still work fine out of the box…

To fix it you can try upgrading the MySQL Connector/J .jar file, which you can download here:
http://dev.mysql.com/downloads/connector/j/

Stop Railo, remove the old mysql-connector-java-bin.jar file from the Railo lib folder (keep a copy of it somewhere else if you like), copy the new file into the Railo lib folder, then start Railo again and test :smile:

1 Like

BOOM!! Justin, you rock!! Fixed.

1 Like