cPanel never installs mySQL properly on FreeBSD fresh install

hicom

Well-Known Member
May 23, 2003
290
4
168
Hi,

For some reason, I've tested this on multiple versions of FreeBSD starting from FBSD 4.7 , 4.11, 5.4 and cPanel never install mySQL properly.

The first install always fails getting mySQL to start, and further tweaking always needed on fresh install to get it to work.

This is sample code from a fresh cPanel install on FreeBSD 4.11 box:

Code:
Running mtree for mysql-server-4.0.22..
mtree -U -f +MTREE_DIRS -d -e -p /usr/local >/dev/null
Running post-install for mysql-server-4.0.22..
Attempting to record package into /var/db/pkg/mysql-server-4.0.22..
Trying to record dependency on package 'rc_subr-1.31' with 'sysutils/rc_subr' origin.
Trying to record dependency on package 'mysql-client-4.0.22' with 'databases/mysql40-client' origin.
Package mysql-server-4.0.22 registered in /var/db/pkg/mysql-server-4.0.22
Running post install scripts for mysql-server-4.0....Done

Waiting for MySQL to restart ...
root     45933  0.2  0.1   648  312  ??  Ss    4:36PM   0:00.05 /bin/sh /usr/local/bin/mysqld_safe --user=mysql
mysql    45947 50.5  8.2 49440 21056  ??  S     4:36PM   0:02.64 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/mysql/ns4.smallvillages.com.pid
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

If you get 'Access denied' errors, you should run this script again
and give the MySQL root user password as an argument!
Converting all privilege tables to MyISAM format
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore these!
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Creating the new table and column privilege tables
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any Unknown column errors from this
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Fixing the func table
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Adding new fields used by MySQL 4.0.2 to the privilege tables
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Waiting for mysql to restart..............finished.


/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

I know how to fix the problem, but why does cPanel until now can't install mySQL properly on a FreeBSD box ?!!
 

hicom

Well-Known Member
May 23, 2003
290
4
168
Thx. I just did!

Surprisingly, I've installed cPanel 3 yrs ago and they had the mySQL problem, and now i'm installing it again and still the mySQL problem. I thought maybe not enough FreeBSD people around here to complain to them :)
 

bjarne

Well-Known Member
Mar 23, 2002
135
0
316
I tryed FreeBSD but decided to go mainstream - even the Trustix was second class to RH.
I think FreeBSD is cool but for Cpanel I now use Centos and are wey pleased. The latest installs I did was perfect:) Nothing wrong:)