search for: database_gr

...pet through Vagrant to manage my dev VM, and as part of that I have a few database grants that I run after creating users, but when I subsequently run vagrant up or provision these grants fail (because of some changes I make to the mysql config after they have been created.) I''m using database_grant to execute the grants, but there doesn''t seem to be a refreshonly parameter for it? Is there any way to avoid running these grants again? -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and...

...ule version 0.6.1 and I wanted to upgrade. After reading a little I saw that migrating from v 1 to 2 must be studied, so I decided to upgrde to version 1. BUT, I''ve seen a couple of warnings on my first run and I''m updating my code, but I''ve found that my old sysntax for database_grant is not compatible with mysql_grant. So, if I had something like: mysql_database{ [ ''biosql'' , ''biosql-test'' ] : ensure => present, require => Class[''mysql::server''], } database_user { ''biocore@%.XXX...

...39;'ve tried a number of different variations, but my user doesn''t get the repl_slave_priv on my user table... This is the relevant part of my manifest: ----------------- database_user { "repl_slave@%": password_hash => mysql_password('' ... ''), } database_grant { "repl_slave@%/*.*": privileges => [''repl_slave_priv''], } ---------------- The puppet run doesn''t raise an error, it says: notice: /Stage[main]/Db::Repl_user/Database_grant[repl_slave@%/*.*]/privileges: privileges changed '''' to &...

...how to export a resource on the app server that gets collected and realized on the database server, but I cannot figure out how to make the package on the app server depend on the exported resource that gets realized on the database server. I have tried something like this: @@numerex_percona::database_grant { $::mysql_hostname: > user => ''root'', > password => $::mysql_server_root_password, > host => $::fqdn, > before => Package[''ublipgw''], > } But that doesn''t work because Packag...

...tage[main]/Nagiosql/Mysql::Db[db_nagiosql]/Database[db_nagiosql]/ensure: change from absent to present failed: Command mysql is missing Error: /Stage[main]/Nagiosql/Mysql::Db[db_nagiosql]/Database_user[nagiosql_user@localhost]: Provider mysql is not functional on this host Error: Could not prefetch database_grant provider ''mysql'': Command mysql is missing Notice: /Stage[main]/Nagiosql/Mysql::Db[db_nagiosql]/Database_grant[nagiosql_user@localhost/db_nagiosql]: Dependency Database[db_nagiosql] has failures: true Notice: /Stage[main]/Nagiosql/Mysql::Db[db_nagiosql]/Database_grant[nagiosql_...

...elect_priv ''user2@localhost'': privileges: - select_priv - insert_priv - lock_tables_priv I have a wrapper class that then does this: class custom::mysql::grants { $grantoptions = hiera_hash(''mysql::grants'') create_resources(''database_grant'', $grantoptions) } That works fine as long as I include the custom::mysql::grants class. But right now I can only include that class on nodes where I define explicit grants. If I don''t have the mysql::grants hash defined for that node in hiera, puppet complains: Error: Cou...

Hello, What would you think of moving database, database_grant and database_user types and providers from puppetlabs-mysql to its own module (puppetlabs-dbproviders for example) so that we can develop providers for others RDBMS ? I''d like to develop providers for postgresql, so I think it makes sense to put this types/providers in its own modu...

Hello All, I wanted to create two two MySQL database with same user credential using Puppet-MySQL. How can I achieve this? Please find my script below. class mysql::vsdatabase { include mysql mysql::db { ''vidispine'': user => ''user'', password => ''user123'', host => ''db.<hostname>.com'', } } How can I add

Hi everyone, I am new to Puppet and try to make some simple "automation things". I have succeed with apache2, ssh modules, but have problems with Puppetlabs mysql module. It installs mysql server, changes/creates admin user password, but does not create database and user. I cannot find anything wrong in logs (--debug --verbose). I see that manifests is read, but no db/user in mysql.