[koldso]

Dear kodi / mariadb experts

I browsed for answers to my predicament - no luck.
I need your help.

Prequel:
I am kodi user for two years (my setup: two rpi boxes for tvs, mac os for scanning etc, android phones for the move),
I ran happily with a MariaDB (mysql) on central server.

Breakdown:
Disk on server broke down.
Did not backup library nor DB 

DB reinstallation and scrape
I did a clean reinstall of MariaDB on server.
I updated kodi to 18,.9 on Mac.
I did a one-hour scrape / scan from on Mac-kodi (kodi seemed to progress normally).
After scan I saw this on server (from mariaDB shell):
   MariaDB [(none)]> SHOW DATABASES;
   +--------------------+
   | Database           |
   +--------------------+
   | MyMusic72          |
   | MyVideos116        |  < This one appeared after kodi scan
   | information_schema |
   | mysql              |
   | performance_schema |
   | test               |
   +--------------------+
   6 rows in set (0.001 sec)

   MariaDB [(none)]> select count(*) from MyVideos116.movie;
   +----------+
   | count(*) |
   +----------+
   |      297 |
   +----------+
   1 row in set (0.000 sec)

Problem
I have next-to-no knowledge of MariaDB, but I figure from above, that kodi scan did populate DB with movie meta data.
However, when I enter kodi library I only see an empty movies (Film in danish) section, cf screendump below:

(I changed the Categories icons).
Normally this screen is filled with movies.
I see the same empty screen, when I enter a category.
I see the same empty screen, if I enter kodi (18.2) on a rpi.

I hope I have made a trivial error somewhere 

Questions

1. Do I need to supply more info... maybe do a fresh rescan while doing a kodi log file?
   
2. Any suggestions for fixing or analysing this problem?
   

Thanx
-Niels

[Klojum]

Did not backup library nor DB

Backups, ah yes... That word that everyone is so afraid of. With the proper tool or script, a backup of your MySQL/MariaDB can be done in under a minute. Really.
An alternate type of backup for Kodi is doing a weekly/monthly Video Export Library (separate files recommended), where there will be .nfo files created along your video files with all the metadata, and watched status and resume points optionally. Also fanart can be stored.

Any crashed database cannot be trusted anymore. So you'll need to take the long way home and rescrape your full media collection from the start.

However, when I enter kodi library I only see an empty movies (Film in danish) section

There are videos in the movie table, but that doesn't mean the rest of the data in the relational database is okay.

We will need Kodi's debug log (wiki) for starters, in order to see what is happening under water.
Enable debugging, enable the Database component in debugging, restart Kodi, and run it. Then provide the log file via paste link below.

[koldso]

Dear @Klojum

Thank you for a very quick reply.

This is requested log.

I did:

1. Drop database MyVideos116
   
2. Enter kodi
   • ​​​​​​​restore movie-source (it was apparently destroyed by step 1)
     
   • enable logging as per request
     
   • exit kodi
     
3. Notice: MyVideos116 recreated and table MyVideos116.movie contains 0 records.
   
4. Enter kodi
   • a movie library rescan (movie folder only contains one movie, namely snemanden)
     
   • exit kodi
     
5. Notice
   • table MyVideos116.movie contains 1 record
     
   • still, not able to view anything in kodi library
     

With respect to backup: yes, nød lærer nøgen kvinde at spinde, ie. I will learn to do a backup and restore (any links appreciated).


​​​​​​​Thanx again !!

[Klojum]

020-12-04 10:54:50.778 T:4862090752 ERROR: SQL: [MyMusic72] The table does not exist
Query: select count(idSong) as NumSongs from songview

Check your database user right for the user 'kodi'. Normal rights may be there, but views (and perhaps triggers) may not have been created.

[koldso]

Thanx @Klojum!  Impresseive response times 

I am not at all familiar with MariaDB, so I am not sure I did what you asked.

I ran the following:
   MariaDB [(none)]> show grants for kodi;
   +--------------------------------------------------------------------------------------------------------------+
   | Grants for kodi@%                                                                                            |
   +--------------------------------------------------------------------------------------------------------------+
   | GRANT ALL PRIVILEGES ON *.* TO 'kodi'@'%' IDENTIFIED BY PASSWORD '*2249595D6A53B38A77AA4AB2091D9B1A71F88735' |
   +--------------------------------------------------------------------------------------------------------------+
Does it help?

I am not sure

• what "normal rights" are.
  
• how to check for views and triggers.
  

If you have a link to "some checklist" I can follow in order to check kodi mairaDB, I think I will be able to comply.

[jmgibson1981]

https://github.com/jmgibson1981/scripts/....sh.source

This link to my git contains my current sql backup function. It's for linux. You would need to find a method / script that fits the server os though.

[koldso]

https://github.com/jmgibson1981/scripts/....sh.source

This link to my git contains my current sql backup function. It's for linux. You would need to find a method / script that fits the server os though.

Thanx @jmgibson1981 
Should fit my un*x-setup ... once I get the DB / kodi working again (it is a struggle).

[koldso]

Fixed

I did

• @DB server (linux): drop database MyVideos116; (run from mariadb shell)
  
• @ kodi machine (mac):
  • removed Kodi-folder (ie./Users/<my-name>/Library/Application Support/Kodi)
    
  • opened and exited kodi, this created a virgin Kodi-folder
    
  • copied old advancedsettings.xml to /Users/<my-name>/Library/Application Support/Kodi/userdata
    • opened kodi
      
    • sat up new movie source, this created within ...userdata/sources.xml:f 
      • <source>
            <name>movies</name>
            <path pathversion="1">smb://192.168.1.1/monster/flix/movies/</path>
            <allowsharing>true</allowsharing>swere
        </source>
        
    • I answered "yes" to "Do you want to refresh information for all items within this path?"
      
    • Scanning ran and voila succes - I see movies in library 
      

Fix resume: Start from scratch by deleting DB and Kodi-folder.

Now I have some configuration to do and then a back up routine 
Thanx again to @jmgibson1981 and @Klojum and bye for now.

[Klojum]

Thread marked solved.