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.

If i trying to update the sql server downgrades..

Discussion in 'Database Discussions' started by torpis, Dec 15, 2005.

  1. torpis

    torpis Registered

    Joined:
    Dec 15, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    To 4.0... i had updated to version 5.0, then i dosent start again, it generates a lot of errors instead.
    How di i solve this, whay does it happen?

    Mvh Patrik
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    cPanel doesn't currently support MySQL 5. If you want to go back down to v4, then remove the v5 rpms (if that's what you used to installed it) and run:

    /scripts/mysqlup --force

    Unless you're saying that you don't want cPanel to mess around with the version of MySQL you install. In that case, look at the top of the script above and it indicates a file that you can create to prevent it from doing so.
     
  3. torpis

    torpis Registered

    Joined:
    Dec 15, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    The server still wont start after forsed installation

    Here is the messages under the installation:


    MySQL-shared-4.0.25-0
    Preparing... ########################################### [100%]
    1:MySQL-shared ########################################### [100%]

    Waiting for MySQL to restart ...
    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 '/var/lib/mysql/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 '/var/lib/mysql/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 '/var/lib/mysql/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 '/var/lib/mysql/mysql.sock' (2)

    Creating the new table and column privilege tables
    ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/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 '/var/lib/mysql/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 '/var/lib/mysql/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 '/var/lib/mysql/mysql.sock' (2)
    ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    Waiting for mysql to restart..............finished.


    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
    mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
    /usr/sbin/setfiles: labeling files under /
    matchpathcon_filespec_eval: hash table stats: 1 elements, 1/65536 buckets used, longest chain length 1
    /usr/sbin/setfiles: Done.
    Install Complete
     
  4. Shinichi Kato

    Shinichi Kato Well-Known Member

    Joined:
    Mar 7, 2005
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Saitama-ken,japan
  5. Sinewy

    Sinewy Well-Known Member

    Joined:
    May 15, 2004
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney, Australia
    cPanel Access Level:
    DataCenter Provider
    MySQL 5.0 will work with cPanel though it's unsupported.

    To disable mysqlup,

    touch /etc/mysqlupdisable
     
  6. Shinichi Kato

    Shinichi Kato Well-Known Member

    Joined:
    Mar 7, 2005
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Saitama-ken,japan
    solved it for myself.

    cd /var/lib/mysql

    ls
    test mysql tmp

    rm -r test
    rm -r tmp
    cp -r mysql 'your backup dir'
    rm -r mysql

    /scripts/mysqlup --force


    ps aux | grep mysql
    Can you find mysql processes?
    OK.Congratulations!

    And, You should change MySQL root password.
    in WHM >> SQL Services >> MySQL Root Passwd

    Warning!! That is all self responsibilities. ;)
     
  7. NetCafe

    NetCafe Registered

    Joined:
    Jan 4, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I encountered the same problem and tried your method.

    I got the following errors:

    MySQL Setup Script Version 6.1
    Fetching version information from http://updates.cpanel.net/mysqlinstall/version (RELEASE)....Done
    This is the MySQL 4.1.13 installer release number 0.glibc23 for platform
    db4-devel is installed and is the latest version.
    pam-devel is installed and is the latest version.
    openssl096b is installed and is the latest version.
    openssl is installed and is the latest version.
    openssl-devel is installed and is the latest version.
    gcc is installed and is the latest version.
    glibc-devel is installed and is the latest version.
    compat-db is installed and is the latest version.
    zlib-devel is installed and is the latest version.
    rpm-build is installed and is the latest version.
    Gathering header information file(s) from server(s)
    Server: Centos-3 - x86_64/x86_64 - Addons
    Server: Centos-3 - x86_64/x86_64 - Base
    Server: Centos-3 - x86_64/x86_64 - Extras
    Server: Centos-3 - x86_64/x86_64 - Updates
    Finding updated packages
    Downloading needed headers
    No actions to take
    Resetting MySQL to cPanel Defaults and Installing the Latest Version
    I ran out of mirrors for MySQL. at /scripts/mysqlup line 227.
     
Loading...

Share This Page