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.

[case 45724] Unable to add user to database via cPanel DB wizard

Discussion in 'Database Discussions' started by renegadechef, Jan 3, 2011.

  1. renegadechef

    renegadechef Registered

    Joined:
    Jan 3, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Hello everyone :)

    I'm having a problem adding users to my databases after the most recent cPanel release was automatically installed on my servers (dedicated boxes with Liquidweb).

    I am simply trying to use the cPanel database creator wizard to create a new database and user and then add the user to the created DB.

    The DB is being created fine, as I can see it in PHPMyAdmin and am able to import my SQL file there without a problem, yet for some reason, the user is not being added to the database, so my scripts are unable to interact with it! :(

    I have seen in another thread (here: http://forums.cpanel.net/f42/cpanel-api-not-adding-created-user-created-database-182011.html) that this problem is not only affecting me, and seems also to be affecting the cPanel API, which btw I just realized existed (awesome!)

    Anyway, I am wondering if anybody has a work around for this issue?

    Thanks everyone :)
     
  2. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Are you seeing any error messages when you try to add the user to the database? Try tail-ing the cPanel error log while you add a user. Run the following command from the shell as root:

    Code:
    # tail -f /usr/local/cpanel/logs/error_log
    and try to add a user to a database via cPanel. Press Ctrl+C when you are finished to stop the tail command. Paste the results of the tail command into your reply.
     
  3. renegadechef

    renegadechef Registered

    Joined:
    Jan 3, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Hey Jared, thanks for the quick response :)

    Yes, I did get an error message within cPanel, in the DB wizard on step 4 of the process:

    ***** Pasted from the page ******

    MySQL® Database Wizard
    Step 4: Complete the task

    User testdb was added to the database testdb.
    You do not have access to that database (testdb)!

    ****************************

    The same thing happens every time I try to create a database now, across all of my cPanel accounts/domains, well I have tested 3-4 of them with the same result, so I'm assuming all of them...

    The good news is that I did find a simple solution! :) After using the MySQL Database Wizard, I can return to cPanel home and then click "MySQL Databases". In this section, I can see that the database I just created is there, as well as the user... but the user has not been added to the DB, although the Wizard just reported that it has.

    So now I simply add the user to the DB from within this section of cPanel, instead of using the Wizard, and it works fine. :)

    It would be really great to be able to use the wizard again though!!!!
     
    #3 renegadechef, Jan 3, 2011
    Last edited: Jan 3, 2011
  4. mtindor

    mtindor Well-Known Member

    Joined:
    Sep 14, 2004
    Messages:
    1,281
    Likes Received:
    37
    Trophy Points:
    48
    Location:
    inside a catfish
    cPanel Access Level:
    Root Administrator
    Jared,

    I'm running 11.28.60 and experience the same problem when using the wizard. After running the Wizard, it says:

    Code:
    User mttestu was added to the database mttest.
    You do not have access to that database (mttest)! 
    
    tail of /usr/local/cpanel/logs/error_log reveals:

    Code:
    [2011-01-03 13:58:12 -0500] info [mysqladmin] Creating MySQL database bobsdom_mttest for user bobsdom
    [2011-01-03 13:58:28 -0500] info [mysqladmin] Creating MySQL virtual user bobsdom_mttestu for user bobsdom
    DBD::mysql::st execute failed: There is no such grant defined for user 'mttestu' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 1166.
    mysqladmin: You do not have access to that database (mttest)!
    
    I opened a ticket regarding this at around 2:12 PM EST today in case you guys cannot reproduce this locally on your test servers and need access to a machine experiencing the problem.

    Mike
     
    #4 mtindor, Jan 3, 2011
    Last edited: Jan 3, 2011
  5. Mozafary

    Mozafary Member

    Joined:
    Sep 30, 2010
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Same problem in WHM 11.28.60

    Code:
    [2011-01-04 08:18:33 +0000] info [mysqladmin] Creating MySQL database username_test for user username
    [2011-01-04 08:18:41 +0000] info [mysqladmin] Creating MySQL virtual user username_is for user username
    DBD::mysql::st execute failed: There is no such grant defined for user 'is' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 1166.
    mysqladmin: You do not have access to that database (test)!
    
    
     
  6. texo

    texo Well-Known Member

    Joined:
    Mar 28, 2007
    Messages:
    143
    Likes Received:
    0
    Trophy Points:
    16
    Seeing this problem, too, on all my servers.
     
  7. akia

    akia Member

    Joined:
    Jun 3, 2010
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Same for me. I've tried adding a user to the database manually but that dosn't work.

    Can anyone tell me how to work around it.
     
  8. cPanelDavidN

    cPanelDavidN Integration Developer
    Staff Member

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Hi All,

    This should be resolved by internal case number 45724, which is resolved as of cPanel build 11.28.64. If this problem persists please post back here or open a support ticket.

    Regards,
    -DavidN
     
  9. crazyaboutlinux

    crazyaboutlinux Well-Known Member

    Joined:
    Nov 3, 2007
    Messages:
    938
    Likes Received:
    0
    Trophy Points:
    16
    Thank you for fixing this issue
     
  10. dlewis

    dlewis Registered

    Joined:
    Jan 6, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    We have that patch installed and it didn't fix the issue

    Change Log for 11.28.64
    Entry: 2011-01-05, 02:00 (UTC)
    cPanel X3

    * Fixed case 45724: The MySQL Database wizard erroneously attempts to use non-prefixed usernames
    ----------------------------

    curl result: <result>You do not have access to that database (38538)!
    </result>

    I'm experiencing as mentioned above. Log into cpanel -> databases and user and db are there. just hit add and it works.
     
  11. cPanelDavidN

    cPanelDavidN Integration Developer
    Staff Member

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Hi dlewis,

    Are you sure that you're not encountering the issue in this other forum thread instead?

    This thread here is about a problem with the DB wizard in the cPanel interface. The internal case 45724 shows that code corrections were for the interface pages and how they handled the form data (though there was also a backend correction, one that is not exposed via an API module/function).

    In the error that you posted, I see "curl result" which leads me to believe that you using a remote API method, possibly our XML-API.

    The thread I link to above is still an active case in Development and is concerned with the Mysql::adduserdb call; specifically the input parameters necessary for a successful action of the request. If that is the call you're making to receive that error, please follow or post on that thread. Otherwise I will need more detail as I don't follow how your error message correlates to this thread.

    Best Regards,
    -DavidN
     
  12. bbennett

    bbennett Registered

    Joined:
    Oct 16, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    I'm getting the identical error, but with Fantastico, could there be any relation?
     
  13. skatebored

    skatebored Member

    Joined:
    Sep 3, 2007
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    same problem down here on WHM 11.28.64 - CENTOS 5.5 x86_64 standard.
    anyone please help...:confused:
     
  14. cPanelDavidN

    cPanelDavidN Integration Developer
    Staff Member

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Then it's most likely a Fantastico issue. Last I looked, Fantastico doesn't always utilize the cPanel APIs. As well, I recall some other folks mentioning (when we released 11.28 to the CURRENT tier) that Fantastico was having issues with DB Mapping.

    I suggest you open a bug report with Fantastico.

    Regards,
    -DavidN
     
  15. cPanelDavidN

    cPanelDavidN Integration Developer
    Staff Member

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    This would be the first report of this issue on a build 11.28.64+. I'll have QA take a look. If you need immediate resolution, I suggest open a support ticket so our technicians can investigate. If you do open a ticket, make sure and reference this thread and PM the ticket ID.

    Regards,
    -DavidN
     
  16. azrael

    azrael Active Member

    Joined:
    Jul 20, 2003
    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    6
    Just update as EDGE version, you can solve it.
     
  17. 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
    Case 45724 is resolved in version 11.28.65 and later. To see if this version (or later) is available on your update tier yet, visit Downloads - cPanel Inc.
     
Loading...

Share This Page