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
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
