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

Bug 833020

Summary: kde-apps/akonadi-21.12.2: README.gentoo wrong upgrade command line
Product: Gentoo Linux Reporter: Sven Eden <sven.eden>
Component: Current packagesAssignee: Gentoo KDE team <kde>
Status: RESOLVED DUPLICATE    
Severity: minor    
Priority: Normal    
Version: unspecified   
Hardware: All   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---

Description Sven Eden 2022-02-10 06:44:37 UTC
The installed README.gentoo.bz2 suggests three steps for each user to perform to ensure that the local mariadb database is sane.

The first two work like they are written, but the third is wrong.

Reproducible: Always

Steps to Reproduce:
1. Install dev-db/mariadb-10.6.5-r1
2. Install kde-apps/kdepim-meta-21.12.2
3. Perform third step (mysql_upgrade) from /usr/share/doc/akonadi-21.12.2/README.gentoo.bz2
Actual Results:  
 ~ $ mysql_upgrade -S /run/user/$(id -u)/akonadi/default/mysql.socket \
         --defaults-file=~/.local/share/akonadi/mysql.conf
mysql_upgrade: unknown variable 'defaults-file=~/.local/share/akonadi/mysql.conf'


Expected Results:  
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
(...)
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
mysql.user                                         OK
(...)
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
akonadi
(...)
akonadi.tagtypetable                               OK
information_schema
performance_schema
sys
sys.sys_config                                     OK
test
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK


The command line is wrong, at least for mariadb-10.6.5

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

It should read:
  mysql_upgrade --defaults-file=~/.local/share/akonadi/mysql.conf \
         -S /run/user/$(id -u)/akonadi/mysql.socket

These two errors are in the line:

1. The argument --defaults-file is now listed as "specified before remaining options" in the mysql_ugrade help text, and has to come first.

2. The socket is not in
  /run/user/$(id -u)/akonadi/default/mysql.socket
but in
  /run/user/$(id -u)/akonadi/mysql.socket

Note: The other two steps in the README use the correct socket path
Comment 1 Andreas Sturmlechner gentoo-dev 2022-02-10 18:08:09 UTC

*** This bug has been marked as a duplicate of bug 792741 ***