I've followed the tutorial here:
https://smartfoxserver.com/blog/multipl ... nnections/
To create a second database connection to an external server, however it seems to be throwing this error message:
{HA3DZone}: java.sql.SQLException: The DBManager is NOT active in this Zone. SQL Query failed. Please activate it the DBManager from the AdminTool
The test SQL is something that shouldn't be possible to fail, here's the code to create the external DB connection:
Code: Select all
DBConfig cfg = new DBConfig();
cfg.active = true;
cfg.driverName = "com.mysql.jdbc.Driver";
cfg.connectionString = "jdbc:mysql://80.0.21.46/horseacademylts";
cfg.userName = "root";
cfg.password = "********";
cfg.testSql = "SHOW TABLES";
remoteDB = new SFSDBManager(cfg);
Is that error code going to be 100% accurate? What could reasons be that I could be seeing this error message? I am able to connect to this mysql database remotely via a PHP script on the main server so firewalls shouldn't be causing this issue. Any advice would be greatly appreciated.