On Thu, Aug 2, 2012 at 11:19 AM, Ryan Coleman <r...@puppetlabs.com> wrote:
> On Tue, Jul 31, 2012 at 11:53 PM, Rakesh K <rkath...@gmail.com> wrote:
>> For mysql I am using the module
>> https://github.com/puppetlabs/puppetlabs-mysql
>>
>> What I am observing is mysql is gets installed and everything but no db is
>> added, also intermittently the password is not set, it is neither not blank
>> nor does it set the password that I have mentioned. The nodes.pp that I am
>> using is as follows
>>
>> [root@pmast1 manifests]# cat /etc/puppet/manifests/nodes.pp
>> class baseclass {
>> class { 'mysql': }
>> class { 'mysql::server':
>> #config_hash => { 'root_password' => 'mypass' }
>> }
>> mysql::db { 'mydb':
>> user => 'myuser',
>> password => 'mypass',
>> host => 'localhost',
>> grant => ['all'],
>> }
>> }
>
> I just noticed that you have commented out the config_hash parameter.
> Have you tried uncommenting that and setting 'mypass' to the actual
> value of your database servers root password?
>
> Puppet uses this information to configure the file /root/.my.cnf which
> is leveraged when the various mysql commands are run to provision the
> database, create database users and assign grants.
Yeah, per Ryan, most likely you already have an existing password, and
you need to set old_root_password before you can set the new password:
...
config_hash => {
root_password => 'mypass',
old_root_password => 'oldpass',
}
...
Nan
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.
