2 XBMC PCs and 1 Database on the shared NAS

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)

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

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

<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

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 What have i done wrong?

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? :S

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

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

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

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.

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

Is the firewall on your mysql serving blocking incoming requests?

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.

Is the firewall on your mysql serving blocking incoming requests?

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

22:09:46 T:3078772608 M:1478246400  NOTICE: Contents of special://profile/advancedsettings.xml are...

                                            <advancedsettings>

                                              <videodatabase>

                                                <type>mysql</type>

                                                <host>192.168.1.8</host>

                                                <user>xbmc</user>

                                                <pass>xbmc</pass>

                                                <name>xbmc</name>

                                              </videodatabase>

                                            </advancedsettings>

[b]22:09:46 T:3078772608 M:1478246400  NOTICE: Detected that the user wants to mess with my settings.....GO FUCK HIM! .....and ignore everything![/b]

No but seriously, this is wierd, it's not giving any errors, just ignores it.

- charrua - 2010-06-22

Cyb3rH4Xter Wrote:
Code:
22:09:46 T:3078772608 M:1478246400 NOTICE: Loaded advancedsettings.xml from special://profile/advancedsettings.xml 22:09:46 T:3078772608 M:1478246400 NOTICE: Contents of special://profile/advancedsettings.xml are... <advancedsettings> <videodatabase> <type>mysql</type> <host>192.168.1.8</host> <user>xbmc</user> <pass>xbmc</pass> <name>xbmc</name> </videodatabase> </advancedsettings>
No but seriously, this is wierd, it's not giving any errors, just ignores it.

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 Sad