LinkBack URL
About LinkBacks
cPanel never installs mySQL properly on FreeBSD fresh install
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 ?!!
Reply With Quote
