Guest - Testers are needed for the reworked CDateTime core component. See... https://forum.kodi.tv/showthread.php?tid=378981 (September 29) x
  • 1
  • 23
  • 24
  • 25(current)
  • 26
  • 27
  • 41
HOW-TO:Share libraries using MySQL: Wiki Edition
Upload your FULL debug log to a pastebin site, don't post logs to the forum. Your as.xml looks like it has an error but the way you're posting it I can't be sure. And seriously, nobody cares about your private IP addresses (192.168.x.x etc.) so stop obfuscating them - if however your MySQL server is using a public ip address somewhere on the internet then that might explain the problem...
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply
Just wanted to let you guys know that i did it,
it was a firewall setting within my synology that wasnt set, the mysql 3306 wasnt add to my firewall rules.

Thanks you all for your help.
Reply
I got another question i dont know if i'm on the right post but here it goes:

I would like to share my watched status of genesis.
Is there any way to do this with a mysql server?

kind regards,

Benito2313
Reply
(2015-06-23, 22:33)benito2313 Wrote: I got another question i dont know if i'm on the right post but here it goes:

That's a banned add-on, no support for that on this forum.
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply
Oeps sorry thanks for the reminder
Reply
I was wondering if anyone would have a step by step guide on installing mysql for windows. There are tons os options during install that made me get lost. I make myself available for taking prints of the screens if someone help me. These prints could go to the wiki.
Reply
I know NOTHING about using MySQL. I just took all the default settings when I installed it, then followed the wiki instructions as best I could and it works for me! The wiki does need an update though as I believe we can now use newer versions of MySQL with Kodi and not have any issues.
Reply
I hope someone can help me, because i am very stuck.
I have an HTPC, windows 7 and an android tablet, both using Kodi.
I am using a addon to stream tv shows and movies.
I want to be able to add videos to my library, but i want to store my library on my nas so i can access it with both devices, and that they sync, so when i watched an episode on my htpc i can see on my tablet that i have watched episode 1.
But i get stuck with the cofiguration and installation.
Do i install mysql on my nas or on my pc.
and in the configuration which config type do i choose?
And when creating the xml file, what ip adress do i put in, my nas or my htpc?
Reply
Some NAS devices will allow installation of MySQL, some can be hacked to add it. I don't know the ins/outs of doing it as the 2 I have need to be hacked and I don't want to do it. So I have installed MySQL on one of my HTPCs as that one is on 24/7. You use the address of the PC that has MySQL installed. You'll also need to open a port (I Think it's 3306) on the router for the IP of the HTPC with MySQL installed. This is done in many different ways as there are many different routers. This site will help with that. You may also need to allow access to the windows firewall I THINK that site can help with that too.

As for the add-on you mentioned, you need to get help with that from it's support site as you are not supposed to discuss 3rd party add-ons here....
Reply
i am so sorry, i changed my post, leaving the name of the addon out
Reply
(2015-08-24, 12:17)MissShadows Wrote: I hope someone can help me, because i am very stuck.
I have an HTPC, windows 7 and an android tablet, both using Kodi.
I am using a addon to stream tv shows and movies.
I want to be able to add videos to my library, but i want to store my library on my nas so i can access it with both devices, and that they sync, so when i watched an episode on my htpc i can see on my tablet that i have watched episode 1.
But i get stuck with the cofiguration and installation.
Do i install mysql on my nas or on my pc.
and in the configuration which config type do i choose?
And when creating the xml file, what ip adress do i put in, my nas or my htpc?

I have my library on my NAS, MySQL on a Windows7 PC, and run KODI on 2 other PCs and 2 Chromeboxes. All my watched flags are synced across devices as well as my resume functions.

My NAS is running unRAID. I tried to put MySQL on the NAS but had nothing but issues during shutdown. You have to shutdown MySQL clean before you can shutdown the NAS or the disks will not dismount. Every time I tried I would end up corrupting my database and doing a rebuild. Since I have a large library this took a LONG time. I don't recommend running off your NAS unless you know what you are doing.

So I use a Windows7 PC for MySQL server and leave it up 7x24 (which it was anyway). I do my library updates from it.

Use the wiki for the config of MySQL. Don't use the latest version of MySQL but the one specified there.

Your xml file should have the ip address of the device running MySQL.

You will have to configure firewall ports but I don't know why you would need to open router ports. Unless you are accessing from outside your LAN it should only go through a switch and not the router. I may be wrong but I don't recall doing anything to my router.
Reply
Port 3306 is mentioned in the wiki as part of the advancedsettings.xml file. I don't know the whys and wherefor for it being there but I opened it on my router and that's when it started working, go figure.
Reply
(2015-08-25, 21:02)skulker Wrote: Use the wiki for the config of MySQL. Don't use the latest version of MySQL but the one specified there.

I have it working on a Synology NAS with the latest mariadb (and PHPmyAdmin) with no visible issues.

The wiki is the way to go, if you follow that you should be fine but learning a little MySQL will help with troubleshooting.
Reply
Just tried the new 5.7.9 MySQL. All looked well, until I tried to clean my database. It couldn't remove items from my database be doing a cleanup, only manual deletion worked. It was a clean install by the way. Back to 5.6 it is ...
CoreElec on a Tanix TX3 (s905x3). Onkyo NR-656. Canton Movie CD-1000. LG 55B6V.

If it ain't broke: break it, fix it, repeat
Reply
(2015-10-23, 23:09)Raytestrak Wrote: Just tried the new 5.7.9 MySQL. All looked well, until I tried to clean my database. It couldn't remove items from my database be doing a cleanup, only manual deletion worked. It was a clean install by the way. Back to 5.6 it is ...

Your debug log (wiki) would have been useful.
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply
  • 1
  • 23
  • 24
  • 25(current)
  • 26
  • 27
  • 41

Logout Mark Read Team Forum Stats Members Help
HOW-TO:Share libraries using MySQL: Wiki Edition2