Our features site is undergoing a refresh! Be sure to explore the revamped site and discover our latest product roadmap launching here on Monday, March 18th.

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

eurorocco shared this idea 10 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.

Replies (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!