+- 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: v18 problem following mysql update (/showthread.php?tid=350887)
Pages:
1
2
problem following mysql update - zeze31 - 2020-01-11
Hello
I have a problem with kodi 18.5.
I have a Mysql MariaDB base for kodi, it has been updated and since kodi can no longer find the base ...
The given database is well started and I find it in mariaDB, the port is also correct.
How do I get kodi to find her? Have you ever had this problem?
RE: problem following mysql update - black_eagle - 2020-01-11
You need to supply a debug log that shows Kodi starting up and trying to connect to the database. The instructions are --> https://kodi.wiki/view/Log_file/Easy <-- in that link. Please make sure you enable debug logging and then restart Kodi, otherwise the log will not contain the relevant information. As soon as you get to Kodi's home screen, there should be enough information in the log to help diagnose your issue so you can quit kodi and upload the log, or use the log uploader addon to do so.
RE: problem following mysql update - zeze31 - 2020-01-11
Ok i just found the line
2020-01-11 13:30:45.273 T:14272 ERROR: Unable to open database: MyVideos116 [2002](Can't connect to MySQL server on '192.168.0.21' (10061))
He cannot connect to the base but the advancesetting file has not changed however
2020-01-11 13:29:18.328 T:6596 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.21</host>
<port>3308</port>
<user>kodi</user>
<pass>*****</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.0.21</host>
<port>3308</port>
<user>kodi</user>
<pass>*****</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>How can I give you the full log file?
RE: problem following mysql update - black_eagle - 2020-01-11
To upload the full log file, open it in whatever text editor you are using and select all, then copy. go to https://paste.kodi.tv/ in your broswer. Right click in the window and paste the logfile into the window. Then click the little disk icon on the right to save the log. When the page refreshes, copy the full url in your browsers address bar and paste that into a post here.
RE: problem following mysql update - Klojum - 2020-01-11
ERROR: Unable to open database: MyVideos116 [2002](Can't connect to MySQL server on '192.168.0.21' (10061))This line should tell you enough. See https://mariadb.com/kb/en/troubleshooting-connection-issues/
Or perhaps totally reinstall MariaDb ?
RE: problem following mysql update - black_eagle - 2020-01-11
Ha yes, permissions issue or mariadb is not running.
RE: problem following mysql update - zeze31 - 2020-01-11
The link of the complete log file : https://paste.kodi.tv/itezigepur.kodi
I will look at the side of mariadb but it seemed to me that everything was correct
RE: problem following mysql update - zeze31 - 2020-01-11
I don't understand, the base is well started, I access it from PHPMyAdmin, I am good on MariaDB 10.4.7 and I find MyVideos116.
I connect well on the base with the user kodi.
I really don't understand what's blocking ...
RE: problem following mysql update - black_eagle - 2020-01-11
Error 2002 means "can't connect through local socket", 10061 means "connection refused". So, if the server is up and running, make sure that there is no firewall blocking the port and that MariaDB is configured to use the port you specified in your advancedsettings.xml (3308) because the default port is 3306.
Note that if you change the port in my.cnf you must restart mariadb for it to be applied.
RE: problem following mysql update - Klojum - 2020-01-11
Is your MariaDB allowed to do remote connections?
Better re-check your database user credentials of the user 'kodi'.
Hosting allowed should be from '%', not just the localhost.
Also re-check as well the "GRANT ALL" privileges.
RE: problem following mysql update - zeze31 - 2020-01-13
I checked, the port is set to 3308.
the Kodi user is correct, I recreated it in case but without change.
I must check the firewall of my NAS (where mariadb is installed).
For the remote access parameter on mariadb, where can I check this?
RE: problem following mysql update - Klojum - 2020-01-13
(2020-01-13, 17:08)zeze31 Wrote: For the remote access parameter on mariadb, where can I check this?In the system database table 'mysql'.
SELECT User,Host from user;where Host should be % for the user 'kodi' .
RE: problem following mysql update - zeze31 - 2020-01-14
The result of the SQL query :
Code:
User Host
kodi %
read %
root 127.0.0.1
root ::1
localhost
kodi localhost
read localhost
root localhost
nas-ts-451
root nas-ts-451I checked, there is no firewall on my server
RE: problem following mysql update - Klojum - 2020-01-14
You seem to have 2 users named 'kodi', with different Host values. Heck, there are multiple entries of several database users, even. Why? (Or did your paste go wrong?)
I'd remove the localhost one for 'kodi' for starters.
RE: problem following mysql update - zeze31 - 2020-01-14
I deleted all unnecessary users, I left only kodi% and root but no change.
Question: on my QNAP NAS, I therefore have QPHPMyAdmin and QMariaDB to install. Everything must be started or only QMariaDB?