Yosemite 10.10.1 Update Seems to Break MySql Again

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

Yosemite 10.10.1 Update Seems to Break MySql Again

Postby GeneralCat » 09. December 2014 00:23

I'm running the latest version of XAMPP: 1.8.3-5
Originally this version fixed the problem with MySql failing to start after upgrading to Yosemite, however Apple's recent update to 10.10.1 seems to break it again.
Apache Web Server will start, and so will ProFTPD, but Mysql will not.
Reinstalling xampp doesn't fix anything.
Running the command:
Code: Select all
sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

in the Terminal will produce this error:
MySQL
. ERROR! The server quit without updating PID file (/Applications/XAMPP/xamppfiles/var/mysql/aluminus.wireless.sbcc.local.pid).

I've verified that the line "unset DYLD_LIBRARY_PATH" exists in Applications/XAMPP/xamppfiles/xampp

I don't know what else I can do to get it to work again.
GeneralCat
 
Posts: 1
Joined: 08. December 2014 23:57
Operating System: 10.10.1

Re: Yosemite 10.10.1 Update Seems to Break MySql Again

Postby lechat » 09. January 2015 16:02

hi,

i got the exact same problem on 10.10.1.
checked that
unset DYLD_LIBRARY_PATH
$XAMPP_ROOT/bin/mysql.server start > /dev/null &
is present, but still mysql won't start. please fix!

thanks
lechat
 
Posts: 3
Joined: 09. January 2015 15:59
Operating System: 10.10.1

Re: Yosemite 10.10.1 Update Seems to Break MySql Again

Postby beck24 » 16. January 2015 09:19

Same issue here...
beck24
 
Posts: 1
Joined: 16. January 2015 09:17
Operating System: OSX

Solved. Re: Yosemite 10.10.1 Update Seems to Break MySql Aga

Postby richardz » 17. January 2015 15:07

Same issue with me, I solved it with following solution:
1. create 2 plist for apache and mysql individually, for example, org.apachefriends.apache.plist, org.apachefriends.mysql.plist
2. put those 2 files into /Library/LaunchDaemons

the sample files as below:

cat org.apachefriends.apache.plist
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Disabled</key>
<false/>
<key>KeepAlive</key>
<true/>
<key>Label</key>
<string>org.apachefriends.apache.plist</string>
<key>ProgramArguments</key>
<array>
<string>/Applications/XAMPP/xamppfiles/apache2/scripts/ctl.sh</string>
<string>start</string>
</array>
<key>RunAtLoad</key>
<true/>
<key>WorkingDirectory</key>
<string>/Applications/XAMPP/xamppfiles/</string>
</dict>
</plist>


cat org.apachefriends.mysql.plist
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Disabled</key>
<false/>
<key>KeepAlive</key>
<true/>
<key>Label</key>
<string>org.apachefriends.mysql.plist</string>
<key>ProgramArguments</key>
<array>
<string>/Applications/XAMPP/xamppfiles/mysql/scripts/ctl.sh</string>
<string>start</string>
</array>
<key>RunAtLoad</key>
<true/>
<key>WorkingDirectory</key>
<string>/Applications/XAMPP/xamppfiles/</string>
</dict>
</plist>
richardz
 
Posts: 1
Joined: 17. January 2015 15:00
Operating System: OSX

Re: Yosemite 10.10.1 Update Seems to Break MySql Again

Postby lechat » 20. January 2015 21:01

hero of the day!

confirmed working! thanks
lechat
 
Posts: 3
Joined: 09. January 2015 15:59
Operating System: 10.10.1

Re: Yosemite 10.10.1 Update Seems to Break MySql Again

Postby kenoli » 27. January 2015 19:43

I'm actually not using the latest version of XAMPP and am using Yosemite.

XAMPP-MYSQL will start from the terminal using:

sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

However it will not start using the XAMPP Application Manager. Application Manager does install Apache and ftp servers.

I tried using the plist described above. Still no work.

Is this a version issue?

Is the only way to update XAMPP when a database exists to export the database as an sql file, delete old XAMPP version and then import the database from the sql file?

Any way to install it and preserve the existing databases in the new install?

--Kenoli
kenoli
 
Posts: 6
Joined: 11. May 2009 19:06

Re: Yosemite 10.10.1 Update Seems to Break MySql Again

Postby cheesejondue » 28. January 2015 02:13

Strike three. I've tried the DYLD_LIBRARY_Path method, I've tried putting those plist files in my LaunchDaemons folder. It tries to start, but fails. Most recently, I tried the "sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start" command in the terminal. I got this error after 30-60 seconds:

ERROR! The server quit without updating PID file (/Applications/XAMPP/xamppfiles/var/mysql/Jonathan-Duecks-MacBook-Pro.local.pid)
.

Newb here. Where's the EASY button? :-P
cheesejondue
 
Posts: 2
Joined: 27. January 2015 16:42
Operating System: OSX Yosemite 10.10.1

Re: Yosemite 10.10.1 Update Seems to Break MySql Again

Postby lechat » 28. January 2015 09:17

@ cheesejondue: why didn't you try richardz solution? it works.

also with 10.10.2 it is working again anyway for me...
lechat
 
Posts: 3
Joined: 09. January 2015 15:59
Operating System: 10.10.1

Re: Yosemite 10.10.1 Update Seems to Break MySql Again

Postby cheesejondue » 29. January 2015 00:31

@lechat: I ended up resolving it by upgrading to 10.10.2 as you mentioned. Thanks!!
cheesejondue
 
Posts: 2
Joined: 27. January 2015 16:42
Operating System: OSX Yosemite 10.10.1

Re: Yosemite 10.10.1 Update Seems to Break MySql Again

Postby yaopgh » 08. February 2015 23:28

Worked for me @Kenoli. Many thanks



kenoli wrote:I'm actually not using the latest version of XAMPP and am using Yosemite.

XAMPP-MYSQL will start from the terminal using:

sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

However it will not start using the XAMPP Application Manager. Application Manager does install Apache and ftp servers.

I tried using the plist described above. Still no work.

Is this a version issue?

Is the only way to update XAMPP when a database exists to export the database as an sql file, delete old XAMPP version and then import the database from the sql file?

Any way to install it and preserve the existing databases in the new install?

--Kenoli
yaopgh
 
Posts: 1
Joined: 08. February 2015 23:24
Operating System: Mac


Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 6 guests