Skip to main content
Answer

Cannot connect to remote MySQL database for JSS server install

  • November 26, 2012
  • 8 replies
  • 29 views
E
Forum|alt.badge.img+4

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

Best answer by Matt_Fjerstad

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"

    8 replies

    donmontalvo
    Forum|alt.badge.img+36
    • donmontalvo
    • Hall of Fame
    • November 26, 2012

    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

    --https://donmontalvo.com
    J
    Forum|alt.badge.img+13
    • justinrummel
    • Contributor
    • November 26, 2012

    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

    N
    Forum|alt.badge.img+18
    • nessts
    • Valued Contributor
    • November 26, 2012

    nevermind

    E
    Forum|alt.badge.img+4
    • echilders
    • Author
    • New Contributor
    • November 26, 2012

    It is a Lion Server.

    J
    Forum|alt.badge.img+24
    • jarednichols
    • Valued Contributor
    • November 26, 2012

    Firewall running? Sounds firewall-ish.

    E
    Forum|alt.badge.img+4
    • echilders
    • Author
    • New Contributor
    • November 26, 2012

    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.

    M
    Forum|alt.badge.img+4
    • Matt_Fjerstad
    • Employee
    • Answer
    • November 29, 2012

    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"

    E
    Forum|alt.badge.img+4
    • echilders
    • Author
    • New Contributor
    • December 7, 2012

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

    Terms & ConditionsCookie settingsAccessibility statement