X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=rt%2Fetc%2Facl.mysql;h=26e27fbfbcf20109752dc53fbf1f7833d13ee404;hb=948b9b8b79874f68bfe24f32035ce0d259da2a31;hp=0982ca22858b927db3b6a3dee914934903ca3b33;hpb=b4b0c7e72d7eaee2fbfc7022022c9698323203dd;p=freeside.git

diff --git a/rt/etc/acl.mysql b/rt/etc/acl.mysql
index 0982ca228..26e27fbfb 100755
--- a/rt/etc/acl.mysql
+++ b/rt/etc/acl.mysql
@@ -5,20 +5,17 @@ sub acl {
     my $db_user = RT->Config->Get('DatabaseUser');
     my $db_pass = RT->Config->Get('DatabasePassword');
     unless ( $db_user ) {
-        print STDERR "DatabaseUser option is not defined or empty. Skipping...\n";
+        RT->Logger->warn("DatabaseUser option is not defined or empty. Skipping...");
         return;
     }
     if ( $db_user eq 'root' ) {
-        print STDERR "DatabaseUser is root. Skipping...\n";
+        RT->Logger->warn("DatabaseUser is root. Skipping...");
         return;
     }
-    print "Granting access to $db_user\@'$db_rthost' on $db_name.\n";
+    $db_name =~ s/([_%\\])/\\$1/g;
     return (
-        "USE mysql;",
-        "DELETE FROM user WHERE user = '$db_user';",
-        "DELETE FROM db where db = '$db_name';",
         "GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE
-               ON $db_name.*
+               ON `$db_name`.*
                TO '$db_user'\@'$db_rthost'
                IDENTIFIED BY '$db_pass';",
     );