Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    166
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,561
    Likes Received:
    42
    Trophy Points:
    308
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    166
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,561
    Likes Received:
    42
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    Are you using FreeBSD or Linux?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    166
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,561
    Likes Received:
    42
    Trophy Points:
    308
    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
    
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    166
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,561
    Likes Received:
    42
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. shann

    shann Well-Known Member

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

    sunyl Active Member

    Joined:
    Oct 12, 2004
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    156
    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,561
    Likes Received:
    42
    Trophy Points:
    308
    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/
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice