Hi,
overall setup.
Maria DB 10 accessed from all kodi installations (PCs & Android TVs)
advancedsettings.xml extract
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.**</host>
<port>3306</port>
<user>xbmc</user>
<pass>***</pass>
<name>myvideos_xbmc</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.0.**</host>
<port>3306</port>
<user>xbmc</user>
<pass>***</pass>
</musicdatabase>
since yesterday kodi got upgraded to 21.0 within all my android TV box. DB Migration occured. Finding MyMusic83 & myvideos_xbmc131 within MariaDB
Since that automatic upgrade, none of the Android TV do succeed to start. They all stay stuck on the initial screen.
Then I decided to. Delete the new DBs then recreate them. No change on the Android TV box. All still stuck on initial screen
So I tried to upgrade one PC Windows 10 from 20.5 to 21.0.
* Delete the newly created MyMusic83 & myvideos_xbmc131
* Start install 21.0
* Then start kodi 21.0 on the PC.
-> Very long start time
-> no more music nor videos
-> within MariaDB, no DB upgrade has occured !
Looking into the kodi.log of the PC, I find
2024-04-28 22:37:08.104 T:5604 info <general>: Running database version Addons33
2024-04-28 22:37:08.105 T:5604 info <general>: Running database version ViewModes6
2024-04-28 22:37:08.105 T:5604 info <general>: Running database version Textures13
2024-04-28 22:37:10.160 T:5604 error <general>: Unable to open database: MyMusic83 [2002](Can’t connect to MySQL server on ‘192.168.0.6’ (10061))
2024-04-28 22:37:11.584 T:15428 info <general>: CIRServerSuite:
rocess: failed to connect to irss, will keep retrying every 5 seconds
2024-04-28 22:37:12.206 T:5604 error <general>: Unable to open database: MyMusic82 [2002](Can’t connect to MySQL server on ‘192.168.0.6’ (10061))
2024-04-28 22:37:14.241 T:5604 error <general>: Unable to open database: MyMusic81 [2002](Can’t connect to MySQL server on ‘192.168.0.6’ (10061))
…
and
2024-04-28 22:38:56.694 T:5604 error <general>: Unable to create new database
2024-04-28 22:38:58.747 T:5604 error <general>: Unable to open database: myvideos_xbmc131 [2002](Can’t connect to MySQL server on ‘192.168.0.6’ (10061))
2024-04-28 22:39:00.796 T:5604 error <general>: Unable to open database: myvideos_xbmc130 [2002](Can’t connect to MySQL server on ‘192.168.0.6’ (10061))
2024-04-28 22:39:02.849 T:5604 error <general>: Unable to open database: myvideos_xbmc129 [2002](Can’t connect to MySQL server on ‘192.168.0.6’ (10061))
Start a different PC still running with kodi 20.5, all is still fine. Old DBs MyMusic82 and myvideos_xbmc121 are still used as before. All works perfectly
On MariaDB nothing has changed and the user ‘xbmc’ still has same password and same authorization (full) since plenty releases
On the NAS nothing has changed too
Any idea of what could be the cause with Kodi Omega 21.0 ?
Thanks a lot in advance.