FAQ
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 @
categoriespuppet
postedMay 29, '13 at 3:05p
activeMay 29, '13 at 4:38p
posts2
users1
websitepuppetlabs.com

1 user in discussion

Thomas: 2 posts

People

Translate

site design / logo © 2022 Grokbase