Description of problem: When Amarok builds the collection it finishes but there is no music listed under local collection. Seems to be an issue with mysql-embedded and current Amarok Version-Release number of selected component (if applicable): See SRPMS How reproducible: Everytime Steps to Reproduce: 1.Build a local collection in Amarok 2. 3. Reproducible: Steps to Reproduce:
Confirmed by mikala on i586 and x86_64.
In fact i just noticed it that it should be fixed with a patch from upstream. Could you test with the amarok-2.4.0-2.mga1
CC: (none) => balcaen.johnSource RPM: mysql-5.5.9 and amarok-2.4.0 => amarok-2.4.0-1.mga1.src.rpm mysql-5.5.9-2.mga1.src.rpm
Still here with 2.4.0-2
CC: (none) => sfietkonstantin
Could you drop amarok config files ? ~/.kde4/share/apps/amarok & ~/.kde4/share/config/amarok* & try again ? Also could you eventually try amarok in debug mode ( amarok --debug) & past the information related to sql ? Regards.
I have drop configs and apps data (1st thing I have done) With debug I have this : amarok: [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL amarok: [ERROR__] [MySqlStorage] Tried to perform escape() on uninitialized MySQL (I'm going to check qt mysql sql plugin ...)
My qt MSQL database plugin is installed ... Everything seems to be ok
on the first start you can get this info, on the second one you should get (i hope) something like : amarok: BEGIN: void CollectionManager::loadServices(const KService::List&) amarok: [CollectionManager] Initialising "mysqle-collection" amarok: defaultsFile "/home/mikala/.kde4/share/apps/amarok/my.cnf" amarok: [MySqlStorage] Connected to MySQL server 5.5.9 amarok: Connected to MySQL server 5.5.9 amarok: [MySqlStorage] Initialized thread, count== 1 Also could you add more info on the error ? does it missing a table or something like that ?
Here it is : BEGIN: void CollectionManager::loadServices(const KService::List&) amarok: [CollectionManager] Initialising "mysqle-collection" amarok: defaultsFile "/home/sk/.kde4/share/apps/amarok/my.cnf" amarok: [ERROR__] Could not connect to mysql! amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (2002) Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) on na" amarok: [MySqlStorage] Initialized thread, count== 1 amarok: BEGIN: bool DatabaseUpdater::update() amarok: [ERROR__] [MySqlStorage] Tried to perform escape() on uninitialized MySQL amarok: [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL amarok: Database version: 0 amarok: BEGIN: void DatabaseUpdater::createTables() const It cannot connect to the mysql base !
There's something wrong in your config : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' it's trying to connect to a local mysql server instead of using mysql embedded. Could you check your amarok configuration (be sure you're not using an external database ) ?
Hum... i can reproduce in fact. Seems like my mysqld was also running... Could try to install & run mysqld, i guess mysqle is going to work now ... :/
I have the same errors, if I try mysql by executing "mysql" I get: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) This is with a clean amarok. What package contains mysqld?
Got it working, stopping ans starting mysqld worked. /etc/rc.d/init.d/mysqld stop /etc/rc.d/init.d/mysqld start Delete the conf files for amarok then rebuild, amarok did have to be restarted to get this to work. I guess something needs to be done to the mysql package.
CC: (none) => thierry.vignaudAssignee: bugsquad => balcaen.john
Same problem here. x86_64 (just to push this a bit forward :))
CC: (none) => Nasenbaer
Could you try amarok-2.4.0.90-1.mga1 i just pushed when it's available ? Mysql-e is now working here :)
Works for me :) Thanks for the fix!
thanks for this good news.
Status: NEW => RESOLVEDCC: (none) => dmorganecResolution: (none) => FIXED
Fixed here as well. Nice work.