XBMC Community Forum
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)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77

- 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.

http://www.heidisql.com/

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:

Code:
<advancedsettings>
<videodatabase>
  <type>mysql</type>
  <host>192.168.1.8</host>
  <port>3306</port>
  <user>root</user>
  <pass>*****</pass>
  <name>xbmc_movies</name>
</videodatabase>
</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
00:09:44 T:524 M:1505943552 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.8</host>
<port>3306</port>
<user>root</user>
<pass>*****</pass>
<name>xbmc_movies</name>
</videodatabase>
</advancedsettings>


But it's still creating a sqlite3 db file and not touching my db Sad 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:

Code:
<advancedsettings>
<videodatabase>
  <type>mysql</type>
  <host>192.168.1.8</host>
  <port>3306</port>
  <user>root</user>
  <pass>*****</pass>
  <name>xbmc_movies</name>
</videodatabase>
</advancedsettings>

And this is from the XBMC log:





But it's still creating a sqlite3 db file and not touching my db Sad What have i done wrong?

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? Confused

- charrua - 2010-06-21 22:28

Cyb3rH4Xter Wrote:I'm going mad at this now! Does anyone know what can be the problem? Confused
Paste the full log in pastebin.com and post the link here.

- Cyb3rH4Xter - 2010-06-22 16:52

http://pastebin.com/RfumRpT2

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/RfumRpT2

here's the log, running theme Dark Legacy and XBMC Live latest installed on hdd.
It 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 Sad

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:

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 Sad

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.

You missed the <port> tag in videodatabase section of the advancedsettings.xml
By default it is 3306. Try adding it.