[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

[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

[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

[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,

[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

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

[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

[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.

[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

[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

[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.

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?

[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

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.

[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

[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

[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

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

[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

[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)"

[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

[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

[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:

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

[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

[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

[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

[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

[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

[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"

[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

[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

[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.

[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