More of a note to myself but I was doing a major version upgrade of OpenELEC for the first time and hit a few snags, so wanted to note these is case anyone else hits the same issues.
Basic setup, and potential issues;
- OpenELEC 6.0.3 running on a RPi3
- Media server is accessible via SMB
- Video database is on the MySQL server rather then locally
- Using TV Headend as a PVR client
OpenELEC 6.0.3 running on a RPi3
OpenELEC will not automatically upgrade to a major new release for fear of breaking things. You are expected to trigger this yourself. The process is fairly straightforward to be honest.
To upgrade, copy the update file (.tar) for the platform you are using into the /storage/.update/ directory and reboot, then when it is up and running, reboot a second time.
Note: I’m assuming you have a backup before you start this 🙂
Media server is accessible via SMB
No problems with this part actually. The SMB configuration was done through OpenELEC (and stored in /storage/.kodi/userdata/sources.xml) so this was preserved through the upgrade.
Video database is on the MySQL server rather then locally
This part caused some problems, as I’d forgotten that I had the permissions for kodi locked down. When starting up the ‘Film’ and ‘TV Shows’ categories weren’t visible.
/storage/.kodi/userdata/advancedsettings.xml was unchanged, so didn’t expect any problems in terms of client config:
<videodatabase>
<type>mysql</type>
<host>192.168.1.x</host>
<port>3306</port>
<user>kodi</user>
<pass>MySecretPassword</pass>
</videodatabase>
Taking a look at the kodi log file (stored in /storage/.kodi/temp/kodi.log) I could see where things were going wrong.
18:42:19 9.573155 T:1963802624 ERROR: Unable to open database: MyVideos99 [1044](Access denied for user 'kodi'@'192.168.1.%' to database 'MyVideos99') 18:42:19 9.591171 T:1963802624 ERROR: Unable to open database: MyVideos98 [1044](Access denied for user 'kodi'@'192.168.1.%' to database 'MyVideos98') 18:42:19 9.611773 T:1963802624 ERROR: Unable to open database: MyVideos97 [1044](Access denied for user 'kodi'@'192.168.1.%' to database 'MyVideos97') 18:42:19 9.636495 T:1963802624 ERROR: Unable to open database: MyVideos96 [1044](Access denied for user 'kodi'@'192.168.1.%' to database 'MyVideos96') 18:42:19 9.657456 T:1963802624 ERROR: Unable to open database: MyVideos95 [1044](Access denied for user 'kodi'@'192.168.1.%' to database 'MyVideos95') 18:42:19 9.676188 T:1963802624 ERROR: Unable to open database: MyVideos94 [1044](Access denied for user 'kodi'@'192.168.1.%' to database 'MyVideos94') 18:42:19 9.705974 T:1963802624 NOTICE: Old database found - updating from version 93 to 99 18:42:19 9.711560 T:1963802624 ERROR: SQL: Can't create database for copy: 'MyVideos93' (1044) 18:42:19 9.716779 T:1963802624 ERROR: Unable to copy old database MyVideos93 to new version MyVideos99
The number that Kodi tags to the end of the database name e.g. MyVideos93, 93 indicates the database version. Part of the upgrade involves upgrading the database to whatever revision we are now on. Kodi will do this for you, but creates it as a new database which means that it has to have permissions to do so.
The base permissions I granted by default weren’t sufficient for this:
mysql> show grants for 'kodi'@'192.168.1.%' ; +-----------------------------------------------------------------------------------------------------+ | Grants for [email protected].% | +-----------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'kodi'@'%' IDENTIFIED BY PASSWORD '*xxxx' | | GRANT ALL PRIVILEGES ON `MyVideos93`.* TO 'kodi'@'192.168.1.%' | +-----------------------------------------------------------------------------------------------------+
Granted full permissions to Kodi.
mysql> GRANT ALL PRIVILEGES ON *.* TO 'kodi'@'192.168.1.%' ; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> show grants for 'kodi'@'192.168.1.%'; +------------------------------------------------------------------------------------------------------------------------+ | Grants for [email protected].% | +------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'kodi'@'192.168.1.%' IDENTIFIED BY PASSWORD '*xxxx' | | GRANT ALL PRIVILEGES ON `MyVideos93`.* TO 'kodi'@'192.168.1.%' | +------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)
Now restart the RPi, and the new database was created and the data migrated across.
... 18:51:37 9.850684 T:1963544576 ERROR: Unable to open database: MyVideos99 [1049](Unknown database 'MyVideos99') 18:51:37 9.869744 T:1963544576 ERROR: Unable to open database: MyVideos98 [1049](Unknown database 'MyVideos98') 18:51:37 9.899451 T:1963544576 ERROR: Unable to open database: MyVideos97 [1049](Unknown database 'MyVideos97') 18:51:37 9.926645 T:1963544576 ERROR: Unable to open database: MyVideos96 [1049](Unknown database 'MyVideos96') 18:51:37 9.944409 T:1963544576 ERROR: Unable to open database: MyVideos95 [1049](Unknown database 'MyVideos95') 18:51:37 9.971253 T:1963544576 ERROR: Unable to open database: MyVideos94 [1049](Unknown database 'MyVideos94') 18:51:37 9.997427 T:1963544576 NOTICE: Old database found - updating from version 93 to 99 18:51:52 25.252617 T:1963544576 NOTICE: Attempting to update the database MyVideos99 from version 93 to 99 18:52:26 59.282043 T:1963544576 NOTICE: Running database version TV29 18:52:26 59.287502 T:1963544576 NOTICE: Running database version Epg11 ...
Then I locked it back down again, but with a slight improvement, as Kodi doesn’t seem to delete the older DB by default.
mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'kodi'@'192.168.1.%'; Query OK, 0 rows affected (0.02 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> show grants for 'kodi'@'192.168.1.%'; +-----------------------------------------------------------------------------------------------------+ | Grants for [email protected].% | +-----------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'kodi'@'192.168.1.%' IDENTIFIED BY PASSWORD '*xxxx' | +-----------------------------------------------------------------------------------------------------+ mysql> GRANT ALL ON `MyVideos%`.* TO 'kodi'@'192.168.1.%' IDENTIFIED BY 'kodi'; Query OK, 0 rows affected (0.02 sec) mysql> flush privileges; Query OK, 0 rows affected (0.02 sec) mysql> show grants for 'kodi'@'192.168.1.%'; +---------------------------------------------------------------------------------------------------------------+ | Grants for [email protected].% | +---------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'kodi'@'192.168.1.%' IDENTIFIED BY PASSWORD '*xxxx' | | GRANT ALL PRIVILEGES ON `MyVideos%`.* TO 'kodi'@'192.168.1.%' | +---------------------------------------------------------------------------------------------------------------+
And that was that.
Using TV Headend as a PVR client
Minor problem here. The automatic update to a newer client version was failing, and the older client was crashing. Uninstalled the old one, did an install of the newer release, and it was back up and running (existing config was preserved).
