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

musioc

Well-Known Member
Aug 4, 2011
127
1
68
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)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.
 

musioc

Well-Known Member
Aug 4, 2011
127
1
68
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 [~]#
 
Last edited:

musioc

Well-Known Member
Aug 4, 2011
127
1
68
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 [~]#
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
I have moved this over to the "Cloud Linux" forum. You should receive more feedback here.

Thank you.