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!

Databases not found problem

Discussion in 'Database Discussion' started by hamza bel, Jun 10, 2018.

  1. hamza bel

    hamza bel Member

    Joined:
    Jun 10, 2018
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    morocco
    cPanel Access Level:
    Root Administrator
    A backup copy has been uploaded to all accounts " ROOT"

    All database users are Not found in all accounts

    Code:
    
    [B]RESTORE: 1 completed, 1 had warnings, and 0 failed.[/B]
    [URL='https://xxx.xxx.xxxx2087/cpsess3943195933/scripts5/render_transfer_log?transfer_session_id=1544921331quick20180610213000AhDox0i&log_file=item-RESTORE_AccountLocal_djrap']RESTORE: Account “djrap”: Warnings [/URL]
    The system failed to grant privileges on the database “djrap_vb” to the user “djrap_vb” because of an error: (XID rqvrz3) The system user “djrap” does not control a MySQL user named “djrap_vb”.
    The system failed to grant privileges on the database “djrap_vb” to the user “djrap_vb” because of an error: (XID 43y8qk) The system user “djrap” does not control a MySQL user named “djrap_vb”.
    The system failed to grant privileges on the database “djrap_vb” to the user “djrap_vb” because of an error: (XID y8vgfg) The system user “djrap” does not control a MySQL user named “djrap_vb”.
    MAXPASSENGERAPPS: The key “MAXPASSENGERAPPS” is unknown, so the system will not restore this key.
    
    -----------------------------------------------------------------------
    Mysql
    Preparing MySQL restore …
    Databases owned by “djrap” will be overwritten on conflict.
    Restoring MySQL databases
    Restoring the database “djrap_vb” as “djrap_vb” …
    The system has created a new database named “djrap_vb”.
    Granting “djrap” access to “djrap_vb” with temporary password …
    Spawning restoration subprocess for “djrap_vb” …
    Connecting to MySQL server as “djrap” in order to restore “djrap_vb” …
    Releasing objects in preparation for database restore for “djrap_vb” …
    Cleaning up in preparation for database restore for “djrap_vb” …
    Disabling InnoDB strict mode for database restore for “djrap_vb” …
    Restoring database data for “djrap_vb” …
    The database restoration subprocess for “djrap_vb” is running …
    The database restoration subprocess for “djrap_vb” has opened the SQL archive.
    The database restoration subprocess for “djrap_vb” has closed the SQL archive.
    The database restoration subprocess for “djrap_vb” has ended.
    The system has restored the contents of the database “djrap_vb”.
    Restoring MySQL database mappings
    Restoring MySQL privileges
    Database users owned by “djrap” will be overwritten on conflict.
    Restoring MySQL grants
    The system failed to grant privileges on the database “djrap_vb” to the user “djrap_vb” because of an error: (XID rqvrz3) The system user “djrap” does not control a MySQL user named “djrap_vb”.
    The system failed to grant privileges on the database “djrap_vb” to the user “djrap_vb” because of an error: (XID 43y8qk) The system user “djrap” does not control a MySQL user named “djrap_vb”.
    The system failed to grant privileges on the database “djrap_vb” to the user “djrap_vb” because of an error: (XID y8vgfg) The system user “djrap” does not control a MySQL user named “djrap_vb”.
    Restoring MySQL access hosts
    Storing MySQL Grants
    Mysql
    
     

    Attached Files:

    #1 hamza bel, Jun 10, 2018
    Last edited by a moderator: Jun 10, 2018
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,888
    Likes Received:
    90
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Samet Chan

    Samet Chan Well-Known Member

    Joined:
    Jun 24, 2016
    Messages:
    354
    Likes Received:
    31
    Trophy Points:
    103
    cPanel Access Level:
    Root Administrator
    Twitter:
    How much your DB SQL size?

    If your DB size is too larger, it's better to use SSH command import, will take long few minutes or one hour to complete.
     
  4. hamza bel

    hamza bel Member

    Joined:
    Jun 10, 2018
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    morocco
    cPanel Access Level:
    Root Administrator
    I ordered it to delete using the command

    /scripts/restorepkg

     
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @hamza bel,

    Can you verify the version of cPanel & WHM installed on the server where the backup was generated, and on the server where the backup was restored? EX:

    Code:
    cat /usr/local/cpanel/version
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    hamza bel likes this.
  6. hamza bel

    hamza bel Member

    Joined:
    Jun 10, 2018
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    morocco
    cPanel Access Level:
    Root Administrator
    The old server from which the backup was pulled:
    cat /usr/local/cpanel/version
    11.68.0.38

    The new server:

    cat /usr/local/cpanel/version
    11.70.0.48
     
  7. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @hamza bel,

    Can you verify if skip-name-resolve is enabled through the /etc/my.cnf file on either server? This is an unsupported option and is known to result in the error message you provided.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. hamza bel

    hamza bel Member

    Joined:
    Jun 10, 2018
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    morocco
    cPanel Access Level:
    Root Administrator
    /etc/my.cnf


    [mysqld]
    performance-schema=0
    #
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    #
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    #
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock

    performance-schema=0
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0

    performance-schema=0
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    innodb_file_per_table=1
    default-storage-engine=MyISAM
    max_allowed_packet=268435456
    open_files_limit=16000

    What should you do to solve the problem
     
    #8 hamza bel, Jun 11, 2018
    Last edited by a moderator: Jun 11, 2018
  9. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @hamza bel,

    Can you open a support ticket so we can take a closer look? You can post the ticket number here and we will update this thread with the outcome.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  10. hamza bel

    hamza bel Member

    Joined:
    Jun 10, 2018
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    morocco
    cPanel Access Level:
    Root Administrator
    The old server or The new server send
     
  11. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    You can use the new server's credentials and then add the source server credentials once the ticket is opened.

    Thanks!
     
    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