Akonadi fresh install fails to start with MySQL 5.7
Bug #1572100 reported by
Lars Tangvald
This bug affects 2 people
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| akonadi (Ubuntu) |
Fix Released
|
High
|
Philip Muškovac | ||
Bug Description
On a fresh install with MySQL 5.7, akonadi will fail to start up because
a) mysql_install_db is run with options that are removed in 5.7
--force has been removed, and to keep the old behavior we need to add --insecure and --basedir=/usr
b) Database init sql scripts are rejected by 5.7's stricter default mode: http://
5.7 is more restrictive of allowed values for different column types (no data truncation, no 0-dates, etc.)
A workaround is to add sql_mode=
Bug is also reported, with suggested fixes, in the kde tracker: https:/
Revision history for this message
| Launchpad Janitor (janitor) wrote | #1 |
| Changed in akonadi (Ubuntu): | |
| status: | New → Confirmed |
Revision history for this message
| Silicomancer (private-g) wrote | #3 |
| Changed in akonadi (Ubuntu): | |
| assignee: | nobody → Philip Muškovac (yofel) |
| importance: | Undecided → High |
| milestone: | none → ubuntu-16.04 |
| status: | Confirmed → In Progress |
| tags: | added: kubuntu xenial |
Revision history for this message
| Launchpad Janitor (janitor) wrote | #4 |
| Changed in akonadi (Ubuntu): | |
| status: | In Progress → Fix Released |
To post a comment you must log in.
Status changed to 'Confirmed' because the bug affects multiple users.