+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Announcements, Info, and General Discussion (/forumdisplay.php?fid=85)
+--- Forum: Tips, tricks, and step by step guides (/forumdisplay.php?fid=110)
+--- Thread: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker (/showthread.php?tid=80829)
- darkscout - 2011-11-16 19:38
You're going to have to rephrase that. You exported. Imported. And nothing is there? What does your debug log say?
- Klyde - 2011-11-17 16:15
I'm running into a similiar issue. Since I set this up, both PC's see the same library. But my tv shows when scanned only show the first episode of each season in the library? some of my movies are missing and I'm no longer able to flag media as watched? Any suggestions? Never got any errors with the MYSQL syntax, when I show databases and users they appear to be correct. Once I remove that advancedsettings.xml file from the folder my whole library reappears
- darkscout - 2011-11-17 16:30
Debug.
Log.
- Klyde - 2011-11-17 17:05
Hopefully this is the part you require
Quote:09:59:38 T:3596 M:1104936960 NOTICE: Loaded advancedsettings.xml from special://profile/advancedsettings.xml
09:59:38 T:3596 M:1104936960 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>172.16.1.202</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>172.16.1.202</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>
09:59:38 T:3596 M:1104928768 WARNING: VIDEO database configuration is experimental.
I'm wondering if the last line has something to do with it?
- darkscout - 2011-11-17 18:10
No. That's basically just a dump of your advanced settings file.
We need the whole thing (in a pastebin, do NOT paste it here).
- Klyde - 2011-11-17 20:41
Hopefully this is the right log file
thanks for the help
- darkscout - 2011-11-17 23:36
Code:
MySQL error: Code (1062)That's a new one.
- Finchy - 2011-11-25 23:16
dsimages Wrote:this is what i did to get mine working.... Im on openelec though. I believe its dharma 10.1
You need to make sure your firewall has whatever port your using open, then flush privledges on the mysql, then grant all on.
http://openelec.tv/forum/14-general-help-and-support/15344-mysql-not-working
I've been away but am trying to do this again but am still having problems getting it to work. MySQL is definately installed as I can access it with SQLyog installed on my Home Server. However, when XBMC runs it's just hanging, and if I try to connect to SQLyog from my PC it won't connect. Are there any specific user accounts and/or permissions I need to grant to give access? Or is it something else I'm doing wrong?
- darkscout - 2011-11-26 01:53
Well. What does your DEBUG LOG SAY?
- Finchy - 2011-11-26 03:30
How do I find that? I have very limited knowledge of SQL, btw!
