===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
mysqltuner-1.7.13/build/build_rpm.sh-2-
mysqltuner-1.7.13/build/build_rpm.sh:3:BUILD_DIR=`dirname $(readlink -f $0)`
mysqltuner-1.7.13/build/build_rpm.sh-4-
##############################################
mysqltuner-1.7.13/build/deployOn-3-
mysqltuner-1.7.13/build/deployOn:4:_DIR=$(dirname `readlink -f $0`)
mysqltuner-1.7.13/build/deployOn-5-
##############################################
mysqltuner-1.7.13/build/updateCVElist.pl-14- print "\nExecution : \t", $cmd, " ", join " ", @_ if defined $verbose;
mysqltuner-1.7.13/build/updateCVElist.pl:15: my $outp=`$cmd @_ 2>&1`;
mysqltuner-1.7.13/build/updateCVElist.pl-16- my $rc=$?;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-277- my $cntCPU =
mysqltuner-1.7.13/mysqltuner.pl:278:`awk -F: '/^core id/ && !P[\$2] { CORES++; P[\$2]=1 }; /^physical id/ && !N[\$2] { CPUs++; N[\$2]=1 }; END { print CPUs*CORES }' /proc/cpuinfo`;
mysqltuner-1.7.13/mysqltuner.pl-279- return ( $cntCPU == 0 ? `nproc` : $cntCPU );
##############################################
mysqltuner-1.7.13/mysqltuner.pl-417- $physical_memory =
mysqltuner-1.7.13/mysqltuner.pl:418: `grep -i memtotal: /proc/meminfo | awk '{print \$2}'`
mysqltuner-1.7.13/mysqltuner.pl-419- or memerror;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-422- $swap_memory =
mysqltuner-1.7.13/mysqltuner.pl:423: `grep -i swaptotal: /proc/meminfo | awk '{print \$2}'`
mysqltuner-1.7.13/mysqltuner.pl-424- or memerror;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-429- $swap_memory =
mysqltuner-1.7.13/mysqltuner.pl:430: `sysctl -n vm.swapusage | awk '{print \$3}' | sed 's/\..*\$//'`
mysqltuner-1.7.13/mysqltuner.pl-431- or memerror;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-438- $swap_memory =
mysqltuner-1.7.13/mysqltuner.pl:439: `swapctl -l | grep '^/' | awk '{ s+= \$2 } END { print s }'`
mysqltuner-1.7.13/mysqltuner.pl-440- or memerror;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-444- $swap_memory =
mysqltuner-1.7.13/mysqltuner.pl:445: `swapinfo | grep '^/' | awk '{ s+= \$2 } END { print s }'`;
mysqltuner-1.7.13/mysqltuner.pl-446- }
##############################################
mysqltuner-1.7.13/mysqltuner.pl-455- $physical_memory =
mysqltuner-1.7.13/mysqltuner.pl:456: `lsattr -El sys0 | grep realmem | awk '{print \$2}'`
mysqltuner-1.7.13/mysqltuner.pl-457- or memerror;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-459- $physical_memory = $physical_memory * 1024;
mysqltuner-1.7.13/mysqltuner.pl:460: $swap_memory = `lsps -as | awk -F"(MB| +)" '/MB /{print \$2}'`
mysqltuner-1.7.13/mysqltuner.pl-461- or memerror;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-521- $update =
mysqltuner-1.7.13/mysqltuner.pl:522:`$httpcli -m 3 -silent '$url' 2>/dev/null | grep 'my \$tunerversion'| cut -d\\\" -f2`;
mysqltuner-1.7.13/mysqltuner.pl-523- chomp($update);
##############################################
mysqltuner-1.7.13/mysqltuner.pl-535- $update =
mysqltuner-1.7.13/mysqltuner.pl:536:`$httpcli -e timestamping=off -t 1 -T 3 -O - '$url' 2>$devnull| grep 'my \$tunerversion'| cut -d\\\" -f2`;
mysqltuner-1.7.13/mysqltuner.pl-537- chomp($update);
##############################################
mysqltuner-1.7.13/mysqltuner.pl-571- $update =
mysqltuner-1.7.13/mysqltuner.pl:572: `$httpcli --connect-timeout 3 '$url$script' 2>$devnull > $script`;
mysqltuner-1.7.13/mysqltuner.pl-573- chomp($update);
##############################################
mysqltuner-1.7.13/mysqltuner.pl-590- $update =
mysqltuner-1.7.13/mysqltuner.pl:591:`$httpcli -qe timestamping=off -t 1 -T 3 -O $script '$url$script'`;
mysqltuner-1.7.13/mysqltuner.pl-592- chomp($update);
##############################################
mysqltuner-1.7.13/mysqltuner.pl-681- $mysqlcmd =~ s/\n$//g;
mysqltuner-1.7.13/mysqltuner.pl:682: my $mysqlclidefaults = `$mysqlcmd --print-defaults`;
mysqltuner-1.7.13/mysqltuner.pl-683- debugprint "MySQL Client: $mysqlclidefaults";
##############################################
mysqltuner-1.7.13/mysqltuner.pl-737- $mysqllogin = "-u $opt{user} " . $remotestring;
mysqltuner-1.7.13/mysqltuner.pl:738: my $loginstatus = `$mysqladmincmd ping $mysqllogin 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-739- if ( $loginstatus =~ /mysqld is alive/ ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-752- $mysqllogin = "-u $opt{user} -p'$opt{pass}'" . $remotestring;
mysqltuner-1.7.13/mysqltuner.pl:753: my $loginstatus = `$mysqladmincmd ping $mysqllogin 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-754- if ( $loginstatus =~ /mysqld is alive/ ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-777- $mysqllogin = "-u $mysql_login -p$mysql_pass";
mysqltuner-1.7.13/mysqltuner.pl:778: my $loginstatus = `mysqladmin $mysqllogin ping 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-779- if ( $loginstatus =~ /mysqld is alive/ ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-793- $mysqllogin = "-u admin -p`cat /etc/psa/.psa.shadow`";
mysqltuner-1.7.13/mysqltuner.pl:794: my $loginstatus = `$mysqladmincmd ping $mysqllogin 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-795- unless ( $loginstatus =~ /mysqld is alive/ ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-799- "-u admin -p`/usr/local/psa/bin/admin --show-password`";
mysqltuner-1.7.13/mysqltuner.pl:800: $loginstatus = `$mysqladmincmd ping $mysqllogin 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-801- unless ( $loginstatus =~ /mysqld is alive/ ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-822-
mysqltuner-1.7.13/mysqltuner.pl:823: my $loginstatus = `mysqladmin ping $mysqllogin 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-824- unless ( $loginstatus =~ /mysqld is alive/ ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-836- $mysqllogin = "--defaults-file=/etc/mysql/debian.cnf";
mysqltuner-1.7.13/mysqltuner.pl:837: my $loginstatus = `$mysqladmincmd $mysqllogin ping 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-838- if ( $loginstatus =~ /mysqld is alive/ ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-851- debugprint "defaults file detected: $opt{'defaults-file'}";
mysqltuner-1.7.13/mysqltuner.pl:852: my $mysqlclidefaults = `$mysqlcmd --print-defaults`;
mysqltuner-1.7.13/mysqltuner.pl-853- debugprint "MySQL Client Default File: $opt{'defaults-file'}";
##############################################
mysqltuner-1.7.13/mysqltuner.pl-855- $mysqllogin = "--defaults-file=" . $opt{'defaults-file'};
mysqltuner-1.7.13/mysqltuner.pl:856: my $loginstatus = `$mysqladmincmd $mysqllogin ping 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-857- if ( $loginstatus =~ /mysqld is alive/ ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-865- debugprint "$mysqladmincmd $remotestring ping 2>&1";
mysqltuner-1.7.13/mysqltuner.pl:866: my $loginstatus = `$mysqladmincmd $remotestring ping 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-867- if ( $loginstatus =~ /mysqld is alive/ ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-907- "Please enter your MySQL administrative password: ";
mysqltuner-1.7.13/mysqltuner.pl:908: system("stty -echo >$devnull 2>&1");
mysqltuner-1.7.13/mysqltuner.pl-909- $password = <STDIN>;
mysqltuner-1.7.13/mysqltuner.pl:910: system("stty echo >$devnull 2>&1");
mysqltuner-1.7.13/mysqltuner.pl-911- }
##############################################
mysqltuner-1.7.13/mysqltuner.pl-919- $mysqllogin .= $remotestring;
mysqltuner-1.7.13/mysqltuner.pl:920: my $loginstatus = `$mysqladmincmd ping $mysqllogin 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-921- if ( $loginstatus =~ /mysqld is alive/ ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-949- debugprint "PERFORM: $req ";
mysqltuner-1.7.13/mysqltuner.pl:950: my @result = `$mysqlcmd $mysqllogin -Bse "\\w$req" 2>>/dev/null`;
mysqltuner-1.7.13/mysqltuner.pl-951- if ( $? != 0 ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-955- debugprint "OPTIONS: $mysqllogin";
mysqltuner-1.7.13/mysqltuner.pl:956: debugprint `$mysqlcmd $mysqllogin -Bse "$req" 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-957-
##############################################
mysqltuner-1.7.13/mysqltuner.pl-975- debugprint "PERFORM: $req ";
mysqltuner-1.7.13/mysqltuner.pl:976: my $result = `$mysqlcmd $mysqllogin -Bse "\\w$req" 2>>/dev/null`;
mysqltuner-1.7.13/mysqltuner.pl-977- if ( $? != 0 ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-981- debugprint "OPTIONS: $mysqllogin";
mysqltuner-1.7.13/mysqltuner.pl:982: debugprint `$mysqlcmd $mysqllogin -Bse "$req" 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-983-
##############################################
mysqltuner-1.7.13/mysqltuner.pl-996- debugprint "PERFORM: $req ";
mysqltuner-1.7.13/mysqltuner.pl:997: my @result = `$mysqlcmd $mysqllogin -re "\\w$req\\G" 2>>/dev/null`;
mysqltuner-1.7.13/mysqltuner.pl-998- if ( $? != 0 ) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-1002- debugprint "OPTIONS: $mysqllogin";
mysqltuner-1.7.13/mysqltuner.pl:1003: debugprint `$mysqlcmd $mysqllogin -Bse "$req" 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-1004-
##############################################
mysqltuner-1.7.13/mysqltuner.pl-1369- my $pid = shift;
mysqltuner-1.7.13/mysqltuner.pl:1370: my @mem = `ps -p $pid -o rss`;
mysqltuner-1.7.13/mysqltuner.pl-1371- return 0 if scalar @mem != 2;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-1491- debugprint "CMD: $cmd";
mysqltuner-1.7.13/mysqltuner.pl:1492: my @result = `$cmd`;
mysqltuner-1.7.13/mysqltuner.pl-1493- @result = remove_cr @result;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-1501- debugprint "CMD: $cmd";
mysqltuner-1.7.13/mysqltuner.pl:1502: my @result = `$cmd`;
mysqltuner-1.7.13/mysqltuner.pl-1503- @result = remove_cr @result;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-1510- my $cmd = "@_";
mysqltuner-1.7.13/mysqltuner.pl:1511: my @result = `$cmd 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-1512- @result = remove_cr @result;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-1525- infocmd_tab("sysctl $param 2>/dev/null");
mysqltuner-1.7.13/mysqltuner.pl:1526: $result{'OS'}{'Config'}{$param} = `sysctl -n $param 2>/dev/null`;
mysqltuner-1.7.13/mysqltuner.pl-1527- }
##############################################
mysqltuner-1.7.13/mysqltuner.pl-1757- @mysqlstatlist = select_array
mysqltuner-1.7.13/mysqltuner.pl:1758:"SELECT CONCAT(user, '\@', host) FROM mysql.user WHERE ($PASS_COLUMN_NAME = '' OR $PASS_COLUMN_NAME IS NULL) AND plugin NOT IN ('unix_socket', 'win_socket', 'auth_pam_compat')";
mysqltuner-1.7.13/mysqltuner.pl-1759- }
##############################################
mysqltuner-1.7.13/mysqltuner.pl-1761- @mysqlstatlist = select_array
mysqltuner-1.7.13/mysqltuner.pl:1762:"SELECT CONCAT(user, '\@', host) FROM mysql.user WHERE ($PASS_COLUMN_NAME = '' OR $PASS_COLUMN_NAME IS NULL)";
mysqltuner-1.7.13/mysqltuner.pl-1763- }
##############################################
mysqltuner-1.7.13/mysqltuner.pl-1789- @mysqlstatlist = select_array
mysqltuner-1.7.13/mysqltuner.pl:1790:"SELECT CONCAT(user, '\@', host) FROM mysql.user WHERE CAST($PASS_COLUMN_NAME as Binary) = PASSWORD(user) OR CAST($PASS_COLUMN_NAME as Binary) = PASSWORD(UPPER(user)) OR CAST($PASS_COLUMN_NAME as Binary) = PASSWORD(CONCAT(UPPER(LEFT(User, 1)), SUBSTRING(User, 2, LENGTH(User))))";
mysqltuner-1.7.13/mysqltuner.pl-1791- if (@mysqlstatlist) {
##############################################
mysqltuner-1.7.13/mysqltuner.pl-2155- [ select_array
mysqltuner-1.7.13/mysqltuner.pl:2156:"SELECT CONCAT(CONCAT(TABLE_SCHEMA, '.'), TABLE_NAME),DATA_FREE FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','performance_schema', 'mysql') AND DATA_LENGTH/1024/1024>100 AND DATA_FREE*100/(DATA_LENGTH+INDEX_LENGTH+DATA_FREE) > 10 AND NOT ENGINE='MEMORY' $not_innodb"
mysqltuner-1.7.13/mysqltuner.pl-2157- ];
##############################################
mysqltuner-1.7.13/mysqltuner.pl-2183- map { [ (split)[@ixs] ] }
mysqltuner-1.7.13/mysqltuner.pl:2184: select_array "SHOW TABLE STATUS FROM \\\`$db\\\`" );
mysqltuner-1.7.13/mysqltuner.pl-2185- }
##############################################
mysqltuner-1.7.13/mysqltuner.pl-2254- push( @generalrec,
mysqltuner-1.7.13/mysqltuner.pl:2255:" OPTIMIZE TABLE `$table_schema`.`$table_name`; -- can free $data_free MB"
mysqltuner-1.7.13/mysqltuner.pl-2256- );
##############################################
mysqltuner-1.7.13/mysqltuner.pl-2289- map { [ (split)[@ia] ] }
mysqltuner-1.7.13/mysqltuner.pl:2290: select_array "SHOW TABLE STATUS FROM \\\`$db\\\`"
mysqltuner-1.7.13/mysqltuner.pl-2291- );
##############################################
mysqltuner-1.7.13/mysqltuner.pl-2484- for
mysqltuner-1.7.13/mysqltuner.pl:2485:`find $myvar{'datadir'} -name "*.MYI" 2>&1 | xargs du -L $duflags 2>&1`;
mysqltuner-1.7.13/mysqltuner.pl-2486- $mycalc{'total_myisam_indexes'} = $size;
##############################################
mysqltuner-1.7.13/mysqltuner.pl-5808- select_one(
mysqltuner-1.7.13/mysqltuner.pl:5809:"SELECT TABLE_SCHEMA, SUM(TABLE_ROWS), SUM(DATA_LENGTH), SUM(INDEX_LENGTH) , SUM(DATA_LENGTH+INDEX_LENGTH), COUNT(DISTINCT ENGINE),COUNT(TABLE_NAME),COUNT(DISTINCT(TABLE_COLLATION)),COUNT(DISTINCT(ENGINE)) FROM information_schema.TABLES WHERE TABLE_SCHEMA='$_' GROUP BY TABLE_SCHEMA ORDER BY TABLE_SCHEMA"
mysqltuner-1.7.13/mysqltuner.pl-5810- );
##############################################
mysqltuner-1.7.13/mysqltuner.pl-5820- select_array(
mysqltuner-1.7.13/mysqltuner.pl:5821:"SELECT DISTINCT(TABLE_COLLATION) FROM information_schema.TABLES WHERE TABLE_SCHEMA='$_';"
mysqltuner-1.7.13/mysqltuner.pl-5822- )
##############################################
mysqltuner-1.7.13/mysqltuner.pl-5838- select_array(
mysqltuner-1.7.13/mysqltuner.pl:5839:"SELECT DISTINCT(ENGINE) FROM information_schema.TABLES WHERE TABLE_SCHEMA='$_'"
mysqltuner-1.7.13/mysqltuner.pl-5840- )
##############################################
mysqltuner-1.7.13/mysqltuner.pl-5887- my @distinct_column_charset = select_array(
mysqltuner-1.7.13/mysqltuner.pl:5888:"select DISTINCT(CHARACTER_SET_NAME) from information_schema.COLUMNS where CHARACTER_SET_NAME IS NOT NULL AND TABLE_SCHEMA ='$_'"
mysqltuner-1.7.13/mysqltuner.pl-5889- );
##############################################
mysqltuner-1.7.13/mysqltuner.pl-5905- my @distinct_column_collation = select_array(
mysqltuner-1.7.13/mysqltuner.pl:5906:"select DISTINCT(COLLATION_NAME) from information_schema.COLUMNS where COLLATION_NAME IS NOT NULL AND TABLE_SCHEMA ='$_'"
mysqltuner-1.7.13/mysqltuner.pl-5907- );
##############################################
mysqltuner-1.7.13/mysqltuner.pl-5943- my @dbtable = select_array(
mysqltuner-1.7.13/mysqltuner.pl:5944:"SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA='$dbname' AND TABLE_TYPE='BASE TABLE' ORDER BY TABLE_NAME"
mysqltuner-1.7.13/mysqltuner.pl-5945- );
##############################################
mysqltuner-1.7.13/mysqltuner.pl-5949- my @tbcol = select_array(
mysqltuner-1.7.13/mysqltuner.pl:5950:"SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='$dbname' AND TABLE_NAME='$tbname'"
mysqltuner-1.7.13/mysqltuner.pl-5951- );
##############################################
mysqltuner-1.7.13/mysqltuner.pl-5953- my $ctype = select_one(
mysqltuner-1.7.13/mysqltuner.pl:5954:"SELECT COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='$dbname' AND TABLE_NAME='$tbname' AND COLUMN_NAME='$_' "
mysqltuner-1.7.13/mysqltuner.pl-5955- );
mysqltuner-1.7.13/mysqltuner.pl-5956- my $isnull = select_one(
mysqltuner-1.7.13/mysqltuner.pl:5957:"SELECT IS_NULLABLE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='$dbname' AND TABLE_NAME='$tbname' AND COLUMN_NAME='$_' "
mysqltuner-1.7.13/mysqltuner.pl-5958- );
##############################################
mysqltuner-1.7.13/runAudit.sh-3-server=$1
mysqltuner-1.7.13/runAudit.sh:4:_DIR=$(dirname `readlink -f $0`)
mysqltuner-1.7.13/runAudit.sh-5-
##############################################
mysqltuner-1.7.13/runAudit.sh-11-export SCP_CLIENT="scp -q $SSH_OPTIONS -o TCPKeepAlive=yes -o ServerAliveInterval=50 -o strictHostKeyChecking=no"
mysqltuner-1.7.13/runAudit.sh:12: _DIR="$(dirname "`readlink -f $0`")"
mysqltuner-1.7.13/runAudit.sh-13-