summaryrefslogtreecommitdiff
path: root/manifests/server
AgeCommit message (Collapse)Author
2011-02-25Remove other default accounts due to security reasonsmh
2010-12-21add some other mysql pluginsmh
2010-12-18Avoid root password leak to process listGabriel Filion
The current procedure of setting the root MySQL password leaks the root password by giving it to the setmysqlpass.sh script on the command line. This means that during the couple of seconds that the script is executing, the password is visible in the process list! Since we're already writing the password in the /root/.my.cnf file, make the setmysqlpass.sh script parse this file to retrieve the password instead of receiving it from a command line argument. Also, in some shells the 'echo' command might appear in the process list. Use a heredoc notation to create the output without using a command. Signed-off-by: Gabriel Filion <lelutin@gmail.com>
2010-10-18. remove the check_mysql_health script from the mysql module, instead it ↵Micah Anderson
belongs in the nagios module . change the default nagios::service::mysql check to use the check_mysql_health 'connection-time' check mode, which is identical to the original check, with some additional information . stop using nagios::plugin::deploy because this doesn't work when more than one node attempts to realize this class . stop exporting the nagios_command because this doesn't work when more than one node attempts to realize this class . remove the check_health define, instead this be how it was before, as the previous nagios::service::mysql define
2010-10-18change the default $check_hostname variable to be the localhost interface. ↵Micah Anderson
This seems to make more sense than using $fqdn
2010-10-17simplify the nagios check_mysql_health plugin process:Micah Anderson
1. use the new plugin deploy feature in nagios (nagios::plugin::deploy) 2. remove unnecessary classes and inheritance - this plugin seems reasonable to install by default, and in fact it could be argued that the other 'check_mysql' plugin that still remains can be removed, as its functionality is vastly overshadowed by this one 3. add the 'repl_client_priv' mysql grant privs to the nagios user. these are needed for the check_mysql_health plugin slave replication modes. According to http://dev.mysql.com/doc/refman/5.0/en/privileges-provided.html#priv_replication-client - The REPLICATION CLIENT privilege enables the use of SHOW MASTER STATUS and SHOW SLAVE STATUS. These privileges are not too much to provide to the nagios user, as they are only informational 4. setup the define "check_health" so it can be used easily
2010-09-27add a more advanced mysql health check plugin:Micah Anderson
* create a mysql::server::nagios::base class with the common parts needed for the basic plugin, and the health plugin * make mysql::server:nagios inherit mysql::server:nagios::base * create a new class mysql::server::nagios::check_health inheriting ::base the nagios module has also received a new define to setup the different nagios::service pieces for the different health check modes that might be desired its assumed you would setup the different health check modes in site-mysql/init.pp as different hosts will require different modes and/or parameters, for example: class site-mysql::server { include mysql::server::nagios::check_health nagios::service::mysql_health { [ 'connection-time', 'uptime', 'threads-connected', 'threadcache-hitrate' ]: require => Mysql_grant[$nagios_mysql_user], } case $hostname { "eider": { nagios::service::mysql_health { [ 'slave-io-running', 'slave-sql-running', 'slave-lag' ]: require => Mysql_grant[$nagios_mysql_user], } } } }
2010-09-22fixing merge error which removed a / -- round 2Micah Anderson
2010-09-22fixing merge error which removed a /Micah Anderson
2010-09-22fix pathing, its /usr not /userMicah Anderson
2010-09-22Merge remote branch 'remotes/immerda/master'Micah Anderson
Conflicts: manifests/server/base.pp
2010-09-22allow for different my.cnf files according to the OS releaseMicah Anderson
2010-09-22require package mysql-server for service mysql instead of mysql-clientMicah Anderson
2010-08-11remove unnecessary fileserver variable (#2460) round IImh
2010-08-07remove unnecessary fileserver variable (#2460)mh
2010-04-22fix quotingmh
2010-04-02manage file before cron, but only when we actually manage the filemh
2010-04-02make backup dir management optionalmh
2010-04-02move scripts to /usr/local/sbin, old scripts are getting removed by wiping ↵mh
the modules dir
2010-04-02no need to have an empty classmh
2010-04-02no need to set an empty source dirmh
2009-12-22adjust nagios mysql user to allow tcp connectionsJerome Charaoui
2009-12-11add nagios class to create mysql user and grant for nagios, with option to ↵Jerome Charaoui
skip nagios service registration if check is done through check_ssh or check_nrpe for example
2009-12-11manage mysql munin plugin per-OS, use debian.cnf on DebianJerome Charaoui
2009-12-11manage permissions on debian.cnfJerome Charaoui
2009-12-10make backup and optimize cron jobs optional; introduce $mysql_backup_cron, ↵Jerome Charaoui
$mysql_backup_dir and$mysql_optimize_cron; use a module_dir for scripts
2009-12-10change mysql client alias and quote resource namesJerome Charaoui
2009-12-10run mysql_set_rootpw if $mysql_rootpw changesJerome Charaoui
2009-12-10add Debian supportJerome Charaoui
2009-11-14update to 0.25.x stylemh
2009-11-02recursivly updating file path to new 0.25 stylemh
2009-10-03refactor classesmh