Kodi Community Forum
HOW-TO:Share libraries using MySQL: Wiki Edition - Printable Version

Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Tips, tricks, and step by step guides (https://forum.kodi.tv/forumdisplay.php?fid=110)
--- Thread: HOW-TO:Share libraries using MySQL: Wiki Edition (/showthread.php?tid=157572)

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


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - flhthemi - 2015-06-03

Just checking to make sure, do you have these lines in your advancedsettings.xml?

<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - jmh2002 - 2015-06-03

I never had those lines in my advancedsettings.xml to enable the Resume functionality.

As far as i remember isn't this for one time only re-importing to your library, to set the watched state from .info files?


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Milhouse - 2015-06-03

(2015-06-03, 18:29)jmh2002 Wrote: As far as i remember isn't this for one time only re-importing to your library, to set the watched state from .info files?

Correct, whether you have these options or not should have no effect on the resume behaviour when starting/stopping playback.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - flhthemi - 2015-06-03

Well, I guess I can take them out of mine. You learn sumpin' new everyday Wink


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - damire80 - 2015-06-04

ok, mine didnt have those lines in it...[/i]


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - billups - 2015-06-08

Ok, finally got it done and updated the wiki in between the newborn napping. lol
I haven't had a chance to test it with XBMC, but that does allow me to access the database remotely through other means.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - benito2313 - 2015-06-22

Hello everybody,

I want to setup the mysql lib sharing on my synology, i have everything setup on my synology phpmyadmin and Maridb.
but when i set my advancedsettings.xml in kodi it doesnt work, kodi is freezing on startup.

Also there are no Databases being created on my synology when i check phpmyadmin.

What am i doing wrong?

kinder regards,

benito2313


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - flhthemi - 2015-06-22

(2015-06-22, 21:39)benito2313 Wrote: Hello everybody,

I want to setup the mysql lib sharing on my synology, i have everything setup on my synology phpmyadmin and Maridb.
but when i set my advancedsettings.xml in kodi it doesnt work, kodi is freezing on startup.

Also there are no Databases being created on my synology when i check phpmyadmin.

What am i doing wrong?

kinder regards,

benito2313

Post the <videodatabase> portion of your advancedsettings.xml file. I'm sure that will help someone help you. Wink


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Milhouse - 2015-06-22

Or just post your full debug log (wiki).


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - jeffjoker - 2015-06-23

Hi,

I have followed the guide and enjoyed the centralized DB ever since.
Just once question, since I upgraded ALL my Kodi devices from 14.2 to 15.0beta (1 then 2), I have multiple DB on my MySQL.
Should I drop the old ones ?

mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| MyMusic48 |
| MyMusic52 |
| MyVideos90 |
| MyVideos92 |
| MyVideos93 |
| mysql |
| performance_schema |
+--------------------+
8 rows in set (0.06 sec)

I guess MyMusic 48, MyVideos90 and MyVideos92 could be dropped, but I wanted advice before doing so
Not that it would takes that much time / bandwith to rescan everything

Maybe better to drop them after Kodi 15 becomes stable !?!


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - mkortstiege - 2015-06-23

Yes, those are safe to delete unless you want to revert and repeat the database upgrade(s) for some reason.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - jeffjoker - 2015-06-23

OK Thanks
I did it

BTW any recommendation or setting to have those removed automatically after successful migration ?
Not that we have that many update nor that it takes that much space


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - mkortstiege - 2015-06-23

I guess you could work with triggers but having a just upgraded db as a backup is not the baddest idea imo.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - benito2313 - 2015-06-23

(2015-06-22, 23:25)flhthemi Wrote:
(2015-06-22, 21:39)benito2313 Wrote: Hello everybody,

I want to setup the mysql lib sharing on my synology, i have everything setup on my synology phpmyadmin and Maridb.
but when i set my advancedsettings.xml in kodi it doesnt work, kodi is freezing on startup.

Also there are no Databases being created on my synology when i check phpmyadmin.

What am i doing wrong?

kinder regards,

benito2313

Post the <videodatabase> portion of your advancedsettings.xml file. I'm sure that will help someone help you. Wink

This is the advancedsetting, i replaced the server part:

<?xml version="1.0"?>

<!-- zerocache -->

-<advancedsettings>


-<network>

<cachemembuffersize>0</cachemembuffersize>

<curlclienttimeout>45</curlclienttimeout>

</network>


-<gui>

<algorithmdirtyregions>3</algorithmdirtyregions>

<nofliptimeout>0</nofliptimeout>

</gui>


-<videoscanner>

<ignoreerrors>true</ignoreerrors>

</videoscanner>


-<videodatabase>

<type>mysql</type>

<host>xxx.xxx.x.xxx</host>

<port>3306</port>

<user>kodi</user>

<pass>kodi</pass>

</videodatabase>


-<musicdatabase>

<type>mysql</type>

<host>xxx.xxx.x.xxx</host>

<port>3306</port>

<user>kodi</user>

<pass>kodi</pass>

</musicdatabase>


-<videolibrary>

<importwatchedstate>true</importwatchedstate>

<importresumepoint>true</importresumepoint>

</videolibrary>

</advancedsettings>


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - benito2313 - 2015-06-23

I also looked at my debug file, this is what is got:

20:02:19 T:5456 DEBUG: SECTION:LoadDLL(special://xbmcbin/system/libcurl.dll)
20:02:19 T:5456 NOTICE: Running database version Addons16
20:02:19 T:5456 DEBUG: CDatabaseManager::Initialize, updating databases...
20:02:19 T:5456 NOTICE: Running database version ViewModes6
20:02:19 T:5456 NOTICE: Running database version Textures13
20:02:19 T:2684 DEBUG: CRemoteControl::Connect - connecting to: 127.0.0.1:24000 ...
20:02:20 T:2684 DEBUG: CRemoteControl::Connect - failed to connect
20:02:20 T:2684 INFO: CRemoteControl:Tonguerocess - failed to connect to irss, will keep retrying every 5 seconds
20:02:40 T:5456 ERROR: Unable to open database: MyMusic48 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))
20:03:01 T:5456 ERROR: Unable to open database: MyMusic47 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))
20:03:22 T:5456 ERROR: Unable to open database: MyMusic46 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))
20:03:28 T:5736 DEBUG: CAESinkDirectSound:Big Grineinitialize: Cleaning up
20:03:44 T:5456 ERROR: Unable to open database: MyMusic45 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))
20:04:05 T:5456 ERROR: Unable to open database: MyMusic44 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))
20:04:26 T:5456 ERROR: Unable to open database: MyMusic43 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))
20:04:47 T:5456 ERROR: Unable to open database: MyMusic42 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))
20:05:08 T:5456 ERROR: Unable to open database: MyMusic41 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))
20:05:29 T:5456 ERROR: Unable to open database: MyMusic40 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))
20:05:50 T:5456 ERROR: Unable to open database: MyMusic39 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))
20:06:11 T:5456 ERROR: Unable to open database: MyMusic38 [2003](Can't connect to MySQL server on 'XXX.XXX.X.XXX' (10060))


This forum uses Lukasz Tkacz MyBB addons.