| Server IP : 49.231.201.246 / Your IP : 216.73.216.248 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/webmin/mysql/ |
Upload File : |
#!/usr/bin/perl
# Show currently connected MySQL users
require './mysql-lib.pl';
$access{'perms'} == 1 || &error($text{'procs_ecannot'});
&ui_print_header(undef, $text{'procs_title'}, "", "procs");
# Get the processes, except this one
$d = &execute_sql($master_db, "show full processlist");
@procs = grep { $_->[7] ne "show full processlist" ||
$_->[3] ne $master_db ||
$_->[1] ne $mysql_login } @{$d->{'data'}};
if (@procs) {
print &ui_form_start("kill_procs.cgi", "post");
@tds = ( "width=5" );
@rowlinks = ( &select_all_link("d"),
&select_invert_link("d") );
print &ui_links_row(\@rowlinks);
print &ui_columns_start([ "",
$text{'procs_id'},
$text{'procs_user'},
$text{'procs_host'},
$text{'procs_db'},
$text{'procs_cmd'},
$text{'procs_time'},
$text{'procs_query'} ], 100, 0, \@tds);
foreach $r (@procs) {
print &ui_checked_columns_row([
$r->[0],
&ui_link("edit_user.cgi?user=$r->[1]",$r->[1]),
$r->[2],
&ui_link("edit_dbase.cgi?db=$r->[3]",$r->[3]),
$r->[4],
&nice_time($r->[5]),
&html_escape($r->[7])
], \@tds, "d", $r->[0]);
}
print &ui_columns_end();
print &ui_links_row(\@rowlinks);
print &ui_form_end([ [ "kill", $text{'procs_kill'} ] ]);
}
else {
print "<b>$text{'procs_none'}</b><p>\n";
}
&ui_print_footer("", $text{'index_return'});
sub nice_time
{
local ($s) = @_;
return sprintf "%2.2d:%2.2d:%2.2d",
int($s / 3600), int($s / 60)%60, $s % 60;
}