cPanel & WHM Version 94 has been released, and brings a slew of great updates. Take a look at what is included, and then upgrade today!

Horde to connect to Mysql through sockets, not networking, to let servers skip networking

eurorocco shared this idea 7 years ago
Completed

For a long time we had Horde working, connecting with Mysql with an /etc/my.cnf with skip-networking , but in late versions Horde demands Mysql to be accessible through local networking.

Here is the fix, but I don't want to do it and then have an upgrade overwrite it, but have it standard in Cpanel...

# vim /usr/local/cpanel/base/horde/config/conf.php

Change:

$conf['sql']['hostspec'] = 'localhost';

$conf['sql']['port'] = 3306;

$conf['sql']['protocol'] = 'tcp';

to:

$conf['sql']['protocol'] = 'unix';

$conf['sql']['socket'] = '/tmp/mysql.sock';

# /usr/local/cpanel/bin/update_horde_config

Please, please. I want to have skip-networking in /etc/my.conf to prevent outside strangers from poking the Mysql ports.

Comments (3)

photo
2

Thanks for your help and for supporting this feature! :)

photo
1

Fixed the problem for me, thanks. Please implement in cPanel.

photo
1

Thank you for requesting this functionality. In cPanel & WHM version 11.50 moved away from Horde using MySQL to Horde using SQLite. With this change Horde no longer requires network access to a database.

Replies have been locked on this page!