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.

Cpanel backups fail - Mysqladmin error

Discussion in 'General Discussion' started by forlinuxsupport, Jul 25, 2005.

  1. forlinuxsupport

    forlinuxsupport Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2004
    Messages:
    386
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hi

    When I run the cpanel backup from the command line it runs fine ( /scripts/cpbackup ). :)
    When it runs via its cronjob at night it runs fine, BUT throws up the mysql error below) :mad:
    It does seem to backup the files fine.


    ---------------------------------------------------------------------------------------------------------
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user: 'root@localhost' (Using password: NO)'

    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: Removing leading `/' from member names
    tar: /var/lib/mysql/mysql.sock: socket ignored pkgacct started.
    pkgacct version 4.1 - running with uid 0 using time::hires for speedups Copying Reseller Config...Done Copying SSL Certificates, CSRS, and Keys...Done Copying Mail files....Done Copying frontpage files....Done Copying proftpd file....Done
    Entering timeout safety mode Grabbing mysql dbs............
    Done

    Grabbing mysql privs...Done
    Grabbing PostgreSQL databases............
    Done
    Grabbing PostgreSQL privileges...Done
    Leaving timeout safety mode
    Copying mailman lists....Done
    Copying mailman archives....Done
    Copying homedir....Done
    Copying cpuser file.......Done
    Copying crontab file.......Done
    Copying quota info.......Done
    Storing Subdomains....
    Done
    -------------------------------------------------------------------------------------------

    If i edit the cpbackup script and comment out the lines where it does the "mysqladmin variables" the backup works correctly via its cronjob. :)

    It seems that that bit of the script is there to try detect where mysql is installed (by searching the output from mysqladmin variables). But a few lines up it is declared with its proper path. :eek:

    Unfortunely cpanel must check if this script is unmodified and changes it back t how it was, so i get the nasty mysqladmin failed error mesages. :confused:

    any ideas ?
    I will log this as a bug request too.

    cheers
    andy
    :)
     
  2. forlinuxsupport

    forlinuxsupport Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2004
    Messages:
    386
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    *bump*

    any ideas ?? :eek:
     
  3. forlinuxsupport

    forlinuxsupport Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2004
    Messages:
    386
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    *bump bump*

    anyone ?
     
  4. richy

    richy Well-Known Member

    Joined:
    Jun 30, 2003
    Messages:
    276
    Likes Received:
    1
    Trophy Points:
    16
    Try using WHM to set the MySQL Root Password.
     
  5. forlinuxsupport

    forlinuxsupport Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2004
    Messages:
    386
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    I have reset the password via WHM.. still no difference.

    And yes the file my.cnf exists in root wth the correct password.

    anyone .. help :)
     
Loading...

Share This Page