Skip to main content

I am setting up a remote JSS server and can not get the install to see the MySQL database on my other JSS server.
I have verified that the user has the grants.



mysql> show grants for jamfsoftware@casperapp3.tsys.com;
+-------------------------------------------------------------------------------------------------------------------------------+
| Grants for jamfsoftware@casperapp3.tsys.com |
+-------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'jamfsoftware'@'casperapp3.tsys.com' IDENTIFIED BY PASSWORD '*B8B7B8C47EF8381F4C2BBD441DAF0E52AEE035DF' |
| GRANT ALL PRIVILEGES ON `jamfsoftware`.* TO 'jamfsoftware'@'casperapp3.tsys.com' |
+-------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
But still cannot get connected.



Please help!!



Thanks,



Ed Childers

If Windows, do you have the proper rules in place and ports open? Did you set up the Cluster with your master?



Settings > Server Configuration > Clustering > [x] Enable Clustering > set one as master



http://www.jamfsoftware.com/libraries/pdf/products/documentation/Casper_Suite_8.6_JSS_Installation_Guide_for_Linux.pdf
http://www.jamfsoftware.com/libraries/pdf/products/documentation/Casper_Suite_8.6_JSS_Installation_Guide_for_Windows.pdf
http://www.jamfsoftware.com/libraries/pdf/products/documentation/Casper_Suite_8.6_JSS_Manual_Installation_Guide.pdf

What OS is the new MySQL db running on? Mac, Windows, Linux? By defualt most instances of MySQL will only allow "localhost" lookups. You may have to modify the my.cnf to allow outside IP's access over port 3306. And speaking of port 3306, most OS's have that blocked (especially RHL).



Hope this gives you some ideas.



- Justin

nevermind

It is a Lion Server.

Firewall running? Sounds firewall-ish.

Firewall is turned off on both servers. I have another server in another location that is working fine. I just can't get this one configured.

Did you try running the mysql grant command using the static IP of the Tomcat server instead of the DNS? Are you able to telnet from the Tomcat server to they MySQL server over 3306? "telnet <mysqlserverDNS> 3302"

Thanks Matt, that was the answer. I had to use the IP instead of the DNS name.

Reply


Terms & ConditionsCookie settings