RT mobile UI, #11630

[freeside.git] / rt / etc / acl.mysql

diff --git a/rt/etc/acl.mysql b/rt/etc/acl.mysql
index 0982ca2..0ecaa3b 100755 (executable)
--- a/rt/etc/acl.mysql
+++ b/rt/etc/acl.mysql
@@ -1,27 +1,8 @@
-
 sub acl {
-    my $db_name = RT->Config->Get('DatabaseName');
-    my $db_rthost = RT->Config->Get('DatabaseRTHost');
-    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";
-        return;
-    }
-    if ( $db_user eq 'root' ) {
-        print STDERR "DatabaseUser is root. Skipping...\n";
-        return;
-    }
-    print "Granting access to $db_user\@'$db_rthost' on $db_name.\n";
-    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.*
-               TO '$db_user'\@'$db_rthost'
-               IDENTIFIED BY '$db_pass';",
-    );
+return  (
+"USE mysql;",
+"DELETE FROM user WHERE user = '${RT::DatabaseUser}';",
+"DELETE FROM db where db = '${RT::DatabaseName}';",
+"GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON ${RT::DatabaseName}.* TO ${RT::DatabaseUser}\@${RT::DatabaseRTHost} IDENTIFIED BY '${RT::DatabasePassword}';");
 }
-
 1;