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.

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,125
    Likes Received:
    0
    Trophy Points:
    36
    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
     
    #1 nyjimbo, Aug 2, 2009
    Last edited: Aug 2, 2009
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

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

     
  3. nyjimbo

    nyjimbo Well-Known Member

    Joined:
    Jan 25, 2003
    Messages:
    1,125
    Likes Received:
    0
    Trophy Points:
    36
    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>
     
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    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
     
  5. nyjimbo

    nyjimbo Well-Known Member

    Joined:
    Jan 25, 2003
    Messages:
    1,125
    Likes Received:
    0
    Trophy Points:
    36
    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 !
     
  6. nyjimbo

    nyjimbo Well-Known Member

    Joined:
    Jan 25, 2003
    Messages:
    1,125
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    New York
    Ok that seems to have fixed it. Thanks again.
     
Loading...

Share This Page