The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

cPanel never installs mySQL properly on FreeBSD fresh install

Discussion in 'General Discussion' started by hicom, Sep 15, 2005.

  1. hicom

    hicom Well-Known Member

    Joined:
    May 23, 2003
    Messages:
    272
    Likes Received:
    0
    Trophy Points:
    16
    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 ?!!
     
  2. easyhoster1

    easyhoster1 Well-Known Member

    Joined:
    Sep 25, 2003
    Messages:
    659
    Likes Received:
    0
    Trophy Points:
    16
  3. hicom

    hicom Well-Known Member

    Joined:
    May 23, 2003
    Messages:
    272
    Likes Received:
    0
    Trophy Points:
    16
    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 :)
     
  4. bjarne

    bjarne Well-Known Member

    Joined:
    Mar 23, 2002
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    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:)
     
Loading...

Share This Page