Guest - Testers are needed for the reworked CDateTime core component. See... https://forum.kodi.tv/showthread.php?tid=378981 (September 29) x
problem with library on mariadb
lpt2007
Junior Member
Posts: 40
#1
2019-12-28, 16:30
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
Find
Reply
black_eagle
Team-Kodi Member
Posts: 3,925
#2
2019-12-28, 16:41
(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.
Learning Linux the hard way !!
Find
Reply
lpt2007
Junior Member
Posts: 40
#3
2019-12-28, 17:05
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')
Find
Reply
pkscout
Team-Kodi Member
Posts: 3,536
#4
2019-12-28, 17:38
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.
Kodi Addons | Estuary mod | Github Projects
Find
Reply
lpt2007
Junior Member
Posts: 40
#5
2019-12-28, 18:39
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')
Find
Reply
black_eagle
Team-Kodi Member
Posts: 3,925
#6
2019-12-28, 19:26 
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.
Learning Linux the hard way !!
Find
Reply
lpt2007
Junior Member
Posts: 40
#7
2019-12-28, 19:55
(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
Find
Reply
black_eagle
Team-Kodi Member
Posts: 3,925
#8
2019-12-28, 20:14
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;
Learning Linux the hard way !!
Find
Reply
Klojum
Lost connection
Posts: 14,208
#9
2019-12-28, 20: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?
Find
Reply

Home
Search
Help
Logout Mark Read Team Forum Stats Members Help
problem with library on mariadb0