We are having exactly the same problem on Debian Wheezy - did you ever find a solution Justin?
We have set root_password to the new password we want to use and old_root_password => ''. The /.my.cnf is created with the root password but root's password is still blank (if you check the the mysql.user table, password column to confirm). In addition setting remove_default_accounts => true is not deleting the default mysql accounts or the test database. Any ideas? On Thursday, 6 February 2014 02:55:19 UTC, Justin Sevier wrote: > > Hi All, > > I did search and found this article before I posted: > https://groups.google.com/forum/#!searchin/puppet-users/mysql$20root/puppet-users/nEZ9bDcaBJE/4O0hN459g9oJ > > Unfortunately there really wasn't a resolution as far as I can see. > > > *The situation:*I am trying to setup a test environment to evaluate if > Puppet will work to automate my deployments. I deployed a couple vm's from > my templates which have RHEL 6 and MySQL is already pre-installed. I am > trying to get MySQL installed with a root password but it appears to not be > working. I have run the following to try and remove all traces of MySQL: > > yum remove mysql > rm -f /etc/my.cnf > rm -rf /var/lib/mysql > rm -rf /etc/mysql > rm -rf /etc/mysql/conf.d > rm -f /var/log/mysqld.log.rpmsave > rm -rf /var/backup/mysql > rm -f /etc/cron.daily/mysqlbackup > rm -f /root/.mysql_history > rm -f /.my.cnf > > When I attempt to install with Puppet MySQL installs but I can login with > no password. The /.my.cnf file is created with the correct password but > even if I try to login with it using mysql -uroot -p and specify the > password it fails. It really seems as though the password is NOT being > set? > > I am using the following in my site.pp for testing: > > class { '::mysql::server': > root_password => 'passwordtest', > override_options => { 'mysqld' => { 'max_connections' => '1024' } } > } > > Below you'll find the complete output of the debug run. I'm hoping > someone can point me in the right direction as I haven't been able to > figure this out now for a few days. > > > debug: /Stage[main]/Mysql::Server::Config/before: requires > Class[Mysql::Server::Service] > debug: /File[/etc/mysql/conf.d]/notify: subscribes to > Class[Mysql::Server::Service] > debug: /Stage[deploy_app]/before: requires Stage[deploy] > debug: /Stage[main]/Mysql::Server::Install/before: requires > Class[Mysql::Server::Config] > debug: /Stage[main]//require: requires Class[Stdlib] > debug: /File[/.my.cnf]/require: requires Mysql_user[root@localhost] > debug: /Stage[setup_app]/before: requires Stage[deploy_app] > debug: /Stage[main]/Mysql::Server::Providers/before: requires > Anchor[mysql::server::end] > debug: /Stage[setup]/before: requires Stage[main] > debug: /File[/etc/my.cnf]/notify: subscribes to > Class[Mysql::Server::Service] > debug: /Stage[main]/Mysql::Server/Anchor[mysql::server::start]/before: > requires Class[Mysql::Server::Install] > debug: /Stage[main]/Mysql::Server::Service/before: requires > Class[Mysql::Server::Root_password] > debug: /File[/etc/httpd/conf.d/ewh.conf]/notify: subscribes to > Service[httpd] > debug: /File[/etc/mysql]/notify: subscribes to > Class[Mysql::Server::Service] > debug: /Stage[main]/Mysql::Server::Root_password/before: requires > Class[Mysql::Server::Providers] > debug: /Stage[setup_infra]/before: requires Stage[deploy_infra] > debug: /Stage[runtime]/require: requires Stage[main] > debug: /Stage[runtime]/before: requires Stage[setup_infra] > debug: /Stage[deploy_infra]/before: requires Stage[setup_app] > debug: /File[/etc/mysql/conf.d]: Autorequiring File[/etc/mysql] > debug: /Schedule[daily]: Skipping device resources because running on a > host > debug: /Schedule[monthly]: Skipping device resources because running on a > host > debug: /Schedule[hourly]: Skipping device resources because running on a > host > debug: /Schedule[never]: Skipping device resources because running on a > host > debug: Prefetching yum resources for package > debug: Puppet::Type::Package::ProviderYum: Executing '/bin/rpm --version' > debug: Puppet::Type::Package::ProviderYum: Executing '/bin/rpm -qa > --nosignature --nodigest --qf '%{NAME} %|EPOCH?{%{EPOCH}}:{0}| %{VERSION} > %{RELEASE} %{ARCH} > '' > debug: Puppet::Type::Package::ProviderYum: Executing '/bin/rpm -q > mysql-server --nosignature --nodigest --qf %{NAME} %|EPOCH?{%{EPOCH}}:{0}| > %{VERSION} %{RELEASE} %{ARCH} > ' > debug: Package[mysql-server](provider=yum): Ensuring => present > debug: Puppet::Type::Package::ProviderYum: Executing '/usr/bin/yum -d 0 -e > 0 -y install mysql-server' > debug: Puppet::Type::Package::ProviderYum: Executing '/bin/rpm -q > mysql-server --nosignature --nodigest --qf %{NAME} %|EPOCH?{%{EPOCH}}:{0}| > %{VERSION} %{RELEASE} %{ARCH} > ' > notice: /Stage[main]/Mysql::Server::Install/Package[mysql-server]/ensure: > created > debug: /Stage[main]/Mysql::Server::Install/Package[mysql-server]: The > container Class[Mysql::Server::Install] will propagate my refresh event > debug: Class[Mysql::Server::Install]: The container Stage[main] will > propagate my refresh event > notice: /File[/etc/mysql]/ensure: created > info: /File[/etc/mysql]: Scheduling refresh of > Class[Mysql::Server::Service] > debug: /File[/etc/mysql]: The container Class[Mysql::Server::Config] will > propagate my refresh event > notice: /File[/etc/my.cnf]/ensure: defined content as > '{md5}4354e13053a5679419f67a6e80b21104' > info: /File[/etc/my.cnf]: Scheduling refresh of > Class[Mysql::Server::Service] > debug: /File[/etc/my.cnf]: The container Class[Mysql::Server::Config] will > propagate my refresh event > debug: /File[/var/www/html/divider.gif]/seluser: Found seluser default > 'system_u' for /var/www/html/divider.gif > debug: /File[/var/www/html/divider.gif]/selrole: Found selrole default > 'object_r' for /var/www/html/divider.gif > debug: /File[/var/www/html/divider.gif]/seltype: Found seltype default > 'httpd_sys_content_t' for /var/www/html/divider.gif > debug: /File[/var/www/html/divider.gif]/selrange: Found selrange default > 's0' for /var/www/html/divider.gif > debug: /File[/var/www/html/logo.gif]/seluser: Found seluser default > 'system_u' for /var/www/html/logo.gif > debug: /File[/var/www/html/logo.gif]/selrole: Found selrole default > 'object_r' for /var/www/html/logo.gif > debug: /File[/var/www/html/logo.gif]/seltype: Found seltype default > 'httpd_sys_content_t' for /var/www/html/logo.gif > debug: /File[/var/www/html/logo.gif]/selrange: Found selrange default 's0' > for /var/www/html/logo.gif > debug: /File[/var/www/html/test.txt]/seluser: Found seluser default > 'system_u' for /var/www/html/test.txt > debug: /File[/var/www/html/test.txt]/selrole: Found selrole default > 'object_r' for /var/www/html/test.txt > debug: /File[/var/www/html/test.txt]/seltype: Found seltype default > 'httpd_sys_content_t' for /var/www/html/test.txt > debug: /File[/var/www/html/test.txt]/selrange: Found selrange default 's0' > for /var/www/html/test.txt > debug: /File[/var/www/html/defaultsite.css]/seluser: Found seluser default > 'system_u' for /var/www/html/defaultsite.css > debug: /File[/var/www/html/defaultsite.css]/selrole: Found selrole default > 'object_r' for /var/www/html/defaultsite.css > debug: /File[/var/www/html/defaultsite.css]/seltype: Found seltype default > 'httpd_sys_content_t' for /var/www/html/defaultsite.css > debug: /File[/var/www/html/defaultsite.css]/selrange: Found selrange > default 's0' for /var/www/html/defaultsite.css > debug: /File[/var/www/html/index.php]/seluser: Found seluser default > 'system_u' for /var/www/html/index.php > debug: /File[/var/www/html/index.php]/selrole: Found selrole default > 'object_r' for /var/www/html/index.php > debug: /File[/var/www/html/index.php]/seltype: Found seltype default > 'httpd_sys_content_t' for /var/www/html/index.php > debug: /File[/var/www/html/index.php]/selrange: Found selrange default > 's0' for /var/www/html/index.php > debug: /File[/var/www/html/ewh.conf]/seluser: Found seluser default > 'system_u' for /var/www/html/ewh.conf > debug: /File[/var/www/html/ewh.conf]/selrole: Found selrole default > 'object_r' for /var/www/html/ewh.conf > debug: /File[/var/www/html/ewh.conf]/seltype: Found seltype default > 'httpd_sys_content_t' for /var/www/html/ewh.conf > debug: /File[/var/www/html/ewh.conf]/selrange: Found selrange default 's0' > for /var/www/html/ewh.conf > debug: /File[/var/www/html/background.jpg]/seluser: Found seluser default > 'system_u' for /var/www/html/background.jpg > debug: /File[/var/www/html/background.jpg]/selrole: Found selrole default > 'object_r' for /var/www/html/background.jpg > debug: /File[/var/www/html/background.jpg]/seltype: Found seltype default > 'httpd_sys_content_t' for /var/www/html/background.jpg > debug: /File[/var/www/html/background.jpg]/selrange: Found selrange > default 's0' for /var/www/html/background.jpg > debug: file_metadata supports formats: b64_zlib_yaml pson raw yaml; using > pson > debug: Service[httpd](provider=redhat): Executing '/sbin/service httpd > status' > debug: /Schedule[weekly]: Skipping device resources because running on a > host > notice: /File[/etc/mysql/conf.d]/ensure: created > info: /File[/etc/mysql/conf.d]: Scheduling refresh of > Class[Mysql::Server::Service] > debug: /File[/etc/mysql/conf.d]: The container > Class[Mysql::Server::Config] will propagate my refresh event > debug: Class[Mysql::Server::Config]: The container Stage[main] will > propagate my refresh event > info: Class[Mysql::Server::Service]: Scheduling refresh of Service[mysqld] > debug: Service[mysqld](provider=redhat): Executing '/sbin/service mysqld > status' > debug: Puppet::Type::Service::ProviderRedhat: Executing '/sbin/chkconfig > mysqld' > debug: Service[mysqld](provider=redhat): Executing '/sbin/service mysqld > start' > debug: Puppet::Type::Service::ProviderRedhat: Executing '/sbin/chkconfig > mysqld' > debug: Puppet::Type::Service::ProviderRedhat: Executing '/sbin/chkconfig > mysqld on' > notice: /Stage[main]/Mysql::Server::Service/Service[mysqld]/ensure: ensure > changed 'stopped' to 'running' > debug: /Stage[main]/Mysql::Server::Service/Service[mysqld]: The container > Class[Mysql::Server::Service] will propagate my refresh event > debug: Service[mysqld](provider=redhat): Executing '/sbin/service mysqld > status' > debug: Service[mysqld](provider=redhat): Executing '/sbin/service mysqld > stop' > debug: Service[mysqld](provider=redhat): Executing '/sbin/service mysqld > start' > notice: /Stage[main]/Mysql::Server::Service/Service[mysqld]: Triggered > 'refresh' from 1 events > debug: /Stage[main]/Mysql::Server::Service/Service[mysqld]: The container > Class[Mysql::Server::Service] will propagate my refresh event > debug: Class[Mysql::Server::Service]: The container Stage[main] will > propagate my refresh event > notice: /File[/.my.cnf]/ensure: defined content as > '{md5}e25a44a94fe8c920bfd6d4d566914024' > debug: /File[/.my.cnf]: The container Class[Mysql::Server::Root_password] > will propagate my refresh event > debug: Class[Mysql::Server::Root_password]: The container Stage[main] will > propagate my refresh event > debug: /Schedule[puppet]: Skipping device resources because running on a > host > debug: Finishing transaction 70259919910440 > debug: Storing state > debug: Stored state in 0.02 seconds > notice: Finished catalog run in 30.20 seconds > debug: report supports formats: b64_zlib_yaml pson raw yaml; using pson > > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/dd79877f-eefa-4d4b-9e74-ad6125a707c8%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
