mySQL on Ubuntu and JSS connection

[anickless]

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.

[marklamont]

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

[sharriston]

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.