Unable to open MYSQL database

Question

Unable to open MYSQL database

Manuel5cc opened this issue 3 years ago · 14 comments

I am getting this error everytime, it seems that Kodi can't connect to my database but it shoukld:
ERROR : Unable to open database: MyVideos92 [2013](Lost connection to MySQL server at 'reading initial communication packet', system error: 2)

I have redacted some data for security reasons.

Answer 1 · 2021-10-15T17:21:04.000Z

The error tells you what the problem is. Access is denied. You need to fix permissions on your sql server. I'd try remove any IP restriction on the user.

Answer 2 · 2021-10-15T17:22:33.000Z

If the problem was the sql server I wouldn't be able to access from my other kodi instances but that is not the case. I think there is something deeper here.

Answer 3 · 2021-10-15T17:24:26.000Z

There isn't. Many use it. And I use it. Again, remove the IP range restriction on the user and then try.

…

On Sat, 16 Oct 2021, 06:22 Manuel, ***@***.***> wrote: If the problem was the sql server I wouldn't be able to access from my other kodi instances but that is not the case. I think there is something deeper here. — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub <#4 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABPQAKPGT4U4TIGK7A5QCFTUHBPOHANCNFSM5GCLEQXA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

Answer 4 · 2021-10-15T17:29:36.000Z

Lost connection to MySQL server at 'reading initial communication packet', system error: 2)

I'll try to investigate further on this

Answer 5 · 2021-10-15T17:34:22.000Z

Is this Matrix AMD64? Or arm? Or arm64?

Answer 6 · 2021-10-15T17:36:36.000Z

Is this Matrix AMD64? Or arm? Or arm64?

It is Matrix arm (Raspberry Pi 4)

Answer 7 · 2021-10-15T17:39:04.000Z

Are you running 64bit or 32bit os?

Answer 8 · 2021-10-15T17:43:01.000Z

Googling your error, still seems like your sql server isn't allowing the docker container. Remember that the sql server may see the Dockers internal IP. Not the pis IP. Or it may be the other way around.

Answer 9 · 2021-10-15T17:43:36.000Z

Are you running 64bit or 32bit os?

This is all the available information about my OS:

PRETTY_NAME="Raspbian GNU/Linux 10 (buster)"
NAME="Raspbian GNU/Linux"
VERSION_ID="10"
VERSION="10 (buster)"
VERSION_CODENAME=buster
ID=raspbian
ID_LIKE=debian
HOME_URL="http://www.raspbian.org/"
SUPPORT_URL="http://www.raspbian.org/RaspbianForums"
BUG_REPORT_URL="http://www.raspbian.org/RaspbianBugs"

Looks like it is a 32bit version since 64bit is still in beta.

Answer 10 · 2021-10-15T17:47:27.000Z

Ok. Well keep trying. The connection error is usually wrong port or firewall, or IP isn't allowed. Report back when you figure out the issue.

…

On Sat, 16 Oct 2021, 06:43 Manuel, ***@***.***> wrote: Are you running 64bit or 32bit os? This is all the available information about my OS: PRETTY_NAME="Raspbian GNU/Linux 10 (buster)" NAME="Raspbian GNU/Linux" VERSION_ID="10" VERSION="10 (buster)" VERSION_CODENAME=buster ID=raspbian ID_LIKE=debian HOME_URL="http://www.raspbian.org/" SUPPORT_URL="http://www.raspbian.org/RaspbianForums" BUG_REPORT_URL="http://www.raspbian.org/RaspbianBugs" Looks like it is a 32bit version since 64bit is still in beta. — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub <#4 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABPQAKO33M7W5C4GLSCRB6TUHBR5JANCNFSM5GCLEQXA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

Answer 11 · 2021-10-15T17:49:36.000Z

Ok. Well keep trying. The connection error is usually wrong port or firewall, or IP isn't allowed. Report back when you figure out the issue.

I have tried giving the container a different IP using a macvlan network and the issue dissapears, but I loose access to the webui.

Answer 12 · 2021-10-15T17:56:34.000Z

I'd change your sql bind to 0.0.0.0 and make sure the user your using allows any IP. If it's all local network, you don't need to be so restricted. And trying to change a docker container IP is a bad idea. Just let docker handle them. They often change so make your sql setup allows for that by doing the above

Answer 13 · 2021-10-16T09:14:14.000Z

I'd change your sql bind to 0.0.0.0 and make sure the user your using allows any IP. If it's all local network, you don't need to be so restricted. And trying to change a docker container IP is a bad idea. Just let docker handle them. They often change so make your sql setup allows for that by doing the above

I finally opted for situating my sql server in a remote location and that seemed to make it work. Not sure if it's ideal but from an enduser perspective it works.

Answer 14 · 2021-10-16T17:38:12.000Z

A remote location?
In my setup, I run my sql (mariadb) in a docker container on my local NAS. And headless is also in a container on the same Nas.
https://hub.docker.com/_/mariadb