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 puppet-users+unsubscribe@googlegroups.com.
To post to this group, send email to puppet-users@googlegroups.com.
Visit this group at http://groups.google.com/group/puppet-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouppuppet-users @
postedMay 29, '13 at 3:05p
activeMay 29, '13 at 4:38p

1 user in discussion

Thomas: 2 posts



site design / logo © 2022 Grokbase