Help

OSX Mavericks upgrade to 10.9.3 caused MYSQL to stop working

khurram
Contributor III

Posted on ‎05-31-2014 02:32 AM

We upgraded Mavericks from 10.9.2 to 10.9.3 and upgraded OSX Server to 3.1.2, after the upgrade the MYSQL stopped running. The SQL Server Startup Status error is "The MySQL server installation was not found. Please make sure the /usr/local/mysql/bin/mysqladmin file is present. The MYSQL Server Instance is not running". cant login using command mysql -u root -p, it gives error "Error 2002 (HY000): Can't connect to local MYSQL server through socket '/tmp/mysql.sock' (2). We couldnt find any my.cnf file inside our sql installation folder. Any suggestions.

0 Kudos
Reply
3 REPLIES 3

khurram
Contributor III

Posted on ‎06-01-2014 09:55 PM

Our MYSQL was quite old, we had to upgrade the MYSQL from 5.5.92 to 5.6.17.

  1. after the upgrade we placed the jss folder in /mysql/data/ and renamed mysql folder

  2. gave full access to mysql on data folder and root to all mysql installation folder as follows.
    sudo chown -RL root:mysql /usr/local/mysql
    sudo chown -RL mysql:mysql /usr/local/mysql/data
    sudo /usr/local/mysql/support-files/mysql.server start

  3. login in to jss database using old users because we copied old jss folder so it has old users and their credentials or using root.

  4. created the 'jss' user again inside jss database, if doesnt exist already, check if this user is hidden.

  5. GRANT ALL on jss.* to 'jss'@'localhost';

  6. Re-run the jds installer it will pickup the database settings, just make sure jss credentials.

  7. test jss from your domain/8443

this is what worked for us.

0 Kudos
Reply

rlandgraf
Contributor

Posted on ‎09-20-2014 05:56 PM

I am getting the same error and really struggling today to get it back up and running. I am wondering what jus folder you are referring to in #1. I don't have a JSS folder anywhere aside from in the /Library folder and I am sure this isn't the folder you are referring too.
Thanks for any help

0 Kudos
Reply

khurram
Contributor III

Posted on ‎09-21-2014 04:36 PM

@rlandgraf
It took us a while to find out where the last admin (before me) had installed the jss folder. We didnt find it at its usual place. I think the best way would be to run some find commands via terminal (include hidden folders). May be something like this http://www.mac-forums.com/forums/os-x-development-darwin/150910-finding-file-terminal.html
Or this
http://www.macissues.com/2014/04/29/commands-for-finding-files-in-the-os-x-terminal/

0 Kudos
Reply