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.

upgrade from 5.0.45-community MySQL to 5.0.77-community MySQL

Discussion in 'General Discussion' started by shann, Jun 18, 2009.

  1. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Website Owner
    Hello guys,

    Our old server is running with 5.0.45 and new server is with 5.0.77 and we transferred few sites to new server and we are getting database error. Can we upgrade from 5.0.45 to 5.0.77 using whm or cpanel script?

    Thanks in advance.
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    It sounds like your MySQL updates are disabled. MySQL 5.0.77 has been available in all branches since June 2, 2009 Try executing /scripts/mysqlup directly via the command line.
     
  3. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Website Owner
    Thanks a lot Kenneth, but it is not helping, how do I verify that mysql update is disabled or not?

    root@server[~]# /scripts/mysqlup
    MySQL Setup Script Version 7.0
    Fetching http://httpupdate.cpanel.net/mysqlinstall/RELEASE/cPpkgversion (0)....@209.188.92.54......connected......receiving...100%......Done
    Loaded cPPkgs::MySQL ok!
    Install Complete
    root@server [~]# mysql -v
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 15053353
    Server version: 5.0.45-community MySQL Community Edition (GPL)

    Reading history-file /root/.mysql_history
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
     
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Are you using FreeBSD or Linux?
     
  5. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Website Owner
    Linux and updated now, but not starting mysql.

    Installing /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so
    Appending installation info to /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod
    CAPTTOFU/DBD-mysql-4.011.tar.gz
    /usr/bin/make install UNINST=1 -- OK
    perlmod--Install done
    /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!
    Unable to reset root MySQL password. at /scripts/securemysql line 154.
    Install Complete
    root@server [/scripts]# mysql -v
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    root@server [/scripts]# /etc/init.d/mysql restart
    ERROR! MySQL manager or server PID file could not be found!
    Starting MySQL. ERROR! Manager of pid-file quit without updating file.
    root@server [/scripts]#
    root@server [/scripts]#
    root@server [/scripts]# mysql -v
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    root@server [/scripts]# ps -ef | grep -i mysql
    root 30900 8195 0 09:06 pts/0 00:00:00 grep -i mysql
    root@server [/scripts]# /etc/init.d/mysql restart
    ERROR! MySQL manager or server PID file could not be found!
    Starting MySQL. ERROR! Manager of pid-file quit without updating file.
     
  6. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    At this point I recommend opening a support ticket ASAP with our tech support analysts: https://tickets.cpanel.net/submit/index.cgi?reqtype=tickets

    A few things to investigate:

    1) Is there only one version of MySQL installed? On the command line, execute 'rpm -qa | grep -i mysql' It should give output like:

    Code:
    root@pxe [~/traces]# rpm -qa | grep -i mysql
    MySQL-devel-5.0.77-0.glibc23
    MySQL-shared-5.0.77-0.glibc23
    MySQL-client-5.0.77-0.glibc23
    MySQL-server-5.0.77-0.glibc23
    MySQL-bench-5.0.77-0.glibc23
    
    If there are multiple versions of any of the RPMs, remove the non 5.0.77 version.

    2) Make a copy of /etc/my.cnf and /root/.my.cnf, move them out of the way, then attempt restarting MySQL

    Code:
    # mv /etc/my.cnf /etc/my.cnf.backup
    # mv /root/.my.cnf /root/.my.cnf.backup
    # /scripts/restartsrv_mysql
    
     
  7. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Website Owner
    Kenneth, thanks a lot. I didn't find any other version, but getting this message when I start

    /scripts/restartsrv_mysql

    Failed to locate MySQL socket. Please check the mysql configuration
     
  8. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
  9. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Website Owner
    Thank you. Also, /var/lib/mysql/mysql.sock- file is missing. Would it causing the problem?
     
  10. sunyl

    sunyl Active Member

    Joined:
    Oct 12, 2004
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Hi Kenneth..

    whats the solution for this problem.

    -root# rpm -qa | grep -i mysql
    MySQL-server-5.0.81-0.glibc23
    MySQL-devel-5.0.81-0.glibc23
    MySQL-bench-5.0.81-0.glibc23
    MySQL-client-5.0.81-0.glibc23
    MySQL-shared-5.0.81-0.glibc23
    -root#
    -root# service mysql stop
    ERROR! MySQL manager or server PID file could not be found!
    -root# service mysql start
    Starting MySQL. ERROR! Manager of pid-file quit without updating file.
    -root# /scripts/restartsrv_mysql
    Failed to locate MySQL socket. Please check the mysql configuration.
    -root#
     
  11. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    try some of the suggestions I offered earlier. If they don't work please open a support ticket at https://tickets.cpanel.net/submit/
     
Loading...

Share This Page