Warnings issue when attempting to import a Slowlog from the CLI

[bonj1987]

i used this with the --logfile= and pointed it to where my cacti's mysql slowlog file was and i got this error PHP Notice: Undefined offset: 3 in C:\inetpub\wwwroot\cacti\plugins\slowlog\slowlog_functions.php on line 139

[TheWitness]

What version of MySQL/MariaDB? Can you upload a 100 or so lines of the file?

[TheWitness]

I've worked around it, but if you can still upload head -100 slowlog that would be good.

[bonj1987]

i uninstalled and redownloaded it and reinstalled it.. i ran the command to import the slow log. php -q import_log.php --logfile=C:\ProgramData\MySQL\MySQL Server 5.7\Data\server-slow.log i got this error.. **PHP Notice: Undefined variable: file in C:\inetpub\wwwroot\cacti\plugins\slowlog\slowlog_functions.php on line 302 FATAL: Can not find file '' on that line $file\n is listed but $file isn't anywhere else in the script print "FATAL: Can not find file '$file'\n";**

[bonj1987]

ignore my last comment.. i forgot to surround my path with "" i ran the command it imported.

other than making it a scheduled task, will we be able to configure that from within cacti itself?

[TheWitness]

Another good catch. Making a light update. I did not use this script previously from the command line, always imported it from the GUI. Good to get this flushed out now.

[TheWitness]

You may want to provide the full path to the logfile.

[bonj1987]

where do you import it in the gui? i didnt see such a control in the gui, which is why i did it from command line.

[bonj1987]

nevermind.. im friggin blind today LOL..

[TheWitness]

There is a plus sign on the table view.

[TheWitness]

Watch those two variables. Some of my slowlog's get to be ~1GB is size. Have to increase those two variables and restart httpd/php-fpm.