#!/usr/bin/perl

$user = $ARGV[0];
if ( $user =~ /^$/ )
{
print "No user detected. exiting\n";
exit;
}
my @response = `mysql -e "select user,Host,max_questions,max_updates,max_connections,max_user_connections from mysql.user where user like '$user\\\_%' or user = '$user' order by user"`;
foreach(@response) {
        my ($user, $host, $maxq, $maxu, $maxc, $maxuc) = split(' ', $_);
        printf("%20s %20s %15s %12s %16s %20s \n" ,$user, $host, $maxq, $maxu, $maxc, $maxuc);
}


if ( $ARGV[1] eq '--block' ) {
    print "Blocking user $user \n";
    if (($user !~ /\_/ ) && ( $user eq "root" )) {
            print "Error, root user detected \n";
            exit;
    }
    if ( $user !~ /\_/ ) {
        $response = `mysql -e "UPDATE mysql.user SET max_questions='1', max_updates='1', max_connections='1', max_user_connections='1' where user LIKE '$user\\\_%'"`;       
    } else {
        $response1 = `mysql -e "UPDATE mysql.user SET max_questions='1', max_updates='1', max_connections='1', max_user_connections='1' where user = '$user'"`;
    }
    $response2 = `mysql -e "flush privileges"`;
    
} else {

$filename = "/var/cpanel/users/" . $user;
$bannedfile = "/opt/hgmods/automated_monitoring/etc/banned_sqlusers";
$userbanned = 0;

if ( ! -e $filename )
{
    print "detected user $user does not have a valid $filename entry\n";
    exit;
}



open(BANNED,$bannedfile);
while(<BANNED>)
{
    if ( /^$user$/ )
    {
    print "User $user is banned in $bannedfile\n";
    $userbanned = 1;
    }
}
close(BANNED);


if ( $ARGV[1] =~ /--unblock/ && $userbanned == 1 )
{
    print "User $user is banned, unblock mode removing ban.\n";
    open(IN,$bannedfile);
    foreach(<IN>)
    {
    if ( /^$user$/ )
    {
        next;
    }
   push(@store2, $_);
   }
close(IN);

open(OUT,">$bannedfile");
foreach $line (@store2)
	{
		print OUT $line;
#		print $line;
    	}
close(OUT);

}

if ( $ARGV[1] =~ /--unblock/ )
{
$response3 = `mysql -e "UPDATE mysql.user SET max_questions='0', max_updates='0', max_connections='0', max_user_connections='0' where user LIKE '$user\\\_%'"`;
$response4 = `mysql -e "UPDATE mysql.user SET max_questions='0', max_updates='0', max_connections='0', max_user_connections='0' where user = '$user'"`;
$response5 = `mysql -e "flush privileges"`;

#print $response3;
#print $response4;
#print $response5;
}

$problem = `grep "DB_USER" /opt/hgmods/automated_monitoring/logs/mysql_autosuspend.log | grep "$user" | tail -n 10`;

print "The last 10 lines matching this DB_USER in the logs are as follows :\n$problem\n";
}