Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Sep 2003
    Posts
    8

    Default cpbackup mysql users gone?

    With the last run of /scripts/cpbackup some errors occured. From all accounts starting with a "L" the mysql users were removed.

    Grabbing mysql privs...DBD::mysql::st execute failed: There is no such grant defined for user 'lotteh' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 366.
    DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 367.
    DBD::mysql::st execute failed: There is no such grant defined for user 'lotteh' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 366.
    DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 367.

    I got a backup from 2 days ago with the mysql.sql in it for the grants. But it's very strange that it only occurs to accounts starting with the letter "L". How is it possible that this happened? We haven't changed anything.

    thanks in advance.
    regards,
    Hans Middelhoek

  2. #2
    Member
    Join Date
    Sep 2003
    Posts
    8

    Default

    Used version on this server: WHM 10.6.0 cPanel 10.8.0-R30 on FreeBSD 5.4p8
    What do you suggest. Should I make a bug report.

    thanks, Hans

  3. #3
    Member
    Join Date
    Sep 2003
    Posts
    126

    Default

    I have same problem, but not only occurs to accounts starting with the letter "L", also "J".

    My cPanel is 10.8.1-STABLE_31 on RHE 3.
    Thank you,

    -fl-
    Last edited by fleksi; 12-21-2005 at 03:17 AM.

  4. #4
    Member
    Join Date
    Oct 2002
    Posts
    751

    Default

    I have had the 'There is no such grant defined for user' error in my cpbackup mails for a long time.

    It only occurs with a few accounts on the server, all of those don't even use a mysql db!

    If anyone knows how to get rid of this error, please do tell

Similar Threads & Tags
Similar threads

  1. cpbackup changes MySQL passwords.
    By eskhosting.com in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 02-12-2009, 04:34 AM
  2. cpBackup not backing up mysql
    By EchoHost in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 10-09-2007, 10:57 AM
  3. mysql errors in cpbackup
    By nothsa in forum cPanel and WHM Discussions
    Replies: 11
    Last Post: 03-11-2006, 11:42 AM
  4. Do Not Backup Users tmp When Using /scripts/cpbackup
    By emericklaw in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 09-23-2005, 12:04 AM
  5. cpbackup - Skipping users not working?
    By justhost in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 02-10-2005, 12:46 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube