Mysql servers predefined socket location



Starting with H-Spehre 2.5.0 Mysql servers have predefined socket location, set in /etc/my.cnf conf file (permissions for /etc/my.conf are changed to "readable for all"), which are:

  • for FreeBSD:
    /var/db/mysql/mysql.sock
  • for Linux:
    /var/lib/mysql/mysql.sock

User's php web applications can locate this socket, because it's set in php.ini file:

  • for FreeBSD:
    mysql.default_socket = /var/db/mysql/mysql.sock
  • for Linux:
    mysql.default_socket = /var/lib/mysql/mysql.sock

User's perl web applications can locate this socket too, because during H-Sphere update, DBD::mysql driver, located in system pathes (/usr/lib/....) is patched by adding the following string to a corresponding perl module:

$dsn .= ";mysql_read_default_file=/etc/my.cnf";

Though if you decide to update DBD::mysql driver or system perl version, execute the following script after the update of DBD::mysql driver or system perl version:

/hsphere/local/config/mysql/scripts/dbd-mysql-config


Copyright 1998-2008. Positive Software Corporation.
All rights reserved.