projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
add omit_cust_main_county flag to payment_info API call, RT#75124
[freeside.git]
/
rt
/
etc
/
acl.mysql
diff --git
a/rt/etc/acl.mysql
b/rt/etc/acl.mysql
index
0982ca2
..
26e27fb
100755
(executable)
--- 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 ) {
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' ) {
return;
}
if ( $db_user eq 'root' ) {
-
print STDERR "DatabaseUser is root. Skipping...\n"
;
+
RT->Logger->warn("DatabaseUser is root. Skipping...")
;
return;
}
return;
}
-
print "Granting access to $db_user\@'$db_rthost' on $db_name.\n"
;
+
$db_name =~ s/([_%\\])/\\$1/g
;
return (
return (
- "USE mysql;",
- "DELETE FROM user WHERE user = '$db_user';",
- "DELETE FROM db where db = '$db_name';",
"GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE
"GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE
- ON
$db_name
.*
+ ON
`$db_name`
.*
TO '$db_user'\@'$db_rthost'
IDENTIFIED BY '$db_pass';",
);
TO '$db_user'\@'$db_rthost'
IDENTIFIED BY '$db_pass';",
);