Re: [Puppet Users] How we can create two database Using same credetial using Puppet

[Calvin Walton]

On Thu, 2013-03-21 at 03:37 -0700, Jithin Xavier wrote:
> Hello All,
> 
> I wanted to create two two MySQL database with same user credential using 
> Puppet-MySQL. How can I achieve this? Please find my script below.
> 
> class mysql::vsdatabase {
>  include mysql
>  mysql::db { 'vidispine':
>  user => 'user',
>  password => 'user123',
>  host => 'db.<hostname>.com',
> }
> }
> 
> How can I add another database here with same credential.(If I create 
> different Class with different database and same credential I am getting 
> below error.

The current git version of the mysql module has a fix for this error:
https://github.com/puppetlabs/puppetlabs-mysql/commit/1d6ca771d480e756cfdc5f84d73ef2d49f08ba38
but it has not yet been released. In the mean time, you can separately
use the underlying resources: (The mysql::db type is just a
convenience), just add additional 'database' and 'database_grant'
resources as needed:

database { 'vidispine':
        ensure => 'present',
        charset => 'utf-8',
        provider => 'mysql',
        require => Class['mysql::server'],
}
        
database_user { 'u...@example.com': 
        ensure => 'present',
        password_hash => mysql_password('user123'),
        provider => 'mysql',
        require => Database['vidispine'],
}

database_grant { 'u...@example.com/vidispine':
        privileges => 'all',
        provider => 'mysql',
        require => Database_user['u...@example.com'],
}
        
-- 
Calvin Walton <calvin.wal...@kepstin.ca>

smime.p7s
Description: S/MIME cryptographic signature