MySQL Bugs: #28954: Installer does not give option to automatically setup boot scripts

Bug #28954	Installer does not give option to automatically setup boot scripts
Submitted:	7 Jun 2007 18:16
Reporter:	Harrison Fisk	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Enterprise Monitor: Installing	Severity:	S4 (Feature request)
Version:	1.1.0	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
The installer for the agent and service manager do not give the option of automatically setting up the boot scripts.  You have to always manually install them by hand after installing the system.  Installing these startup scripts takes additional time and can cause some confusion.

This is different from Windows, where the service manager and agent is set to automatically start at boot time by the installer.

How to repeat:
Install the agent and install the service manager on a non-windows sytem.

Start them up.

Reboot.

Suggested fix:
Make the installer setup the services to automatically start at boot time.

The documentation also says that the agent should restart automatically reboot (in section 3.4.6)  So either the installer or the documentation should be changed.

From the 3.0 docs:
http://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-install-agent-unix.html

"To automatically start the agent upon rebooting, you must install while logged in as root. If you install as an unprivileged user, you must start the agent yourself after each reboot."

From crontab(5)
.....
       These special  time  specification  "nicknames"  are  supported,  which
       replace the 5 initial time and date fields, and are prefixed by the ’@’
       character:
       @reboot    :    Run once after reboot.
.....

So a solution might be to add this to the crontab of the non-root user:
@reboot /opt/mysql/enterprise/agent/etc/init.d/mysql-monitor-agent start

The crontab(5) manual is from 4th Berkeley Distribution (Source: RHEL 5.9, which uses the vixie 4.1 crond implementation)

The @reboot doesn't work on Solaris 10, but it should work on Linux and FreeBSD.

http://www.freebsd.org/cgi/man.cgi?query=crontab&sektion=5&apropos=0&manpath=FreeBSD+10.0-...

Creating a 'run_this_as_root_to_install_mem_startup.sh' would also be helpful.