Displaying 9 results from an estimated 9 matches for "database_grant".
2013 Mar 12
2
Only running database_grant the first time.
...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 sto...
2013 Dec 09
0
mysql module v 1.0 mysql_grant - database_grant
...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@%.XXXXX&...
2012 Jul 19
3
Problems granting privileges with puppetlabs/mysql
...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 '...
2012 Jun 15
1
cross server dependancies
...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 Package[&...
2013 Jul 22
0
wyrie/puppet-nagiosql -- anyone have experience with this module?
...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_use...
2013 Aug 23
1
Test the result of a hiera_hash() lookup
...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: Could...
2013 Jun 04
1
puppet DB providers
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 module....
2013 Mar 21
6
How we can create two database Using same credetial using Puppet
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
2012 Mar 12
5
Database and user not created (Puppetlabs mysql module)
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.