MySQL Database: Multiple XBMC HTPC's with 1 Shared Library

tommymsw · 2012-02-29 18:32

Can somebody help me with this? I have tried several times over the last few years on several systems and never can get it to even pretend to work. I must be missing something.
I am setting this up on a NAS now. This is what I did:
#mysql -u root -p
>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
>GRANT ALL ON *.* TO 'xbmc';
>exit
Then deleted the library file on a XBMC (to get a fresh library install hoping this would help) Placed the advanedsettings.xml in the right directory:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>***.***.***.***</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>***.***.***.***</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
</advancedsettings>
With my NAS IP in the correct spot.

FYI... I don't have a "music" library set up on any systems.

Added the video directory to the XBMC and allowed it to build a library. Then checked for library:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
+--------------------+
2 rows in set (0.13 sec)

I have never been able to get mysql to make a library. It is like the xbmc devices all ignore the .xml

block134 · 2012-02-29 19:05

Just going by the info you gave I would check firewalls/port settings and make sure you are using the ip address for the computer that has the MySQL server on it in your advanced settings file. If you are not using music then you do not need to add that to the advanced settings file. Also make sure you are putting the advanced.xml under the userdata folder. For Win7 you can find it at

Code:

C:\Users\Account Name Here\AppData\Roaming\XBMC\userdata

This is what mine looks like using Eden RC1

Code:

<advancedsettings>

<video>

    <!-- Compensate display latency (video lag). Latency is given in msecs. -->

    <latency>

      <!-- Global default display latency -->

      <delay>0</delay>

    </latency>

</video>

 <!-- Video database for sharing MySQL, IP addy needs to be from the MySQL Server, use static IP on that computer. -->

    <videodatabase>

        <type>mysql</type>

        <host>192.168.1.109</host>

        <port>3306</port>

        <user>root</user>

        <pass>XXXXX</pass>

    </videodatabase>

 <!-- Shares Thumbnails with all computers, use IP addy of computer hosting the files, use a static IP addy. -->

  <pathsubstitution>

    <substitute>

      <from>special://masterprofile/Thumbnails/</from>

      <to>smb://192.168.1.109/Thumbnails/</to>

    </substitute>

  </pathsubstitution>

</advancedsettings>

If you still have problems I would recommend adding a debug log. Something else you can try is to completely re-install MySQL so that it has the correct settings, make sure you use the standard configuration. If you do reinstall that make sure you delete all of the folder and files the uninstall likes to leave behind.

tommymsw · 2012-02-29 20:14

No matter what I do, mysql will not make a database. I shut off firewall, the IP address is correct. The mysql has the user name (I also tried "root").

It's like xbmc is ignoring the .xml file. There is no "fail" or "error" when the .xml fails, it just ignores it completely!

Morpio · 2012-02-29 21:21

It is the same with my installation. I can't get XBMC (11.0 RC1) to use the MySql database tables.

How can we debug this problem?

darkscout · 2012-03-01 06:42

Sure. With some DEBUG LOGS.

tommymsw · 2012-03-01 08:23

Want to tell me how to place a debug log? Please?
I would just like to get this working. I have tried for quite some time on MANY different machines every way imaginable and have yet to get the mysql to write the database.

I started back when you had to manually make the databases, and then got re-excited when you didn't have to do that anymore, and now I even went out and bought a NAS figuring it would be easier than doing it on a PC. NOTHING I do even pretends to work! This sucks!

I don't see how 3 lines of code can get messed up! It looks so simple. I have done things that require pages of code and gotten them to work no problem. I just think xbmc is ignoring the .xml file. I have placed it on 6 different systems in my home, pc, laptop, htpc, new systems, old systems... and nothing.

And I "searched" my question first and went through 3 pages of "results" and didn't find one of them that pertained to my problem. I would MUCH rather read the answer to the problem then have to wait for help.

tommymsw · 2012-03-01 08:26

When I search "problem sharing library mysql" I get exactly two results:
http://forum.xbmc.org/showthread.php?tid...rary+mysql
http://forum.xbmc.org/showthread.php?tid...rary+mysql

**jmarshall** · 2012-03-01 08:37

Again, generate a debug log (Settings->System->Debugging) - where it is will depend on your OS - see the links in my sig.

tommymsw · 2012-03-01 09:10

This is what I get in reference to advanced settings:
02:04:44 T:2648 NOTICE: -----------------------------------------------------------------------
02:04:44 T:2648 NOTICE: Starting XBMC (11.0-RC1 Git:20120226-30312f1), Platform: Windows 7, 32-bit Service Pack 1 build 7601. Built on Feb 26 2012 (compiler 1600)
02:04:44 T:2648 NOTICE: Intel® Atom™ CPU D525 @ 1.80GHz
02:04:44 T:2648 NOTICE: Desktop Resolution: 1280x1024 32Bit at 60Hz
02:04:44 T:2648 NOTICE: Running with restricted rights
02:04:44 T:2648 NOTICE: Aero is enabled
02:04:44 T:2648 NOTICE: special://xbmc/ is mapped to: C:\Program Files\XBMC
02:04:44 T:2648 NOTICE: special://xbmcbin/ is mapped to: C:\Program Files\XBMC
02:04:44 T:2648 NOTICE: special://masterprofile/ is mapped to: C:\Users\Z-BOX\AppData\Roaming\XBMC\userdata
02:04:44 T:2648 NOTICE: special://home/ is mapped to: C:\Users\Z-BOX\AppData\Roaming\XBMC\
02:04:44 T:2648 NOTICE: special://temp/ is mapped to: C:\Users\Z-BOX\AppData\Roaming\XBMC\cache
02:04:44 T:2648 NOTICE: The executable running is: C:\Program Files\XBMC\XBMC.exe
02:04:44 T:2648 NOTICE: Local hostname: Z-BOX-PC
02:04:44 T:2648 NOTICE: Log File is located: C:\Users\Z-BOX\AppData\Roaming\XBMC\xbmc.log
02:04:44 T:2648 NOTICE: -----------------------------------------------------------------------
02:04:44 T:2648 NOTICE: Setup SDL
02:04:44 T:2648 NOTICE: Found screen: Dummy Monitor on RDPDD Chained DD, adapter 0.
02:04:44 T:2648 NOTICE: Primary mode: 1280x1024 @ 60.00 - Full Screen
02:04:44 T:2648 NOTICE: Additional mode: 1280x1024 @ 60.00 - Full Screen
02:04:44 T:2648 NOTICE: load settings...
02:04:44 T:2648 NOTICE: special://profile/ is mapped to: special://masterprofile/
02:04:44 T:2648 NOTICE: loading special://masterprofile/guisettings.xml
02:04:44 T:2648 NOTICE: Getting hardware information now...
02:04:44 T:2648 NOTICE: Checking resolution 12
02:04:44 T:2648 NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
02:04:44 T:2648 NOTICE: Loaded playercorefactory configuration
02:04:44 T:2648 NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
02:04:44 T:2648 NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
02:04:44 T:2648 NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
02:04:44 T:2648 NOTICE: No settings file to load (special://masterprofile/advancedsettings.xml)
02:04:44 T:2648 NOTICE: Default DVD Player: dvdplayer

There is no mention of it after that. Please let me know if you want the entire report. Smile

tommymsw · 2012-03-01 09:36

I see this:
special://masterprofile/ is mapped to: C:\Users\Z-BOX\AppData\Roaming\XBMC\userdata
and this:
No settings file to load (special://masterprofile/advancedsettings.xml)

And I promise you that the .xml is in that directory! What could be wrong?

tommymsw Senior Member Posts: 266 Joined: Oct 2005 Reputation: 1	2012-02-29 20:14 Post: #233 No matter what I do, mysql will not make a database. I shut off firewall, the IP address is correct. The mysql has the user name (I also tried "root"). It's like xbmc is ignoring the .xml file. There is no "fail" or "error" when the .xml fails, it just ignores it completely!
	find quote

Morpio Junior Member Posts: 2 Joined: Dec 2008 Reputation: 0	2012-02-29 21:21 Post: #234 It is the same with my installation. I can't get XBMC (11.0 RC1) to use the MySql database tables. How can we debug this problem?
	find quote

darkscout Posting Freak Posts: 2,146 Joined: Jul 2008 Reputation: 12	2012-03-01 06:42 Post: #235 Sure. With some DEBUG LOGS. Code: GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%'; IF you have a mysql problem, find one of the 4 dozen threads already open.
	find quote

tommymsw Senior Member Posts: 266 Joined: Oct 2005 Reputation: 1	2012-03-01 08:26 Post: #237 When I search "problem sharing library mysql" I get exactly two results: http://forum.xbmc.org/showthread.php?tid...rary+mysql http://forum.xbmc.org/showthread.php?tid...rary+mysql
	find quote

tommymsw Senior Member Posts: 266 Joined: Oct 2005 Reputation: 1	2012-03-01 09:36 Post: #240 I see this: special://masterprofile/ is mapped to: C:\Users\Z-BOX\AppData\Roaming\XBMC\userdata and this: No settings file to load (special://masterprofile/advancedsettings.xml) And I promise you that the .xml is in that directory! What could be wrong?
	find quote