2 XBMC PCs and 1 Database on the shared NAS - Printable Version
+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)
- blacklist - 2010-06-20 03:30
craigd Wrote:@ WisdomWolf, I suck on db's, really need to start learning them more, but download mysql workbench and it's fairly easy to delete shemes and tables from the gui, http://dev.mysql.com/downloads/workbench/5.2.html
I HIGHLY recommend HeidiSQL.
Open Source, Free, and super simple to edit, add, manipulate, etc mySQL servers.
- Cyb3rH4Xter - 2010-06-21 00:22
I have created the advancedsettings.xml in the right directory and have written this into it:
And this is from the XBMC log:
Quote:00:09:44 T:524 M:1505951744 NOTICE: Loaded advancedsettings.xml from special://profile/advancedsettings.xml
But it's still creating a sqlite3 db file and not touching my db What have i done wrong?
- blacklist - 2010-06-21 04:24
Cyb3rH4Xter Wrote:I have created the advancedsettings.xml in the right directory and have written this into it:
did you actually create the xbmc_movies database in mysql?
- Cyb3rH4Xter - 2010-06-21 08:17
Yep its created.
- Cyb3rH4Xter - 2010-06-21 22:12
I'm going mad at this now! Does anyone know what can be the problem?
- charrua - 2010-06-21 22:28
Cyb3rH4Xter Wrote:I'm going mad at this now! Does anyone know what can be the problem?Paste the full log in pastebin.com and post the link here.
- Cyb3rH4Xter - 2010-06-22 16:52
here's the log, running theme Dark Legacy and XBMC Live latest installed on hdd.
- charrua - 2010-06-22 17:11
Cyb3rH4Xter Wrote:http://pastebin.com/RfumRpT2It doesn't have anything about connecting to any database, try to paste a bigger piece of the log, or try to identify the part that shows when XBMC tries to connect to the DB.
- Cyb3rH4Xter - 2010-06-22 17:36
This is the whole latest log after a restart of the system. It's like ignoring my setting. What i have done before i restarted and this new log was created:
I deleted the VideoDb file, deleted the video source.
After the restart:
I added a new source and scanned it's contents. It created a new videoDB file
I can't find anywhere in any log that it tries to connect to a db. I have tested this on 2 of my computers running XBMC, one XBMC Live i mentioned, and one W7 XBMC.
- charrua - 2010-06-22 17:51
Cyb3rH4Xter Wrote:This is the whole latest log after a restart of the system. It's like ignoring my setting. What i have done before i restarted and this new log was created:
You missed the <port> tag in videodatabase section of the advancedsettings.xml
By default it is 3306. Try adding it.