Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 792741

Summary: kde-apps/akonadi-20.12.3: manual post installation MySQL upgrade instructions are potentially wrong
Product: Gentoo Linux Reporter: Theo Baumgartner <theo.baumgartner>
Component: Current packagesAssignee: Gentoo KDE team <kde>
Status: RESOLVED FIXED    
Severity: normal CC: ionen, sven.eden
Priority: Normal    
Version: unspecified   
Hardware: AMD64   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---

Description Theo Baumgartner 2021-05-29 07:45:51 UTC
I went through the post installation instructions and the following command didn't worked for me:

mysql_upgrade -S /run/user/$(id -u)/akonadi/default/mysql.socket --defaults-file=~/.local/share/akonadi/mysql.conf

it gave me the error:
mysql_upgrade: unknown variable 'defaults-file=~/.local/share/akonadi/mysql.conf'

According to "mysql_upgrade --help" the --defaults-file option is "specified before remaining options"

So, changing the command to:
mysql_upgrade --defaults-file=~/.local/share/akonadi/mysql.conf -S /run/user/$(id -u)/akonadi/default/mysql.socket

gave me this:
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/user/1000/akonadi/default/mysql.socket' (2)
FATAL ERROR: Upgrade failed

When checking where mysql.socket is I found out that it's in the path /run/user/1000/akonadi/

So, doing:
mysql_upgrade --defaults-file=~/.local/share/akonadi/mysql.conf -S /run/user/$(id -u)/akonadi/mysql.socket

Actually upgraded the DB successfully.

Reproducible: Always

Steps to Reproduce:
1. See Description
Actual Results:  
Akonadi MySQL DB doesn't get (manually) upgraded due to wrong instructions.

Expected Results:  
Akonadi MySQL DB should be upgraded
Comment 1 Andreas Sturmlechner gentoo-dev 2022-02-10 18:08:09 UTC
*** Bug 833020 has been marked as a duplicate of this bug. ***
Comment 2 Larry the Git Cow gentoo-dev 2022-02-10 19:08:36 UTC
The bug has been referenced in the following commit(s):

https://gitweb.gentoo.org/proj/kde.git/commit/?id=3f270384bb3680af84a39b5dd741e03ba9e7fa3f

commit 3f270384bb3680af84a39b5dd741e03ba9e7fa3f
Author:     Andreas Sturmlechner <asturm@gentoo.org>
AuthorDate: 2022-02-10 19:04:27 +0000
Commit:     Andreas Sturmlechner <asturm@gentoo.org>
CommitDate: 2022-02-10 19:07:17 +0000

    kde-apps/akonadi: Fix README.gentoo with newer mariadb/akonadi
    
    Bug: https://bugs.gentoo.org/792741
    Reported-by: Theo Baumgartner <theo.baumgartner@gmail.com>
    Reported-by: Sven Eden <sven.eden@prydeworx.com>
    Package-Manager: Portage-3.0.30, Repoman-3.0.3
    Signed-off-by: Andreas Sturmlechner <asturm@gentoo.org>

 kde-apps/akonadi/files/README.gentoo | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)
Comment 3 Larry the Git Cow gentoo-dev 2022-02-10 20:10:11 UTC
The bug has been closed via the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=1b255239ae8403b699534092d672a18063f27536

commit 1b255239ae8403b699534092d672a18063f27536
Author:     Andreas Sturmlechner <asturm@gentoo.org>
AuthorDate: 2022-02-10 19:04:27 +0000
Commit:     Andreas Sturmlechner <asturm@gentoo.org>
CommitDate: 2022-02-10 20:09:51 +0000

    kde-apps/akonadi: Fix README.gentoo with newer mariadb/akonadi
    
    Closes: https://bugs.gentoo.org/792741
    Reported-by: Theo Baumgartner <theo.baumgartner@gmail.com>
    Reported-by: Sven Eden <sven.eden@prydeworx.com>
    Package-Manager: Portage-3.0.30, Repoman-3.0.3
    Signed-off-by: Andreas Sturmlechner <asturm@gentoo.org>

 kde-apps/akonadi/files/README.gentoo | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)