matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
https://matomo.org/
GNU General Public License v3.0
19.83k stars 2.64k forks source link

[Bug] Unable to use IPv6 database server #22677

Open cwchristerw opened 1 week ago

cwchristerw commented 1 week ago

What happened?

I'm trying to install Matomo in Docker container with using MariaDB that has IPv6 address. I'll get following error message in Web UI. "Could not connect to the database server: SQLSTATE[HY000] [2002] Failed to parse IPv6 address "[fd80:3306"

Database Address: [fd80:deaf:1::95]

What should happen?

It should be possible to use IPv6 address in database address.

How can this be reproduced?

  1. Go to https://analytics.example.com/index.php?action=databaseSetup&clientProtocol=https
  2. Add Database server settings with database address that is IPv6 address.

Matomo version

5.1.2

PHP version

8.2.24

Server operating system

Debian

What browsers are you seeing the problem on?

Firefox

Computer operating system

Linux Mint

Relevant log output

No response

Validations

randy-innocraft commented 1 week ago

Hi @cwchristerw. Thank you for creating the issue and bringing this to our attention, that's very appreciated. We have reviewed and triaged the problem internally, and we have confirmed it is an issue. Our team will prioritise this, and we will update you on the progress here when we have an update to share. If you have any further information or questions, please feel free to add them here.

cwchristerw commented 1 week ago

Thank you for your response, I'll be waiting. I'll use IPv4 temporarily until then. :smile: