Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Commits on Feb 9, 2015
  1. @mhaskel

    move tests to examples

    mhaskel authored
  2. @mhaskel

    lint cleanup

    mhaskel authored
Commits on Feb 6, 2015
  1. @hunner

    Merge pull request #645 from dveeden/auth-plugins

    hunner authored
    Support authentication plugins
Commits on Jan 28, 2015
  1. @casharma
Commits on Jan 26, 2015
  1. @dveeden
Commits on Jan 24, 2015
  1. @dveeden

    Support authentication plugins

    dveeden authored
    This uses CREATE USER xxx IDENTIFIED WITH yyy
    
    For tests:
     unix_socket is not loaded by default, so this might require:
     install plugin unix_socket soname 'auth_socket.so';
    
     The mysql_native_password plugin is available by default and
     allows you to also set a password.
    
    Try to make it compatible with MySQL < 5.5.7 it uses version
    specific code with "/*!50508 stmt */"
Commits on Jan 22, 2015
  1. @cmurphy
Commits on Jan 17, 2015
  1. @dveeden

    Support authentication plugins

    dveeden authored
    This uses CREATE USER xxx IDENTIFIED WITH yyy
    
    For tests:
     unix_socket is not loaded by default, so this might require:
     install plugin unix_socket soname 'auth_socket.so';
    
     The mysql_native_password plugin is available by default and
     allows you to also set a password.
Commits on Nov 18, 2014
  1. @biancini @mhaskel

    Fixed test classes

    biancini authored mhaskel committed
    Oracle 7 uses mariadb
    
    Update PE and OS compatibility info in metadata
    
    Now compatible with PE 3.4 and SLES 10.
    
    Clean up metadata for new SLES support
    
    Add timeout parameter to increase for long time running sql imports
    
    Signed-off-by: refnode <refnode@gmail.com>
    
    Add documentation for new mysql::db "import_timeout" parameter
    
    Signed-off-by: refnode <refnode@gmail.com>
    
    Add support for Gentoo
    
    The old regex requires something after the 'host' part. Fix this.
    
    Old regex is : /^GRANT\s(.+)\sON\s(.+)\sTO\s(.*)@(.*?)(\s.*)$/ . The
    last part (\s.*)$ means "a space followed by anything". The issue is
    that when user has no GRANT privileges, the "SHOW GRANTS FOR #{user_string}" returns
    "GRANT SELECT ON `database`.* TO 'user'@'%'" which does not match (\s.*)$ .
    This small patch fixes this making last bloc optional (thanks to '?').
    
    Add explicit dependencies for types
    
    mysql_grant has an autorequire()'d dependency on the .my.cnf file used
    by the provider to talk to the database.
    
    I've added this to mysql_database and mysql_user too since logically
    these also need the file to be in place.
    
    I've hit this bug because of a slightly unusual edge case in our own
    manifests, but I think this fix belongs upstream regardless.
    
    (maint) add statement "MANAGED BY PUPPET" to my.cnf config file template and remove unused my.conf.cnf.erb template
    
    Improve checks for MySQL user's name.
    
    As per http://dev.mysql.com/doc/refman/5.5/en/identifiers.html , MySQL
    allows for more than '\w-'. This commit improves the check to ensure
    that:
     - if username only contains [0-9a-zA-Z$_], it might be quoted. It is
       not a requirement though
     - if username contains anything else, it MUST be quoted
    
    I kept 2 checks, but the 2nd one can probably be removed (I can't find a
    username which match the 2nd one but not the first.)
    
    Fix escaped backslashes in grants
    
    * Mysql uses the underscore character to represent a single character
      wildcard.
    * A grant on table `the_database`.* would match `theAdatabase`.*, so
      underscores must be escaped to avoid this match.
    * The output from mysql escapes special characters (\n, \t, \0, and \\),
      but the input does not need to be escaped.
    * In order for the provider to compare the tables, the output of
      mysql -NBe <query> must have \\ substituted with \.
    
    Fixed backup test
    
    Oracle 7 uses mariadb
    
    Update PE and OS compatibility info in metadata
    
    Now compatible with PE 3.4 and SLES 10.
    
    Add timeout parameter to increase for long time running sql imports
    
    Signed-off-by: refnode <refnode@gmail.com>
    
    Add documentation for new mysql::db "import_timeout" parameter
    
    Signed-off-by: refnode <refnode@gmail.com>
    
    Add support for Gentoo
    
    The old regex requires something after the 'host' part. Fix this.
    
    Old regex is : /^GRANT\s(.+)\sON\s(.+)\sTO\s(.*)@(.*?)(\s.*)$/ . The
    last part (\s.*)$ means "a space followed by anything". The issue is
    that when user has no GRANT privileges, the "SHOW GRANTS FOR #{user_string}" returns
    "GRANT SELECT ON `database`.* TO 'user'@'%'" which does not match (\s.*)$ .
    This small patch fixes this making last bloc optional (thanks to '?').
    
    Add explicit dependencies for types
    
    mysql_grant has an autorequire()'d dependency on the .my.cnf file used
    by the provider to talk to the database.
    
    I've added this to mysql_database and mysql_user too since logically
    these also need the file to be in place.
    
    I've hit this bug because of a slightly unusual edge case in our own
    manifests, but I think this fix belongs upstream regardless.
    
    (maint) add statement "MANAGED BY PUPPET" to my.cnf config file template and remove unused my.conf.cnf.erb template
    
    Improve checks for MySQL user's name.
    
    As per http://dev.mysql.com/doc/refman/5.5/en/identifiers.html , MySQL
    allows for more than '\w-'. This commit improves the check to ensure
    that:
     - if username only contains [0-9a-zA-Z$_], it might be quoted. It is
       not a requirement though
     - if username contains anything else, it MUST be quoted
    
    I kept 2 checks, but the 2nd one can probably be removed (I can't find a
    username which match the 2nd one but not the first.)
    
    Fix escaped backslashes in grants
    
    * Mysql uses the underscore character to represent a single character
      wildcard.
    * A grant on table `the_database`.* would match `theAdatabase`.*, so
      underscores must be escaped to avoid this match.
    * The output from mysql escapes special characters (\n, \t, \0, and \\),
      but the input does not need to be escaped.
    * In order for the provider to compare the tables, the output of
      mysql -NBe <query> must have \\ substituted with \.
Commits on Sep 16, 2014
  1. @mmonaco

    mysql_database: prevent syntax error with collate=>'binary'

    mmonaco authored
    On MySQL v5.5.38, creating a database such as:
    
    	CREATE DATABASE `mydb` CHARACTER SET binary COLLATE binary;
    
    seems to hit a parser bug. A workaround is simply to quote COLLATE
    `binary`. As the quoting is harmless, and for aesthetics, quote both
    the CHARACTER SET and COLLATE arguments.
Commits on May 21, 2014
  1. Fix a syntax error in one of the tests.

    Ashley Penney authored
Commits on Apr 21, 2014
  1. @ryansechrest

    Replaced database_user with mysql_user

    ryansechrest authored
    database_user has been deprecated in favor of mysql_user.
Commits on Mar 15, 2014
  1. @xcompass

    Allow use different name for db resource other than db name

    xcompass authored
    When defining the mysql::db as exported resources, there are chances that the
    same resource names are defined across the site, which will cause puppet agent
    fail. By adding an optional dbname parameter, default to the $name, it allows the
    resouce name to be defined differently, e.g. ${dbname}_${domain}.
    Also updated test and docs for dbname parameter and add acceptance test for
    dbname parameter feature
Commits on Nov 5, 2013
  1. Merge pull request #355 from tekenny/master

    Ashley Penney authored
    added * for table name in title to match documented usage
  2. @tekenny
Commits on Oct 30, 2013
  1. @terrimonster

    add bindings test

    terrimonster authored
Commits on Oct 17, 2013
  1. @glarizza

    Update mysql::server test

    glarizza authored
    With the update to the new version of mysql, the test for the
    mysql::server class is incorrect.  This quick commit updates
    the test according to the new syntax.
Commits on Sep 3, 2013
  1. Refactor and rename database_grant to mysql_grant.

    Ashley Penney authored
    This provider has undergone the largest set of changes and currently
    just accepts a full SQL grant string as the name and then applies it,
    making things easier for DBAs and removes the awkward attempts at
    modelling grants into Puppet.
Commits on May 3, 2013
  1. @RsrchBoy

    mysql::perl tests

    RsrchBoy authored
Commits on Sep 4, 2012
  1. @dalen

    Fix lint warnings

    dalen authored
Commits on Aug 13, 2012
  1. @Savar

    New configuration define.

    Savar authored
    * added a define to easily create .cnf files in /etc/mysql/conf.d/
    * fix wrong path for .my.cnf in /etc/
Commits on May 11, 2012
  1. @bodepd

    Merge pull request #64 from runningman/backup

    bodepd authored
    Added mysql::backup class.
Commits on May 5, 2012
  1. @bodepd

    Merge pull request #63 from runningman/security

    bodepd authored
    Added mysql::server::account_security class.
Commits on Apr 24, 2012
  1. @razorsedge

    Added mysql::server::account_security class.

    razorsedge authored
    Secures the MySQL installation by removing the test database and the
    default users that are created during the MySQL first-run
    (root@${fqdn}, @%, @localhost, etc.).
    Includes rspec tests and updated documentation.
  2. @razorsedge

    Added mysql::backup class.

    razorsedge authored
    Installs a mysql backup script, cronjob, and priviledged backup user. 
    Includes rspec tests and updated documentation.
  3. @razorsedge

    Added tests to mysql::java.

    razorsedge authored
Commits on Mar 13, 2012
  1. @nanliu

    Major refactor of mysql module.

    nanliu authored
    This is a major change to the module and would be released as a new
    version.
    
    * Add self.instances to database and database_user for puppet resource.
    * Update database provider to use flush method.
    * Update module to conform to puppet-lint recommendations.
    * Cleanup some unecessary logic in mysql::db define type.
    * Move mysql_restart to config class.
    * Use class to class dependency instead of resource dependency.
    * Change appropriate rspec-puppet tests.
    * Add fixtures directory to simplify testing.
    * Update raketask and spec_helper to reflect fixture changes.
    * Update mysql_password function to support validation.
    * Move client installation to a separate class.
    * Update documentation and readme.
Commits on Dec 5, 2011
  1. @cwarden @kbarber

    (#11184) Allow wildcards in account host names

    cwarden authored kbarber committed
    Allow wildcard in the host part of MySQL accounts:
    
    http://dev.mysql.com/doc/refman/5.0/en/grant.html#grant-accounts-passwords
    
    For the examples, Add a database_user test that contains a wildcard in the host
    name part.
    
    Also in the examples, pass root_password to mysql::server in config_hash.
Commits on Oct 31, 2011
  1. (#10391) Update docs to reflect config_hash.

    Dan Bode authored
    Configuration was moved to config hash param of the mysql::server class.
    
    This was done so that additional parameters can be
    added in the future and not have to be added to
    both mysql::config and mysql::server as class params
    
    This patch updates the README, docs, and examples to
    correctly use the parameter.
Commits on May 27, 2011
  1. @bodepd

    cleaned up style a little:

    bodepd authored
        
    - updated mysql::ruby to use params value for
      package_name
    - updated server to use params value for service
      and package
    - clarified some param names to make them more
      consistent
  2. @bodepd
Commits on May 25, 2011
  1. @bodepd

    adding first commit for mysql.

    bodepd authored
Something went wrong with that request. Please try again.