Public bug reported: [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". ** Affects: cacti (Ubuntu) Importance: High Assignee: Paul Gevers (paul-climbing) Status: In Progress ** Tags: mysql-5.7-transition xenial -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1588813 Title: cacti still not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/cacti/+bug/1588813/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
