Updated from 9.10.1-U4 to 9.10.2 and now MySQL stopped working

[Vinh]

I just finished updated my FreeNas system to 9.10.2 and noticed my MySQL server wasn't working. I am using it with Kodi. when i ssh into the jail and try to log into MySQL i get the following error

Code:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I tried manually starting the serve with the following code, but don' t think its actually starting because when i stop it it save server not running.

Code:

root@sabnzbd_1:/ # service mysql-server start
Starting mysql.
root@sabnzbd_1:/ # service mysql-server stop
mysql not running? (check /var/db/mysql/sabnzbd_1.pid).

I have tried reverting back to a couple different boot versions and problem seem to still be there. Please help let me know what other information I can give that will be helpful

update: i think it might be either a permissions issure or user issure. if i change the owner and group of the /etc/pam.d from root:wheel to media:media i then get the following when i try to start the server

Code:

Starting mysql.
su: pam_start: system error
/usr/local/etc/rc.d/mysql-server: WARNING: failed to start mysql

 

[dlavigne]

Were you able to figure this out?