Kodi Community Forum
problem with library on mariadb - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: problem with library on mariadb (/showthread.php?tid=350479)

problem with library on mariadb - lpt2007 - 2019-12-28

I added this in advancedsettings.xml:

Code:
  <videodatabase>
    <name>kodi_all_</name>
    <type>mysql</type>
    <host>ip</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </videodatabase>

and I added kodi_all_116 database in mariadb and granted ALL PRIVILEGES to user.

I get this error in kodi:
Code:
2019-12-28 14:28:32.328 T:685 NOTICE: MYSQL: Connected to version 10.3.17-MariaDB
2019-12-28 14:28:32.344 T:685 ERROR: SQL: [kodi_all_116] The table does not exist Query: SELECT idVersion FROM version
2019-12-28 14:28:32.345 T:685 ERROR: Process error processing job


RE: problem with library on mariadb - black_eagle - 2019-12-28

(2019-12-28, 16:30)lpt2007 Wrote: added kodi_all_116 database in mariadb

That's what you have done wrong.  Don't add or attempt to create the database(s) yourself, let kodi do it.

So, log into mariadb and drop that database you made.  Then start kodi and it should create it for you.

RE: problem with library on mariadb - lpt2007 - 2019-12-28

I alredy try that. Here is error if I let kodi create the database:

Code:
2019-12-28 15:03:15.639 T:2252  NOTICE: MYSQL: Connected to version 10.3.17-MariaDB
2019-12-28 15:03:15.648 T:2252   ERROR: Unable to open database: kodi_video_all_116 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_116')
2019-12-28 15:03:15.661 T:2252   ERROR: Unable to open database: kodi_video_all_115 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_115')
2019-12-28 15:03:15.674 T:2252   ERROR: Unable to open database: kodi_video_all_114 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_114')
2019-12-28 15:03:15.689 T:2252   ERROR: Unable to open database: kodi_video_all_113 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_113')
2019-12-28 15:03:15.700 T:2252   ERROR: Unable to open database: kodi_video_all_112 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_112')
2019-12-28 15:03:15.711 T:2252   ERROR: Unable to open database: kodi_video_all_111 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_111')
2019-12-28 15:03:15.743 T:2252   ERROR: Unable to open database: kodi_video_all_110 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_110')
2019-12-28 15:03:15.755 T:2252   ERROR: Unable to open database: kodi_video_all_109 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_109')
2019-12-28 15:03:15.768 T:2252   ERROR: Unable to open database: kodi_video_all_108 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_108')
2019-12-28 15:03:15.784 T:2252   ERROR: Unable to open database: kodi_video_all_107 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_107')
2019-12-28 15:03:15.799 T:2252   ERROR: Unable to open database: kodi_video_all_106 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_106')
2019-12-28 15:03:15.811 T:2252   ERROR: Unable to open database: kodi_video_all_105 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_105')
2019-12-28 15:03:15.845 T:2252   ERROR: Unable to open database: kodi_video_all_104 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_104')
2019-12-28 15:03:15.857 T:2252   ERROR: Unable to open database: kodi_video_all_103 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_103')
2019-12-28 15:03:15.870 T:2252   ERROR: Unable to open database: kodi_video_all_102 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_102')
2019-12-28 15:03:15.881 T:2252   ERROR: Unable to open database: kodi_video_all_101 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_101')
2019-12-28 15:03:15.894 T:2252   ERROR: Unable to open database: kodi_video_all_100 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_100')
2019-12-28 15:03:15.905 T:2252   ERROR: Unable to open database: kodi_video_all_99 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_99')
2019-12-28 15:03:15.916 T:2252   ERROR: Unable to open database: kodi_video_all_98 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_98')
2019-12-28 15:03:15.949 T:2252   ERROR: Unable to open database: kodi_video_all_97 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_97')
2019-12-28 15:03:15.961 T:2252   ERROR: Unable to open database: kodi_video_all_96 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_96')
2019-12-28 15:03:15.973 T:2252   ERROR: Unable to open database: kodi_video_all_95 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_95')
2019-12-28 15:03:15.990 T:2252   ERROR: Unable to open database: kodi_video_all_94 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_94')
2019-12-28 15:03:16.002 T:2252   ERROR: Unable to open database: kodi_video_all_93 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_93')
2019-12-28 15:03:16.014 T:2252   ERROR: Unable to open database: kodi_video_all_92 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_92')
2019-12-28 15:03:16.045 T:2252   ERROR: Unable to open database: kodi_video_all_91 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_91')
2019-12-28 15:03:16.060 T:2252   ERROR: Unable to open database: kodi_video_all_90 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_90')
2019-12-28 15:03:16.075 T:2252   ERROR: Unable to open database: kodi_video_all_89 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_89')
2019-12-28 15:03:16.086 T:2252   ERROR: Unable to open database: kodi_video_all_88 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_88')
2019-12-28 15:03:16.100 T:2252   ERROR: Unable to open database: kodi_video_all_87 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_87')
2019-12-28 15:03:16.111 T:2252   ERROR: Unable to open database: kodi_video_all_86 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_86')
2019-12-28 15:03:16.127 T:2252   ERROR: Unable to open database: kodi_video_all_85 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_85')
2019-12-28 15:03:16.157 T:2252   ERROR: Unable to open database: kodi_video_all_84 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_84')
2019-12-28 15:03:16.169 T:2252   ERROR: Unable to open database: kodi_video_all_83 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_83')
2019-12-28 15:03:16.181 T:2252   ERROR: Unable to open database: kodi_video_all_82 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_82')
2019-12-28 15:03:16.193 T:2252   ERROR: Unable to open database: kodi_video_all_81 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_81')
2019-12-28 15:03:16.206 T:2252   ERROR: Unable to open database: kodi_video_all_80 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_80')
2019-12-28 15:03:16.217 T:2252   ERROR: Unable to open database: kodi_video_all_79 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_79')
2019-12-28 15:03:16.248 T:2252   ERROR: Unable to open database: kodi_video_all_78 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_78')
2019-12-28 15:03:16.262 T:2252   ERROR: Unable to open database: kodi_video_all_77 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_77')
2019-12-28 15:03:16.274 T:2252   ERROR: Unable to open database: kodi_video_all_76 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_76')
2019-12-28 15:03:16.288 T:2252   ERROR: Unable to open database: kodi_video_all_75 [1044](Access denied for user 'admin'@'%' to database 'kodi_video_all_75')


RE: problem with library on mariadb - pkscout - 2019-12-28

It shouldn't make a difference, but unless there is a very specific reason you need your Kodi databases to start with kodi_all_ you can delete the name section from the XML. With that Kodi will use its default names with nothing added.

RE: problem with library on mariadb - lpt2007 - 2019-12-28

I try with mysql:

Code:
2019-12-28 16:36:25.974 T:4697  NOTICE: MYSQL: Connected to version 8.0.18
2019-12-28 16:36:26.015 T:4697   ERROR: Unable to open database: kodi_all_116 [1049](Unknown database 'kodi_all_116')
2019-12-28 16:36:26.104 T:4697   ERROR: Unable to open database: kodi_all_115 [1049](Unknown database 'kodi_all_115')
2019-12-28 16:36:26.194 T:4697   ERROR: Unable to open database: kodi_all_114 [1049](Unknown database 'kodi_all_114')
2019-12-28 16:36:26.281 T:4697   ERROR: Unable to open database: kodi_all_113 [1049](Unknown database 'kodi_all_113')
2019-12-28 16:36:26.378 T:4697   ERROR: Unable to open database: kodi_all_112 [1049](Unknown database 'kodi_all_112')
2019-12-28 16:36:26.481 T:4697   ERROR: Unable to open database: kodi_all_111 [1049](Unknown database 'kodi_all_111')
2019-12-28 16:36:26.582 T:4697   ERROR: Unable to open database: kodi_all_110 [1049](Unknown database 'kodi_all_110')
2019-12-28 16:36:26.690 T:4697   ERROR: Unable to open database: kodi_all_109 [1049](Unknown database 'kodi_all_109')
2019-12-28 16:36:26.788 T:4697   ERROR: Unable to open database: kodi_all_108 [1049](Unknown database 'kodi_all_108')
2019-12-28 16:36:26.886 T:4697   ERROR: Unable to open database: kodi_all_107 [1049](Unknown database 'kodi_all_107')
2019-12-28 16:36:27.005 T:4697   ERROR: Unable to open database: kodi_all_106 [1049](Unknown database 'kodi_all_106')
2019-12-28 16:36:27.106 T:4697   ERROR: Unable to open database: kodi_all_105 [1049](Unknown database 'kodi_all_105')
2019-12-28 16:36:27.206 T:4697   ERROR: Unable to open database: kodi_all_104 [1049](Unknown database 'kodi_all_104')
2019-12-28 16:36:27.310 T:4697   ERROR: Unable to open database: kodi_all_103 [1049](Unknown database 'kodi_all_103')
2019-12-28 16:36:27.411 T:4697   ERROR: Unable to open database: kodi_all_102 [1049](Unknown database 'kodi_all_102')
2019-12-28 16:36:27.515 T:4697   ERROR: Unable to open database: kodi_all_101 [1049](Unknown database 'kodi_all_101')
2019-12-28 16:36:27.620 T:4697   ERROR: Unable to open database: kodi_all_100 [1049](Unknown database 'kodi_all_100')
2019-12-28 16:36:27.726 T:4697   ERROR: Unable to open database: kodi_all_99 [1049](Unknown database 'kodi_all_99')
2019-12-28 16:36:27.818 T:4697   ERROR: Unable to open database: kodi_all_98 [1049](Unknown database 'kodi_all_98')
2019-12-28 16:36:27.914 T:4697   ERROR: Unable to open database: kodi_all_97 [1049](Unknown database 'kodi_all_97')
2019-12-28 16:36:28.016 T:4697   ERROR: Unable to open database: kodi_all_96 [1049](Unknown database 'kodi_all_96')


RE: problem with library on mariadb - black_eagle - 2019-12-28 

sql:
Access denied for user 'admin'@'%'

means you have set your permissions wrongly. 
(2019-12-28, 16:30)lpt2007 Wrote: <user>kodi</user>
    <pass>kodi</pass>

That's what you said is in your advancedsettings.xml but the log you posted shows kodi trying to connect as admin.  You can't have it both ways. 

With the mysql stuff (and not mariadb), that is to be expected.  Kodi will attempt to connect to it's current version database.  If that fails (eg, new install so no db) it will then attempt to connect to older versions in case one exists and it can be upgraded.  If all that fails (and it has the correct permissions) then it will create new databases.

RE: problem with library on mariadb - lpt2007 - 2019-12-28

(2019-12-28, 19:26)black_eagle Wrote: 
sql:
Access denied for user 'admin'@'%'

means you have set your permissions wrongly. 
(2019-12-28, 16:30)lpt2007 Wrote: <user>kodi</user>
    <pass>kodi</pass>

That's what you said is in your advancedsettings.xml but the log you posted shows kodi trying to connect as admin.  You can't have it both ways. 

With the mysql stuff (and not mariadb), that is to be expected.  Kodi will attempt to connect to it's current version database.  If that fails (eg, new install so no db) it will then attempt to connect to older versions in case one exists and it can be upgraded.  If all that fails (and it has the correct permissions) then it will create new databases. 

This is only example config, not real.

Error I posted is only first start error.

Thanks for help Smile

RE: problem with library on mariadb - black_eagle - 2019-12-28

Well, it's difficult to help you if you don't post the actual stuff.  My crystal ball seems to be broken at the moment.

Regardless, that first error is a permissions error with mariadb and means that the kodi client does not have the required permissions to connect remotely.

Log into mariadb and post the output of show grants;

RE: problem with library on mariadb - Klojum - 2019-12-28

(2019-12-28, 16:30)lpt2007 Wrote: and I added kodi_all_116 database in mariadb and granted ALL PRIVILEGES to user.
Seems like your 'user' admin still does not have sufficient database rights.
Did you do 'flush privileges' or do a mysql server restart after the grant command?