Skip to main content
Question

Connection to JSS Database error

  • November 6, 2017
  • 5 replies
  • 10 views
K
Forum|alt.badge.img+13

Hi all, tearing my hair out trying to figure this one.

So, Create a local database = All fine.

When connecting to a database on another server, I get the following error: See attached

JSS running on RHEL vm

5 replies

sdagley
Forum|alt.badge.img+25
  • sdagley
  • Jamf Heroes
  • November 6, 2017

@kerouak Since the access to your MySQL Server is now coming from a non-local account, did you do a GRANT ALL on the JSS database for the user@<ipaddressofjsstomcathost>?

K
Forum|alt.badge.img+13
  • kerouak
  • Author
  • Valued Contributor
  • November 6, 2017

Yep, did that, also used mysql on the database server using u/n and password

sdagley
Forum|alt.badge.img+25
  • sdagley
  • Jamf Heroes
  • November 6, 2017

@kerouak Did you comment out the bind-address line in the MySQL my.conf file so external connections are allowed?

    K
    Forum|alt.badge.img+13
    • kerouak
    • Author
    • Valued Contributor
    • November 8, 2017

    Yep! Previously connected fine but built new jss and get the error

    sdagley
    Forum|alt.badge.img+25
    • sdagley
    • Jamf Heroes
    • November 8, 2017

    @kerouak Can you try manually connecting to MySQL on your database server from a different machine to verify it is accepting remote connections (if that isn’t what you meant by your post on 11/06 at 10:58AM)? Connect to a MySQL database remotely

    Terms & ConditionsCookie settingsAccessibility statement