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.

Adding mysql db user to db works in X, not elsewhere

Discussion in 'General Discussion' started by Charlottezweb, Oct 4, 2007.

  1. Charlottezweb

    Charlottezweb Member

    Joined:
    Feb 11, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    This is a weird issue I can replicate on one server I have -- haven't tried it on others yet.

    When I use X3 and RVSkin (that I've tried so far), I can create a database and a db user fine. However, when I add the user to the db, I get a successful message that it completes, however, when I "go back" or reload the mysql page, there are no users assigned in to that db showing up in the table.

    I've tried restoring a dump at this point and confirmed that the users are indeed not properly permissioned to access that db.

    However, when I switch the same account over to X skin, it works as planned.

    I figured I'd post here first since X3 is also impacted though RVSkin obviously has it's own support channel.

    Anyone else seen this yet? Any known fixes?

    Thanks,
    Jason
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    What is the full version of your cPanel install?

    Is there anything relevant in /usr/local/cpanel/logs/error_log?
     
  3. Charlottezweb

    Charlottezweb Member

    Joined:
    Feb 11, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    We confirmed there's nothing in the logs related to this user or mysql during the window we were troubleshooting.

    WHM 11.2.0 cPanel 11.10.0-S16448

    Thanks Kenneth
     
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    This answer sounds really vague and generic, but, your build of Stable is a bit old. The latest Stable is 16999. We recommend using the latest version of the particular cPanel branch installed to ensure all known fixes for the branch are in place.
     
  5. Charlottezweb

    Charlottezweb Member

    Joined:
    Feb 11, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Fair enough. I'll give that a shot and post the results.

    Thanks
     
  6. Charlottezweb

    Charlottezweb Member

    Joined:
    Feb 11, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    I'm now running WHM 11.2.0 cPanel 11.11.0-S16999 and am still facing this issue.
     
  7. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Which version of MySQL and what is your Operating System?

    This function worked for me using the latest Release (which is the same as Stable at this point in time) and X. Is anything output in /usr/local/cpanel/logs/error_log when you attempt this procedure?
     
  8. Charlottezweb

    Charlottezweb Member

    Joined:
    Feb 11, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    mysql (5.0.27-standard-log)

    CENTOS Enterprise 4.5 i686

    Note: It's working fine in X. It doesn't work in X3 or RVSkin. Those are the only three I've tried thus far.

    There was no related output last time we checked but I can try it again tonight and report back.
     
  9. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    My apologies, I was reading your problem in reverse. I'll look at this again tomorrow when I'm back in the office
     
Loading...

Share This Page