SiteBuilder bug on FreeBSD

[yurtesen]

SiteBuilder is trying to access to mysql socket at /tmp/mysql.sock however this is at /var/db/mysql/mysql.sock in FreeBSD boxes.

Below is some logs from the H-Sphere updater, the SiteBuilder is looking at the socket although all my.cnf files point to /var/db/mysql/mysql.sock

| | |-- Check/install SiteBuilder related packages.
| | | |-- SiteBuilder post-install stage
| | | | |-- Reconfiguring SiteBuilder Mysql database at A.B.C.D ...
| | | | |--Logs saved to /usr/local/sitebuilder/tmp/sb_config-0909161144.log
| | | | |-- Postinstall SiteBuilder configuration ...
| | | | |-- sitebuilder group exists (FreeBSD)
| | | | |-- sitebuilder user exists. Modifying ... (FreeBSD)
| | | | |-- htdocs/sites owners changed
| | | | |-- htdocs/tmp owners changed
| | | | |-- htdocs/images/logos owners changed
| | | | |-- tmp owners changed
| | | | |-- ~cpanel/apache/logs/fastcgi owners changed
| | | | |-- enabling need PHP extensions and accelerators
| | | | |-- Generating SiteBuilder VH config file ...
| | | | |-- Backing up sitebuilder.conf as backup/sitebuilder-16.09.09-11:44:23.conf
| | | | |-- Reconfiguring httpd CP service ...
| | | | |-- Restarting httpd CP service ... OK
| | | | |-- SiteBuilder Hotfix installation ...
| | | | |-- SiteBuilder default mysql user will be used: sitebuilder_db
Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
file: /usr/local/sitebuilder/include/Zend/Db/Adapter/Pdo/Abstract.php
line: 131
code: 0
Internal Sitebuilder error.
Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
file: /usr/local/sitebuilder/include/Zend/Db/Adapter/Pdo/Abstract.php
line: 131
code: 0
| | | | |-- *** Failed to execute sb_patch refresh! ***
| | | | `-- SiteBuilder post-install stage
| | | `-- Check/install SiteBuilder related packages.

Also the SiteBuilder seems to be using ancient and wrong perl modules on FreeBSD.

I see that the p5-DBD-mysql41-3.0007 was installed which is for MySQL 4.1! You should use MySQL 5.0 DBD!

This causes (although this is from /tmp problem, it gets fixed if you use the right module):

root@cp:/usr/local/sitebuilder/utils# ./mysql_ping.pl
DBI connect('mysql:localhost:3306','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at ./mysql_ping.pl line 18
2002
root@cp:/usr/local/sitebuilder/utils#

After changing to p5-DBD-mysql50-4.010:

DBI connect('mysql:localhost:3306','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at ./mysql_ping.pl line 18
1045

(which is normal since password is not there but it can reach MySQL!...). If you want to use the ancient one which shipped with FreeBSD 6.2(although people perhaps would prefer if you would use a newer one!), you can get it from:

ftp://ftp-archive.freebsd.org/pub/FreeBSD-Archive/old-releases/i386/6.2-RELEASE/packages/databases/