Re: [Puppet Users] Re: Management of MySQL grant tables?

2011-05-23 Thread Joe McDonagh
On 07/28/2010 02:58 AM, David Schmitt wrote: On 7/28/2010 12:41 AM, Christopher Johnston wrote: David, Curious on how you handle doing a grant of *.* (all attributes) I looked through your puppet type and I see you are individually listing every type out but you are missing event_priv and

[Puppet Users] Re: Management of MySQL grant tables?

2011-05-18 Thread Jakub Veverka
I have been solving same issue and it came out that all I had to do was RTFMhttp://docs.puppetlabs.com/guides/plugins_in_modules.html. I had to enable pluginsync both on client and puppetmaster... [main] pluginsync = true -- You received this message because you are subscribed to the

Re: [Puppet Users] Re: Management of MySQL grant tables?

2010-07-28 Thread David Schmitt
On 7/28/2010 12:41 AM, Christopher Johnston wrote: David, Curious on how you handle doing a grant of *.* (all attributes) I looked through your puppet type and I see you are individually listing every type out but you are missing event_priv and trigger_priv as grant types. I haven't worked on

Re: [Puppet Users] Re: Management of MySQL grant tables?

2010-07-28 Thread Christopher Johnston
I believe so, have to crack your code open to confirm. But in mysql I see the grants listed. It would also be useful to have an all_grants so each one does not have to be listed out. Sent from my iPhone On Jul 28, 2010, at 2:58 AM, David Schmitt da...@dasz.at wrote: On 7/28/2010 12:41 AM,

Re: [Puppet Users] Re: Management of MySQL grant tables?

2010-07-27 Thread Christopher Johnston
David, Curious on how you handle doing a grant of *.* (all attributes) I looked through your puppet type and I see you are individually listing every type out but you are missing event_priv and trigger_priv as grant types. -Chris On Mon, Jun 21, 2010 at 11:51 AM, David Schmitt da...@dasz.at

[Puppet Users] Re: Management of MySQL grant tables?

2010-07-22 Thread bowlby
Now we're getting somewhere! I replaced /bin/sh for /bin/bash (mv /bin/sh /bin/sh_old; ln -s /bin/ bash /bin/sh). Probably an oddity of Lucid in /bin/sh? 'which mysql' gave me /usr/bin/mysql but then I checked for mysql- client, it wasn't installed so I did. Below is my debug info. As shown in

Re: [Puppet Users] Re: Management of MySQL grant tables?

2010-07-20 Thread steve .
Hmmm: info: Loading facts in mysql sh: Syntax error: Bad fd number debug: catalog supports formats: b64_zlib_yaml marshal pson raw yaml; using pson Any insight as to what could be causing that syntax error? Perhaps Puppet's/Facter's attempts at shelling out to run the MySQL command-line

Re: [Puppet Users] Re: Management of MySQL grant tables?

2010-07-19 Thread steve .
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

[Puppet Users] Re: Management of MySQL grant tables?

2010-07-17 Thread bowlby
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

[Puppet Users] Re: Management of MySQL grant tables?

2010-07-16 Thread bowlby
Hi Steve, Thanks for your suggestion but it doesn't change the behaviour I see. MySQL gets installed nicely, but the db's do not appear nor any error- messages in the logfiles. I use: node 'puppettest' { include mysql::server include augeas mysql::database {tsdfsdf: ensure = present,} }

[Puppet Users] Re: Management of MySQL grant tables?

2010-07-16 Thread bowlby
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

Re: [Puppet Users] Re: Management of MySQL grant tables?

2010-07-16 Thread steve .
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

[Puppet Users] Re: Management of MySQL grant tables?

2010-07-14 Thread bowlby
Hi, I tried the mysq-module (from http://github.com/camptocamp/puppet-mysql) and it will install mysql but it won't create db's or users. I had to create /usr/share/augeas/lenses/contrib, because the module seems to expect it. Otherwise I get no error-logs, it just won't create users or

Re: [Puppet Users] Re: Management of MySQL grant tables?

2010-07-14 Thread steve .
If you grab the Augeas module from the same source, that should satisfy the dependency... On Wed, Jul 14, 2010 at 7:11 AM, bowlby bramenn...@gmail.com wrote: Hi, I tried the mysq-module (from http://github.com/camptocamp/puppet-mysql) and it will install mysql but it won't create db's or

Re: [Puppet Users] Re: Management of MySQL grant tables?

2010-06-21 Thread David Schmitt
On 5/19/2010 5:44 PM, Ken wrote: I found a github reference to a package that might do it (http://github.com/camptocamp/puppet-mysql) but I can't understand what it is, how it works, or even what to do with it. Hmm. How familiar are you with puppet modules? Not quite clear how detailed we need

[Puppet Users] Re: Management of MySQL grant tables?

2010-05-20 Thread jb
I've setup something where I put a grants file in the data directory of each database: remotefile {$db_datadir/grants: mode = 500, source = db/$db_name/data/grants, require = File[${db_datadir}], notify = Exec[refresh_${db_name}] } this

[Puppet Users] Re: Management of MySQL grant tables?

2010-05-19 Thread Ken
I found a github reference to a package that might do it (http://github.com/camptocamp/puppet-mysql) but I can't understand what it is, how it works, or even what to do with it. Hmm. How familiar are you with puppet modules? Not quite clear how detailed we need to be here :-). Here is a doc