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.

backup error

Discussion in 'Data Protection' started by taproot, Mar 7, 2009.

  1. taproot

    taproot Well-Known Member

    Joined:
    Aug 22, 2008
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    Hi folks,

    I got this error today doing a full backup, first time I have seen this:

    info [mysqladmin] Not updating privileges for readitli (reseller login and no password specified in ~/.my.cnf)


    The account is not a reseller, in fact I have no reseller accounts. Strange thing is I got the same error on another account the day before.

    Any ideas what's up?

    I do full backups daily and just started getting these errors yesterday. I have not changed anything in WHM except updated my wordpress install addon.

    Thanks!
     
  2. JPC-Shaun

    JPC-Shaun Well-Known Member

    Joined:
    Oct 29, 2008
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Hi;

    Try to figure out the exact error message from the Cpanel logs on the server.

    Check the .my.cnf file to ensure that both a username and password exists for the user account. i.e your /root/.my.cnf, should look as follows:

    [client]
    user=root
    pass="rootpassword"

    To search for the other potentially relevant user .my.cnf file:
    find / -name .my.cnf
     
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,482
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    See the part that says INFO? This is not an error, just some INFO for you.
     
  4. taproot

    taproot Well-Known Member

    Joined:
    Aug 22, 2008
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    I understand that it is just info, but the fact that I did not start receiving these in the error logs until the past 2 days is a little odd. I'll check the files as noted, but I am still hoping that someone has an idea of what is causing this to happen across a few accounts.

    Cheers,
    TR
     
  5. SoftDux

    SoftDux Well-Known Member

    Joined:
    May 27, 2006
    Messages:
    983
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Johannesburg, South Africa
    cPanel Access Level:
    Root Administrator
    Does anyone know how to fix these errors? I get quite a few emails every day, from various different servers, similar to this:

    Running 'tail -f usr/local/cpanel/logs/error_log', I see a lot of entries as follows:

    And these entries appear every few minutes, as can be seen from the log entries.
     
  6. sergio2004

    sergio2004 Well-Known Member

    Joined:
    Feb 28, 2004
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Rio de Janeiro
    Hi,

    In my server occour the same error:

    The backup of xtoyscoz's account encountered errors
    Please check /usr/local/cpanel/logs/error_log and /usr/local/cpanel/logs/cpbackup/1236906004.log for more information.

    Anyone?

    Thank you.
     
  7. clicknow

    clicknow Registered

    Joined:
    Dec 17, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Me too, I have 3 servers and this started on two of them. The error_logs are empty and the backup logs suggest the backup was a success:-

    Storing Addon Domains....
    Done
    Storing ssl domain......Done
    Copying password.......Done
    Copying shell.......Done
    pkgacctfile is: //cpbackup/daily/exchange.tar.gz
    Creating Archive ....Done
    md5sum is: bbfb36c7b7a671ec11dc7f9e80d39d3e
    [cpbackup] Completed at Thu Apr 2 01:47:10 2009

    I have opened a backup and as far as I can see everything is there, at least the web and database files are, perhaps there's some cpanel goo missing? :eek:
     
  8. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,482
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:

    You simply need to view both of those logs to find the errors it speaks of and fix what it says is the problem.




    tailing that log will be of no use after the backup is completed. You'd need to tail it while the backup is running, on that account. But you wouldn't know the account having problems unless you view a previous backup log file.
     
  9. mwmconsulting

    mwmconsulting Member

    Joined:
    Apr 15, 2006
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    I just received this same error last night. I have changed nothing manually on my VPS, so I presume this is indeed a cPanel update bug.

    cPanel Developers, can you please confirm. Why would these errors start happening?

    :confused:
     
  10. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    I recommend letting our technical analysts take a look at your server so we can determine the cause of this issue and take corrective action.
     
  11. mwmconsulting

    mwmconsulting Member

    Joined:
    Apr 15, 2006
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    David,

    Thanks for the reply, but I don't think it's a one-off server issue. You have MULTIPLE people complaining about this issue and dealing w/ the errors.

    Perhaps cPanel should address the issue from their end, no?

    Thx.

    - MWM
     
  12. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Submitting a support ticket will, in my experience, substantially expedite the process of us resolving the issue. The process will be expedited since our Technical Analysts will have logs indicating how this has occurred and access to the server to properly interpret and act upon the log output. If our Technical Analysts determine this to be an issue with our software, they can begin the process of having the developers to modify the cPanel/WHM software. If instead this happens to be a result of a server configuration, our technical analysts will attempt to resolve the issue and can let you know how to implement their solution on your other servers.
     
  13. puntie

    puntie Member

    Joined:
    Oct 9, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    So hold on - has ANYONE submitted anything to cPanel's team for review? I'm having this issue and it only started a few weeks ago without any changes to the server (heck, I forgot *how* to update my server since I haven't needed to!), and clearly, I'm not alone here.

    I'd be curious to know if cPanel's team has figured this out--or if anyone else has for that matter.
     
  14. mwmconsulting

    mwmconsulting Member

    Joined:
    Apr 15, 2006
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Hey all,

    I fixed the problem on my end by creating a .my.cnf file in the root directory for each account on my VPS. This file is chmod 600 (read/write by owner only) and contains the following text:

    Code:
    [client]
    user=XXXXX
    pass="YYYYY"
    where XXXXX = user account login and YYYYY = user account password.

    No clue why this had to be done (and not happy about it), but it did solve the problem. :confused:

    Explain this to us please cPanel developers! :(

    - MWM
     
    #14 mwmconsulting, Apr 24, 2009
    Last edited: Apr 24, 2009
  15. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    From what I can tell in testing, the mysqladmin message is not caused by backups.
     
  16. puntie

    puntie Member

    Joined:
    Oct 9, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Thanks - yes MWM, looks like cPanel's update made this necessary, but perhaps we'd need an explanation from the development arm that actually made this a requirement. I thank DavidG for his presence here, but I think it'd be best to hear from someone who actually was behind the change, and I'd be certain that DavidG can speak to the right people without requiring server access. Again, multiple people are having this problem and it seems to be a result of a recent cPanel update. How many people on the cPanel team actually develop these updates? I'd imagine it wouldn't be hard to find the person behind this change.

    While your workaround is probably ideal for the time being, MWM, I don't think throwing a password in a plaintext file is something I want on my server, even if it's dedicated!

    Therefore, cPanel staff, can you please let us know what's up here?
     
  17. puntie

    puntie Member

    Joined:
    Oct 9, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Thanks Kenneth. I'm not 100% sure myself, but I don't use cPanel that heavily (I have processed backups running weekly; I normally don't log into cPanel) and I've only begun getting these as of just 2-3 weeks ago.

    If not for a backup, what *would* cause these errors to occur? It's the only process I run on cPanel that has prompted it. Everything else runs on its own (but I guess I do get cPanel automatic updates...)
     
  18. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    This message occurs when a person or process is accessing the MySQL interface in a cPanel account using the reseller override feature.

    As a refresher, the reseller override feature is what allows a reseller ( root is also a reseller in the cPanel system ) to login to a user's cPanel account using the reseller's password. The login can happen directory by access https://example.com:2083 and providing the user name and reseller password as login credentials.

    More often the feature is used from within WHM via List Accounts. When clicking the cPanel icon in the List Accounts list, one is performing a reseller override login.

    It is also possible to use the reseller override feature within the reseller's cPanel interface via the Switch Reseller Account list.

    After using the reseller override login to access an end users cPanel interface, if one then visits the MySQL interface, it will cause the INFO message be logged to the cPanel error log.

    This feature can be disabled via Tweak Settings in WHM as root. Look for the entry labeled "Disable login with root or reseller password into the users' cPanel interface. Also disable switch account dropdown in themes with switch account feature."
     
  19. puntie

    puntie Member

    Joined:
    Oct 9, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Thanks Kenneth. I understand what I can do to avoid it, but I'm curious to know why it started. I hadn't touched anything with regards to reseller accounts EVER, and I've had these cPanel accounts for years. That said, I'm convinced (especially due to the timing of the recent posts) that this is because of some development issue in a later cPanel update.
     
  20. puntie

    puntie Member

    Joined:
    Oct 9, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    As an FYI, my account was changed using the settings suggested above, and I'm still getting errors when performing my backups. Something here is clearly not right.
     
Loading...

Share This Page