Hello Gentleman, MySQL 5.7 have now enabled some strict mode (1) settings. Cacti have lot of bugs in SQL statements (2) which were refused by MySQLd. I had therefore used simple workaround (3) and my instance of cacti was back to life. So, I have therefore thre questions: 1) Where to report missing dependency of cacti for php7.0-mbstring if php7 is used? 2) Where to report incompatibility about mysqld default settings for cacti? 3) Which ubuntu repository is used for testing versions of software? REM: 1) ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION 2) Bad handling of date/time, bad conditions in select commands 3) Disabled SQL Mode:ONLY_FULL_GROUP_BY, NO_ZERO_IN_DATE, NO_ZERO_DATE ______________________________________________________________ > Od: "Peter Golis" <golisp@centrum.sk> > Komu: Peter Golis <golisp@centrum.sk>, Aere Greenway <Aere@dvorak-keyboards.com>, lubuntu user list <lubuntu-users@lists.ubuntu.com> > Dátum: 08.04.2016 12:06 > Predmet: Re: [lubuntu-users] Lubuntu 16.04 PPC: Cacti stopped working afterPHP upgrade > Hello Gentleman, My cacti reporting had again stopped working. Root call was automatic upgrade of MySQL from 5.6 tp 5.7 where was done also performed upgrade of some tables due to changed format of column TIME/TIMESTAMP/DATETIME. Now I have just overloaded CPU due to repeating of DB transactions from cacti php like: INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (0, 5472, NOW(), '0000-00-00 00:00:00'); ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1 How can I mask MySQL 5.7 until cacti will reflect correct handling of date values? Thanks for answer, Peter. ______________________________________________________________ > Od: Peter Golis <golisp@centrum.sk> > Komu: Aere Greenway <Aere@dvorak-keyboards.com>, lubuntu user list <lubuntu-users@lists.ubuntu.com> > Dátum: 26.03.2016 19:34 > Predmet: Re: [lubuntu-users] Lubuntu 16.04 PPC: Cacti stopped working afterPHP upgrade > Hello, I had installed cacti using command "apt-get install cacti" and it was working for one year. So, if I can understood you correctly, all of dependencies are tested in Debian? Have a nice day, Peter. <div class="gmail_quote">On March 26, 2016 6:45:29 PM CET, Aere Greenway <Aere@Dvorak-Keyboards.com> wrote: <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid #cccccc; padding-left: 1ex;"> <pre class="k9mail">On 03/26/2016 07:16 AM, Peter Golis wrote:</pre> <blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">Hello Gentleman, Yesterday, after upgrade of PHP v7 package with removal of older version of PHP v5 had stopped working my Cacti instance. What had please happened with PHP v5, was it marked as obsolete? Error in cacti.log had pointed to missing function mb_strlen() which was moved into separate package php7.0-mbstring in PHP v7. After installing it, Cacti was back in life. That simply point to wrong dependencies for package Cacti. Are somewhere tested also dependencies for packages? [Fri Mar 25 21:23:20.098957 2016] [:error] [pid 18311] [client <a>127.0.0.1:34556</a>] PHP Fatal error: Uncaught Error: Call to undefined function mb_strlen() in /usr/share/cacti/site/lib/rrd.php:1049\nStack trace:\n#0 /usr/share/cacti/site/graph_image.p hp (92): rrdtool_function_graph('36', '0', Array)\n#1 {main}\n thrown in /usr/share/cacti/site/lib/rrd.php on line 1049, referer: <a href="http://rybnik.zapto.org/cacti/graph_view.php">http://rybnik.zapto.org/cacti/graph_view.php</a> Have a nice day, Peter.</blockquote> <pre class="k9mail"> Peter: I don't know how you originally installed Cacti, so I am speculating here, with a generality. When we install software from sources other than the Ubuntu repository, or Debian packages, the package manager is not aware of what other packages your 'custom install' software requires. So (being unaware of the requirements), it may allow packages not required by software installed from the repository (or other Debian packages), to be marked as 'not needed', or perhaps 'obsolete'. Un-needed or obsolete packages get removed when you upgrade to a new system level. I am speculating that this sit uationmay have come into-play in the problem you reported.</pre> </blockquote> </div> -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ---------- -- Lubuntu-users mailing list Lubuntu-users@lists.ubuntu.com Modify settings or unsubscribe at: <a href="https://lists.ubuntu.com/mailman/listinfo/lubuntu-users">https://lists.ubuntu.com/mailman/listinfo/lubuntu-users</a>