Kodi Community Forum
Solved Cannot Connect to mysql Database - 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: Raspberry Pi (https://forum.kodi.tv/forumdisplay.php?fid=166)
+---- Thread: Solved Cannot Connect to mysql Database (/showthread.php?tid=364813)

Cannot Connect to mysql Database - rebeltaz21 - 2021-10-07

I have the biggest headache. I have been trying to work on this for HOURS and cannot figure it out.

I am running Kodi on multiple systems, all sharing the same mysql database. Up until yesterday, this database was hosted on a raspberry pi and worked fine. The pi crashed so I have migrated the network sever to a minipc running Ubuntu 20.04. I did the same thing I have always done - following https://kodi.wiki/view/MySQL/Setting_up_MySQL - but I cannot get Kodi to connect to the database. 

I have tried commenting out bind-address. I have tried using 0.0.0.0. I have tried using 192.168.1.15 (the server address). No matter what I do, the mysql error log shows:

2021-10-07T00:30:57.013665Z 8 [Warning] [MY-010055] [Server] IP address '192.168.1.21' could not be resolved: Name or service not known


Can someone PLEASE tell me why this is happening and what to do to fix it?!

RE: Cannot Connect to mysql Database - Karellen - 2021-10-07

(2021-10-07, 02:38)rebeltaz21 Wrote: I have tried using 192.168.1.15
But according to the error you posted, it is looking for '192.168.1.21'
Check your advancedsettings.xml file.

RE: Cannot Connect to mysql Database - rebeltaz21 - 2021-10-07

(2021-10-07, 03:37)Karellen Wrote:
(2021-10-07, 02:38)rebeltaz21 Wrote: I have tried using 192.168.1.15
But according to the error you posted, it is looking for '192.168.1.21'
Check your advancedsettings.xml file.
I'm sorry. That's the error shown in the mysql log file that is on the database server. mysql runs on 192.168.1.15 - which is what the advancedsettings.xml points to. One of the kodi instances is on 192.168.1.21.

RE: Cannot Connect to mysql Database - rebeltaz21 - 2021-10-07

(2021-10-07, 03:37)Karellen Wrote:
(2021-10-07, 02:38)rebeltaz21 Wrote: I have tried using 192.168.1.15
But according to the error you posted, it is looking for '192.168.1.21'
Check your advancedsettings.xml file.
Son of a crack pipe. I spent four hours staring at this screen trying to figure out what the problem was. I kept looking at the mysql error log and it didn't occur to me to look at kodi's error log. If I had... the answer was right there in the file. Something about too many connection errors and to run 'mysqladmin flush-hosts'. Bam. Issue fixed. I swear. Well, thank you anyway for putting that idea into my head.

Cannot Connect to mysql Database - Karellen - 2021-10-07

Thread marked solved.