Never mind! Some how mysql's root user lost privileges and once I fixed
that the mysql module worked great!
On Wednesday, May 29, 2013 11:05:10 AM UTC-4, Thomas wrote:
>
> I'm new to using the puppetlabs/mysql forge module and having trouble
> creating the user for performing backups. My guess is that I'm overlooking
> something simple... Any advise is appreciated!
>
> I'm using puppet 3.1.1 on the master and puppet 2.7.14 on the node both on
> RHEL 6.0, mysql 5.1.47, mysql module 0.6.1 and stdlib module 4.1.0
>
> I get the following error:
> err: /Stage[main]/Mysql::Backup/Database_user[backup@localhost]/ensure:
> change from absent to present failed: Execution of '/usr/bin/mysql
> --defaults-file=/root/.my.cnf mysql -e create user 'backup'@'localhost'
> identified by PASSWORD '*BD5515535695CE93D0D73DB8B4C3297B61184286''
> returned 1: *ERROR 1227 (42000) at line 1: Access denied; you need the
> CREATE USER privilege for this operation*
> notice: /Stage[main]/Mysql::Backup/Database_grant[backup@localhost]:
> Dependency Database_user[backup@localhost] has failures: true
> warning: /Stage[main]/Mysql::Backup/Database_grant[backup@localhost]:
> Skipping because of failed dependencies
>
> For the following puppet code:
>
> Database {
> require => Class['mysql::server'],
> }
>
> class { 'mysql': }
> class { 'mysql::java': }
> class { 'mysql::server':
> config_hash => { 'root_password' => "${dbPassword}" },
> }
> database { [ 'dbname1', dbname2' ] :
> ensure => present,
> charset => 'latin1',
> }
> class { 'mysql::backup':
> backupuser => "${dbBackupUser}",
> backuppassword => "${dbBackupPassword}",
> backupdir => "${dbBackupDir}",
> }
>
>
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/puppet-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
