Friday, March 2, 2012

Logitech Media Server & MySQL

Logitech, in their infinite wisdom, has decided to rename slimserver to SqueezeCenter then Squeezebox Server and finally Logitech Media Server.
Because I like to run it on my NAS, I despise the embedded SQLite and always want it to use MySQL instead. This has always been well-documented in the slimdevices wiki.
When these steps are applied to Logitech Media Server, it reverts to SQLite on it's own.

After some troubleshooting i found updated instructions here. For the tl;dr folks, here's the relevant lines to server.prefs:
dbtype: MySQL
dbusername: slimserver
dbpassword: slimserver
dbsource: dbi:mysql:database=slimserver;mysql_socket=/var/lib/mysql/mysql.sock
 I can't wait to see how they will name v8 - and how they'll change the config settings once more. Sigh.

1 comment:

Anonymous said...

Thank you for sharing information.

Logitech Media Server Version 7.9.0 on Synology DSM 6.1.x needs for MariaDB 10:
'mysql_socket=/var/lib/mysql/mysql.sock'

Conclusion: Media Server is running, but unfortunately this will cause a bunch of Server-Errors during scan. So I felt more secure changing back to SQLite.