[Bug 1565003] [NEW] snmptrapd fails to build with MySQL 5.7

2016-04-01 Thread Lars Tangvald
Public bug reported: MySQL 5.7 restricts which symbols are exported and useable from the outside. The function load_defaults, using in apps/snmptrapd_sql.c is not exported from libmysqlclient20, so the build will fail. However, the function my_load_defaults is exported, and has the same signatur

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-04-01 Thread Lars Tangvald
pitti: Yeah, we have a bug in dbconfig-common (1563274), and a patch ready for mysql-5.7 that downgrades that error to a deprecation warning to give them time to fix it -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. htt

[Bug 1563274] Re: dbconfig-mysql sets blank port in config

2016-03-30 Thread Lars Tangvald
As this isn't a simple fix, and is currently blocking MySQL 5.7 in Ubuntu 16, we will patch MySQL to allow the empty port option for now (it will print a warning instead of the error). There's also a related upstream bug at http://bugs.mysql.com/bug.php?id=80903 ** Bug watch added: MySQL Bug Syst

[Bug 1563274] Re: dbconfig-mysql sets blank port in config

2016-03-29 Thread Lars Tangvald
** Also affects: mysql-5.7 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to dbconfig-common in Ubuntu. https://bugs.launchpad.net/bugs/1563274 Title: dbconfig-mysql sets blank port

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-03-29 Thread Lars Tangvald
Yeah, the copying is an ugly hack, but it's already done to some degree, and has the least risk of breaking anything, I think. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1528583 Titl

[Bug 1563274] [NEW] dbconfig-mysql sets blank port in config

2016-03-29 Thread Lars Tangvald
Public bug reported: For non-remote setups, dbconfig will not set a port value, leaving it blank in generated option files. MySQL 5.7 will no longer accept a blank port option in the config file (See https://github.com/mysql/mysql- server/commit/3d8b4570d1a9d8d03d32e4cd6705b6a2d354e992 for more i

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-03-29 Thread Lars Tangvald
The test failures for dbconfig-common and redmine are due to a) The tests setting empty port options in config files and b) MySQL 5.7 no longer allowing empty options in config file. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the b

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-03-29 Thread Lars Tangvald
Some of the headers that are in include/mysql/mysql are also copied (not moved) to include/mysql, probably to patch this sort of problem. With the way the headers are structured right now I don't really see a very nice way to solve this, so one suggestion is to simply copy everything. -- You rece

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-03-11 Thread Lars Tangvald
The previous comment contains the overview of the upgrade testing we've done. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1528583 Title: [FFe] Please update to MySQL 5.7 series To

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-03-11 Thread Lars Tangvald
1 Background These tests were conducted to verify that MySQL upgrades are possible from from previous Ubuntu releases to Ubuntu 16.04 (Xenial Xerus). There are 3 live Ubuntu versions: - Ubuntu 12.04 LTS (Precise Pangolin) - Ships with MySQL 5.5 - Ubuntu 14.04 LTS (Trusty Tahr)

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-03-10 Thread Lars Tangvald
I'll do a more complete writeup once the testing is complete, but want to follow up on the above comment: I can confirm that the package from ppa:racb/experimental fixes the apparmor issue we saw before. I've also tested the same starting from Precise. So the upgrade from 5.5 in Trusty to 5.7 in

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-03-09 Thread Lars Tangvald
I'm a part of the MySQL engineering team, and have been working with Robie Basak on this for a while -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1528583 Title: [FFe] Please update t

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-03-09 Thread Lars Tangvald
I've redone the basic smoke testing for verifying just the package upgrades. No issues were found during testing. These tests do not include full Ubuntu release upgrades; They were only run on 16.04. To include 5.5 I rebuilt it from the current 5.5.47 source in Debian. The 5.6 packages were used

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-03-08 Thread Lars Tangvald
I've been testing the packages as we work on them, ironing out issues with upgrading from both 5.5 and 5.6 as we go (I'll need to rerun these tests for the currently uploaded package, though). But I've only been testing on Xenial, i.e. installing 5.5/5.6 then replacing with 5.7, so I haven't don

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-02-22 Thread Lars Tangvald
Alternate amarok patch: Changes it to depend on virtual-mysql-server-core instead of changing 5.7 packaging to provide mysql-server-core. ** Attachment added: "Alternative debdiff for amarok package" https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1528583/+attachment/4578102/+files/a

[Bug 1528583] Re: [FFe] Please update to MySQL 5.7 series

2016-02-22 Thread Lars Tangvald
The package libmysqld-pic has been removed as it is obsolete (there was no difference between libmysqld-pic and libmysqld-dev in 5.6 either). The amarok package depends on it, so this dependency needs changing. Attaching debdiff output for the patch. Another note is that it also depends on mysql-

[Bug 1528583] Re: Please update to MySQL 5.7 series

2016-02-15 Thread Lars Tangvald
Packaging has been moved to master branch of https://github.com/ltangvald/mysql-5.7/ and uploaded to https://launchpad.net/~lars-tangvald/+archive/ubuntu/mysql-5.7 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu

[Bug 1528583] Re: Please update to MySQL 5.7 series

2016-01-31 Thread Lars Tangvald
** Changed in: mysql-5.6 (Ubuntu) Status: Triaged => In Progress -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1528583 Title: Please update to MySQL 5.7 series To manage

[Bug 1528583] Re: Please update to MySQL 5.7 series

2016-01-31 Thread Lars Tangvald
I've uploaded the packaging to https://github.com/ltangvald/mysql-5.7/tree/mysql-alt (will add to a ppa as well). Should be ready to start testing and reviewing. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. htt

[Bug 1468185] Re: Function 'innodb' already exists and other errors

2015-12-04 Thread Lars Tangvald
@Robie Yup, I'll post a patch for this -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1468185 Title: Function 'innodb' already exists and other errors To manage notifications ab

[Bug 1516010] Re: "[Warning] TIMESTAMP with implicit DEFAULT value" on install

2015-12-04 Thread Lars Tangvald
The cause is that MySQL used to only support implicit timestamp default value, which is not according to the SQL spec. When this was fixed, it was decided to keep the old behavior for historical reasons, but add a deprecation warning. Adding the suggested value to the config would remove the warni

[Bug 1468185] Re: Function 'innodb' already exists and other errors

2015-12-03 Thread Lars Tangvald
Will try to get a patch for this up tomorrow. Note that it's not a serious error, just output junk, so the workaround is basically to ignore it :) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchp

Re: [Bug 1468185] Re: Function 'innodb' already exists and other errors

2015-11-18 Thread Lars Tangvald
Yes, this seems to be something that was copied over from 5.5 and can be removed. -- Lars On 11/18/2015 11:18 AM, 冯宇 wrote: > +1 Same issue here. > > This might be ha_innodb.so and other files not exist in > /usr/lib/mysql/plugin/, but mysql-server-5.5 contains these files. > -- You received t