Cannot connect to remote MySQL database for JSS server install

[echilders]

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

[Matt_Fjerstad · Accepted solution]

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"

[donmontalvo]

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_G...
http://www.jamfsoftware.com/libraries/pdf/products/documentation/Casper_Suite_8.6_JSS_Installation_G...
http://www.jamfsoftware.com/libraries/pdf/products/documentation/Casper_Suite_8.6_JSS_Manual_Install...

[justinrummel]

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

[nessts]

nevermind

[echilders]

It is a Lion Server.

[jarednichols]

Firewall running? Sounds firewall-ish.

[echilders]

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.

[Matt_Fjerstad · Accepted solution]

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"

[echilders · Accepted solution]

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