search

major / MySQLTuner-perl

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
GNU General Public License v3.0
8.94k stars 1.29k forks source link

Problems in FreeBSD 10.2 #227

Closed kosfango closed 8 years ago

kosfango commented 8 years ago

Hi All, I have FreeBSD 10.2 and mysql Ver 15.1 Distrib 10.1.13-MariaDB, for FreeBSD10.2 (amd64) using readline 6.3. Recently, I did git clone and tried to run mysqltuner.pl

root@server:~/MySQLTuner-perl# ./mysqltuner.pl

MySQLTuner 1.6.14 - Major Hayden major@mhtx.net Bug reports, feature requests, and downloads at http://mysqltuner.com/ Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script [!!] Successfully authenticated with no password - SECURITY RISK! [!!] failed to execute: SELECT VERSION() [!!] FAIL Execute SQL / return code: 256 [!!] failed to execute: SHOW VARIABLES [!!] FAIL Execute SQL / return code: 256 [!!] failed to execute: SHOW GLOBAL VARIABLES [!!] FAIL Execute SQL / return code: 256 [!!] failed to execute: SHOW STATUS [!!] FAIL Execute SQL / return code: 256 [!!] failed to execute: SHOW GLOBAL STATUS [!!] FAIL Execute SQL / return code: 256 [!!] failed to execute: SHOW ENGINES [!!] FAIL Execute SQL / return code: 256 [!!] failed to execute: SHOW SLAVE STATUS\G [!!] FAIL Execute SQL / return code: 256 [!!] failed to execute: SHOW SLAVE HOSTS [!!] FAIL Execute SQL / return code: 256 [!!] failed to execute: \s [!!] FAIL Execute SQL / return code: 256 Use of uninitialized value $myvar{"version"} in pattern match (m//) at ./mysqltuner.pl line 1588 (#1) (W uninitialized) An undefined value was used as if it were already defined. It was interpreted as a "" or a 0, but maybe it was a mistake. To suppress this warning assign a defined value to your variables.

To help you figure out what was undefined, perl will try to tell you
the name of the variable (if any) that was undefined.  In some cases
it cannot do this, so it also tells you what operation you used the
undefined value in.  Note, however, that perl optimizes your program
and the operation displayed in the warning may not necessarily appear
literally in your program.  For example, "that $foo" is usually
optimized into "that " . $foo, and the warning will refer to the
concatenation (.) operator, even though there is no . in
your program.

Use of uninitialized value $mysqlvermajor in numeric gt (>) at ./mysqltuner.pl line 1614 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1614 (#1) Use of uninitialized value $myvar{"version"} in concatenation (.) or string at ./mysqltuner.pl line 1593 (#1) [!!] Your MySQL version is EOL software! Upgrade soon! [OK] Operating on 64-bit architecture

-------- Storage Engine Statistics ----------------------------------------------------------------- [!!] failed to execute: SHOW DATABASES [!!] FAIL Execute SQL / return code: 256 [--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster [OK] Total fragmented tables: 0 [!!] failed to execute: SELECT ~0 [!!] FAIL Execute SQL / return code: 256

-------- Security Recommendations ------------------------------------------------------------------ Use of uninitialized value $myvar{"version"} in pattern match (m//) at ./mysqltuner.pl line 1404 (#1) [!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE TRIM(USER) = '' OR USER IS NULL [!!] FAIL Execute SQL / return code: 256 [OK] There are no anonymous accounts for any database users Use of uninitialized value $mysqlvermajor in numeric lt (<) at ./mysqltuner.pl line 1624 (#1) [!!] No more password checks for MySQL version <=5.1 [!!] MySQL version <=5.1 are deprecated and end of support.

-------- CVE Security Recommendations -------------------------------------------------------------- Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 1 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 2 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 3 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 4 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 5 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 6 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 7 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 8 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 9 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 10 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 11 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 12 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 13 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 14 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 15 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 16 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 17 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 18 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 19 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 20 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 21 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 22 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 23 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 24 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 25 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 26 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 27 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 28 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 29 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 30 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 31 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 32 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 33 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 34 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 35 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 36 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 37 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 38 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 39 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 40 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 41 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 42 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 43 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 44 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 45 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 46 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 47 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 48 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 49 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 50 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 51 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 52 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 53 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 54 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 55 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 56 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 57 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 58 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 59 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 60 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 61 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 62 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 63 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 64 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 65 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 66 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 67 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 68 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 69 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 70 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 71 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 72 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 73 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 74 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 75 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 76 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 77 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 78 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 79 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 80 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 81 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 82 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 83 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 84 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 85 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 86 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 87 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 88 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 89 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 90 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 91 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 92 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 93 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 94 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 95 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 96 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 97 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 98 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 99 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 100 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 101 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 102 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 103 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 104 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 105 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 106 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 107 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 108 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 109 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 110 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 111 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 112 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 113 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 114 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 115 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 116 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 117 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 118 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 119 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 120 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 121 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 122 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 123 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 124 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 125 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 126 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 127 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 128 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 129 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 130 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 131 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 132 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 133 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 134 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 135 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 136 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 137 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 138 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 139 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 140 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 141 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 142 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 143 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 144 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 145 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 146 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 147 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 148 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 149 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 150 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 151 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 152 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 153 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 154 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 155 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 156 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 157 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 158 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 159 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 160 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 161 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 162 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 163 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 164 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 165 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 166 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 167 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 168 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 169 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 170 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 171 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 172 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 173 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 174 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 175 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 176 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 177 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 178 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 179 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 180 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 181 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 182 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 183 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 184 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 185 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 186 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 187 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 188 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 189 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 190 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 191 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 192 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 193 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 194 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 195 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 196 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 197 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 198 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 199 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 200 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 201 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 202 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 203 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 204 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 205 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 206 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 207 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 208 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 209 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 210 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 211 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 212 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 213 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 214 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 215 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 216 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 217 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 218 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 219 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 220 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 221 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 222 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 223 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 224 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 225 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 226 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 227 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 228 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 229 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 230 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 231 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 232 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 233 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 234 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 235 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 236 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 237 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 238 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 239 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 240 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 241 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 242 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 243 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 244 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 245 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 246 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 247 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 248 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 249 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 250 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 251 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 252 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 253 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 254 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 255 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 256 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 257 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 258 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 259 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 260 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 261 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 262 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 263 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 264 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 265 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 266 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 267 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 268 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 269 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 270 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 271 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 272 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 273 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 274 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 275 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 276 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 277 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 278 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 279 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 280 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 281 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 282 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 283 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 284 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 285 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 286 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 287 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 288 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 289 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 290 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 291 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 292 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 293 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 294 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 295 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 296 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 297 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 298 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 299 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 300 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 301 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 302 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 303 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 304 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 305 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 306 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 307 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 308 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 309 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 310 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 311 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 312 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 313 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 314 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 315 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 316 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 317 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 318 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 319 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 320 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 321 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 322 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 323 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 324 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 325 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 326 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 327 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 328 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 329 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 330 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 331 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 332 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 333 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 334 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 335 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 336 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 337 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 338 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 339 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 340 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 341 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 342 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 343 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 344 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 345 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 346 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 347 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 348 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 349 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 350 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 351 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 352 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 353 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 354 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 355 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 356 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 357 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 358 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 359 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 360 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 361 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 362 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 363 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 364 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 365 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 366 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 367 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 368 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 369 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 370 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 371 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 372 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 373 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 374 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 375 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 376 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 377 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 378 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 379 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 380 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 381 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 382 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 383 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 384 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 385 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 386 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 387 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 388 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 389 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 390 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 391 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 392 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 393 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 394 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 395 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 396 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 397 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 398 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 399 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 400 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 401 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 402 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 403 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 404 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 405 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 406 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 407 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 408 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 409 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 410 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 411 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 412 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 413 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 414 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 415 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 416 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 417 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 418 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 419 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 420 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 421 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 422 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 423 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 424 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 425 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 426 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 427 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 428 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 429 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 430 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 431 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 432 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 433 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 434 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 435 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 436 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 437 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 438 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 439 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 440 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 441 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 442 (#1) Use of uninitialized value $mysqlvermajor in numeric eq (==) at ./mysqltuner.pl line 1632, line 443 (#1) [OK] NO SECURITY CVE FOUND FOR YOUR VERSION Use of uninitialized value $mystat{"Questions"} in numeric lt (<) at ./mysqltuner.pl line 1943 (#1) [!!] Your server has not answered any queries - cannot continue... root@server:~/MySQLTuner-perl#

jmrenouard commented 8 years ago

Hi @kosfango

Can you run the same script using a user and password with enought privileges ? You need at least following privileges: SELECT, PROCESS,EXECUTE, REPLICATION CLIENT,SHOW DATABASES,SHOW VIEW

Options are --user and --pass Thanks for your feedback. @jmrenouard

kosfango commented 8 years ago

Hi,

I tried next command as you asked: ./mysqltuner.pl --user root --pass

Seems ok! Is it changing of command line rules or bug?

Thank you for help!

jmrenouard commented 8 years ago

@kosfango Your default user doesn't have enough privileges for running MySQLTuner properly.

This is also a bug regarding MySQL Tuner which can't detecct properly when privileges are too low.

@jmrenouard

kosfango commented 8 years ago

Yes, previous versions of mysqltuner asked user and password for mysql.

jmrenouard commented 8 years ago

Hi @kosfango Can you rerun your script using last verrsion without any options ?

I add a stop code when SELECT VERSION return nothing.

Thanks for your help. @jmrenouard

kosfango commented 8 years ago

Let me try. I need to do git pull..

kosfango commented 8 years ago

(pts/1)[root@server:~/MySQLTuner-perl]# git pull remote: Counting objects: 6, done. remote: Compressing objects: 100% (6/6), done. remote: Total 6 (delta 1), reused 0 (delta 0), pack-reused 0 Unpacking objects: 100% (6/6), done. From https://github.com/major/MySQLTuner-perl ccc1fe2..b42b97f master -> origin/master Updating ccc1fe2..b42b97f Fast-forward mysqltuner.pl | 4 ++++ vulnerabilities.csv | 83 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++------------ 2 files changed, 75 insertions(+), 12 deletions(-) (pts/1)[root@server:~/MySQLTuner-perl]# ./mysqltuner.pl Backslash found where operator expected at ./mysqltuner.pl line 1033, near "remove_cr \" (#1) (S syntax) The Perl lexer knows whether to expect a term or an operator. If it sees what it knows to be a term when it was expecting to see an operator, it gives you this warning. Usually it indicates that an operator or delimiter was omitted, such as a semicolon.

    (Do you need to predeclare remove_cr?) (#2)
(S syntax) This is an educated guess made in conjunction with the message
"%s found where operator expected".  It often means a subroutine or module
name is being referenced that hasn't been declared yet.  This may be
because of ordering problems in your file, or because of a missing
"sub", "package", "require", or "use" statement.  If you're referencing
something that isn't defined yet, you don't actually have to define the
subroutine or package before the current location.  You can use an empty
"sub foo;" or "package FOO;" to enter a "forward" declaration.

Array found where operator expected at ./mysqltuner.pl line 1110, at end of line (#1)

    (Missing operator before ?) (#3)
(S syntax) This is an educated guess made in conjunction with the message
"%s found where operator expected".  Often the missing operator is a comma.

Array found where operator expected at ./mysqltuner.pl line 1111, at end of line (#1) String found where operator expected at ./mysqltuner.pl line 1119, near "get_file_contents "/etc/lsb-release"" (#1) (Do you need to predeclare get_file_contents?) (#2) Array found where operator expected at ./mysqltuner.pl line 1120, at end of line (#1) String found where operator expected at ./mysqltuner.pl line 1128, near "get_file_contents "/etc/system-release"" (#1) Array found where operator expected at ./mysqltuner.pl line 1129, at end of line (#1) String found where operator expected at ./mysqltuner.pl line 1134, near "get_file_contents "/etc/os-release"" (#1)

syntax error at ./mysqltuner.pl line 950, near "exit" syntax error at ./mysqltuner.pl line 1033, near "remove_cr \" syntax error at ./mysqltuner.pl line 1110, near "remove_cr @procs" syntax error at ./mysqltuner.pl line 1111, near "remove_empty @procs" syntax error at ./mysqltuner.pl line 1119, near "get_file_contents "/etc/lsb-release"" Global symbol "@info_release" requires explicit package name at ./mysqltuner.pl line 1120. Global symbol "@info_release" requires explicit package name at ./mysqltuner.pl line 1121. syntax error at ./mysqltuner.pl line 1128, near "get_file_contents "/etc/system-release"" Global symbol "@info_release" requires explicit package name at ./mysqltuner.pl line 1129. Global symbol "@info_release" requires explicit package name at ./mysqltuner.pl line 1130. ./mysqltuner.pl has too many errors (#4) (F) Probably means you had a syntax error. Common reasons include:

    A keyword is misspelled.
    A semicolon is missing.
    A comma is missing.
    An opening or closing parenthesis is missing.
    An opening or closing brace is missing.
    A closing quote is missing.

Often there will be another error message associated with the syntax
error giving more information.  (Sometimes it helps to turn on -w.)
The error message itself often tells you where it was in the line when
it decided to give up.  Sometimes the actual error is several tokens
before this, because Perl is good at understanding random input.
Occasionally the line number may be misleading, and once in a blue moon
the only way to figure out what's triggering the error is to call
perl -c repeatedly, chopping away half the program each time to see
if the error went away.  Sort of the cybernetic version of 20 questions.

Uncaught exception from user code: syntax error at ./mysqltuner.pl line 950, near "exit" syntax error at ./mysqltuner.pl line 1033, near "remove_cr \" syntax error at ./mysqltuner.pl line 1110, near "remove_cr @procs" syntax error at ./mysqltuner.pl line 1111, near "remove_empty @procs" syntax error at ./mysqltuner.pl line 1119, near "get_file_contents "/etc/lsb-release"" Global symbol "@info_release" requires explicit package name at ./mysqltuner.pl line 1120. Global symbol "@info_release" requires explicit package name at ./mysqltuner.pl line 1121. syntax error at ./mysqltuner.pl line 1128, near "get_file_contents "/etc/system-release"" Global symbol "@info_release" requires explicit package name at ./mysqltuner.pl line 1129. Global symbol "@info_release" requires explicit package name at ./mysqltuner.pl line 1130. ./mysqltuner.pl has too many errors. (pts/1)[root@server:~/MySQLTuner-perl]#

jmrenouard commented 8 years ago

Hi @kosfango

Can you perform a new test, I have a compilation error :)

Thanks @jmrenouard

kosfango commented 8 years ago

Sure,

root@server:~/MySQLTuner-perl# git pull remote: Counting objects: 3, done. remote: Compressing objects: 100% (3/3), done. remote: Total 3 (delta 0), reused 0 (delta 0), pack-reused 0 Unpacking objects: 100% (3/3), done. From https://github.com/major/MySQLTuner-perl b42b97f..da1819d master -> origin/master Updating b42b97f..da1819d Fast-forward mysqltuner.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) root@server:~/MySQLTuner-perl# ./mysqltuner.pl

MySQLTuner 1.6.14 - Major Hayden major@mhtx.net Bug reports, feature requests, and downloads at http://mysqltuner.com/ Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script [!!] Successfully authenticated with no password - SECURITY RISK! [!!] failed to execute: SELECT VERSION() [!!] FAIL Execute SQL / return code: 256 Argument "" isn't numeric in numeric eq (==) at ./mysqltuner.pl line 948 (#1) (W numeric) The indicated string was fed as an argument to an operator that expected a numeric value instead. If you're fortunate the message will identify which operator was so unfortunate.

[!!] You probably doesn't get enough privileges for running MySQLTuner ... root@server:~/MySQLTuner-perl#

jmrenouard commented 8 years ago

Hi @kosfango

Thanks for your feedback. I think it is perfect :)

Can we close this issue ? @jmrenouard

kosfango commented 8 years ago

Thank you for help.

The last attempt:

root@server:~/MySQLTuner-perl# git pull remote: Counting objects: 6, done. remote: Compressing objects: 100% (6/6), done. remote: Total 6 (delta 2), reused 0 (delta 0), pack-reused 0 Unpacking objects: 100% (6/6), done. From https://github.com/major/MySQLTuner-perl da1819d..97587f6 master -> origin/master Updating da1819d..97587f6 Fast-forward mysqltuner.pl | 57 +++++++++++++++++++++++++++++++++++++++++++++------------ 1 file changed, 45 insertions(+), 12 deletions(-) root@server:~/MySQLTuner-perl# ./mysqltuner.pl

MySQLTuner 1.6.15 - Major Hayden major@mhtx.net Bug reports, feature requests, and downloads at http://mysqltuner.com/ Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script [!!] Successfully authenticated with no password - SECURITY RISK! [!!] failed to execute: SELECT VERSION() [!!] FAIL Execute SQL / return code: 256 [!!] You probably doesn't get enough privileges for running MySQLTuner ... root@server:~/MySQLTuner-perl#

jmrenouard commented 8 years ago

This is perfect :)

I close this issue.

Thanks for your help ! @jmrenouard