I just installed 10.0.0 and can't get mysql DB to work. I've read the Wiki and searched the forum quite a bit but haven't been able to crack this nut.
Would really appreciate a bump in the right direction!
QuoteDisplay More<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>irvine</host>
<port>3306</port>
<user>user</user>
<pass>pass</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>irvine</host>
<port>3306</port>
<user>user</user>
<pass>pass</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
The DB seems to be configured properly?
QuoteDisplay More2021-10-14 01:22:32.873 T:1057 INFO <general>: Loaded settings file from special://profile/advancedsettings.xml
2021-10-14 01:22:32.874 T:1057 INFO <general>: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>172.16.1.68</host>
<port>3306</port>
<user>kodi</user>
<pass>*****</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>irvine</host>
<port>3306</port>
<user>kodi</user>
<pass>*****</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
2021-10-14 01:22:32.875 T:1057 WARNING <general>: VIDEO database configuration is experimental.
There is clearly something wrong with the database.
QuoteDisplay More2021-10-14 01:22:34.594 T:1067 ERROR <general>: Unable to open database: MyMusic82 [1045](Plugin caching_sha2_password could not be loaded: /usr/lib/mariadb/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory)
2021-10-14 01:22:34.594 T:1067 DEBUG <general>: connect replacing configured host irvine with resolved host 172.16.1.68
2021-10-14 01:22:34.624 T:1067 ERROR <general>: Unable to open database: MyMusic81 [1045](Plugin caching_sha2_password could not be loaded: /usr/lib/mariadb/plugin/cachi
ng_sha2_password.so: cannot open shared object file: No such file or directory)
2021-10-14 01:22:34.624 T:1067 DEBUG <general>: connect replacing configured host irvine with resolved host 172.16.1.68
2021-10-14 01:22:34.654 T:1067 ERROR <general>: Unable to open database: MyMusic80 [1045](Plugin caching_sha2_password could not be loaded: /usr/lib/mariadb/plugin/cachi
ng_sha2_password.so: cannot open shared object file: No such file or directory)
2021-10-14 01:22:34.655 T:1067 DEBUG <general>: connect replacing configured host irvine with resolved host 172.16.1.68
2021-10-14 01:22:34.685 T:1067 ERROR <general>: Unable to open database: MyMusic79 [1045](Plugin caching_sha2_password could not be loaded: /usr/lib/mariadb/plugin/cachi
ng_sha2_password.so: cannot open shared object file: No such file or directory)
[snip]