Xibo

xibo does not seem to honour mysql socket path in php.ini

Asked by bork

Despite having my mysql socket path explicitly set in php.ini (to /srv/mysql/mysql.sock), xibo 1.6.3 upgrade still fails to connect to mysql as it's still trying to connect to a socket in /var/lib/mysql.

This seems to be a PDO compile-time assumption issue, but should be easy enough to fix.

Question information

Language:
English Edit question
Status:
Answered
For:
Xibo Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Alex Harrington (alexharrington) said : 		#1

You need to restart your webserver for changes to the php configuration to
be reflected in the running PHP system. Xibo itself has no hardcoded path
to the MySQL socket

Revision history for this message
bork (robk-h) said : 		#2

No, Xibo might not, but it's using a compile-time PDO option that is hardcoded.

MYSQL_SOCKET => /var/lib/mysql/mysql.sock
mysql.default_socket => /srv/mysql/mysql.sock => /srv/mysql/mysql.sock

Revision history for this message
Alex Harrington (alexharrington) said : 		#3

Then you would need to recompile php to change that hardcoded option

Revision history for this message
bork (robk-h) said : 		#4

And I've just found pdo_mysql.default_socket but there are some php versions that don't honour it.

Revision history for this message
Alex Harrington (alexharrington) said : 		#5

My point is those are all PHP configuration options, not Xibo ones.

If PHP isn't honouring it's configuration then you need to file bugs against PHP not Xibo.

Can you help with this problem?

Provide an answer of your own, or ask bork for more information if necessary.

To post a message you must log in.