2 XBMC PCs and 1 Database on the shared NAS - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111) +---- Forum: Windows (https://forum.kodi.tv/forumdisplay.php?fid=59) +---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603) |
- blacklist - 2010-06-20 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. http://www.heidisql.com/ Open Source, Free, and super simple to edit, add, manipulate, etc mySQL servers. - Cyb3rH4Xter - 2010-06-21 I have created the advancedsettings.xml in the right directory and have written this into it: Code: <advancedsettings> 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 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 Yep its created. - Cyb3rH4Xter - 2010-06-21 I'm going mad at this now! Does anyone know what can be the problem? :S - charrua - 2010-06-21 Cyb3rH4Xter Wrote:I'm going mad at this now! Does anyone know what can be the problem? :SPaste the full log in pastebin.com and post the link here. - Cyb3rH4Xter - 2010-06-22 http://pastebin.com/RfumRpT2 here's the log, running theme Dark Legacy and XBMC Live latest installed on hdd. - charrua - 2010-06-22 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 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 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. - wstewart - 2010-06-22 Cyb3rH4Xter Wrote:Yep its created. Looks like your connecting over a network. Did you grant permission to the database to allow external connections? By default (on linux), external network connections to mysql are disabled. I think there`s a setting in /etc/mysql/my.cnf that you have to change also. Is the firewall on your mysql serving blocking incoming requests? - charrua - 2010-06-22 wstewart Wrote:Looks like your connecting over a network. Did you grant permission to the database to allow external connections? By default (on linux), external network connections to mysql are disabled. I think there`s a setting in /etc/mysql/my.cnf that you have to change also.The strange thing is that in the log there is nothing indicating a connection error. It seems that XBMC is not even trying to connect to the MySQL db. - Cyb3rH4Xter - 2010-06-22 wstewart Wrote:Looks like your connecting over a network. Did you grant permission to the database to allow external connections? By default (on linux), external network connections to mysql are disabled. I think there`s a setting in /etc/mysql/my.cnf that you have to change also. Nope, i can connect to the mysql on the W7 computer through Navicat and PhpmyAdmin. But now i think i know the problem. Attitude. The logfile should look like this instead: Code: 22:09:46 T:3078772608 M:1478246400 NOTICE: Loaded advancedsettings.xml from special://profile/advancedsettings.xml No but seriously, this is wierd, it's not giving any errors, just ignores it. - charrua - 2010-06-22 Cyb3rH4Xter Wrote:I insist, the <port> setting is not there... Check again, cause that could be the problem. - Cyb3rH4Xter - 2010-06-22 Oh i had that setting there like 4 posts ago, but removed it because à guy didn't have it in an earlier post in this topic. So nope, thats not the problem |