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!

After upgrade to mysql5, cpbackups fail with error

Discussion in 'Data Protection' started by nyjimbo, Aug 2, 2009.

  1. nyjimbo

    nyjimbo Well-Known Member

    Joined:
    Jan 25, 2003
    Messages:
    1,131
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    New York
    We just noticed that after upgrading two freebsd 6.2 servers to mysql 5.0.84 (from 4.1.25) when we do a "pkgacct" or view logs from cpbackup we see lines like this:

    Grabbing mysql privs...DBD::mysql::db do failed: Table 'mysql.procs_priv' doesn't exist at /usr/local/cpanel/Cpanel/Mysql.pm line 1074.

    or

    DBD::mysql::st execute failed: There is no such grant defined for user 'xxxxxxx_' on host '%' at /usr/local/cpanel/Cpanel/Mysql.pm line 370.
    DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 371.


    Anyone know what might have gone wrong ?

    Servers are running cPanel 11.24.5-C37629 - WHM 11.24.2 - X 3.9
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 nyjimbo, Aug 2, 2009
    Last edited: Aug 2, 2009
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,563
    Likes Received:
    43
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    Does that table exist in the mysql database?

     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. nyjimbo

    nyjimbo Well-Known Member

    Joined:
    Jan 25, 2003
    Messages:
    1,131
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    New York
    If I run it on either of the freebsd servers it shows the it does not exist:

    xxxxxx# mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 826926
    Server version: 5.0.84 FreeBSD port: mysql-server-5.0.84

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql> use mysql;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Database changed
    mysql> describe procs_priv;
    ERROR 1146 (42S02): Table 'mysql.procs_priv' doesn't exist
    mysql>
     
    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,563
    Likes Received:
    43
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    You might need to run one of the following:

    /usr/local/bin/mysql_upgrade

    /usr/local/bin/mysql_fix_privilege_tables
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. nyjimbo

    nyjimbo Well-Known Member

    Joined:
    Jan 25, 2003
    Messages:
    1,131
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    New York
    This looks familiar:

    /usr/local/bin/mysql_fix_privilege_tables

    I will run that and see if it fixes it. I could have sworn I did this before for some reason a long time ago, not sure why but might have been something similiar.

    Thanks Kenneth !
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. nyjimbo

    nyjimbo Well-Known Member

    Joined:
    Jan 25, 2003
    Messages:
    1,131
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    New York
    Ok that seems to have fixed it. Thanks again.
     
    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