Reply to topic

The amarok database reported the following errors...

guilledan
Registered Member
Posts
3
Karma
0
While updating from 2.6 to 2.7 Amarok show this legens on start up:

"The amarok database reported the following errors:
GREPME MySQL-server query failed! (2003) Can't connect to MySQL server on 'localhost' (10061) on na
In most cases you will need to resolve these errors before Amarok will run properly."

Now i cant use mysql to manage the local collection

¿Anyone knows how to fix this issue?

Thanks!
User avatar bcooksley
Administrator
Posts
18586
Karma
83
OS
In Amarok > Settings > Configure Amarok > Database, please make sure "Use external MySQL database" is unchecked.


System Settings and Device Actions KCM maintainer
Image
Dogges
Registered Member
Posts
7
Karma
0
OS
I often get the same message.
But after starting amarok a second time, the message disappears and amarok starts without any further error messages.
Do you have any network devices added to your playlists? It seems, that amarok can't handle them properly. :(
Perhaps, somebody knows a solution for this.
User avatar bcooksley
Administrator
Posts
18586
Karma
83
OS
Are these attached network drives, or simple network shares which you access via "\\serverName\share"?


System Settings and Device Actions KCM maintainer
Image
guilledan
Registered Member
Posts
3
Karma
0
bcooksley wrote:In Amarok > Settings > Configure Amarok > Database, please make sure "Use external MySQL database" is unchecked.

but... I want to use MySQL to handle my local colection... And I'm not using any external device: all my music is in my hard drive.
And if Amarok starts after the error it wont display any file in Local Colection.
Now I've unchecked "Use external MySQL database" so I can use Amarok anyway, but I think that It will decrease It's performance (100 Gb of music).
User avatar Mamarok
Manager
Posts
2916
Karma
8
OS
Amarok by default uses the internal MySQL embedded database, no need for an external one, and there are no performance issues at all.


Mamarok, hanging out in the Amarok forum since August, 2007
Currently running Kubuntu Trusty 14.04, KDE 4.12.95, Amarok 2.8-git of the day
Dogges
Registered Member
Posts
7
Karma
0
OS
Mamarok wrote:Amarok by default uses the internal MySQL embedded database, no need for an external one, and there are no performance issues at all.

... and how can I import all information of my external MySQL-amarok-database-content into the embedded one?
Dogges
Registered Member
Posts
7
Karma
0
OS
bcooksley wrote:Are these attached network drives, or simple network shares which you access via "\\serverName\share"?

Sorry, but what is the exact difference between those device types?
I use a simple NAS with Twonkey; in Windows I have access to my music-files via "\\serverName\music".
User avatar bcooksley
Administrator
Posts
18586
Karma
83
OS
In that case, using the existing external MySQL server is probably the better option - just make sure to configure the settings correctly.

The difference is that "attached network drives" are mounted into the system (under Windows, these would be given a drive letter such as Z:) while "simple network shares" are accessed via paths such as "\\serverName\share". The difference between them is purely in how the client interacts with them - and has nothing to do with the server.


System Settings and Device Actions KCM maintainer
Image
Dogges
Registered Member
Posts
7
Karma
0
OS
bcooksley wrote:In that case, using the existing external MySQL server is probably the better option - just make sure to configure the settings correctly.

The difference is that "attached network drives" are mounted into the system (under Windows, these would be given a drive letter such as Z:) while "simple network shares" are accessed via paths such as "\\serverName\share". The difference between them is purely in how the client interacts with them - and has nothing to do with the server.


Thanks for your short description.
I followed mamarok's advice and choosed the embedded MySQL database. My network drive is given a drive letter Y., so I imported the complete directory as a new collection. After restart of amarok the local collection with all music-files is available.
Don't know why I cannot use the external MySQL-database in the same manner as well?
User avatar bcooksley
Administrator
Posts
18586
Karma
83
OS
In theory at least, you should be able to use the external MySQL server - however that will probably depend on all machines using that database having the same paths to the files on disk I suspect.


System Settings and Device Actions KCM maintainer
Image
guilledan
Registered Member
Posts
3
Karma
0
Ok, thanks you for the support.

 
Reply to topic

Bookmarks



Who is online

Registered users: alake, Baidu [Spider], bcooksley, Bing [Bot], colomar, dehnhardt, einar, Exabot [Bot], garthecho, ggael, Google [Bot], google01103, GreatEmerald, industrie13, inhiway, ivan, jensreuterberg, koriun, lazyit, Majestic-12 [Bot], nezumi, private_lock, SecretCode, tknight, urgo, valoriez, wolfi323, Yahoo [Bot]