2012-05-28, 20:05
I am having some trouble getting the sql database to work together, I am probably omitting something pretty simple. I have two machines an one atv with crystal buntu and one aspire revo with xbmcbuntu. I can see the database when I run show databases; in this case I named it bob60 and I am getting counts for each database part when running SELECT COUNT(*) from databasename.movie; SELECT COUNT(*) from databasename.tvshow; However when media is either watched, or paused/stopped I cannot resume it from the other machine. In my advanced settings.xml file I added:
<videodatabase>
<type>mysql</type>
<host>192.168.1.3</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>bob</name>
</videodatabase>
Here is the Debug log for my revo with crystalbuntu
http://xbmclogs.com/show.php?id=3041
Here is the Debug log for ATV
(Will be added shortly)
<videodatabase>
<type>mysql</type>
<host>192.168.1.3</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>bob</name>
</videodatabase>
Here is the Debug log for my revo with crystalbuntu
http://xbmclogs.com/show.php?id=3041
Here is the Debug log for ATV
(Will be added shortly)