...
Granting these permissions makes the MySQL server fully accessible to SQL DM for MySQL. To actually start collecting data on this server you also need to register it with the application.
Running SQL DM for MySQL as unprivileged user
By default, SQL DM for MySQL runs under the 'root' account in Linux. This may be a security nightmare for some.
Here's how you can create and use a user account exclusively for running SQL DM for MySQL:
- First add a new user and group; replace <GID>, with the group ID, and <PASSWORD>:
Code Block |
---|
|
# groupadd monyog |
Code Block |
---|
|
# useradd -g <GID> -p <passwd> monyog |
Copy the original files to the new location and change the file ownership.
Code Block |
---|
|
# cp -r /usr/local/MONyog/. /home/monyog/ |
Code Block |
---|
|
# chown -R monyog:monyog /home/monyog |
Next, we need to change the initialization script. Be sure to make a backup first!
Code Block |
---|
|
# cp /etc/init.d/MONyogd /etc/init.d/MONyogd.orig |
Code Block |
---|
|
# vi /etc/init.d/MONyogd |
Change the following lines for the new path.
Code Block |
---|
|
PREFIX="/home/monyog" |
Code Block |
---|
|
MONYOGBIN="$PREFIX/bin/MONyog" |
In the same file, you also need to update the start command to the following.
Code Block |
---|
|
# Start MONyog.
...
else
action "`su - monyog -c \"$MONYOGBIN -s\"`" /bin/true
fi |
Now you need to alter the configuration file.
Code Block |
---|
|
# vi /home/monyog/MONyog.ini |
Change the data path to the new directory.
Code Block |
---|
|
Data_path=/home/monyog/data |
After this you should be able to start SQL DM for MySQL running as an unprivileged user.
Code Block |
---|
|
# service MONyog start |