Re: [SlimDevices: Plugins] TrackStat and Amarok MySQL
that was it. I restarted CPU 2 then I restarted SC on CPU 1 and it works flawlessly. For some reason just restarting MySQL on CPU2 and then restarting SC on CPU1 did not work (this had been what I was trying)...I wonder why the need for the full reboot? Thanks! -- evencoil evencoil's Profile: http://forums.slimdevices.com/member.php?userid=19329 View this thread: http://forums.slimdevices.com/showthread.php?t=59195 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] TrackStat and Amarok MySQL
Do you get any other errors the first time it tries to connect after SqueezeCenter has been restarted ? The Amarok integration currently only connects the first time, so I'm not sure how it works if you for example restart CPU 2 but not CPU 1. Could this be the problem ? I assume you have entered the correct username and password in the Amarok settings in the Custom Scan interface ? Which version of the TrackStat and Custom Scan plugins are you using ? Which version of SqueezeCenter are you using ? If you are able to connect from CPU 1 with the mysql command, I don't think the problem is on the mysql side, but to make sure you can check the /var/log/mysql/* and /var/log/syslog files on CPU 2 to see if you get any access denied messages in the logs. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=59195 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] TrackStat and Amarok MySQL
A question for Erland I think. I'm trying to do the following: CPU 1: Runs SC. Hosts the SC default mySQL database. CPU 2: Hosts an Amarok mySQL database. And then use CustomScan to dynamically update to the Amarok database, by changing the Amarok database URL in CustomScan options to Code: dbi:mysql:hostname=192.168.1.100;port=3306;database=amarok Here's the error I am getting; Code: [09-02-02 21:53:52.8862] Plugins::TrackStat::Amarok::Export::writeTrack (195) Exporting track: ./music/collection/Pink Floyd/The Piper At The Gates Of Dawn/09. Chapter 24.mp3 [09-02-02 21:53:52.8870] Slim::Utils::Misc::msg (1398) Warning: [21:53:52.8866] DBD::mysql::st execute failed: MySQL server has gone away at Plugins/TrackStat/Amarok/Export.pm line 203. [09-02-02 21:53:52.8875] Slim::Utils::Misc::msg (1398) Warning: [21:53:52.8872] Use of uninitialized value in string ne at Plugins/TrackStat/Amarok/Export.pm line 204. [09-02-02 21:53:52.8879] Plugins::TrackStat::Amarok::Export::writeTrack (204) Track exported: ./music/collection/Pink Floyd/The Piper At The Gates Of Dawn/09. Chapter 24.mp3 [09-02-02 21:53:52.8886] Slim::Utils::Misc::msg (1398) Warning: [21:53:52.8882] DBD::mysql::st execute failed: MySQL server has gone away at Plugins/TrackStat/Amarok/Export.pm line 217. [09-02-02 21:53:52.8891] Plugins::TrackStat::Plugin::setTrackStatStatistic (4514) Exiting setTrackStatStatistic Ok so that's pretty clear; its not connecting to the Amarok database. I realize there are some special steps I need to do to open up mySQL to a LAN connection, but I think I did them correctly. When I am on CPU 1 I can do; Code: mysql -u amarok -h 192.168.1.100 -p and successfully log into CPU 2's MySQL (that's IP 192.168.1.100). Is there something else I can check check? I had this working fine when it was CPU 1 hosting the Amarok database as well, so it seems like some sort of MySQL networking issue. Thanks! -- evencoil evencoil's Profile: http://forums.slimdevices.com/member.php?userid=19329 View this thread: http://forums.slimdevices.com/showthread.php?t=59195 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins