[lubuntu-users] Lubuntu 16.04 PPC: Cacti stopped working afterPHP upgrade

[Peter Golis]

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 at centrum.sk>
> Komu: Peter Golis <golisp at centrum.sk>, Aere Greenway <Aere at dvorak-keyboards.com>, lubuntu user list <lubuntu-users at 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 at centrum.sk>
> Komu: Aere Greenway <Aere at dvorak-keyboards.com>, lubuntu user list <lubuntu-users at 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.



On March 26, 2016 6:45:29 PM CET, Aere Greenway <Aere at Dvorak-Keyboards.com> wrote:On 03/26/2016 07:16 AM, Peter Golis wrote: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 127.0.0.1:34556] 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: http://rybnik.zapto.org/cacti/graph_view.php <http://rybnik.zapto.org/cacti/graph_view.php>
 
 Have a nice day,
 Peter.
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.
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

----------

-- 
Lubuntu-users mailing list
Lubuntu-users at lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/lubuntu-users <https://lists.ubuntu.com/mailman/listinfo/lubuntu-users>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/lubuntu-users/attachments/20160417/4c9d90d0/attachment.html>