Ok problem solved
Evidently pupped uses the /etc/my.cfg to get the password to access to the
DB
This info is not written down in the puppet-mysql template (I believe that
few people use the database creation of the module).
Also there is a bit of mess right now on the writing of that file it seems
that it get written by too many pieces.
In the end is possible to add the password key in that file and all goes
well.
As a workaround this can be a good solution, but for long term approach I
think that writing down in clear in the host the root passowrd is not a
good approach, but anyway...
Thanks
Luca
Il giorno giovedì 6 settembre 2012 10:15:38 UTC+2, Luca Gioppo ha scritto:
>
> On a second run of puppet after adding the mysql::db is not possible to
> create the db getting the error below
>
> class { 'mysql::server':
> config_hash => {root_password => 'changeme',}
> }
> mysql::db { 'mydatabase':
> user => 'myapp1',
> password => 'supersecret',
> host => 'webapp1.puppetlabs.com',
> }
>
> Error: Execution of '/usr/bin/mysql -NBe create database `mydatabase`
> character set utf8' returned 1: ERROR 1045 (28000): Access denied for user
> 'root'@'localhost' (using password: NO)
>
> Executing the command from shell (after replacing the quotes ` with ' )
> and including all the command in double quote the db gets created.
> It seems that the puppet process cannot find the password that is present
> in the /root/.my.conf
>
> For sure there is some problem in my installation any help?
> Thanks
> Luca
>
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/puppet-users/-/zZzw5IGBF0IJ.
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.
