Trying to make a centralized library using Mariadb

[shremi]

Ok guys so first of all i have read all of the guides available but it seems i am out of luck here .... As the title says i am trying to create a centralized library using mariadb

 

So i first went ahead and followed the guide basically here are the results of following the steps :

 

Setting environment for using XAMPP for Windows.
Marcos Z97@MARCOSZ97-PC c:\xampp
# mysql -uroot -h 192.168.0.119
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 38
Server version: 5.5.37-MariaDB-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SELECT host,user from mysql.user;
+--------------+------+
| host         | user |
+--------------+------+
| %            | root |
| %            | xbmc |
| 127.0.0.1    | root |
| 258cd5c1689e | root |
| ::1          | root |
| localhost    | root |
+--------------+------+
6 rows in set (0.00 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| xbmc_music         |
| xbmc_video         |
+--------------------+
5 rows in set (0.00 sec)

 

And then i created the advancedsettings.xml which looks somthing like this :

 

<advancedsettings>
<videolibrary>
	<actorthumbs>false</actorthumbs>
	<importwatchedstate>true</importwatchedstate>
	<dateadded>0</dateadded>
	<backgroundupdate>true</backgroundupdate>
	<updateonstartup>true</updateonstartup>
</videolibrary>
<musiclibrary>
	<backgroundupdate>true</backgroundupdate>
</musiclibrary>
<videodatabase>
	<type>mysql</type>
	<host>192.168.0.119</host>
	<port>3306</port>
	<user>xbmc</user>
	<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
	<type>mysql</type>
	<host>192.168.1.50</host>
	<port>3306</port>
	<user>xbmc</user>
	<pass>xbmc</pass>
</musicdatabase>
<videoscanner>
	<ignoreerrors>true</ignoreerrors> <!-- Set to true to silently ignore errors while scanning videos. This prevents the error dialogue box, so you don't have to keep hitting "yes" to keep scanning.-->
</videoscanner>
<splash>false</splash>
<bginfoloadermaxthreads>2</bginfoloadermaxthreads>
<myvideos>
	<extractflags>false</extractflags>
	<extractthumb>false</extractthumb>
</myvideos>
<lookandfeel>
	<enablerssfeeds>false</enablerssfeeds>
</lookandfeel>
<audiooutput>
	<guisoundmode>0</guisoundmode>
	<ac3passthrough>false</ac3passthrough>
	<dtspassthrough>false</dtspassthrough>
	<multichannellpcm>false</multichannellpcm>
	<truehdpassthrough>false></truehdpassthrough>
	<dtshdpassthrough>false</dtshdpassthrough>
	<mode>2</mode>
</audiooutput>
<videoscreen>
	<vsync>2</vsync>
</videoscreen>
<input>
	<enablemouse>false</enablemouse>
	<remoteaskeyboard>false</remoteaskeyboard>
</input>
<general>
	<addonnotifications>false</addonnotifications>
</general>
<services>
	<devicename>XBMC Server</devicename>
	<esallinterfaces>false</esallinterfaces>
	<escontinuousdelay>25</escontinuousdelay>
	<esenabled>true</esenabled>
	<esinitialdelay>750</esinitialdelay>
	<esmaxclients>20</esmaxclients>
	<esport>9777</esport>
	<esportrange>10</esportrange>
	<upnpannounce>true</upnpannounce>
	<upnprenderer>false</upnprenderer>
	<upnpserver>true</upnpserver>
	<webserver>true</webserver>
	<webserverpassword>xbmc</webserverpassword>
	<webserverport>8090</webserverport>
	<webserverusername>xbmc</webserverusername>
	<webskin>webinterface.default</webskin>
	<zeroconf>true</zeroconf>
</services>
<skinsettings>
	<setting type="bool" name="skin.confluence.FirstTimeRun">false</setting>
</skinsettings>

</advancedsettings>

 

When i try to start xbmc i get a black screen the full log of XBMC is in the attached file but i think here is the part where it talks about Mysql

 

20:41:45 T:4368   DEBUG: CRemoteControl::Connect - connecting to: 127.0.0.1:24000 ...
20:41:46 T:4368   DEBUG: CRemoteControl::Connect - failed to connect
20:41:46 T:4368    INFO: CRemoteControl::Process - failed to connect to irss, will keep retrying every 5 seconds
20:42:06 T:2412   ERROR: Unable to open database: MyMusic46 [2003](Can't connect to MySQL server on '192.168.1.50' (10060))

 

 

So i think the problem is the IP address 127.0.0.1 which i don't know if i should modify in order to make it my current ip which is 192.168.0.119 and also the address of MySQL server which is located in 192.168.1.50 as you can see right above .... i wanted to ask here before i start screwing things up...

 

And i am a complete newbie with unraid but i am trying to learn so please bare with me

xbmc.txt

[bkastner]

I have this same configuration setup, however I used the real ip address of the server, not 127.0.0.1.

 

I did have some permissions issues, which you will hopefully manage to avoid. I had to install a Windows based MySQL client to fix them, but it wasn't too difficult.

 

I also notice you have a lot more going on with your advancedsettings than I do.

 

Here is mine for reference:

<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.1.40</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </videodatabase> 
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.1.40</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
  <substitute>
    <from>special://profile/playlists/</from>
    <to>nfs://192.168.1.40/mnt/user/playlists/</to>
  </substitute>
</advancedsettings>

 

[shremi]

I have this same configuration setup, however I used the real ip address of the server, not 127.0.0.1.

 

I did have some permissions issues, which you will hopefully manage to avoid. I had to install a Windows based MySQL client to fix them, but it wasn't too difficult.

 

I also notice you have a lot more going on with your advancedsettings than I do.

 

Here is mine for reference:

<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.1.40</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </videodatabase> 
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.1.40</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
  <substitute>
    <from>special://profile/playlists/</from>
    <to>nfs://192.168.1.40/mnt/user/playlists/</to>
  </substitute>
</advancedsettings>

Thank you for the reply...  I have been trying to find out how to change the settings it seems there is a config file inside the Mariadb that you need to modify but I can't seem to find it... 

 

How did you manage to change the default ip address in your setup??

[bkastner]

I didn't have to modify the ip address. Any docker container will share the ip address of your host machine, so I just used the ip of my host machine (which for me is 192.168.1.40).