Hi,
Using this module https://forge.puppetlabs.com/puppetlabs/mysql as
described on documentation:
class { ''mysql::server'':
config_hash => { ''root_password'' =>
''foo'' }
}
But, couldn''t set password after logging getting error: Access denied
for
user ''root''@''localhost'' (using password:
YES)
System:Ubuntu 12.10
--
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.
Hi, just took a peek at the code. Note that you need to specify the old_root_password if one is set, otherwise puppet cannot modify the system. What''s the output of a puppet agent run? Regards, Felix On 04/04/2013 02:33 PM, Bob wrote:> Hi, > > Using this module https://forge.puppetlabs.com/puppetlabs/mysql as > described on documentation: > > |class { ''mysql::server'': > config_hash => { ''root_password'' => ''foo'' } > }| > > > But, couldn''t set password after logging getting error: Access denied > for user ''root''@''localhost'' (using password: YES)-- 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.
Hi Frank,
Here is output:
# puppet agent --test --server=node0
info: Caching catalog for node2
info: Applying configuration version ''1365082883''
notice: /Stage[main]/Mysql::Server/Package[mysql-server]/ensure: ensure
changed ''purged'' to ''present''
notice: /Stage[main]/Mysql/Package[mysql_client]/ensure: ensure changed
''purged'' to ''present''
notice: /Stage[main]/Mysql::Config/File[/etc/mysql/my.cnf]/content:
--- /etc/mysql/my.cnf 2013-01-16 15:47:04.000000000 -0500
+++ /tmp/puppet-file20130404-24456-fxnutx-0 2013-04-04
09:42:06.187898921 -0400
@@ -1,127 +1,41 @@
-#
-# The MySQL database server configuration file.
...
...
info: FileBucket got a duplicate file {md5}77f15d6c87f9c136c4efcda072017f71
info: /Stage[main]/Mysql::Config/File[/etc/mysql/my.cnf]: Filebucketed
/etc/mysql/my.cnf to puppet with sum 77f15d6c87f9c136c4efcda072017f71
notice: /Stage[main]/Mysql::Config/File[/etc/mysql/my.cnf]/content: content
changed ''{md5}77f15d6c87f9c136c4efcda072017f71'' to
''{md5}d9e035104d0794fd82604e6c0ae8d715''
info: /Stage[main]/Mysql::Config/File[/etc/mysql/my.cnf]: Scheduling
refresh of Exec[mysqld-restart]
notice: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/returns:
mysqladmin: connect to server at ''localhost'' failed
notice: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/returns: error:
''Access denied for user
''root''@''localhost'' (using password:
NO)''
err: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/returns: change from
notrun to 0 failed: mysqladmin -u root password ''foo''
returned 1 instead
of one of [0] at /etc/puppet/modules/mysql/manifests/config.pp:107
notice: /Stage[main]/Mysql::Config/File[/root/.my.cnf]: Dependency
Exec[set_mysql_rootpw] has failures: true
warning: /Stage[main]/Mysql::Config/File[/root/.my.cnf]: Skipping because
of failed dependencies
notice: /Stage[main]/Mysql::Config/Exec[mysqld-restart]: Dependency
Exec[set_mysql_rootpw] has failures: true
warning: /Stage[main]/Mysql::Config/Exec[mysqld-restart]: Skipping because
of failed dependencies
notice: /Stage[main]/Mysql::Config/Exec[mysqld-restart]: Triggered
''refresh'' from 1 events
notice: Finished catalog run in 50.84 seconds
четверг, 4 апреля 2013 г., 18:09:57 UTC+5 пользователь Felix.Frank
написал:>
> Hi,
>
> just took a peek at the code. Note that you need to specify the
> old_root_password if one is set, otherwise puppet cannot modify the
> system.
>
> What''s the output of a puppet agent run?
>
> Regards,
> Felix
>
> On 04/04/2013 02:33 PM, Bob wrote:
> > Hi,
> >
> > Using this module https://forge.puppetlabs.com/puppetlabs/mysql as
> > described on documentation:
> >
> > |class { ''mysql::server'':
> > config_hash => { ''root_password'' =>
''foo'' }
> > }|
> >
> >
> > But, couldn''t set password after logging getting error:
Access denied
> > for user ''root''@''localhost'' (using
password: YES)
>
--
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.
On 04/04/2013 03:48 PM, Bob wrote:> notice: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/returns: > mysqladmin: connect to server at ''localhost'' failed > notice: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/returns: > error: ''Access denied for user ''root''@''localhost'' (using password: NO)'' > err: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/returns: change > from notrun to 0 failed: mysqladmin -u root password ''foo'' returned 1 > instead of one of [0] at /etc/puppet/modules/mysql/manifests/config.pp:107Yes, it doesn''t work. Puppet needs your existing root password. -- 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.
MySQL was purged before running puppet script with command: apt-get purge mysql\* So I can''t input root password as it''s fresh install. четверг, 4 апреля 2013 г., 18:52:15 UTC+5 пользователь Felix.Frank написал:> On 04/04/2013 03:48 PM, Bob wrote: > > notice: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/returns: > > mysqladmin: connect to server at ''localhost'' failed > > notice: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/returns: > > error: ''Access denied for user ''root''@''localhost'' (using password: NO)'' > > err: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/returns: change > > from notrun to 0 failed: mysqladmin -u root password ''foo'' returned 1 > > instead of one of [0] at > /etc/puppet/modules/mysql/manifests/config.pp:107 > > Yes, it doesn''t work. > > Puppet needs your existing root password. >-- 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.
I don''t know about Ubuntu, but Debian will store the inital root password you''ve entered once in the config database. It may get re-used when puppet installs the mysql server. Point in fact: MySQL won''t accept a password-less root login. The safe route will be for you to start with skip-grant and unset the root password. Or, you know - rebuild the system from scratch ;-) On 04/04/2013 03:56 PM, Bob wrote:> MySQL was purged before running puppet script with command: apt-get > purge mysql\* > So I can''t input root password as it''s fresh install.-- 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.