Shared Kodi MySQL hosted on Android / FireTV boxes

[LivinLOS]

Well I finally got around to testing this and it worked very simply, after days and days fighting trying to make it work hosting it on my NAS.

I wont call this a guide or Howto as I didnt do any screengrabs but just to outline the very simple steps.

First I have all my AFTVs and my NAS on fixed IPs. And I made sure my Kodi installs were all using IP address's in sources.

I downloaded the APK of ksweb server suite for sideloading from http://kslabs.ru/

I pushed it over to my primary AFTV box using adbfire to sideload.

First problem is that the app did not have its 7 day trial, said it had expired.. I am unsure of this was unique to me, or due to sideloading, or some other error.. I contacted the Dev who asked for the device id (its on settings tab) and he sent me a key.

Second problem is KSWEB is designed for touchscreen devices and doesnt have a highlighter to tell you where the cursor is. So some click counting and guessing is needed to navigate, but not that hard, just a little UI bug.

Once you have the serial (or I assume a trial period) the servers will start. This will also give you a web interface on <IP Address>:8000 however after much puzzling I discovered the web interface lacks some essential config needing access on the AFTV and click counting again.

Set up KSWEB to start on boot, and start minimized.

On the AFTV KSWEB interface, on the tools tab, you can install phpmyadmin (or adminer) and once you do so this will then add that tool on another port <IP address>:8001 :8002 etc.. Once this step is done everything else can be done from another machine and you no longer need to access with the AFTV.

Open PHPMyAdmin via the link/port it gave you.. Login root blank PW.. Security conscious should of course change that after logging in.

Once in PHPMyAdmin -> users tab, add user.. Choose username (kodi) pass (kodi) and leave it it for 'any host' access.. Database and user created.. Job now done.

If you want to test the MySQL is working.. This little windows tool seems to do an easy job http://mysql-system-tray-monitor.software.informer.com/ it wont of course work until you have an 'any host' user configured.

After that simply follow the steps as per the wiki, create a sample advancedsettings.xml as per http://kodi.wiki/view/MySQL/Setting_up_Kodi Just a simple case of the IP address of the AFTV running KSWEB and the user pass created above.

Worth mentioning at this point your going to need a rescan of the sources, so either have your NFO files created or export library (within Kodi) now if you want to keep it as it is currently.

Again use the ADBFire to push the advancedsettings.xml to the AFTV and and reboot it..

Open Kodi, which now has a blank library and rescan your sources..

Once you have your sources scanned into the database.. Push the same advancedsettings.xml out to each AFTV on your network with ADBFire again.

Voila..MySQL running on one primary android AFTV, with all the other nodes sharing the library.. Now watched status, pause and resume in another room, all the benefits of MySQL database sharing, all handled on the low power AFTVs. Really was easy and so far not seeing any load issues with the box. I am assuming this will be the same for any android box which is set to not sleep.

MySQL hosting on AFTVs and other android boxes as simple as that.

[Nomad97]

I have KODI Helix on 2 Android boxes and I will admit I am new to the game. I did install KODI myself and I am still on the learning curve as to how to programme and add features to the system. However, your post #1 is way above my limited knowledge and totally meaningless to me. Just shows me how much I have to learn. LOL!

[LivinLOS]

By using a shared mysql library it keeps all your boxes watched status properly synced.. Watch a movie on one box and all boxes know this.. Handy for watching series's as it keeps a centralized memory of which episode your up to.

Also allows pause and resume between boxes.. Watch half a movie downstairs, then restart it in the bedroom and it knows where you watched it up to.

[johng]

Just be aware that all your boxes must be running the same version of XBMC ( Kodi ) ( or at least major branch ) you cant mix and match for example Frodo and Gotham as the database versions are different...could be a problem if some are set to autoupdate themselfs.

http://kodi.wiki/view/Databases/Versions

[WorriedNoodle]

By using a shared mysql library it keeps all your boxes watched status properly synced.. Watch a movie on one box and all boxes know this.. Handy for watching series's as it keeps a centralized memory of which episode your up to.

Also allows pause and resume between boxes.. Watch half a movie downstairs, then restart it in the bedroom and it knows where you watched it up to.

Really appreciate this post as it saves me reading your first post that is a bit above my head as well. At least I now know this is something I will never need, but appreciate the info, your efforts and that fact it can be done.

[MGrG1183]

First off thank you so much for the information!
In your first post it since you had some problems with the APK that you download them about the 7-Day trial.

I'm trying to setup server on a Xiaomi Mi Box 3/Android TV.
Do you have a link to the APK file that will work without having to worry about the trial period Or any other issues?

Sent from my LGMS428 using Tapatalk

[Jai Dee]

You do realise that the last comment on this thread is nearly 2 years old?

[johng]

My Mysql database has been corrupted or lost on a few occasions

this backup script has saved the day

automysqlbackup-v3.0_rc6.tar.gz