diff options
| -rw-r--r-- | lib/puppet/provider/mysql_grant/mysql.rb | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/lib/puppet/provider/mysql_grant/mysql.rb b/lib/puppet/provider/mysql_grant/mysql.rb index e1bdc07..5652cf4 100644 --- a/lib/puppet/provider/mysql_grant/mysql.rb +++ b/lib/puppet/provider/mysql_grant/mysql.rb @@ -108,6 +108,7 @@ Puppet::Type.type(:mysql_grant).provide(:mysql) do end if name[:type] == :column fields << :column + end not mysql( "mysql", "-NBe", 'SELECT "1" FROM %s WHERE %s' % [ name[:type], fields.map do |f| "%s = '%s'" % [f, name[f]] end.join(' AND ')]).empty? end @@ -200,8 +201,8 @@ Puppet::Type.type(:mysql_grant).provide(:mysql) do all_privs = MYSQL_TABLE_PRIVS when :column stmt = 'update columns_priv set ' - where = ' where user="%s" and host="%s" and Db="%s" and Table="%s"' % [ name[:user], name[:host], name[:db], name[:table] ] - all_privs = MYSQL_DB_PRIVS + where = ' where user="%s" and host="%s" and Db="%s" and Table_name="%s"' % [ name[:user], name[:host], name[:db], name[:table_name] ] + all_privs = MYSQL_COLUMN_PRIVS end if privs[0] == :all @@ -220,6 +221,7 @@ Puppet::Type.type(:mysql_grant).provide(:mysql) do #puts "set:", set stmt = stmt << set << where + #puts "stmt:", stmt if !set.empty? mysql "mysql", "-Be", stmt |