Cacti

Osiris wrote:You've got to love docker.

Yep, the footprint was tiny using Alpine Linux. rrdtool 1.5 was already in the repository.

Osiris wrote:Cacti 1.x requires 1.3+. Get a raspberry PI.

I resolved it by using Docker to run just rrdtool 1.5.

I just upgraded from Cacti 0.8.8g to 1.1.16 on a Synology NAS and everything seems OK except graphs don't draw. They give the error: ERROR: unknown option --pango-markup My rrdtool version is 1.2.30 and I double checked the Cacti requirements page which still says 1.0.49 is the minimum. However, the...

Please log the bug: http://cacti.net/bugs.php Done. BTW, i am curious, what is (was) purpose of this change? It is safe to revert these changes or it will affect something other too, please? Sorry, I have no idea why this was changed - there is no mention of it in the change log. If you revert just...

Comparing the source code with the previous version, this has been caused by the changes to function "strip_quotes" in "functions.php".

It is now stripping non-numeric prefixes from the output string, which is wrong! Reverting this function to the old version fixes the problem.

Same problem here as original poster after upgrading to 0.8.8e. SQL field output is type text. You can see it is eating the output, just like the example the original poster gave. 07/13/2015 09:55:11 PM - CMDPHP: Poller[0] Host[3] DS[35] CMD: perl /<path>/<script>.pl, output: 14.6 snrd:8.8 attu:0.0 ...

ALTER TABLE `poller_output` ADD PRIMARY KEY (`local_data_id`, `rrd_name`, `time`) /*!50060 USING BTREE */ makes use of MySQL conditional comments. It will use default index type for older versions (which should be quite fine) and force the index type of BTREE for MySQL >= 5.00.60. So you should run...

gandalf wrote:This was fixed in 5.0.60. So you still have it!

It looks like the Debian etch packages don't go as high as that version - even the backports package.

Please verify by running ALTER TABLE `poller_output` ADD PRIMARY KEY USING BTREE (`local_data_id`, `rrd_name`, `time`) In case this gives us what I expect now, I will have to make up my mind how to worka round this nasty mysql bug ... R. I get: ERROR 1068 (42000): Multiple primary key defined Which...

I just ran ALTER TABLE `poller_output` ADD PRIMARY KEY (`local_data_id`, `rrd_name`, `time`) USING BTREE on our production MySQL 5.0.77 without issues (it's a RHEL 5 system) So I need exact parameters to reproduce the effect. Please specify - platform - exact mysql version - result of running the a...

gandalf wrote:Did you find a mysql bug report for that? Well, 5.0 is out of service, from their point of viewing ...
R.

Well I'm just using the MySQL version as provided by Netgear (NAS products) on Debian Etch that they use. I'll have to investigate if MySQL can be upgraded without breaking anything.

Looking at http://dev.mysql.com/doc/refman/5.0/en/alter-table.html it SHOULD be supported in 5.0. This is, what I was looking at when coding this bit. It was present even in earlier releases: http://dev.mysql.com/doc/refman/4.1/en/alter-table.html But perhaps I missed sth. R. Strange but it definat...

Weird.. I am running 5.1.54-1 on my dev machine, and it wouldn't take the command minus the "use btree".. Wonder why?? Oh, well. If it works for you, then good. -chadd. It looks like that command is not supported in MySQL 5.0, see here: http://prattski.com/2010/06/01/mysql-using-btree-err...

No problem. You should be fine. If you want to confirm you are using BTREE data structure, just do this: SHOW INDEX FROM cacti.poller_output\G Also, I'd be curious to know what version of MySQL you are running, and on what OS? And, was this a new install, or an upgrade? -chadd. Yes, SHOW INDEX indi...

Hi chadd Thank you for the helpful reply. Second, if you issue the command at the mysql> prompt you get a better error message: mysql> ALTER TABLE `poller_output` ADD PRIMARY KEY (`local_data_id`, `rrd_name`, `time`) USING BTREE; ERROR 1068 (42000): Multiple primary key defined Actually, I get a syn...