MYSQL Library Sharing

Posted on Author Kodi Community Forum - All Forums

Good evening or day (depending on where you live), community.

I’ve recently tried to set up a MySQL-Server to share my Kodi database with my upcoming new clients (I’m planning on 3 additions soon).
So I figured I’d get the server set up before my new clients arrive.

However I don’t know if I’m too dumb, but I seem to be missing something quite basic. I cannot get Kodi to sync my database onto the MySQL-server.

Some details first:
—————-the_server—————-

MySQL-Server running on
Raspberry Pi 3 running Rasbian Jessie with PIXEL

Code:
IP: 192.168.0.13

Installed
mysql-server
mysql-client
php5-mysql
phpmyadmin
samba
and all prerequisites

Code:
made user 'kodi' with pass 'kodi' for both linux and mysql. Permissions root and ALL on linux and mysql.

—————-the_client—————-

Client01 running
Windows 7 x64 32GB RAM with Kodi

Code:
Kodi 17.0-RC4 Git: 20170119-53a5c83-dirty

I’m planning to upgrade to Kodi 17.0 as soon as it comes out. My other clients will also run Kodi 17.0

Code:
IP: 192.168.0.2

The Firewall has exceptions for TCP and UDP for port 3306 in both directions.

—————-my_media—————-

A WDMyCloudEX2 NAS with 8TB of storage
(I’ve tried running the MySQL server on that, but I ran into the same problems)
All files shared using samba

Code:
IP: 192.168.0.12

I’ve also tried moving my userdata files to the NAS for easy implementation

Code:
//192.168.0.12/kodi/

—————-my_advancedsettings.xml—————-

Code:
<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.0.13</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </videodatabase>
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.0.13</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
  <pathsubstitution>
   <substitute>
    <from>special://profile/sources.xml</from>
    <to>SMB://192.168.0.12/kodi/userdata/sources.xml</to>
  </substitute>
  <substitute>
    <from>special://profile/mediasources.xml</from>
    <to>SMB://192.168.0.12/kodi/userdata/mediasources.xml</to>
  </substitute>
<substitute>
    <from>special://profile/favourites.xml</from>
    <to>SMB://192.168.0.12/kodi/userdata/favourites.xml</to>
  </substitute>
  </pathsubstitution>
</advancedsettings>

—————-the_my.cnf—————-

Code:
bind-address = 192.168.0.12 (I've also tried 0.0.0.0)
port = 3306
max_allowed_packet = 32M

!includedir /etc/mysql/conf.d/

—————-the_php.ini—————-

Code:
engine = On
output_buffering = 8192
zlib.output_compression = Off
max_execution_time = 60
max_input_time = 120
memory_limit = 256M
post_max_size = 32M
file_uploads = On
upload_max_filesize = 64M
max_file_uploads = 128

(and before you ask, yes I’ve tried importing my XML library into the MySQL database, to no avail)

Code:
default_socket_timeout = 90

—————-the_conclusion—————-

I’ve followed just about every tutorial out there, but there seems to be that tiny something I seem to be missing for this to work.
No matter what I’ve tried, my MySQL database stayed empty.

Please help me!
It is very appreciated!