2020-08-03, 21:27
According to your log, your device does connect to mariadb.
But then I noticed
Unless you have copied the sources.xml file (and possibly mediasources.xml) to that device, I doubt that updating the library with it on startup is a good idea.
The address needs to be the address of the PC or device running mariadb, although the log does show it connecting.
If you do
Then you could try
Quote:
2020-08-02 09:33:12.989 T:4559 NOTICE: MYSQL: Connected to version 10.3.22-MariaDB-1ubuntu1
But then I noticed
Quote:2020-08-02 09:33:13.864 T:4445 NOTICE: UpdateLibraries: Starting video library startup scan
Unless you have copied the sources.xml file (and possibly mediasources.xml) to that device, I doubt that updating the library with it on startup is a good idea.
(2020-08-03, 14:13)Yoshifriend Wrote: No I've tried another pc to test thats why I wrote the pc running kodi is 192.168.1.162.
The address needs to be the address of the PC or device running mariadb, although the log does show it connecting.
If you do
mysql -u kodi -p
and then enter the password from your advancedsettings,xml file then that should log you into mariadb as the kodi user. Then do show databases;
to check that the db's exist.Then you could try
use MyVideos116;
followed by select * from movie where idMovie = 1;
and ensure it returns some data.