[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
** Changed in: cacti Status: Incomplete => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
This bug was fixed in the package cacti-spine - 0.8.8b-1ubuntu1.1 --- cacti-spine (0.8.8b-1ubuntu1.1) xenial; urgency=medium * Add make_spine_sql_mode-strict_compatible.patch to enable cacti-spine to work with the default settings of MySQL 5.7 (LP: #1578144) -- Paul Gevers Sat, 14 May 2016 21:24:30 +0200 ** Changed in: cacti-spine (Ubuntu Xenial) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
With respect to those 1055 errors, I have looked at a couple and without digging deep, I can't judge how severe they are. Several of those appear in places where I expect issues would have turned up already. For at least one case, upstream already said: "user management, JOIN between usear_auth and user_log where in user_log entries for certain users may be missing due to the fact that they did not yet login" Although I don't fully follow, it appears to me that they judged "I know what I am doing". So I suggest we indeed add the line in comment #41. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Hmm, at least those other errors are also there with sql_mode=''. So it looks like only those 1055 errors are new and they completely disappear with removal of ONLY_FULL_GROUP_BY. So indeed, I will only check those. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
** Bug watch added: Debian Bug tracker #825644 http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=825644 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Hi Lygie, On 28-05-16 10:23, lygie wrote: > I found another issue. Thanks for reporting this. > Some selects fail because of MYSQLs "ONLY_FULL_GROUP_BY" mode. I decided to run my new cacti autopkgtest on the xenial version (why didn't I do that before, I wonder), and found some more... The annoying thing is, the test passes, but there are errors in the cacti.log. The following error numbers show up: Error:'1054' Error:'1055' <- the one found by you Error:'1062' Error:'1064' I'll dive into it, but I don't mind advice from readers here. I read some of the documentation with respect to what ONLY_FULL_GROUP_BY is protecting us from and I will try to figure out if it isn't pointing at a bugs in cacti. Probably the same goes for the other errors. Paul Note to self: let the autopkgtest also check the log for errors, just filed as Debian bug 825644¹. ¹ https://bugs.debian.org/825644 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Hi,
I found another issue.
Some selects fail because of MYSQLs "ONLY_FULL_GROUP_BY" mode. Think we habe to
add something like
$cnn_id->EXECUTE("SET SESSION sql_mode = (SELECT
REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY', ''))");
to database.php also.
Lygie
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1578144
Title:
cacti and cacti-spine are not compatible with MySQL 5.7 default
sql_mode
To manage notifications about this bug go to:
https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Both updates fixed the issue in my xenial lxc. Replacing the verification tag appropriately. ** Tags removed: verification-needed ** Tags added: verification-done -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Hi there, I can confirm, the patch in proposed works for me. Thanks. Lygie -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Hello Hans, or anyone else affected, Accepted cacti into xenial-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/cacti/0.8.8f+ds1-4ubuntu4.16.04 in a few hours, and then in the -proposed repository. Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users. If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, and change the tag from verification-needed to verification-done. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed. In either case, details of your testing will help us make a better decision. Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance! ** Changed in: cacti (Ubuntu Xenial) Status: In Progress => Fix Committed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Hello Hans, or anyone else affected, Accepted cacti-spine into xenial-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/cacti-spine/0.8 .8b-1ubuntu1.1 in a few hours, and then in the -proposed repository. Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users. If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, and change the tag from verification-needed to verification-done. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed. In either case, details of your testing will help us make a better decision. Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance! ** Changed in: cacti-spine (Ubuntu Xenial) Status: In Progress => Fix Committed ** Tags added: verification-needed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
On 21-05-16 12:19, Robie Basak wrote: > I trust those tweaks were OK with your name on it - I didn't think it > was worth another round trip to check. You judged correctly. > Thank you again for looking after this for us in Ubuntu! Have you > considered asking for upload access for cacti-spine? As you maintain it > in Debian and are already an Ubuntu uploader this should be a > no-brainer I think. Well, I hadn't used my Ubuntu upload rights in a long time, so I haven't taken any action lately. However, multiple people already suggested me to apply for MOTU rights, which I am considering. Paul -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
On Sat, May 21, 2016 at 06:49:27AM -, Paul Gevers wrote: > @Robie, did you also upload cacti-spine [to Xenial]? I did not, sorry. Thank you for checking. I wasn't following this bug closely enough, hadn't realised you had provided an upload for Xenial that needed sponsoring and hadn't scrolled up far enough. I've uploaded your debdiff just now, so it's now awaiting SRU team review. Please note that I made a couple of minor tweaks. 1) I changed the version to ubuntu1.1 following the guidance linked from the SRU process page. ubuntu2 would have been technically fine too as Yakkety has a newer version, but I hear that 1.1 is preferred to make it clearer that it is an SRU from the version number alone. 2) I appreciate the dep3 header (I usually insist on these) but s/Ubuntu-bug/Bug-Ubuntu/ to match the spec. I trust those tweaks were OK with your name on it - I didn't think it was worth another round trip to check. Thank you again for looking after this for us in Ubuntu! Have you considered asking for upload access for cacti-spine? As you maintain it in Debian and are already an Ubuntu uploader this should be a no-brainer I think. ** Changed in: cacti-spine (Ubuntu Xenial) Status: Confirmed => In Progress -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
On 21-05-16 08:49, Paul Gevers wrote: > @Robie, did you also upload cacti-spine? ... to xenial (I meant to add that, but my brain was faster than my fingers). Paul -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
@Robie, did you also upload cacti-spine? @all, please check that the current state of this bug is according to the procedures for SRU. (at least cacti is all ready as far as I can tell. ** Changed in: cacti (Ubuntu Xenial) Status: Confirmed => In Progress ** Changed in: cacti (Ubuntu Xenial) Assignee: (unassigned) => Paul Gevers (paul-climbing) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
This bug was fixed in the package cacti-spine - 0.8.8h-1ubuntu1 --- cacti-spine (0.8.8h-1ubuntu1) yakkety; urgency=medium * Sync from Debian Remaining change: - d/p/libmysqlclient_r: build against libmysqlclient, not _r (LP: #1564871). -- Paul Gevers Fri, 20 May 2016 15:11:04 +0200 ** Changed in: cacti-spine (Ubuntu Yakkety) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
OK, sponsored. Thanks! Please note that I modified debian/changelog to merge the old Ubuntu entry. This is convention in Ubuntu for merge uploads where an old Ubuntu delta is brought forward (but dropped on a sync). You can do it manually using dpkg-mergechangelogs, or Merge-o-Matic does it automatically (when it works). ** Changed in: cacti-spine (Ubuntu Yakkety) Status: Confirmed => Fix Committed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Robie, On 20-05-16 15:30, Robie Basak wrote: > So do you want to apply that in Debian and then I can sync cacti-spine > in Yakkety? Or if that will take you some time, I'll be happy to upload > your merge now. Good to know, but please proceed with the merge, so we can get this bug out of the way. Paul -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Paul, this looks good, thanks. Note that the Ubuntu change (build against libmysqlclient, not libmysqlclient_r) is actually applicable to Debian too, even against MySQL 5.6. I haven't yet sent all of these up to Debian/upstreams (I'm tracking in bug 1566364). libmysqlclient_r is deprecated in 5.6 but still exists as a symlink which is gone in 5.7. So the patch should work against MySQL 5.6 in Debian though I've not tested it. So do you want to apply that in Debian and then I can sync cacti-spine in Yakkety? Or if that will take you some time, I'll be happy to upload your merge now. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
I created the merge debdiff for cacti-spine. It works in my lxc. Attached, both the debdiff against the current 0.8.8h-1 in Debian and the version in Ubuntu. ** Patch added: "cacti-spine debdiff for yakkety (against Debian)" https://bugs.launchpad.net/ubuntu/+source/cacti/+bug/1578144/+attachment/4666900/+files/LP1578144_cacti-spine_yakkety__debian.debdiff -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Forgot to mention explicitly, this merge needs sponsorship. ** Patch added: "cacti-spine debdiff for yakkety (against Ubuntu)" https://bugs.launchpad.net/ubuntu/+source/cacti/+bug/1578144/+attachment/4666902/+files/LP1578144_cacti-spine_yakkety__ubuntu.debdiff -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
This bug was fixed in the package cacti - 0.8.8h+ds1-1ubuntu1 --- cacti (0.8.8h+ds1-1ubuntu1) yakkety; urgency=medium * Lower versioned depends of libphp-adodb as Ubuntu fixed it earlier -- Paul Gevers Fri, 20 May 2016 09:54:29 +0200 ** Changed in: cacti (Ubuntu Yakkety) Status: Confirmed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
I uploaded fixed packages for cacti in yakkety and xenial. They are now in the process. Unfortunately, I don't have upload rights for cacti-spine, so somebody needs to sponsor those for me, once I created a yakkety package (hopefully today). ** Changed in: cacti (Ubuntu Xenial) Assignee: Paul Gevers (paul-climbing) => (unassigned) ** Changed in: cacti (Ubuntu Yakkety) Assignee: Paul Gevers (paul-climbing) => (unassigned) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Hi Robie, On 19-05-16 12:22, Robie Basak wrote: > Paul, thank you for taking care of this. If I can help, please let me > know. Well, help judging. I think my debdiffs can be uploaded (maybe fix the version to not conflict with the logical version number for yakkety). However, I am delaying now because of the requirement¹ that the fix should also be available in yakkety. My sync of cacti² failed because of a dependency on libphp-adodb which is behind in Ubuntu with respect to Debian, but Ubuntu stripped more than required (I think) so either it needs every time a manual action, or that diff should be ignored. I don't have the time to investigate what the proper solution is. I could take the Ubuntu version in Debian, but honestly, I don't like to upload in Debian, just to fix it in Ubuntu. I updated cacti-spine in Debian yesterday, but because of the mysql changes, that also needs an Ubuntu change (applying the libmysql-client_r patch). I just haven't gotten around yet to do it. So, if the fix is considered urgent (I sure do think we could press), you could just sponsor my debdiffs. Otherwise, please help decide what to do and/or making sure cacti and cacti-spine are quickly synced/merged from Debian. Paul ¹ https://wiki.ubuntu.com/StableReleaseUpdates#Procedure ² see http://people.canonical.com/~ubuntu-archive/proposed-migration/update_excuses.html -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Paul, thank you for taking care of this. If I can help, please let me know. ** Tags added: mysql-5.7-transition -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
tested and working, thanks! -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
I build (pending publication) the updated packages in my PPA. I would appreciate it when people would test these packages and give feedback before I upload to xenial-proposed. https://launchpad.net/~paul-climbing/+archive/ubuntu/cacti -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Fixed type mismatch in previous debdiff for cacti-spine ** Patch added: "Proposed debdiff for cacti-spine" https://bugs.launchpad.net/ubuntu/+source/cacti/+bug/1578144/+attachment/4662988/+files/LP1578144_cacti-spine_v2.debdiff -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
New and verified debdiff for cacti. ** Patch added: "Proposed debdiff for cacti" https://bugs.launchpad.net/ubuntu/+source/cacti/+bug/1578144/+attachment/4662987/+files/LP1578144_cacti.debdiff -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
** Patch removed: "First try to fix the issue (UNRELEASED)" https://bugs.launchpad.net/ubuntu/+source/cacti/+bug/1578144/+attachment/4662119/+files/LP1578144.debdiff ** Patch removed: "First try for cacti-spine fix" https://bugs.launchpad.net/ubuntu/+source/cacti/+bug/1578144/+attachment/4662840/+files/LP1578144_cacti-spine.debdiff -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
** Description changed:
- Ubuntu 16.04 LTS
+ [Impact]
- Cacti 0.8.8f which is the default version for Ubuntu 16.04 uses invalid
- datetime values ("-00-00 00:00:00"). MySQL 5.7 does not support
- zero-dates, this causes the Cacti poller script to run amok and execute
- the same SQL queries over and over. In my case this ends up with MySQL
- consuming about 35% CPU and php (via the poller) about 15% CPU.
+ * When cacti and/or cacti-spine is used with the MySQL server on the same
host
+and without modifications to the MySQL global setting, cacti fails to
+install and (e.g. for installations that upgraded) cacti and cacti-spine
+fail to run properly since MySQL 5.7 became the default (shortly before the
+Xenial release).
- This probably goes for clean installs as well (as Cacti has this invalid
datetime in a number of the php-files supplied by the Cacti package)
- ---
- ApportVersion: 2.20.1-0ubuntu2
- Architecture: amd64
- DistroRelease: Ubuntu 16.04
- InstallationDate: Installed on 2013-11-08 (915 days ago)
- InstallationMedia: Ubuntu-Server 13.10 "Saucy Salamander" - Release amd64
(20131016)
- Package: cacti 0.8.8f+ds1-4ubuntu4 [modified:
usr/share/cacti/site/lib/database.php]
- PackageArchitecture: all
- ProcVersionSignature: Ubuntu 4.4.0-22.39-generic 4.4.8
- Tags: xenial
- Uname: Linux 4.4.0-22-generic x86_64
- UpgradeStatus: Upgraded to xenial on 2016-05-03 (8 days ago)
- UserGroups: adm cdrom dip lpadmin media plugdev sambashare sudo www-data
- _MarkForUpload: True
- modified.conffile..etc.cron.d.cacti:
- #MAILTO=root
- #*/5 * * * * www-data php --define suhosin.memory_limit=512M
/usr/share/cacti/site/poller.php 2>&1 >/dev/null | if [ -f /usr/bin/ts ] ; then
ts ; else tee ; fi >> /var/log/cacti/poller-error.log
- mtime.conffile..etc.cron.d.cacti: 2016-05-04T14:31:46.265760
+ * This bug renders the cacti and cacti-spine packages nearly useless for most
+users.
+
+ * The fix forces the sql_mode NO_ZERO_DATE setting in the MySQL connection to
+be unset which enables the MySQL INSERT and UPDATE commands that involve
the
+date "-00-00" to succeed.
+
+ [Test Case]
+
+ [ Verify issue ]
+
+ * Install cacti on a xenial system with mysql-server installed, and see it
+fails during the population of the database via dbconfig-common. If the
+dbconfig-common defaults are choosen for the error handling (abort), the
+package fails to install.
+
+ * Install cacti on a wily 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
+upgrade to xenial and see that every five minutes a line like the following
+is added to the /var/log/cacti/cacti.log file:
+
+05/13/2016 06:55:02 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!,
+ Error:'1292', SQL:"INSERT INTO poller_time (poller_id, pid, start_time,
+ end_time) VALUES (0, 4044, NOW(), '-00-00 00:00:00')'
+
+ * Install cacti-spine on a wily 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). Now
+navigate to the settings item, select the poller tab and change the field
+"The poller type to use. This setting will take effect at next polling
+interval." to "spine". Then upgrade to xenial and see that every five
+minutes a line like the following is added to the /var/log/cacti/cacti.log
+file:
+
+05/13/2016 07:50:00 PM - SPINE: Poller[0] ERROR: SQL Failed!
+ Error:'1292', Message:'Incorrect datetime value: '-00-00 00:00:00'
+ for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time
+ (poller_id, pid, start_time, end_time) VALUES (0, 4685, NOW(),
+ '-00-00 00:00:00')'
+
+ [ Verify fix ]
+
+ * Install the proposed cacti package on a xenial system with mysql-server
+installed and very that it installs cleanly.
+
+ * Same as previous point, but also 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). Verify that you see lines
+like the following appear every five minutes
+
+05/13/2016 07:09:59 PM - SYSTEM STATS: Time:298.6378 Method:cmd.php
+ Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5
+ RRDsProcessed:5
+
+and that lines like the following line are absent:
+
+05/13/2016 06:55:02 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!,
+ Error:'1292', SQL:"INSERT INTO poller_time (poller_id, pid, start_time,
+ end_time) VALUES (0, 4044, NOW(), '-00-00 00:00:00')'
+
+ * Install cacti-spine 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 pa
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
I confirm that spine has the issue. Trying to fix that in a similar way. ** Patch added: "First try for cacti-spine fix" https://bugs.launchpad.net/ubuntu/+source/cacti-spine/+bug/1578144/+attachment/4662840/+files/LP1578144_cacti-spine.debdiff -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
** Changed in: cacti-spine (Ubuntu Xenial) Status: New => Confirmed ** Changed in: cacti-spine (Ubuntu Yakkety) Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode
Actually, I was using spine (as a desperate attempt to reduce CPU load) and forgot about it. Switching back to cmd.php and using the supplied patch and all is good. CPU usage back to normal levels again. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1578144 Title: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode To manage notifications about this bug go to: https://bugs.launchpad.net/cacti/+bug/1578144/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
