MySQL Bugs: #20124: MySQL Startup Item Will Not Install on Intel Mac mini / OS X 10.4.6

Bug #20124	MySQL Startup Item Will Not Install on Intel Mac mini / OS X 10.4.6
Submitted:	29 May 2006 11:53	Modified:	22 Feb 2008 17:12
Reporter:	Peter Mackie	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.21	OS:	MacOS (OSX10.4-i686)
Assigned to:		CPU Architecture:	Any

Description:
The 5.0.21 MySQLStartupItem.pgk will not install on the Intel Mac mini after updating OS X from 10.4.5 to 10.4.6. Action is the install appears to work, but the Startup Item button never appears in the System Preference dialog. Tried the install several times. Subsequent install the "Upgrade" button appears.

The Intel Mac mini OS X 10.4.6 update is 163MB, so lots has changed here.

How to repeat:
Attempt to install 5.0.21 MySQLStartupItem.pgk on Intel Mac mini running OS X 10.4.6.

Hi, 

Unfortunately I can not repeat this, on a MacBook Pro running 10.4.6, using the MySQLStartupitem.pkg from our 5.0.22 Mac 10.4 x86 binary, I get the "MySQL" item under "Other" in the system preferences, and from there I can start, stop, and set to autostart MySQL. 

Could you try this with the following binary and let me know if there is any difference please?

http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-standard-5.0.22-osx10.4-i686.dmg/from/h...

Best regards

Mark

At 04:23 AM 6/2/2006, Mark Leith wrote:
Hi, 

Unfortunately I can not repeat this, on a MacBook Pro running 10.4.6,
using the MySQLStartupitem.pkg from our 5.0.22 Mac 10.4 x86 binary, I
get the "MySQL" item under "Other" in the system preferences, and from
there I can start, stop, and set to autostart MySQL. 

Could you try this with the following binary and let me know if there
is any difference please?

http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-standard-5.0.22-osx10.4-i686.dmg/from/h...

Best regards

Mark
------------------------------------------------------------------------------
Mark,

I installed the MYSQLStartupItem only on Mac mini hard drive. I did a reboot and didn't get the result we hoped for...there's no MYSQL start/stop button in the system preferences pane.

I assume that the MYSQLStartupItem did install, because the following works for MySQL startup:
  
  shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

Its just that the start/stop button does not show up on the Mac System Preferences pane.

We do have a external Firewire connected hard disk. Doubt this is creating the problem, but thought it best to mention for potential side effects.

Pete

I can report similar behavior on a G4 Mac Mini running 10.4.6. The StartUp Item will either not install or it will install but then the Start MySQL Server button does nothing when pressed.
Not sure why the Mac Mini would have this problem.

Similar problem here: I just installed MySQL on a MacMini/Intel OS X 10.4.8, could install everything nearly the same way as on the G4 iMac before, but cannot start the MySQL server from the system preferences, nor does it start at computer's startup.
If I try to start, it takes some time, showing the spinning ball, but nothing happens.
It DOES start with

  shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start   or
  shell> sudo /usr/local/MySQL/support-files/mysql.server start

AND: I can use the syspref to stop the server then!
It seems to me to be some kind of access privilege problem..

Best regards,
Matthias

Sorry, my problem doesn't exist any longer.
I removed and reinstalled everything again and my MySQL works and restarts again and again on my Intel-MacMini. Don't know, what could have been wrong before..
Matthias

I installed 5.0.27-osx10.4-i686 on G5 MacPro 2x2.66GHz Dual, 2GB Ram and had the same problem with the Startup Item button not appearing in System Preferences.

This worked fine:

shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

Mike Ealy

I had a similar problem installing the MySQL startup item on OS 10.4.9 on a new MacBook Pro -- perhaps because I started off by synching my new machine with my old G4 which had this installed already.

I discovered, though, that 1) the PKG application had installed the MYSQLCOM in the top level /Library/StartupItems directory rather than /System/Library/StartupItems so I moved it.  Furthermore, 2) this is NOT the actual button that appears in the control panel.  To install that manually, you need to take MySQL.prefPane and drag it into /System/Library/PreferencesPanes/ and then reboot.

I just discovered that it makes no difference which StartupItems directory the files are in.  I had one other item which I had copied into /System/Library/StartupItems/ from /Library/StartupItems/ and now have two icons for the same thing appearing on my menu bar!

mac system preferences error

Attachment: Picture 1.png (image/png, text), 18.69 KiB.

I have this problem on my g4 mac after upgrading to leopard.

mac version: 
Hardware Overview:

  Model Name:	PowerBook G4 15"
  Model Identifier:	PowerBook5,4
  Processor Name:	PowerPC G4  (1.1)
  Processor Speed:	1.5 GHz
  Number Of CPUs:	1
  L2 Cache (per CPU):	512 KB
  Memory:	1 GB
  Bus Speed:	167 MHz
  Boot ROM Version:	4.8.6f0

System Software Overview:

  System Version:	Mac OS X 10.5.1 (9B18)
  Kernel Version:	Darwin 9.1.0
  Boot Volume:	Macintosh HD

mysql version:
mysql  Ver 14.12 Distrib 5.1.7-beta, for apple-darwin7.9.0 (powerpc) using readline 5.0

Connection id:		13
Current database:	
Current user:		<redacted>
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.1.7-beta-log
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	latin1
Conn.  characterset:	latin1
UNIX socket:		/tmp/mysql.sock
Uptime:			1 hour 3 min 4 sec

Threads: 1  Questions: 122  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 28  Queries per second avg: 0.032

attached file show the output error from the system prefs.

I'm guessing you'll tell me to upgrade mysql?  But thought it was worth sharing.

Installing mysql-5.0.51a.osx10.4-powerpc.dmg on Leopard 10.5.1 I find that the MySQLCOM directory has been installed under /usr/local not /System/Library/StartupItems or /Library/StartupItems . Using Terminal to mv the directory under /System/Library/StartupItems causes MySQL to run on boot as per the prefs pane. However, the prefs pane cannot start/stop mysql independently of this. Has the .pkg (and possibly the prefs pane) been built with incorrect file paths in it's configuration?

See also <a href="http://bugs.mysql.com/bug.php?id=25008">Bug #25008</a>.

The MySQLCOM directory is missing from MySQLStartupItem.pkg and wrongly placed in  mysql-5.0.51a.osx10.4-{ppc,i686}.pkg. The former installs under /Library/StartupItems/, while the latter installs under /usr/local/.

This is clearly a (simple) bug.

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

> Startup Item button never appears in the System Preference dialog

Please double-click MySQL.prefPane to get System Preference Pane installed

Setting this to verified again, there is no MySQLCOM file in the MySQLStartupItem.pkg located in the dmg-package. (verified for 5.0.51sp1a maxosx10.5 32-bit and 5.0.54a both 10.5 and 10.4)

The MySQL.prefPane is another bug (Bug#28854, where a fix for leopard exist and will probably be included in the next build)

Oops wrong of me... this is not a bug, (MySQL.prefPane is in Bug#28854, and the empty MySQLStartupItem.pkg is in Bug#25008)

I'm sorry...

Thanks to Andrew Lindley