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.

MySQL Permissions lost during update - WHM 10.8.0 cPanel 10.9.0-S13517

Discussion in 'General Discussion' started by pcsteve, Jul 3, 2007.

  1. pcsteve

    pcsteve Registered

    Joined:
    Jun 10, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hi Guys,

    I am running a VPS server with the following:
    WHM 10.8.0 cPanel 10.9.0-S13517
    RedHat 9 i686 - WHM X v3.1.0
    phpMyAdmin - 2.9.0.2
    MySQL client version: 4.1.10
    mysql version: 5.0.27-standard

    I have a database that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE".

    Does anyone know how to correct this issue?
     
    #1 pcsteve, Jul 3, 2007
    Last edited: Jul 3, 2007
  2. pcsteve

    pcsteve Registered

    Joined:
    Jun 10, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hi Everyone,

    Here's a look at the database permissions from phpMyAdmin.

    Code:
    User     Host          Password         Global privileges        Grant
    hello    localhost      Yes                ALL PRIVILEGES        Yes
    hello_    %               No                 ALL PRIVILEGES         Yes
    hello_   localhost       No                 ALL PRIVILEGES         Yes
    The database "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.

    Does anyone know what is causing this problem?
     
    #2 pcsteve, Jul 3, 2007
    Last edited: Jul 3, 2007
  3. figure8hosting

    Joined:
    May 24, 2007
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    Same problem.
     
  4. MaraBlue

    MaraBlue Well-Known Member

    Joined:
    May 3, 2005
    Messages:
    335
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Carmichael, CA
    cPanel Access Level:
    Root Administrator
    Ditto. I'm still looking if there's a fix listed in the forums, otherwise I'll just hope it's fixed in cP 11.
     
  5. jrehmer

    jrehmer Well-Known Member

    Joined:
    Apr 10, 2003
    Messages:
    287
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Denver, CO
    Has anyone submitted a support ticket about this? If not, I'd highly recommend doing so if you wish to see resolution of your problem.
     
  6. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
  7. ascent_hosting

    ascent_hosting Registered

    Joined:
    Dec 30, 2008
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Still unresolved

    This issue appears to STILL be unresolved:

    cPanel 11.24.4-R33245 - WHM 11.24.2 - X 3.9
    CENTOS 5.2 i686 on virtuozzo

    Forced to use root on db's which is not a satisfactory solution for obvious security reasons.

    The bugzilla report 5622 seems to have been abandoned.

    Any updates on a fix for this?
     
  8. jrehmer

    jrehmer Well-Known Member

    Joined:
    Apr 10, 2003
    Messages:
    287
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Denver, CO
    I recommend opening a Support ticket regarding the issue. If the bug exists that's the fastest way to get it resolved.
     
  9. ascent_hosting

    ascent_hosting Registered

    Joined:
    Dec 30, 2008
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Cpanel or database update wiping permissions?

    We are having similar problems;

    Setup is VPS running cPanel 11.24.4-R33609 - WHM 11.24.2 - X 3.9
    CENTOS 5.2 i686 on virtuozzo - MYSQL 5.x, PHP 5.x

    Our db's utilise the mysql root user account to perform certain db functions (SUPER) and we also created a second user with "ALL" privileges.

    The second user privs are being periodically reset, as for others in this thread, and of course this breaks the production db our client runs its business on.

    When updating the full databases via script from a local testbed we do a drop and recreate to ensure all procedures and triggers are properly updated. AFAIK this should not affect mysql user tables and privs but perhaps it does.

    Is it possible that cpanel has some sort of triggered process that may alter a user's privileges if the relevant database is removed as happens through this script?

    It may be the cpanel updates that are resetting user privs - and if it is then hopefully the disabling of the mysqlsecure script will prevent this problem.

    But I'd really appreciate a cpanel expert's view on whether the drop and recreate process might be the culprit.
     
  10. knbaer

    knbaer Registered

    Joined:
    Jan 27, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Any updates on this?

    Just had an instance where all 'non-root' mySQL user privileges were all wiped out and set to USAGE. Cannot find any satisfactory explanation for how this could happen. Was definitely not result of a user initiated action. Is there something in cPanel or phpMyAdmin that could automatically trigger something like this?

    Thanks.
    cPanel 11.24.4
    whm 11.24.2
    mySQL 4.1.22
     
  11. 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
    There is nothing in cPanel/WHM that could automatically do such a thing.
     
Loading...

Share This Page