| Age | Commit message (Collapse) | Author |
|---|
|
|
|
|
|
|
|
add $use_nagios hiera check
|
|
Lenny support was phased out and squeeze is the current stable.
There is an instruction in the file that originally came from lenny:
skip-bdb doesn't exist anymore in the mysql version in squeeze, so the
config file makes a fresh mysql install crash on Squeeze.
Signed-off-by: Gabriel Filion <lelutin@gmail.com>
|
|
inline in the manifest
|
|
by default, and how to get around it
|
|
Conflicts:
manifests/server/munin/default.pp
manifests/server/nagios.pp
|
|
|
|
|
|
|
|
Conflicts:
files/munin/mysql_connections
manifests/server/base.pp
manifests/server/munin/default.pp
|
|
|
|
Conflicts:
manifests/server/base.pp
|
|
|
|
check_hostname is not defined. We need to use check_host instead
|
|
|
|
|
|
|
|
mysql has one innodb file per default and this can become very
huge, which can trigger various issues [1]. So in general it
is recommended to set the innodb_file_per_table option [2].
[1] http://forums.mysql.com/read.php?35,121880,121886
[2] http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-tablespaces.html
|
|
|
|
When we are working with tables_priv we need to first get a downcased array of the currently set privileges, and a downcased array of the desired permissions.
Then we make a list of the permissions to revoke by subtracting the requested permissions from the currently set ones.
If the list of permissions to revoke is not empty, then we issue a REVOKE.
Then we make a list of the permissions to add by subtracting the requested permissions from the current set (no need to add select again if it is already there).
Then if the set of permissions to add is not empty, then we actually execute the statement.
|
|
inserts of Y/N values into the table.
To handle this, this comment removes the create_row for table_privs, it also selects the actual value of the Table_priv so its value can be used instead of the method that is used for Y/N value settings
|
|
|
|
columns can be matched
|
|
actually available privileges are less than was originally thought, so I trimmed those down
|
|
|
|
|
|
|
|
This reverts commit 74bf6b84e413b3cc1cce83c334341c1fe58b3b1c. It was
accidentally pushed to shared_mysql before it was ready
|
|
|
|
|
|
|
|
MySQL introduced some new privileges in Versions > 5.1.6, add them
to our set, so puppet still knows what :all is.
|
|
|
|
|
|
It would make the daemon fail to load if put in the config.
|
|
|
|
|
|
|
|
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>
|
|
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>
|
|
|
|
location of where they are
|
|
Parameter unless failed: 'mysqladmin -uroot status > /dev/null' is both unqualifed and specified no search path at /etc/puppet/modules/mysql/manifests/server/base.pp:62
unless you have set globally:
Exec { path => "/usr/bin:/usr/sbin/:/bin:/sbin:/usr/local/bin:/usr/local/sbin" }
|
|
|
|
|
|
|
|
|
|
|
