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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/81781e1c-3924-475b-9468-8553ff26d430%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
