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.

ERROR : Ran adminbin Cpanel/hooks/mysql::adduser

Discussion in 'CloudLinux' started by musioc, Oct 20, 2013.

  1. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Hello dears

    We can not add user to database via wizard. We get this error :
    Ran adminbin Cpanel/hooks/mysql::adduser

    I test it and there is no problem with creating mysql database, but there is problem while trying to add user via wizard.
    And also we can create user and add that user to database from "MySQL Databases" page (Not wizard).

    Do you know what is the problem? (I was installed DBGoverner recently)
     
  2. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Do you experience this problem too?
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please check the output from /usr/local/cpanel/logs/error_log when this issue occurs. Do you see any additional output compared to what shows up in the user interface?

    Thank you.
     
  4. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Hello
    Thank you for your reply

    There is not any additional output.

    This is error log:

    Code:
    root@server [~]# tail -f /usr/local/cpanel/logs/error_log
    [2013-10-22 12:03:29 +0430] info [cpmysql] Creating MySQL database cpuser_db for user cpuser
    [2013-10-22 12:04:17 +0430] info [cpmysql] Creating MySQL virtual user cpuser_dbuser for user cpuser
    [B]Undefined subroutine &Cpanel::DB::get_map called at /usr/share/lve/dbgovernor/utils/dbgovernor_map line 84[/B].
    [2013-10-22 12:04:18 +0430] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request subprocess exited with status 255: namespace=[Cpanel] module=[hooks] function=[mysql::adduser]: set error in context mysql: raw_response=[{"error":1,"data":"","statusmsg":"[B]Ran adminbin Cpanel/hooks/mysql::adduser[/B]","version":"2.3","exit_code":65280,"mode":"full","status":1,"timeout":0,"action":"run"}] at /usr/local/cpanel/Cpanel/Wrap.pm line 123
            Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'hooks', 'function', 'mysql::adduser', 'data', HASH(0x446bdf0), 'action', 'run', 'env', HASH(0x4470250)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 77
            Cpanel::AdminBin::adminstor('hooks', 'mysql::adduser', HASH(0x446bdf0)) called at /usr/local/cpanel/Cpanel/EventHandler.pm line 45
            Cpanel::EventHandler::hook('mysql', 'adduser', HASH(0x44202e0), ARRAY(0x439d680)) called at /usr/local/cpanel/Cpanel/EventHandler.pm line 112
            Cpanel::EventHandler::post_event(1, 'post', 'Mysql', 'adduser', ARRAY(0x2070fa0), ARRAY(0x439d680)) called at cpanel line 1414
            main::__ANON__('') called at cpanel line 1885
            main::real_exectag('<cpanel Mysql="adduser($RAW_FORM{\'user\'},$RAW_FORM{\'pass\'})">') called at cpanel line 4135
            main::dotag_finished_headers(1) called at cpanel line 3955
            main::cpanel_parseblock('<cpanel setvar="headerimg=../images/topmysql.gif">\x0A<cpanel setvar="dprefix=../">\x0A<cpanel Branding="include(stdheader.html)">\x0A\x0A\x0A<script type="text/javascript">\x0A//<![CDATA[\x0Avar checkallprivs = function() {\x0A    var privall = YAHOO.util.Dom.get("ALL");\x0A    var user_rights = YAHOO.util.Dom.getElementsByClassName("user_right", "input", "add_user_table");\x0A\x0A    for (var i in user_rights) {\x0A        if (privall.checked == true) {\x0A            user_rights[i].checked = true;\x0A        }\x0A        else {\x0A            user_rights[i].checked = false;\x0A        }\x0A    }\x0A};\x0A\x0Avar checkprivs = function() {\x0A    var all_checked = true;\x0A    var user_rights = YAHOO.util.Dom.getElementsByClassName("user_right", "input", "add_user_table");\x0A    for (var i in user_rights) {\x0A        if (user_rights[i].checked == false) all_checked = false;\x0A    }\x0A    YAHOO.util.Dom.get("ALL").checked = all_checked;\x0A};\x0A\x0Avar init_user_rights = function() {\x0A    YAHOO.util.Event.on("ALL", "click", checkallprivs);\x0A    YAHOO.util.Event.on(YAHOO.util.Dom.getElementsByClassName("user_right", "input", "add_user_table"), "click", checkprivs);\x0A\x0A};\x0AYAHOO.util.Event.onDOMReady(init_user_rights);\x0A//]]>\x0A</script>\x0A\x0A<div class="body-content">\x0A\x0A<div class="h1Title"><div class="spriteicon_img_mini" id="icon-mysql_mini"></div> <cpanel langprint="SQLWizard"></div>\x0A\x0A<!--<cpanel Mysql="adduser($RAW_FORM{\'user\'},$RAW_FORM{\'pass\'})">-->\x0A\x0A<cpanelif !$CPERROR{\'mysql\'}>\x0A    <p><cptext \'Added user \xE2\x80\x9C[output,class,_1,status][output,class,_2,status]\xE2\x80\x9D with password \xE2\x80\x9C[output,class,_3,status]\xE2\x80\x9D.\',$dbownerprefix,$FORM{"user"},$FORM{"pass"}></p>\x0A</cpanelif>\x0A\x0A<cpanelif $CPERROR{\'mysql\'}>\x0A\x09<style type="text/css">\x0A\x09\x09#wizardform, #step3{\x0A\x09\x09\x09display:none;\x0A\x09\x09}\x0A\x09</style>\x0A\x09<p class="errors"><cpanel langprint="PostgreUserError">\x09<a href="#" onclick="document.getElementById(\'details\').style.display=\'block\'; return false;"><cpanel langprint="AODShowDetails"></a></p>\x0A\x09<div class="details" id="details">\x0A\x09\x09 <cpanel print="$CPERROR{\'mysql\'}">\x0A\x09</div>\x0A\x09<noscript>\x0A\x09\x09<div class="details-noscript" id="details">\x0A\x09\x09\x09<cpanel print="$CPERROR{\'mysql\'}">\x0A\x09\x09</div>\x0A\x09</noscript>\x0A</cpanelif>\x0A\x0A<div id="step3">\x0A    <h2><cpanel langprint="MySQLStep3"></h2>\x0A    <p><cpanel langprint="FTPUser">: <b><cpanel print="$dbownerprefix"><cpanel print="$FORM{\'user\'}"></b>\x0A    <br />\x0A    <cpanel langprint="BUDatabase">: <b><cpanel print="$FORM{\'db\'}"> </b></p>\x0A</div>\x0A\x0A<form action="wizard4.html" name="adduserdb" id="wizardform" method="post">\x0A    <input type="hidden" name="db" value="<cpanel print="$FORM{\'db\'}">" />\x0A    <input type="hidden" name="user" value="<cpanel print="$dbownerprefix"><cpanel print="$FORM{\'user\'}">" />\x0A    <br />\x0A\x0A    <?cptt sql/userrights.tmpl ?>\x0A\x0A  <br />\x0A  <input type="submit" value="<cpanel langprint="NextStep">" class="input-button" />\x0A</form>\x0A\x0A<br />\x0A\x0A<div class="return-link"><a href="wizard1.html">&larr; <cptext "Go Back"></a> | <a href="index.html"><cptext "Go Back"> <cpanel langprint="ToMainSQL"></a></div>\x0A\x0A</div><!-- end body-content -->\x0A\x0A<cpanel Branding="include(stdfooter.html)">\x0A') called at cpanel line 3869
            main::y(GLOB(0x3e2a510)) called at cpanel line 5227
            main::run_standard_mode() called at cpanel line 767
    [2013-10-22 12:04:18 +0430] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request error: namespace=[Cpanel] module=[hooks] function=[mysql::adduser]: set error in context mysql: statusmsg=[Ran adminbin Cpanel/hooks/mysql::adduser] at /usr/local/cpanel/Cpanel/Wrap.pm line 128
            Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'hooks', 'function', 'mysql::adduser', 'data', HASH(0x446bdf0), 'action', 'run', 'env', HASH(0x4470250)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 77
            Cpanel::AdminBin::adminstor('hooks', 'mysql::adduser', HASH(0x446bdf0)) called at /usr/local/cpanel/Cpanel/EventHandler.pm line 45
            Cpanel::EventHandler::hook('mysql', 'adduser', HASH(0x44202e0), ARRAY(0x439d680)) called at /usr/local/cpanel/Cpanel/EventHandler.pm line 112
            Cpanel::EventHandler::post_event(1, 'post', 'Mysql', 'adduser', ARRAY(0x2070fa0), ARRAY(0x439d680)) called at cpanel line 1414
            main::__ANON__('') called at cpanel line 1885
            main::real_exectag('<cpanel Mysql="adduser($RAW_FORM{\'user\'},$RAW_FORM{\'pass\'})">') called at cpanel line 4135
            main::dotag_finished_headers(1) called at cpanel line 3955
            main::cpanel_parseblock('<cpanel setvar="headerimg=../images/topmysql.gif">\x0A<cpanel setvar="dprefix=../">\x0A<cpanel Branding="include(stdheader.html)">\x0A\x0A\x0A<script type="text/javascript">\x0A//<![CDATA[\x0Avar checkallprivs = function() {\x0A    var privall = YAHOO.util.Dom.get("ALL");\x0A    var user_rights = YAHOO.util.Dom.getElementsByClassName("user_right", "input", "add_user_table");\x0A\x0A    for (var i in user_rights) {\x0A        if (privall.checked == true) {\x0A            user_rights[i].checked = true;\x0A        }\x0A        else {\x0A            user_rights[i].checked = false;\x0A        }\x0A    }\x0A};\x0A\x0Avar checkprivs = function() {\x0A    var all_checked = true;\x0A    var user_rights = YAHOO.util.Dom.getElementsByClassName("user_right", "input", "add_user_table");\x0A    for (var i in user_rights) {\x0A        if (user_rights[i].checked == false) all_checked = false;\x0A    }\x0A    YAHOO.util.Dom.get("ALL").checked = all_checked;\x0A};\x0A\x0Avar init_user_rights = function() {\x0A    YAHOO.util.Event.on("ALL", "click", checkallprivs);\x0A    YAHOO.util.Event.on(YAHOO.util.Dom.getElementsByClassName("user_right", "input", "add_user_table"), "click", checkprivs);\x0A\x0A};\x0AYAHOO.util.Event.onDOMReady(init_user_rights);\x0A//]]>\x0A</script>\x0A\x0A<div class="body-content">\x0A\x0A<div class="h1Title"><div class="spriteicon_img_mini" id="icon-mysql_mini"></div> <cpanel langprint="SQLWizard"></div>\x0A\x0A<!--<cpanel Mysql="adduser($RAW_FORM{\'user\'},$RAW_FORM{\'pass\'})">-->\x0A\x0A<cpanelif !$CPERROR{\'mysql\'}>\x0A    <p><cptext \'Added user \xE2\x80\x9C[output,class,_1,status][output,class,_2,status]\xE2\x80\x9D with password \xE2\x80\x9C[output,class,_3,status]\xE2\x80\x9D.\',$dbownerprefix,$FORM{"user"},$FORM{"pass"}></p>\x0A</cpanelif>\x0A\x0A<cpanelif $CPERROR{\'mysql\'}>\x0A\x09<style type="text/css">\x0A\x09\x09#wizardform, #step3{\x0A\x09\x09\x09display:none;\x0A\x09\x09}\x0A\x09</style>\x0A\x09<p class="errors"><cpanel langprint="PostgreUserError">\x09<a href="#" onclick="document.getElementById(\'details\').style.display=\'block\'; return false;"><cpanel langprint="AODShowDetails"></a></p>\x0A\x09<div class="details" id="details">\x0A\x09\x09 <cpanel print="$CPERROR{\'mysql\'}">\x0A\x09</div>\x0A\x09<noscript>\x0A\x09\x09<div class="details-noscript" id="details">\x0A\x09\x09\x09<cpanel print="$CPERROR{\'mysql\'}">\x0A\x09\x09</div>\x0A\x09</noscript>\x0A</cpanelif>\x0A\x0A<div id="step3">\x0A    <h2><cpanel langprint="MySQLStep3"></h2>\x0A    <p><cpanel langprint="FTPUser">: <b><cpanel print="$dbownerprefix"><cpanel print="$FORM{\'user\'}"></b>\x0A    <br />\x0A    <cpanel langprint="BUDatabase">: <b><cpanel print="$FORM{\'db\'}"> </b></p>\x0A</div>\x0A\x0A<form action="wizard4.html" name="adduserdb" id="wizardform" method="post">\x0A    <input type="hidden" name="db" value="<cpanel print="$FORM{\'db\'}">" />\x0A    <input type="hidden" name="user" value="<cpanel print="$dbownerprefix"><cpanel print="$FORM{\'user\'}">" />\x0A    <br />\x0A\x0A    <?cptt sql/userrights.tmpl ?>\x0A\x0A  <br />\x0A  <input type="submit" value="<cpanel langprint="NextStep">" class="input-button" />\x0A</form>\x0A\x0A<br />\x0A\x0A<div class="return-link"><a href="wizard1.html">&larr; <cptext "Go Back"></a> | <a href="index.html"><cptext "Go Back"> <cpanel langprint="ToMainSQL"></a></div>\x0A\x0A</div><!-- end body-content -->\x0A\x0A<cpanel Branding="include(stdfooter.html)">\x0A') called at cpanel line 3869
            main::y(GLOB(0x3e2a510)) called at cpanel line 5227
            main::run_standard_mode() called at cpanel line 767
    ^C
    root@server [~]#
    
     
    #4 musioc, Oct 22, 2013
    Last edited: Oct 22, 2013
  5. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    I'm sure I was installed db_governer!
    I can see /usr/sbin/db_governor in processes list

    But I can not remove, upgrade or install dbgoverner again!

    Doc: MySQL Governor > Installation
    Code:
    root@server [~]# [B]yum update db-governor db-governor-mysql --enablerepo=cloudlinux-updates-testing[/B]
    Loaded plugins: fastestmirror, rhnplugin
    Loading mirror speeds from cached hostfile
     * cloudlinux-x86_64-server-6: cl-mirror.uk2group.com
     * rpmforge: mirror.yongbok.net
    cloudlinux-updates-testing                                                                                                                       | 1.1 kB     00:00
    cloudlinux-updates-testing/primary                                                                                                               | 554 kB     00:01
    cloudlinux-updates-testing                                                                                                                                    2159/2159
    Setting up Update Process
    No Match for argument: db-governor
    No package db-governor available.
    No Match for argument: db-governor-mysql
    No package db-governor-mysql available.
    No Packages marked for Update
    root@server [~]# [B]yum install db-governor --enablerepo=cloudlinux-updates-testing[/B]
    Loaded plugins: fastestmirror, rhnplugin
    Loading mirror speeds from cached hostfile
     * cloudlinux-x86_64-server-6: cl-mirror.uk2group.com
     * rpmforge: mirror.yongbok.net
    Setting up Install Process
    No package db-governor available.
    Error: Nothing to do
    root@server [~]# [B]/usr/share/lve/dbgovernor/install-mysql.py --install[/B]
    -bash: /usr/share/lve/dbgovernor/install-mysql.py: No such file or directory
    root@server [~]# [B]yum remove db-governor db-governor-mysql[/B]
    Loaded plugins: fastestmirror, rhnplugin
    Setting up Remove Process
    No Match for argument: db-governor
    Loading mirror speeds from cached hostfile
     * cloudlinux-x86_64-server-6: cl-mirror.uk2group.com
     * rpmforge: mirror.yongbok.net
    No Match for argument: db-governor-mysql
    No Packages marked for removal
    root@server [~]#
    
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  7. iseletsk

    iseletsk Well-Known Member

    Joined:
    Mar 3, 2010
    Messages:
    163
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Princeton, New Jersey, United States
    Please, edit this file:
    /usr/share/lve/dbgovernor/utils/dbgovernor_map
    change this line
    #!/usr/bin/perl
    with this line.

    #!/usr/local/cpanel/3rdparty/bin/perl
     
  8. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    It is solved now.
    Thank you ;)
     
Loading...

Share This Page