Hi, Following are the requested details
OS - Centos 5.4 Puppet Server - 2.7.12 Pupper Client - puppet-2.6.16 puppet-mysql module version - 0.4.0<https://github.com/puppetlabs/puppetlabs-mysql/commit/583e60fe843082e5c551ee93ab2ce45b47733216> Git Cloned from : https://github.com/puppetlabs/puppetlabs-mysql.git Yes.. I first used the "config_hash => { 'root_password' => 'mypass' }" parameter but later when it wasn't working, I commented it. I also enabled pluginsync in my puppet.conf. Still no avail. I really appreciate the help from you guys. Thanks & Regards, Rakesh K. On Thu, Aug 2, 2012 at 11:58 PM, Nan Liu <n...@puppetlabs.com> wrote: > 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. > > -- 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.