Posted on 10-24-2012 10:35 AM
I'm trying to set up a new client server on our cluster - until now it's been a simple parent/child setup, but I'm adding several child servers, this one being the first. Trying to install the JSS on the new server, it's refusing to accept the MySQL information of the parent server. I verified the info from the DB utility's xml file (which is a security issue, but that's another topic) so everything seems correct but it's still refusing to connect.
Ideas? Should I just install a local MySQL and then reconfigure the box to point to the master after the fact?
Solved! Go to Solution.
Posted on 10-24-2012 12:04 PM
Have you allowed connections from this child cluster on your Master's MySQL?
(On the Master MySQL).
Posted on 10-24-2012 10:36 AM
Also: Is there a way to see the database connection info on the child? If I did something different there I might be able to see it...but I'm not finding that info in the JSS.
Posted on 10-24-2012 12:04 PM
Have you allowed connections from this child cluster on your Master's MySQL?
(On the Master MySQL).
Posted on 10-24-2012 05:07 PM
You can test the connection to your Database from your servers to see if you have given the user access to the database.
databaseusername: username for the database you are connecting
databasehost: hostnem or IP of the database server.
mysql -u databaseusername -p -h databasehost -P 3306
Posted on 10-25-2012 06:34 AM
bentoms - that was it, thanks! I'd forgotten that step:
grant all privileges on jamfsoftware.* to 'myusername'@'myremoteserver' identified by 'mypassword';
(The clustering documentation could really use some details...)