[Koha-bugs] [Bug 11974] Enable non-default unix socket location for database connections.

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11974

--- Comment #32 from David Cook <dcook at prosentient.com.au> ---
Ok this is actually pretty interesting. It looks like DBD::mysql was provided
by a stable OS package, so it was already compiled presumably against the
Mariadb libraries provided on the system. 

So that's... interesting. 

Looks like mysql_real_connect is the thing doing the heavy lifting...
https://metacpan.org/source/DVEEDEN/DBD-mysql-4.050/dbdimp.c#L2107

According to
https://github.com/mariadb-corporation/mariadb-connector-c/blob/3.1/CMakeLists.txt,
the default client socket is /tmp/mysql.sock. 

I guess it's possible that OpenSuse compile the mysql-server and mysql-client
packages with a new default of /var/run/mysql/mysql.sock.

Looks like they overrode it in
http://download.opensuse.org/source/distribution/leap/15.0/repo/oss/src/mariadb-10.2.14-lp150.1.1.src.rpm
and
http://download.opensuse.org/source/distribution/leap/15.0/repo/oss/src/mariadb-connector-c-3.0.3-lp150.1.2.src.rpm

But that should mean that DBD::mysql was compiled with the same overriden
socket address...

Especially since the spec file in
http://download.opensuse.org/source/distribution/leap/15.0/repo/oss/src/perl-DBD-mysql-4.046-lp150.1.1.src.rpm
requires the libmariadb-devel which is created by that mariadb-connector-c
source package...

Bizarre...

I imagine this isn't useful for most people, but maybe it's similar to
Olli-Antti Kivilahti's issue.

-- 
You are receiving this mail because:
You are watching all bug changes.