Critical permissions for SE v2.1.x Network Plus server files on Mac OS X
This topic describes the permissions that must be set in order for the SE mysqld process to function correctly on a Mac OS X computer that is hosting the SE server components. Note that only Mac OS X v10.3.x and later is supported for the SE server components.
When the SE server components are installed, the installer should set all permissions for the SE folders correctly; you should not change these permissions after SE has been installed. If the permissions are not set correctly, errors may result when the mysqld process is started, SE may not work at all, or unexpected behavior may occur even if the mysqld process appears to be running normally (for example, clients may not be able to connect).
Note: You may see two mysqld processes in the Activity Monitor of Mac OS X v10.x server software. The SE mysqld process displays as a "PowerPC" process; however, it works fine on Macintosh computers with Intel processors.
Note: If you find that permissions are set differently than specified below but SE is working, we recommend that you leave the permissions as they are.
SE Network Plus Server Permissions
It is critically important that you set the permissions correctly for the following folder and files in order for SE to work correctly.
HDD/Applications/RNSENetworkPlus/RNSEServer/ServerFiles/data
Set the permissions for this folder as follows:
Who |
Permissions Required |
| Owner: mysql, or _mysql if running Leopard 10.5.x | Read/Write/Execute |
| Group: wheel | Read/Execute |
| Everyone | No access |
It is important that all of the files and folders in the data folder have the same permissions. If you use Finder or a utility such as Batchmod to set permissions, be sure to select Apply to enclosed folders and files. If you use a chown or chmod command in a terminal window, be sure to use the -R option. For more information about these commands, enter man chown or man chmod in the terminal window.
HDD/Applications/RNSENetworkPlus/RNSEServer/ServerFiles/my.cnf
Set the permissions for this file as follows:
Who |
Permissions Required |
| Owner: Normally, the owner is set to the user that installed the software | Read/Write |
| Group: wheel or the owner | Read |
| Everyone | Read |
The important thing here is to make sure that only the owner has read/write access. Otherwise, when starting up the mysqld process it will launch alright, but it will see that the file is accessible to everyone and for security purposes will not use the options in it. This will result in the mysqld process using the default locations for data files and it will also default to using port 3306 instead of our port 23460. In this case, you would see that mysqld is running fine, but the client application and our utilities will not be able to connect to it.
HDD/Applications/RNSENetworkPlus/RNSEServer/ServerFiles/mysql.server
Set the permissions for this file as follows:
Who |
Permissions Required |
| Owner: Normally, the owner is set to the user that installed the software | Read/Write/Execute |
| Group: wheel | Read/Execute |
| Everyone | Read/Execute |
