Login at Kodi Home

midianmlt · 2022-10-17, 13:42

Hi @Wetsocks

First of, big thanks for the tutorial.

Question: I I already have 2 Android boxes with kodi running independently. Will this import the already watch info to the MariaDB database? If not, is there a way this is possible?

Thanks

**Klojum** · 2022-10-17, 15:35

(2022-10-17, 13:42)midianmlt Wrote: Question: I I already have 2 Android boxes with kodi running independently. Will this import the already watch info to the MariaDB database?

If you refer to the watch info from the existing local databases on your Android boxes, nothing will to be (auto)imported to a MariaDB database. Things do not work that way.

jonnyp

Can someone please help me?

I've followed tutorials and almost managed to get there. Lots of trial and error with ports but after setting the SQL port to 3007 both in my.cnf and in the port settings for the entries in advancedsettings.xml file, it finally started to populate the SQL database on my QNAP server when I scanned my Kodi libraries.

So it seems connection from Kodi to the database is fine and dandy now, and all scanned content seems to be there in the database, however my Kodi libraries are completely empty. And it's not showing the standard "Your library is currently empty..." text etc but the view is empty and only showing Categories, such as Genres etc and they are empty.

It seems Kodi is writing to the database but not reading the database back?

**pkscout** · 2024-10-12, 00:25

(2024-10-11, 21:39)jonnyp Wrote: Can someone please help me?

I've followed tutorials and almost managed to get there. Lots of trial and error with ports but after setting the SQL port to 3007 both in my.cnf and in the port settings for the entries in advancedsettings.xml file, it finally started to populate the SQL database on my QNAP server when I scanned my Kodi libraries.

So it seems connection from Kodi to the database is fine and dandy now, and all scanned content seems to be there in the database, however my Kodi libraries are completely empty. And it's not showing the standard "Your library is currently empty..." text etc but the view is empty and only showing Categories, such as Genres etc and they are empty.

It seems Kodi is writing to the database but not reading the database back?

Without a debug log it's impossible to tell, especially given your decision to pick a random port for the SQL server. Which you really shouldn't have to do unless you have a very strange setup where you have something else that is using the port MySQL/MariaDB normally use. The likelihood is there is somewhere that you needed to add that odd port number and haven't.

jonnyp

Hi, thanks for replying. Well I tried to use the default port 3306 but nothing happened when I scanned my libraries in Kodi, i.e. the SQL database would not populate and nothing appeared in the Kodi library.

When I changed the port number to 3307 in my.conf and advancedsettings.xml, the database started populating when I scanned my libraries so obviously there now is communication between Kodi and the SQL database in one direction. I can also connect remotely to the SQL database on 3307 with MySQL Workbench and see the database being populated in real time from Kodi.

I will tinker some more but find it really strange I can populate the database from Kodi library scan but the library isn't showing in Kodi. Thought maybe someone had seen that issue before and knew what the issue was.

EDIT: SOLVED
Seems like I had the same issue that this guy https://forum.kodi.tv/showthread.php?tid=158082 had with Kodi not creating the views in the database.

I dropped the video and music databases. Dropped and re-created the user. And Bob's yer uncle, that did the trick! I must have screwed something up with the user privileges the first time.

sufreak · 2024-11-03, 17:58

Curious how this has been working for folks? I tried it years ago and it was so slow to run, update, etc, that I moved back off of Synology.

TyKH · 2024-11-03, 18:08

It works perfectly if I must say. Synology supports containers now, so updating goes smoothly. Do understand that this has to do with updating the the mysql version within MariaDB and not MariaDB itself. But even so, fixing it was an easy command prompt.

I also didn't encounter issues when used the MariaDB package on my old DS212.

The only issues I encountered was when the versions of the Kodi installation didn't match.

sufreak · 2024-11-03, 18:16

Thanks for the insight. Maybe I'll give a container a shot instead for the future. I gave up a few years ago with my Syno 920 and MariaDB, even upgraded RAM.

TyKH · 2024-11-03, 18:38

I have a 920, installing MariaDB and myphpadmin was a breeze. I also suggest to take a look at https://drfrankenstein.co.uk/ for other containers.

wags1 · 2024-11-04, 04:52

@sufreak I have been running it on my Synology NAS for years sharing Music and Movie libraries for my 2 Nvidia Shields. I use a pretty heavy duty skin (currently MQ 9 Mod for Omega) so lots of traffic to the library DBs. I have never had any performance issues. I do not use containers. What model Synology NAS were you trying? Some of the lower end models are definitely under powered.