Let CiviCRM accept unix domain sockets for the database URL.

Currently the database address input of the onboarding page expects an address of the format of

$host:$

port number.

The issue is that some databases may be set up instead to communicate through a unix domain socket.

A solution would be to allow for additional address parsing that would recognise the use of a socket instead of a port number.

This address format is supported by mysqli_connect already, so we just need to adapt our handling of the input field. The solution would allow the user to specify the address something like unix:///var/run/mysql-socket.

Best wishes,

Alex

changed the description

I have a patch available at https://github.com/a-sassmannshausen/civicrm-core/tree/dev/core%23427-unix-socket .

It allows path names of the following format: 'localhost:/var/lib/mysql/mysql.sock'

added needs:concept approval triaged type:proposal labels

@atheia have you tested this? i'm just wondering how the PEAR_DB package handles DSNs such as that

Hi @seamuslee, I have been using it on my local dev install. Is the PEAR_DB package the name of the package that provides mysqli_connect or is that an additional different DB interface?

If the latter then I would need to do additional investigation. If this is the PHP standard, then I can confirm it works on my laptop.

Hi,

Thank you for raising an issue to help improve CiviCRM. We're sorry about this, but this particular issue has gone unnoticed for quite some time.

We would like to ask you to help us out and determine whether this issue should be kept open:

• If this issue is reporting a bug, can you attempt to reproduce on the latest version of CiviCRM?
• If this issue is proposing a new feature, can you verify whether the feature proposal is still relevant? Did it get the concept-approved label? Have other people also shown interest? Could it be implemented as an extension?

If yes,

• Is it something that you could help implement, either by sending a patch or hiring someone who can?
• Would you be willing to fund the work, either through a CiviCRM partner, or the Core Team?

Please feel free to comment or re-open the issue. We understand that automatic responses are annoying, but as the project evolves, we need a bit of help to triage and prioritise the most relevant issues.

Thank you for your help

P.S. This is an automated message. See infra/gitlab issue 20.

closed