Commit graph

213 commits

Author SHA1 Message Date
Jerome Charaoui
2c137af198 Merge branch 'non_ascii_comment' into 'master'
remove non-ascii char in comment in init.pp

Apparently puppet doesn't like ppl who don't speak English and crashes
on non-ASCII chars in comments.

Assigned to Jerome for review (but the pick was somewhat random)

See merge request !4
2015-10-07 15:46:27 +00:00
Gabriel Filion
19ddc07abc remove non-ascii char in comment in init.pp
Apparently puppet doesn't like ppl who don't speak English and crashes
on non-ASCII chars in comments.
2015-09-26 17:58:23 -04:00
Jerome Charaoui
491f7f4dd4 package containing ruby bindings is renamed 'ruby-mysql' in wheezy and later releases 2015-08-05 10:22:04 -04:00
Gabriel Filion
4724a15633 account_security doesn't exist anymore 2015-05-13 16:05:42 -04:00
Gabriel Filion
d69d43efa5 mysql_ibdata1 is not managed anymore but is still overridden for debian 2015-05-13 16:03:47 -04:00
Gabriel Filion
1522deafda mysql root password is leaked to the process list
Every time the root password reset is used we're leaking the password to
the process list. If we use the already present /root/.my.cnf for
credentials then it has the same effect for verification and we avoid
leaking the password.
2015-05-13 16:02:36 -04:00
Jerome Charaoui
85514f6feb Merge branch 'master' into merge_immerda_new
Conflicts:
	manifests/server/cron/backup.pp
2015-04-21 09:44:01 -04:00
Jerome Charaoui
e5a66002f3 Restore a few things that got removed:
* Manage /etc/mysql/mysql.conf.d
* Account security ensures
* Check mysql_exists before realizing ressources

These last two points partially revert commit
e1649647f3
2015-04-17 17:18:25 -04:00
Jerome Charaoui
31ecdf427d Restore parameters from optimize cronjob class 2015-04-17 11:59:40 -04:00
Micah Anderson
568c76139e Add GPLv3 license 2015-04-17 11:27:57 -04:00
Gabriel Filion
35c351f926 Cron jobs are not removed when unused.
Currently, if you have the bad idea of setting backup_cron or
optimize_cron to true in the main class and later to change it back to
false, the associated cronjob will stay in place even though you don't
want it.

To make this option more consistant, let's remove cron jobs (and backup
helper scripts) when the appropriate option is set to false.

Signed-off-by: Gabriel Filion <gabster@lelutin.ca>
2015-03-27 15:37:25 -04:00
Jerome Charaoui
a713d36aeb Merge branch 'master' of git://git.puppet.immerda.ch/module-mysql
Conflicts:
	files/scripts/optimize_tables.rb
	manifests/server/base.pp
2015-02-24 16:46:45 -05:00
Jerome Charaoui
9b327191c7 Merge branch 'document_nagios_custom_logic' into 'master'
Document nagios custom logic

Add some note for ppl who need to inject their own logic before creating nagios-related checks.

See merge request !1
2015-02-20 22:40:18 +00:00
Gabriel Filion
a2d32440d0 README: mention why using manage_nagios can be used for inserting logic
If you need to avoid creating certain nagios checks for some reason
that's specific to your local policies, you can avoid letting the module
from automatically managing nagios services and then include it whenever
you need it.
2015-02-20 16:24:45 -05:00
Gabriel Filion
a38a833167 README: fix variable name for nagios
Documentation mentions something but the manifests use another name for
the variable.
2015-02-20 16:14:43 -05:00
mh
0ce33a632f we only need to ensure grants if the user is present 2015-01-25 13:48:52 +01:00
mh
e1649647f3 fix issues for EL7 + simplify account security
* EL7 uses mariadb & systemd -> adjust setpasswd script to that
* move the security ensurance to the setpassword script, as it's
  easier to ensure that there
2015-01-24 18:05:08 +01:00
mh
fd71b9473f split on new line, which fixes an issue if no table is found 2015-01-12 23:29:41 +01:00
mh
3820ed70a0 this should be variables 2015-01-10 11:42:33 +01:00
mh
02c8f3342e introduce new mariadb based config for EL7 2015-01-10 02:18:15 +01:00
mh
6be4faa81f There is no need to call “super” here.
This patch avoid the following error:
  Validate method failed for class sleep: implicit argument passing
  of super from method defined by define_method() is not supported.
  Specify all arguments explicitly.

See https://git.openstack.org/cgit/stackforge/puppet-vswitch/commit/?id=25afbfe58867fb39266a8862cfd6a3f8f38a9564
2015-01-10 02:05:11 +01:00
mh
553831bf34 on EL7 there is now mariadb 2015-01-10 01:50:39 +01:00
Gabriel Filion
0f817282af Merge branch 'mention_path' 2014-03-12 16:26:42 -04:00
Gabriel Filion
102de3b0e7 Merge branch 'conf_define' 2014-03-12 16:26:32 -04:00
Gabriel Filion
b06570a940 Document the new define in the README
Signed-off-by: Gabriel Filion <gabster@lelutin.ca>
2014-03-12 16:25:58 -04:00
Gabriel Filion
84fba22bad Merge branch 'randomize_optimize' 2014-03-12 11:43:31 -04:00
Jerome Charaoui
8fbc1b33ee Fix command output capturing in optimize_tables.rb for Ruby 1.9 2014-03-11 17:57:03 -04:00
Jerome Charaoui
f34882cadd Fix munin plugin class on Debian 2014-03-11 15:28:20 -04:00
Gabriel Filion
a5754aa802 document the new arguments for setting optimize run time 2014-03-06 18:52:57 -05:00
Gabriel Filion
ae2fbce7ac Randomize time of execution for optimize script.
By default, time will be between midnight and 7:00 any day of the week.

The values are currently hard-coded. This can have serious I/O
repercussions on a server with multiple VMs that run mysql since they
will all run their optimizations simultaneously.
2014-03-06 18:46:06 -05:00
mh
c06abd681c add mysqltuner class 2014-02-28 14:50:17 +01:00
mh
cae3a3cbe8 fix #6638 - remove the unless check & improve script
To workaround a limitation of the exec provider within puppet, we
do the unless check no within the script itself and ensure that
we use the password there.

https://labs.riseup.net/code/issues/6638
2014-02-05 22:34:17 +01:00
mh
7bde4efe1e improve optimize script 2014-01-12 14:19:26 +01:00
Gabriel Filion
e3b382edeb conf: notify mysql service to make changes effective 2013-12-18 15:15:37 -05:00
Gabriel Filion
fc6458e9e4 manage configuration snippets in a conf.d directory
this should make it easier to override values from my.cnf, or to set
other values that aren't in the main config file.
2013-12-05 16:19:52 -05:00
mh
d459760890 update README to document the stdlib dependency 2013-12-05 20:18:27 +01:00
mh
c38546e15f introduce the /etc/mysql/conf.d/ directory for CentOS 2013-12-05 20:14:04 +01:00
mh
6d485b1693 better use this built in fact now 2013-12-05 10:49:54 +01:00
mh
1caaa07190 some reasonable defaults 2013-12-05 10:47:25 +01:00
mh
eb03b7f647 update to latest EL release 2013-12-04 23:40:38 +01:00
mh
808a83374c rename deprecated option 2013-12-04 23:24:59 +01:00
mh
bad8721b44 also chown the data dir 2013-12-04 23:19:09 +01:00
mh
e9f0304525 this is not really necessary 2013-12-04 23:15:26 +01:00
mh
5665884209 EL6.4 doesn't know about bdb 2013-12-04 23:12:22 +01:00
Gabriel Filion
3c93ba2339 setmysqlpass: be more careful before plundering into action
Since this script is rooting the database, it'd be good to use a little
more precaution so that we don't let systems be in an inconsistent case
when crashing.

In cases where the PATH variable is not appropriately set (variable is
empty by default when script is invoked by puppet) the script shuts down
mysql and then is not able to call most commands.
2013-11-15 04:07:28 -05:00
Gabriel Filion
82cf365b2c README: Mention the need for setting the path appropriately
Without at least /sbin, /bin, /usr/sbin and /usr/bin, the
setmysqlpass.sh script won't run correctly and the module will not set
the requested root password.
2013-11-15 01:15:59 -05:00
mh
0e8a73ecea fix ordering 2013-05-20 14:36:59 +02:00
mh
86ef2c3dd2 use the defaults file if available 2013-05-20 14:32:43 +02:00
mh
1e8e9f472c symbolize was removed in puppet 3 - See http://projects.puppetlabs.com/issues/16791 2013-05-20 14:05:00 +02:00
mh
bd6abae490 some mysql versions start to display a nasty warning - http://bugs.mysql.com/bug.php?id=68376 2013-05-03 11:55:41 +02:00