summaryrefslogtreecommitdiff
path: root/files/scripts
AgeCommit message (Collapse)Author
2015-05-13mysql root password is leaked to the process listGabriel Filion
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-02-24Merge branch 'master' of git://git.puppet.immerda.ch/module-mysqlJerome Charaoui
Conflicts: files/scripts/optimize_tables.rb manifests/server/base.pp
2015-01-24fix issues for EL7 + simplify account securitymh
* 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-12split on new line, which fixes an issue if no table is foundmh
2014-03-12Merge branch 'mention_path'Gabriel Filion
2014-03-11Fix command output capturing in optimize_tables.rb for Ruby 1.9Jerome Charaoui
2014-02-05fix #6638 - remove the unless check & improve scriptmh
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-01-12improve optimize scriptmh
2013-12-04also chown the data dirmh
2013-11-15setmysqlpass: be more careful before plundering into actionGabriel Filion
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.
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-09-22Merge remote branch 'remotes/immerda/master'Micah Anderson
Conflicts: manifests/server/base.pp
2010-09-22increase timeout before killing to account for slower startup speed of ↵Micah Anderson
larger databases
2010-04-04as we are in ruby we need to double escape thatmh
2010-04-04escape table and db namesmh
2010-04-02improve optimize script to work as well on weird named tablesmh
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