linux.dsplabs.com.au/forums

[QuantumKnot]

Rather than using the default SQLITE database, you can tell amarok to use either MySQL or PostgreSQL. I've chosen the latter and followed the instructions at the following link.

http://amarok.kde.org/wiki/Postgresql_HowTo

However, on Fedora 7 (and possibly 8), this leads to an authentication problem. After many hours, I figured out that you need to change some settings in the following file: /var/lib/pgsql/data/pg_hba.conf

Code: Select all

host all all 127.0.0.1/32 ident sameuser

Change this line to:

Code: Select all

host all all 127.0.0.1/32 password sameuser

[kamil]

I have been selecting MySQL database for amarok on fresh distro installs, but will try PostgreSQL next time... It is handy to know where the configs for PostgreSQL are located (/var/lib/pgsql/data/pg_hba.conf)... cheers

[Muhibbah]

I have not tried postgres for amarok. I will check the tutorial in future when I have to configure postgres for amarok.

I have used both mysql and postgres with Fedora core 7 and 8. I did not face any problem with mysql. Mysql automatically got installed with Fedora installation. The configuration files locates at /var/lib/mysql.

I have faced authentication issues with postgres. But most of the time, I manage to resolve them by editing pg_hba.conf.
Postgresql.conf is also very important to configure postgres.

[jhonsm26]

I was also facing such kind of problems, thanks for suggesting
alternatives, as soon as possible i will try postgres for amarok.