Re: [kde-linux] amarok dislikes mysql - at least, when you're not root.

Philipp Paul wrote:
hi all,

today i decided to switch the database that amarok uses from SQLite to
MySQL.

i created a new database called 'amarok' and a seperate user, that has
all rights (including GRANT) in this -and only this- database.
so i got into the amarok settings, and submitted all necessary
information to make amarok work with mysql.

but since then, nothing works anymore.
i restarted amarok, and all there goes is the splash screen.
using 'top' i can see, that it is running.
but there is now tray icon, there is no playlist-window, and there is no
player.
so in the first moment i thought, maybe the console output may give some
more information.
but all there comes is:

Amarok: [Loader] Amarok is taking a long time to load! Perhaps something
has gone wrong?

VERY useful.

my next thought was, maybe amarok is in disharmony with mysql, so i
started:
amarok --wizard
in the command line.
i switched back to SQLite and clicked finish.

i started amarok once again, and there we go again: nothing.
pretty strange, huh?

well, then i decided to get back to mysql, because i know it works. at
least it worked with previous installations.
this time i made amarok access the database as root.
and there you go, it worked.
but the real strange thing is, afterwards, i decided to change the
settings back, to let amarok access mysql as the appropriate user (the
one mentioned in the beginning). and then restarting amarok switched me
back to the point i was in the beginning.
(but this time the tray-icon and the playlist-window appeared, at least)

mmhhmh..

any ideas?
i don't want to let amarok access the db as root. (that gives me a
uncomfortable feeling).
did that happened to anyone before?

i mean i can live with, letting access root the db till i find a fix,
but i just can't explain why SQLite won't work anymore if MySQL has the
wrong login information.

and if anyone knows: what rights does the user != root need to make it
work with amarok (maybe some global rights)

I think that your mistake was creating the data base rather than letting
Amarok create it. So, I would recommend deleting the database you
created and then start Amarok. In the Configure Amarok KCM, under
Collections, give it the information including your MySQL user name and
password and let it create the database.

--
JRT
___________________________________________________
This message is from the kde-linux mailing list.
Account management: https://mail.kde.org/mailman/listinfo/kde-linux.
Archives: http://lists.kde.org/.
More info: http://www.kde.org/faq.html.

Relevant Pages

  • Re: amarok 1.3.5 and mysql???
    ... > the mysql dependence to appear (just because there is nothing special ... Why not just grab the source RPM and modify the spec file to make sure Amarok is ...
    (Fedora)
  • Re: Irrsinnige SQLite-"Datenbank" in digikam
    ... Kostet halt mehr Performance, mehr RAM und ist für den Benutzer mehr ... ich bin von Amarok begesitert seit ich auf MySQL umgestellt habe. ...
    (de.comp.os.unix.apps.kde)
  • [kde-linux] amarok dislikes mysql - at least, when youre not root.
    ... i created a new database called 'amarok' and a seperate user, ... to make amarok work with mysql. ... i switched back to SQLite and clicked finish. ...
    (KDE)
  • Re: Yum disaster! DELETED mysql!
    ... I didn't change anything on mysql. ... > um..For some silly reason I have Amarok on this machine. ... > Amarok told yum to do it. ... The -y switch is for updates, ...
    (Fedora)
  • Re: Worst Linux Interfaces: Vote here:
    ... In the "Database" drop down menu, select MySQL and then fill in the ... then your copy of amaroK is not compiled with mySQL support- You ... /* Ugly, ugly fucker. ...
    (alt.os.linux.suse)