Bug #37341 Installed files belong to user, not root
Submitted: 11 Jun 2008 13:12 Modified: 25 Jul 2008 17:52
Reporter: Kai Voigt Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Enterprise Monitor: Installing Severity:S2 (Serious)
Version:1.3.2 Release Candidate OS:MacOS (10.5)
Assigned to: CPU Architecture:Any

[11 Jun 2008 13:12] Kai Voigt
Description:
When installing the monitor using the installer, the files get the ownership of the installing user, not the root user.

This causes the bultin mysqld not to start because of missing permissons.

How to repeat:
Install the monitor on a fresh MacOSX machine as a standard user. Shutdown the box, try to restart everything and check /Applications/mysql/enterprise/monitor/mysql/data/mysqld.log:

080611 14:50:46  mysqld started
080611 14:50:46 [Warning] Setting lower_case_table_names=2 because file system for /Applications/mysql/enterprise/monitor/mysql/data/ is case insensitive
080611 14:50:46  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
080611 14:50:46  mysqld ended

Suggested fix:
I did the following to get things running.

# cd /Applications
# chown -R root mysql/
# cd /Applications/mysql/enterprise/monitor/mysql/
# chown -R mysql data

Also, the data directory should be non readable for everyone

# chmod 750 data
[16 Jun 2008 20:00] Sveta Smirnova
Seems same as bug #35203
[25 Jun 2008 17:52] Marcos Palacios
Logged in as a non-root user during installation, I can't reproduce the error. What group does the 'standard user' belong to?
[25 Jul 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".