OSMC June 2023 on RPi3 and RPi4 wireless and MySql issue

Hi,
I have 2 Raspberry a Pi3B and a Pi4 4GB today I have update both with New version with Kodi 20.1.
I have 2 Issue on both Raspberry:

  • Wireless doesn’t accept password (it’s correct I check with "show Password and on my router)
  • MySql is well configured and Library are setup correctly but Movie and TV show categories are empty.
    Any hints?
    Thanks
    MH

same with mysql on vero 4k

maybe something wrong with the db update?
https://paste.osmc.tv/ahujowakig

Without logs determining your issue is problematic.

Looks like. What are you running the database on? Is this post relevant perhaps…

The db (Maria 10.3.38): is running on a remote server.
On my log this part looks strange:

2023-06-06 20:54:16.945 T:3454     info <general>: MYSQL: Connected to version 10.3.38-MariaDB-0ubuntu0.20.04.1-log
2023-06-06 20:54:16.954 T:3454     info <general>: Attempting to update the database MyVideos121 from version 119 to 121
2023-06-06 20:54:16.965 T:3454    error <general>: SQL: [MyVideos121] Undefined MySQL error: Code (1060)
                                                   Query: ALTER TABLE streamdetails ADD strHdrType text
                                                   
2023-06-06 20:54:16.965 T:3454    error <general>: Exception updating database MyVideos121 from version 119 to 121
2023-06-06 20:54:16.965 T:3454    error <general>: Error updating database MyVideos121 from version 119 to 121
2023-06-06 20:54:16.973 T:3454    error <general>: Unable to open database: MyVideos120 [1049](Unknown database 'MyVideos120')
2023-06-06 20:54:16.982 T:3454     info <general>: Old database found - updating from version 119 to 121
2023-06-06 20:54:16.985 T:3454    error <general>: SQL: Can't create database for copy: 'MyVideos119' (1007)
2023-06-06 20:54:16.985 T:3454    error <general>: Unable to copy old database MyVideos119 to new version MyVideos121

more complete logs (debugging mode)
https://paste.osmc.tv/ifutokojof

I have the same problem and posted to this location. Perhaps merging the two might help, but I also have an issue with playing a file directly from the video tab (files) as it gives a frown face.

I’m running 10.4.17 on a Win10 PC and didn’t run into the issue during testing on the two machines with the db they were using, nor did I have an issue with the upgrade of a different db that happened with the final release installed on other boxes, so whatever the issue it isn’t universal, and I suspect it it’s server side. Unfortunately, when it comes to the topic of databases I’m very much a noob so I can’t offer much. I did raise the issue with the dev team though.

If you drop the 121 database (if it created it at all) and have Kodi installed on a PC do the db update does it fail there as well?

If I delete the new db 121, on the Next reboot Will be recreated… but on osmc I continue to see nothing.

When you delete 121 it not being there tells Kodi to upgrade from the previously found version (119). This is failing so Kodi just loads up the local (empty) SQLite db instead. What I was asking was if instead of having Kodi running on OSMC to do this update, you instead configure a PC running Kodi with the same advancedsettings.xml so it will do the database update. In this way it would help isolate where the issue is coming from, ie if Kodi on Windows fails the same way then it is probably something to do with the server configuration. You don’t actually need to fully setup all your sources, passwords, etc. on the Win Kodi to do the update as none of them are involved in the process.

Unfortunately the log just shows you telling the file to play and then the log stops so there isn’t any information to go off of. Is that drive your playing it from self powered? If you put the file on a thumb drive does it play from that without crashing?

The drives are self-powered (plugged into a hub). These files played properly prior to the update. Because of this, I thought that this issue had to do with the update since it happened at the same time as the other issue of not being able to access movies/tv shows the regular way (library on the home page). Are you asking me to copy a file to a usb drive and then plug the usb drive directly into the Pi4?

When there exist a possible power delivery issue a quick and dirty is to try playing the same file from something that uses very little power. It’s a bit of a stab in the dark kind of thing lacking a more solid footing for a proper diagnostic.

Hi, I’m sorry but I don’t have windows machine to do this.

If the db setup in advancedsettings.xml is a mysql (or Maria), if you deleted the new version (121) on the next reboot kodi will trig the migration process from the last version (119) to the current one (121).

So, I just create a fresh new database server (this time mysql 8, instead Maria 10.3.38), restored the 119 db* and restarted kodi… all movie/tv show are back!

Kodi developers maybe no longer support too old versions of Maria/mysql? Versions 10.3 or 5.7 are old…

*) I just have a little problem with this error on restore:
Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
fixed with:
sed -i 's/,NO_AUTO_CREATE_USER//g' path/119_db_dump.sql

1 Like

Didn’t Kodi stop officially supporting MySQL and instead say to only use Maria?

I use MariaDB 10.5.8 on QNAP NAS

After another try to access do MariaDB Server Kodi 20.1 a scratched all data :face_with_symbols_over_mouth:
Every time there are a new Kodi major release we have to reinstall all from the scratch (DB, network path, profile, configuration, Audio setup). Everytime a fresh install. I am very disappointed (refered to KODI not OSMC)

You should make sure your MySQL user can create and access new databases.

Kodi creates new databases for each upgrade. Fortunately this preserves data across each upgrade if a migration is unsuccessful.

Having the same issue Sam. User can create and access databases, it looks like there is something weird going on. Here is a snippet of the logs in question. Updated the mariadb that I’m running in a docker container, and checked the perms of the user kodi is using (it has full access). When I look at the database in dbeaver, you’ll notice that MyVideos119 and MyVideos121 both exist. Even running a quick select all, is showing that the database does have data in it. But when restarting both Vero devices, I still see nothing in Movies or TV. Halp.

2023-06-06 16:02:01.569 T:2959     info <general>: MYSQL: Connected to version 10.11.3-MariaDB-log
2023-06-06 16:02:01.590 T:2959     info <general>: Running database version MyMusic82
2023-06-06 16:02:01.590 T:2959    debug <general>: connect replacing configured host 192.168.1.254 with resolved host 192.168.1.254
2023-06-06 16:02:01.610 T:2959     info <general>: Attempting to update the database MyVideos121 from version 119 to 121
2023-06-06 16:02:01.611 T:2959    debug <general>: Mysql Start transaction
2023-06-06 16:02:01.630 T:2959    error <general>: SQL: Can't determine list of routines to drop.
2023-06-06 16:02:01.630 T:2959    error <general>: Exception droping old analytics from MyVideos121
2023-06-06 16:02:01.632 T:2959    debug <general>: Mysql rollback transaction
2023-06-06 16:02:01.632 T:2959    debug <general>: connect replacing configured host 192.168.1.254 with resolved host 192.168.1.254
2023-06-06 16:02:01.643 T:2959    error <general>: Unable to open database: MyVideos120 [1049](Unknown database 'MyVideos120')
2023-06-06 16:02:01.643 T:2959    debug <general>: connect replacing configured host 192.168.1.254 with resolved host 192.168.1.254
2023-06-06 16:02:01.661 T:2959     info <general>: Old database found - updating from version 119 to 121
2023-06-06 16:02:01.697 T:2959    error <general>: SQL: Can't create database for copy: 'MyVideos119' (1007)
2023-06-06 16:02:01.697 T:2959    error <general>: Unable to copy old database MyVideos119 to new version MyVideos121

Edit: I can provide the full logs if they are needed.
Edit2: Running Maria DB 10.11.3. Dropped the MyVideos121 database. Restarted Vero device, it shows that a database migration is in progress. “Finishes” and then shows me an empty Movies and TV section.

If you’re running Maria in a Docker container it’s hard to advise.

We don’t even know what distribution it’s running on and if they’ve changed default policies.

Have you tried with an OSMC based on install?

Definitely looks like CREATE permission issues.

Sam