FS#24384 - [amarok] doesn't initialize mysql db

Attached to Project: Arch Linux
Opened by Jakub Schmidtke (sjakub) - Sunday, 22 May 2011, 04:53 GMT
Last edited by Andrea Scarpino (BaSh) - Saturday, 06 August 2011, 07:16 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Andrea Scarpino (BaSh)
Architecture x86_64
Severity High
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description:
When starting amarok 2.4.1-1 it displays an error:
"The amarok database reported the following errors:
GREPME MySQLe query failed! (1049) Unknown database 'Reality' on na
In most cases you will need to resolve these errors before Amarok will run properly."

When I start it as 'amarok --debug' it displays, among other things, lots of error
messages about the database:
"[ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL".

When I downgraded to 2.4.0-4 the initial error message was gone,
but the same error messages were still produced with the '--debug' there.

I checked content of ~/.kde4/share/apps/amarok/mysqle and it is empty.
This task depends upon

Closed by  Andrea Scarpino (BaSh)
Saturday, 06 August 2011, 07:16 GMT
Reason for closing:  Not a bug
Additional comments about closing:  configuration issue
Comment by Andrea Scarpino (BaSh) - Sunday, 22 May 2011, 10:20 GMT
Please setup correctly the database and your amarokuser in MySQL.
Comment by Jakub Schmidtke (sjakub) - Sunday, 22 May 2011, 13:25 GMT
  • Field changed: Percent Complete (100% → 0%)
I never had it enabled. I also tried enabling it and disabling again, and removing the entire configuration (config + apps) completely several times now.
Comment by Andrea Scarpino (BaSh) - Sunday, 22 May 2011, 13:26 GMT
please post: $ pacman -Qi amarok mysql
Comment by Jakub Schmidtke (sjakub) - Sunday, 22 May 2011, 13:27 GMT
$ pacman -Qi amarok mysql
Name : amarok
Version : 2.4.1-1
URL : http://amarok.kde.org
Licenses : GPL2 LGPL2.1 FDL
Groups : None
Provides : None
Depends On : kdebase-runtime mysql qtscriptgenerator taglib-extras liblastfm ffmpeg libofa qjson
Optional Deps : libgpod: support for Apple iPod audio devices
libmtp: support for portable media devices
loudmouth: backend needed by mp3tunes for syncing
ifuse: support for Apple iPod Touch and iPhone
libmygpo-qt: gpodder.net Internet Service
Required By : None
Conflicts With : None
Replaces : amarok-base amarok-engine-xine amarok-base-mysqlfree
Installed Size : 46552.00 K
Packager : Andrea Scarpino <andrea@archlinux.org>
Architecture : x86_64
Build Date : Fri 06 May 2011 02:44:56 AM EDT
Install Date : Sun 22 May 2011 12:40:55 AM EDT
Install Reason : Explicitly installed
Install Script : Yes
Description : The powerful music player for KDE

Name : mysql
Version : 5.5.12-1
URL : http://www.mysql.com/
Licenses : GPL
Groups : None
Provides : None
Depends On : mysql-clients
Optional Deps : perl-dbi
perl-dbd-mysql
Required By : akonadi amarok
Conflicts With : None
Replaces : None
Installed Size : 65492.00 K
Packager : Andrea Scarpino <andrea@archlinux.org>
Architecture : x86_64
Build Date : Fri 06 May 2011 08:43:57 PM EDT
Install Date : Sun 08 May 2011 12:42:45 AM EDT
Install Reason : Installed as a dependency for another package
Install Script : Yes
Description : A fast SQL database server
Comment by Jakub Schmidtke (sjakub) - Sunday, 22 May 2011, 13:46 GMT
By the way - is something wrong with bugs.kde.org or with my chromium? When I try to access bugs.kde.org I get redirected to https:// and get a message "The server's security certificate is revoked!"...
Comment by Andrea Scarpino (BaSh) - Monday, 18 July 2011, 07:43 GMT
Status? I cannot reproduce this.
Comment by Jakub Schmidtke (sjakub) - Monday, 18 July 2011, 13:57 GMT
I still get the error message every time I start amarok. With amarok 2.4.1-3 and mysql 5.5.14-1.
Actually I was wondering if the fact that my entire ~/.kde4 is symlinked to another partition (encrypted)
could have anything to do with that... Haven't tested that yet.
Comment by Andrea Scarpino (BaSh) - Friday, 05 August 2011, 09:25 GMT
status? Have you tried amarok 2.4.3?
Comment by Jakub Schmidtke (sjakub) - Friday, 05 August 2011, 12:57 GMT
Yes. Still the same. I kind of got used to it by now... ;)
Comment by Jakub Schmidtke (sjakub) - Saturday, 06 August 2011, 06:41 GMT
I have finally done some more testing with this. And it looks like the problem was with some old, random mysql configuration in ~/.my.cnf file.
Before Amarok switched to using mysqle everything was fine, but once it did, mysqle decided to try to use options from that file.
It feels weird since this is 'embedded', but it's not an issue with Amarok.

Loading...