mySQL on Ubuntu and JSS connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 10-12-2017 03:04 PM
I am was asked to move our SQL database from a MAC localhost to a Ubuntu VM however I am having connection issues. Has anyone setup an Ubuntu mySQL instance and modified the JSS's Database.xml successfully.
The error is maybe about the port being used and if mySQL is accepting network connections.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 10-13-2017 01:11 AM
if you are now connecting across the network to the DB you need to disable the bind-address in the mysql my.cnf.
copy the mysqld.cnf from /etc/mysql/mysql.conf.d/ to /etc/mysql/my.cnf
then edit it to comment the line bind-address = 127.0.0.1 so it's # bind-address = 127.0.0.1
you also need to up the max_connections value (default to 181) to cover the number of webapps connecting to it.
by default each webapp has 45 connections (look in database.xml) so set the max connections to be (number of webapps x 45) +1
restart mysql
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 10-13-2017 05:01 AM
The other thing to think about is you need to create a new user account instead of using 'jamfsoftware' @ 'localhost' you need to make a new user that is 'jamfsoftware'@'(IP Address of JSS). Just something I forgot to check when I was setting it up.
