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

diff --git a/rt/etc/acl.mysql b/rt/etc/acl.mysql
index 0982ca228..0ecaa3b15 100755
--- 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;