/.my.cnf is correct, /root/.my.cnf is never created. I am using puppet 2.7.23 from the debian wheezy repositories, I think the problem is that the 2.X versions of the puppetlabs/mysql module are not fully compatible with this version of puppet. I think perhaps it is missing some facts or other feature - strange that it does not error though!
On Wednesday, 23 April 2014 20:06:31 UTC+1, Cristian Falcas wrote: > > Is this a typo? > rm -f /.my.cnf > > I think it should be /root/.my.cnf > > Best regards > Cristian Falcas > > > On Wed, Apr 23, 2014 at 6:01 PM, Tom Ford <[email protected]<javascript:>> > wrote: > > 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 [email protected] <javascript:>. > > 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. > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/c432971b-5f5e-4fba-ad27-d9d92f358fcb%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
