group.of.nepali.translators team mailing list archive

[Launchpad Bug Tracker <1588813@xxxxxxxxxxxxxxxxxx>]

This bug was fixed in the package cacti - 0.8.8f+ds1-4ubuntu4.16.04.1

---------------
cacti (0.8.8f+ds1-4ubuntu4.16.04.1) xenial; urgency=medium

  * Update make_cacti_sql_mode-strict_compatible.patch to also drop
    ONLY_FULL_GROUP_BY (LP: #1588813)

 -- Paul Gevers <elbrus@xxxxxxxxxx>  Fri, 03 Jun 2016 13:46:55 +0200

** Changed in: cacti (Ubuntu Xenial)
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of नेपाली
भाषा समायोजकहरुको समूह, which is subscribed to Xenial.
Matching subscriptions: Ubuntu 16.04 Bugs
https://bugs.launchpad.net/bugs/1588813

Title:
  cacti still not compatible with MySQL 5.7 default sql_mode

Status in cacti package in Ubuntu:
  Fix Released
Status in cacti source package in Xenial:
  Fix Released

Bug description:
  [Impact]

   * Although bug 1578144 fixed the installability and the fundamental running
     of cacti, multiple functions of the cacti web-page do not work with the
     default MySQL 5.7 sql_mode.

   * The fix forces the sql_mode ONLY_FULL_GROUP_BY setting in the MySQL connection
     to be unset.

  [Test Case]

   [ Verify issue ]

   * Install cacti on a xenial system with mysql-server installed. Connect to
     http://localhost/cacti, pass through the install process (i.e. hit "Ok", log
     in with admin/admin credentials and provide a new admin password).  Then go
     to the http://localhost/cacti/user_admin.php page. Check that the following
     line appears in the /var/log/cacti/cacti.log file:

  06/03/2016 07:44:43 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!,
  Error:'1055', SQL:"SELECT  id,  user_auth.username,  full_name,
  realm,  enabled,  policy_graphs,  time,  max(time) as dtime  FROM
  user_auth  LEFT JOIN user_log ON (user_auth.id = user_log.user_id)
  GROUP BY id  ORDER BY username ASC LIMIT 0,30"

   [ Verify fix ]

   * Same as above, but now without the error appearing.

  [Regression Potential]

   * The change is very similar to the fix of bug 1578144, which fixed a
     completely useless package. Due to the nature of the change, either it
     doesn't do anything, or breaks the package completely, so regression is easy
     to check.

  [Other Info]

   * I am the maintainer of cacti in Debian and have incorporated this change in
     sid as well. The fix is already in yakkety. Upstream has applied this in
     their git repository as well, although in the past they "didn't support
     MySQL safe mode".

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/cacti/+bug/1588813/+subscriptions