Hi Matt,
you might need to override also ::mysql::server::service_name. I don't
know what's the service name of percona but it looks like that is not
'mysqld':
> Error: Could not start Service[mysqld]: Execution of '/sbin/service
mysqld start' returned 1: mysqld: unrecognized service
Best Regards,
Elisiano Petrini
On Tuesday, March 24, 2015 at 8:27:37 AM UTC-4, Matt Shields wrote:
>
> Does anyone have an example of provisioning Percona MySQL using the
> puppetlabs-mysql module?
>
> Here's my puppet code:
>
> 15 package { 'percona-release':
> 16 ensure => present,
> 17 source => '
> http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
> ',
> 18 provider => rpm,
> 19 }
> 20
> 21 $override_options = {
> 22 'mysqld' => {
> 23 'bind-address' => '0.0.0.0',
> 24 'max_connections' => '1024',
> 25 }
> 26 }
> 27
> 28 class { '::mysql::server':
> 29 package_name => 'Percona-Server-server-56',
> 30 root_password => "${percona_root}",
> 31 remove_default_accounts => true,
> 32 override_options => $override_options,
> 33 require => [ Package['percona-release'] ],
> 34 }
>
> And here's the output I'm getting.
>
> [root@testing-bidb001 ~]# puppet agent -t
> Info: Retrieving pluginfacts
> Info: Retrieving plugin
> Info: Loading facts
> Info: Caching catalog for testing-bidb001
> Info: Applying configuration version '1427198241'
> Notice: /Stage[main]/Profile::Bidb/Package[percona-release]/ensure: created
> Notice: /Stage[main]/Mysql::Server::Install/Package[mysql-server]/ensure:
> created
> Notice: /Stage[main]/Mysql::Server::Config/File[/etc/mysql]/ensure: created
> Notice: /Stage[main]/Mysql::Server::Config/File[/etc/my.cnf]/ensure:
> defined content as '{md5}8ef60204b1f3c4d7ffd673f9debc5df1'
> Notice: /Stage[main]/Mysql::Server::Config/File[/etc/mysql/conf.d]/ensure:
> created
> Error: Could not start Service[mysqld]: Execution of '/sbin/service mysqld
> start' returned 1: mysqld: unrecognized service
> Wrapped exception:
> Execution of '/sbin/service mysqld start' returned 1: mysqld: unrecognized
> service
> Error: /Stage[main]/Mysql::Server::Service/Service[mysqld]/ensure: change
> from stopped to running failed: Could not start Service[mysqld]: Execution
> of '/sbin/service mysqld start' returned 1: mysqld: unrecognized service
> Error: Could not prefetch mysql_user provider 'mysql': Execution of
> '/usr/bin/mysql -NBe SELECT CONCAT(User, '@',Host) AS User FROM mysql.user'
> returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through
> socket '/var/lib/mysql/mysql.sock' (2)
> Notice:
> /Stage[main]/Mysql::Server::Root_password/Mysql_user[root@localhost]:
> Dependency Service[mysqld] has failures: true
> Warning:
> /Stage[main]/Mysql::Server::Root_password/Mysql_user[root@localhost]:
> Skipping because of failed dependencies
> Notice: /Stage[main]/Mysql::Server::Root_password/File[/root/.my.cnf]:
> Dependency Service[mysqld] has failures: true
> Warning: /Stage[main]/Mysql::Server::Root_password/File[/root/.my.cnf]:
> Skipping because of failed dependencies
> Notice: /Stage[main]/Mysql::Server/Anchor[mysql::server::end]: Dependency
> Service[mysqld] has failures: true
> Warning: /Stage[main]/Mysql::Server/Anchor[mysql::server::end]: Skipping
> because of failed dependencies
> Notice: /Stage[main]/Mysql::Server::Account_security/Mysql_user[@
> testing-bidb001.useast.fanmanager.com]: Dependency Service[mysqld] has
> failures: true
> Warning: /Stage[main]/Mysql::Server::Account_security/Mysql_user[@
> testing-bidb001.useast.fanmanager.com]: Skipping because of failed
> dependencies
> Error: Could not prefetch mysql_database provider 'mysql': Execution of
> '/usr/bin/mysql -NBe show databases' returned 1: ERROR 2002 (HY000): Can't
> connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
> Notice: /Stage[main]/Mysql::Server::Account_security/Mysql_database[test]:
> Dependency Service[mysqld] has failures: true
> Warning:
> /Stage[main]/Mysql::Server::Account_security/Mysql_database[test]: Skipping
> because of failed dependencies
> Notice:
> /Stage[main]/Mysql::Server::Account_security/Mysql_user[@testing-bidb001]:
> Dependency Service[mysqld] has failures: true
> Warning:
> /Stage[main]/Mysql::Server::Account_security/Mysql_user[@testing-bidb001]:
> Skipping because of failed dependencies
> Notice: /Stage[main]/Mysql::Server::Account_security/Mysql_user[@%]:
> Dependency Service[mysqld] has failures: true
> Warning: /Stage[main]/Mysql::Server::Account_security/Mysql_user[@%]:
> Skipping because of failed dependencies
> Notice: /Stage[main]/Mysql::Server::Account_security/Mysql_user[
> r...@testing-bidb001.useast.fanmanager.com <javascript:>]: Dependency
> Service[mysqld] has failures: true
> Warning: /Stage[main]/Mysql::Server::Account_security/Mysql_user[
> r...@testing-bidb001.useast.fanmanager.com <javascript:>]: Skipping
> because of failed dependencies
> Notice: /Stage[main]/Mysql::Server::Account_security/Mysql_user[root@::1]:
> Dependency Service[mysqld] has failures: true
> Warning:
> /Stage[main]/Mysql::Server::Account_security/Mysql_user[root@::1]: Skipping
> because of failed dependencies
> Notice:
> /Stage[main]/Mysql::Server::Account_security/Mysql_user[@localhost]:
> Dependency Service[mysqld] has failures: true
> Warning:
> /Stage[main]/Mysql::Server::Account_security/Mysql_user[@localhost]:
> Skipping because of failed dependencies
> Notice: /Stage[main]/Mysql::Server::Account_security/Mysql_user[
> root@127.0.0.1 <javascript:>]: Dependency Service[mysqld] has failures:
> true
> Warning: /Stage[main]/Mysql::Server::Account_security/Mysql_user[
> root@127.0.0.1 <javascript:>]: Skipping because of failed dependencies
> Notice:
> /Stage[main]/Mysql::Server::Account_security/Mysql_user[root@testing-bidb001]:
>
> Dependency Service[mysqld] has failures: true
> Warning:
> /Stage[main]/Mysql::Server::Account_security/Mysql_user[root@testing-bidb001]:
>
> Skipping because of failed dependencies
> Notice: Finished catalog run in 20.06 seconds
>
>
> Matt
>
--
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/c2574d88-52fa-4b06-97ce-1dec8b468902%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
