RESOLVED: Can't get mysql DB to function

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!

Quote

<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>

Display More

The DB seems to be configured properly?

Quote

2021-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.

Display More

There is clearly something wrong with the database.

Quote

2021-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]

Display More

I'm pretty confident the issue is with my server. It's not listening, for some reason.

I will post back, if/when I figure it out.

Fantastic. Thank you, mglae.