Hmm. Usually I run my clients with --verbose as well for debugging,
but I'm not sure that's relevant. I did a test run just now on a
client that uses the MySQL module and it printed out debug data for
the MySQL provider.
I get the following after the configuration is retrieved from the
Puppetmaster and before the line, "info: Applying configuration
version '${TIMESTAMP}'" :
debug: Creating default schedules
debug: Loaded state in 0.01 seconds
debug: Prefetching mysql resources for mysql_database
debug: Puppet::Type::Mysql_database::ProviderMysql: Executing
'/usr/bin/mysql mysql -NBe 'show databases''
debug: Prefetching mysql resources for mysql_user
debug: Puppet::Type::Mysql_user::ProviderMysql: Executing
'/usr/bin/mysql mysql -NBe 'select concat(user, "@", host), password
from user''
debug: Prefetching parsed resources for ssh_authorized_key
debug: Prefetching yum resources for package
Do you have the mysql client installed on that machine?
On Sat, Jul 17, 2010 at 10:17 AM, bowlby <bramenn...@gmail.com> wrote:
> Hi Steve,
>
> Thanks for your pointers, although still with no results (which
> probably is the fault of my still meager puppet-knowledge)...
>
> Indeed the libs weren't copied to /var/lib/puppet/lib/* but doing so
> did not solve the problem: still no db gets created, still no errors
> in the logfile.
>
> I'm testing puppet and puppetmaster on the same (virtual)machine.
> I issue: 'puppetd --test --server puppettest --trace --debug' to test
> my setup.
>
> Using a different virtual machine as a client (so not running puppet
> and puppetmaster on the same machine) didn't help either.
>
>
> Any more suggestions left?
>
>
> On Jul 17, 4:50 am, "steve ." <leftath...@gmail.com> wrote:
>> It looks like mysql::database is not loading at all -- it's being
>> skipped entirely.
>>
>> The camptocamp MySQL module relies on a facter plugin *and* a puppet
>> plugin for its functionality.
>>
>> In order for this to work, you have to ensure that the plugins
>> propagate from the Puppetmaster to the client. I scratched (banged)
>> my head on this one for a while until I ran the Puppet daemon on my
>> Puppetmaster. It said, "Ooh, plugins!!!" and copied them all from
>> their respective module directories into
>> /var/lib/puppet/lib/puppet/[parser,provider,type] and everything
>> suddenly started working on the next go-round.
>>
>> In retrospect, this makes sense since the Puppetmaster's the one
>> generating these manifests, and if it doesn't know about the plugins
>> it can't parse the manifests fully. But on the other hand, it makes
>> no sense that the Puppetmaster relies on a run of the Puppet daemon in
>> order to get things placed in the right section of the hierarchy.
>>
>> So I suggest that you make sure that you have the mysql_*.rb types,
>> providers and parsers in your client *and* puppetmaster's libdir.
>> Running puppet on my puppetmaster made things a bit wonky for me as
>> I'd been making a lot of config tweaks to get everything up and
>> running without keeping manifests up to date. So yeah, that kind of
>> clobbered some of my puppetmaster configs and I had to rebuild a bit.
>>
>> Hope this helps. FWIW, I am using this module on CentOS and it's
>> working for me, so just hang in there -- you'll get it!
>>
>> On Fri, Jul 16, 2010 at 2:29 PM, bowlby <bramenn...@gmail.com> wrote:
>> > btw, this is my log:
>> > debug: Failed to load library 'selinux' for feature 'selinux'
>> > debug: Puppet::Type::User::ProviderPw: file pw does not exist
>> > debug: Puppet::Type::User::ProviderDirectoryservice: file /usr/bin/
>> > dscl does not exist
>> > debug: Puppet::Type::User::ProviderUser_role_add: file roleadd does
>> > not exist
>> > debug: Puppet::Type::User::ProviderLdap: true value when expecting
>> > false
>> > debug: Failed to load library 'ldap' for feature 'ldap'
>> > debug: /File[/var/lib/puppet/lib]: Autorequiring File[/var/lib/puppet]
>> > debug: /File[/etc/puppet/puppet.conf]: Autorequiring File[/etc/puppet]
>> > debug: /File[/var/lib/puppet/ssl/public_keys]: Autorequiring File[/var/
>> > lib/puppet/ssl]
>> > debug: /File[/var/lib/puppet/ssl/private_keys]: Autorequiring File[/
>> > var/lib/puppet/ssl]
>> > debug: /File[/var/lib/puppet/ssl]: Autorequiring File[/var/lib/puppet]
>> > debug: /File[/var/lib/puppet/client_yaml]: Autorequiring File[/var/lib/
>> > puppet]
>> > debug: /File[/var/lib/puppet/state]: Autorequiring File[/var/lib/
>> > puppet]
>> > debug: /File[/var/lib/puppet/ssl/public_keys/puppettest.pem]:
>> > Autorequiring File[/var/lib/puppet/ssl/public_keys]
>> > debug: /File[/var/lib/puppet/state/graphs]: Autorequiring File[/var/
>> > lib/puppet/state]
>> > debug: /File[/var/lib/puppet/ssl/certificate_requests]: Autorequiring
>> > File[/var/lib/puppet/ssl]
>> > debug: /File[/var/lib/puppet/ssl/certs/ca.pem]: Autorequiring File[/
>> > var/lib/puppet/ssl/certs]
>> > debug: /File[/var/lib/puppet/ssl/private_keys/puppettest.pem]:
>> > Autorequiring File[/var/lib/puppet/ssl/private_keys]
>> > debug: /File[/var/lib/puppet/state/classes.txt]: Autorequiring File[/
>> > var/lib/puppet/state]
>> > debug: /File[/var/lib/puppet/state/state.yaml]: Autorequiring File[/
>> > var/lib/puppet/state]
>> > debug: /File[/var/lib/puppet/facts]: Autorequiring File[/var/lib/
>> > puppet]
>> > debug: /File[/var/lib/puppet/ssl/crl.pem]: Autorequiring File[/var/lib/
>> > puppet/ssl]
>> > debug: /File[/var/lib/puppet/ssl/certs]: Autorequiring File[/var/lib/
>> > puppet/ssl]
>> > debug: /File[/var/lib/puppet/ssl/certs/puppettest.pem]: Autorequiring
>> > File[/var/lib/puppet/ssl/certs]
>> > debug: /File[/var/lib/puppet/ssl/private]: Autorequiring File[/var/lib/
>> > puppet/ssl]
>> > debug: /File[/var/lib/puppet/clientbucket]: Autorequiring File[/var/
>> > lib/puppet]
>> > debug: Finishing transaction -610424768 with 0 changes
>> > debug: Using cached certificate for ca, good until Sun Jul 12 19:07:56
>> > UTC 2015
>> > debug: Using cached certificate for puppettest, good until Sun Jul 12
>> > 19:07:56 UTC 2015
>> > debug: Loaded state in 0.01 seconds
>> > info: Retrieving plugin
>> > debug: Using cached certificate for ca, good until Sun Jul 12 19:07:56
>> > UTC 2015
>> > debug: Using cached certificate for puppettest, good until Sun Jul 12
>> > 19:07:56 UTC 2015
>> > debug: Using cached certificate_revocation_list for ca, good until
>> > debug: file_metadata supports formats: b64_zlib_yaml marshal pson raw
>> > yaml; using pson
>> > debug: Finishing transaction -610639268 with 0 changes
>> > debug: Executing '/etc/puppet/etckeeper-commit-pre'
>> > info: Loading facts in mysql
>> > info: Loading facts in acpi_available
>> > info: Loading facts in munin_interfaces
>> > info: Loading facts in mysql
>> > info: Loading facts in acpi_available
>> > info: Loading facts in munin_interfaces
>> > sh: Syntax error: Bad fd number
>> > debug: catalog supports formats: b64_zlib_yaml marshal pson raw yaml;
>> > using pson
>> > info: Caching catalog for puppettest
>> > debug: Puppet::Type::Package::ProviderFreebsd: file /usr/sbin/
>> > pkg_delete does not exist
>> > debug: Puppet::Type::Package::ProviderUp2date: file /usr/sbin/up2date-
>> > nox does not exist
>> > debug: Puppet::Type::Package::ProviderAptrpm: file rpm does not exist
>> > debug: Puppet::Type::Package::ProviderRpm: file rpm does not exist
>> > debug: Puppet::Type::Package::ProviderUrpmi: file rpm does not exist
>> > debug: Puppet::Type::Package::ProviderYum: file rpm does not exist
>> > debug: Puppet::Type::Package::ProviderPortage: file /usr/bin/emerge
>> > does not exist
>> > debug: Puppet::Type::Package::ProviderSunfreeware: file pkg-get does
>> > not exist
>> > debug: Puppet::Type::Package::ProviderRug: file /usr/bin/rug does not
>> > exist
>> > debug: Puppet::Type::Package::ProviderGem: file gem does not exist
>> > debug: Puppet::Type::Package::ProviderHpux: file /usr/sbin/swlist does
>> > not exist
>> > debug: Puppet::Type::Package::ProviderSun: file /usr/sbin/pkgrm does
>> > not exist
>> > debug: Puppet::Type::Package::ProviderPorts: file /usr/local/sbin/
>> > portversion does not exist
>> > debug: Puppet::Type::Package::ProviderOpenbsd: file pkg_delete does
>> > not exist
>> > debug: Puppet::Type::Package::ProviderFink: file /sw/bin/fink does not
>> > exist
>> > debug: Puppet::Type::Service::ProviderRedhat: file /sbin/chkconfig
>> > does not exist
>> > debug: Puppet::Type::Service::ProviderRunit: file /usr/bin/sv does not
>> > exist
>> > debug: Puppet::Type::Service::ProviderLaunchd: file /bin/launchctl
>> > does not exist
>> > debug: Puppet::Type::Service::ProviderDaemontools: file /usr/bin/svc
>> > does not exist
>> > debug: Puppet::Type::Service::ProviderGentoo: file /sbin/rc-update
>> > does not exist
>> > debug: Creating default schedules
>> > debug: Finishing transaction -610106008 with 0 changes
>> > debug: Loaded state in 0.01 seconds
>> > debug: Prefetching apt resources for package
>> > debug: Executing '/usr/bin/dpkg-query -W --showformat '${Status} $
>> > {Package} ${Version}\n''
>> > debug: Puppet::Type::Package::ProviderApt: Executing '/usr/bin/dpkg-
>> > query -W --showformat '${Status} ${Package} ${Version}\n''
>> > debug: //mysql::server/Service[mysql]/require: requires Package[mysql-
>> > server]
>> > debug: //mysql::server/Augeas[my.cnf/mysqld]/require: requires File[/
>> > etc/mysql/my.cnf]
>> > debug: //mysql::server/Augeas[my.cnf/mysqld]/notify: subscribes to
>> > Service[mysql]
>> > debug: //mysql::server/Augeas[my.cnf/replication]/require: requires
>> > File[/etc/mysql/my.cnf]
>> > debug: //mysql::server/Augeas[my.cnf/replication]/notify: subscribes
>> > to Service[mysql]
>> > debug: //mysql::server/File[/root/.my.cnf]/require: requires
>> > Exec[Initialize MySQL server root password]
>> > debug: //mysql::server/Augeas[my.cnf/client]/require: requires File[/
>> > etc/mysql/my.cnf]
>> > debug: //mysql::server/Exec[Initialize MySQL server root password]/
>> > require: requires Package[mysql-server]
>> > debug: //mysql::server/Exec[Initialize MySQL server root password]/
>> > require: requires Service[mysql]
>> > debug: //mysql::server/Exec[Initialize MySQL server root password]/
>> > notify: subscribes to Exec[Generate my.cnf]
>> > debug: //augeas::debian/Package[augeas-tools]/before: requires File[/
>> > usr/share/augeas/lenses/contrib]
>> > debug: //mysql::server/User[mysql]/require: requires Package[mysql-
>> > server]
>> > debug: //mysql::server/File[/var/lib/mysql]/require: requires
>> > Package[mysql-server]
>> > debug: //mysql::server/File[/etc/mysql/my.cnf]/require: requires
>> > Package[mysql-server]
>> > debug: //mysql::server/Augeas[my.cnf/performance]/require: requires
>> > File[/etc/mysql/my.cnf]
>> > debug: //mysql::server/Augeas[my.cnf/performance]/notify: subscribes
>> > to Service[mysql]
>> > debug: //augeas::debian/Package[augeas-lenses]/before: requires File[/
>> > usr/share/augeas/lenses/contrib]
>> > debug: //augeas::debian/Package[libaugeas0]/before: requires File[/usr/
>> > share/augeas/lenses/contrib]
>> > debug: //mysql::server/Augeas[my.cnf/mysqld_safe]/require: requires
>> > File[/etc/mysql/my.cnf]
>> > debug: //mysql::server/Augeas[my.cnf/mysqld_safe]/notify: subscribes
>> > to Service[mysql]
>> > debug: //mysql::server/Exec[Initialize MySQL server root password]:
>> > Skipping automatic relationship with File[/root/.my.cnf]
>> > debug: //mysql::server/File[/var/lib/mysql]: Autorequiring User[mysql]
>> > debug: //mysql::server/File[/usr/share/augeas/lenses/contrib/
>> > mysql.aug]: Autorequiring File[/usr/share/augeas/lenses/contrib]
>> > info: Applying configuration version '1279301348'
>> > debug: //mysql::server/File[/etc/mysql/my.cnf]/seltype: SELinux
>> > bindings not found. Ignoring parameter.
>> > debug: Augeas[my.cnf/mysqld_safe](provider=augeas): Opening augeas
>> > with root /, lens path /usr/share/augeas/lenses/contrib/, flags 0
>> > debug: Augeas[my.cnf/mysqld_safe](provider=augeas): Augeas version
>> > 0.7.0 is installed
>> > debug: Augeas[my.cnf/mysqld_safe](provider=augeas): Will attempt to
>> > save and only run if files changed
>> > debug: Augeas[my.cnf/mysqld_safe](provider=augeas): sending command
>> > 'set' with params ["/files//etc/mysql/my.cnf/mysqld_safe/pid-file", "/
>> > var/run/mysqld/mysqld.pid"]
>> > debug: Augeas[my.cnf/mysqld_safe](provider=augeas): sending
>>
>> ...
>>
>> read more »
>
> --
> You received this message because you are subscribed to the Google Groups
> "Puppet Users" group.
> To post to this group, send email to puppet-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> puppet-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/puppet-users?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-us...@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.
