Impossible to create database's user

[globcom]

When I try to creata an user for a database I have this error message :

The adminbin “hooks” in the “Cpanel” namespace call to function “mysql::adduser” ended prematurely: The subprocess reported the “” (255) error when it ended.

server info : CLOUDLINUX 6.5 x86_64 standard WHM 11.44.0 (build 18)

Did you have any idea ?

Thx

 

[cPanelMichael]

Hello

Please check to see if the following post is helpful:

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

Thank you.

 

[globcom]

Hello Michael

I already saw this post.

In /usr/share/lve/dbgovernor/utils/dbgovernor_map
I have already this line :
#!/usr/local/cpanel/3rdparty/bin/perl

Thank you

 

[cPanelMichael]

Could you let us know the full output from /usr/local/cpanel/logs/error_log when this occurs?

Thank you.

 

[globcom]

/usr/local/cpanel/logs/error_log

[2014-07-02 18:23:54 +0200] info [cpses_tool] MYSQL: Remove dbuser cpses_glaI5rTCQZ for owner global02 on 62.210.202.8
[2014-07-02 18:24:04 +0200] info [cpmysql] Creating MySQL database global02_test for user global02
[2014-07-02 18:24:20 +0200] info [cpmysql] Creating MySQL virtual user global02_test for user global02
Undefined subroutine &Cpanel::Config::Users::getcpusers called at /usr/share/lve/dbgovernor/utils/dbgovernor_map line 82,  line 739.
[2014-07-02 18:24:20 +0200] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request The adminbin “hooks” in the “Cpanel” namespace call to function “mysql::adduser” ended prematurely: The subprocess reported the “” (255) error when it ended.: namespace=[Cpanel] module=[hooks] function=[mysql::adduser]: set error in context mysql: raw_response=[{"exit_code":65280,"status":1,"version":"2.3","action":"run","data":"","mode":"full","statusmsg":"The adminbin “hooks” in the “Cpanel” namespace call to function “mysql::adduser” ended prematurely: The subprocess reported the “” (255) error when it ended.","error":1,"timeout":0}] at /usr/local/cpanel/Cpanel/Wrap.pm line 117
	Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'hooks', 'function', 'mysql::adduser', 'data', HASH(0x43eddc0), 'action', 'run', 'env', HASH(0x43edfa0)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 79
	Cpanel::AdminBin::adminstor('hooks', 'mysql::adduser', HASH(0x43eddc0)) called at /usr/local/cpanel/Cpanel/EventHandler.pm line 45
	Cpanel::EventHandler::hook('mysql', 'adduser', HASH(0x4396540), ARRAY(0x432a400)) called at /usr/local/cpanel/Cpanel/EventHandler.pm line 112
	Cpanel::EventHandler::post_event(1, 'post', 'Mysql', 'adduser', ARRAY(0x27c3d70), ARRAY(0x432a400)) called at cpanel line 1504
	main::__ANON__('') called at cpanel line 1971
	main::_api1(__CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, ARRAY(0x27c3d70), __CPANEL_HIDDEN__, undef, undef) called at cpanel line 1610
	main::real_exectag('') called at cpanel line 4211
	main::dotag_finished_headers(0) called at cpanel line 4031
	main::cpanel_parseblock(__CPANEL_HIDDEN__) called at cpanel line 3945
	main::y(GLOB(0x3b987b0)) called at cpanel line 5297
	main::run_standard_mode() called at cpanel line 782
[2014-07-02 18:24:20 +0200] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request error: namespace=[Cpanel] module=[hooks] function=[mysql::adduser]: set error in context mysql: statusmsg=[The adminbin “hooks” in the “Cpanel” namespace call to function “mysql::adduser” ended prematurely: The subprocess reported the “” (255) error when it ended.] at /usr/local/cpanel/Cpanel/Wrap.pm line 127
	Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'hooks', 'function', 'mysql::adduser', 'data', HASH(0x43eddc0), 'action', 'run', 'env', HASH(0x43edfa0)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 79
	Cpanel::AdminBin::adminstor('hooks', 'mysql::adduser', HASH(0x43eddc0)) called at /usr/local/cpanel/Cpanel/EventHandler.pm line 45
	Cpanel::EventHandler::hook('mysql', 'adduser', HASH(0x4396540), ARRAY(0x432a400)) called at /usr/local/cpanel/Cpanel/EventHandler.pm line 112
	Cpanel::EventHandler::post_event(1, 'post', 'Mysql', 'adduser', ARRAY(0x27c3d70), ARRAY(0x432a400)) called at cpanel line 1504
	main::__ANON__('') called at cpanel line 1971
	main::_api1(__CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, ARRAY(0x27c3d70), __CPANEL_HIDDEN__, undef, undef) called at cpanel line 1610
	main::real_exectag('') called at cpanel line 4211
	main::dotag_finished_headers(0) called at cpanel line 4031
	main::cpanel_parseblock(__CPANEL_HIDDEN__) called at cpanel line 3945
	main::y(GLOB(0x3b987b0)) called at cpanel line 5297
	main::run_standard_mode() called at cpanel line 782

 

[cPanelMichael]

Does a symbolic link from /var/lib/mysql/mysql.sock to /tmp/mysql.sock exist on your system?

Thank you.

 

[globcom]

My mysql folder is in /home/var_mysql/mysql
(my tmp partition was to small and I move the mysql folder in home in march)

In /var/lib/ I have a symlink to mysql -> /home/var_mysql/mysql/

In /tmp/ I have a symlink to mysql.sock -> ../../var/lib/mysql/mysql.sock=

Thank you.

 

[cPanelMichael]

Feel free to open a support ticket so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.

 

[Judd Taylor]

Feel free to open a support ticket so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.

What was the outcome of this issue??

I'm experiencing a very similar issue on our server

 

[cPanelMichael]

A ticket number was not provided, so feel free to open a ticket and post the ticket number here.

Thank you.

 

[royalredover]

When I try to creata an user for a database I have this error message :

The adminbin “hooks” in the “Cpanel” namespace call to function “mysql::adduser” ended prematurely: The subprocess reported the “” (255) error when it ended.

server info : CLOUDLINUX 6.5 x86_64 standard WHM 11.44.0 (build 18)

Did you have any idea ?

Thx

I'm face this problem some time, the solution is you reinstall db_governor and the error will gones away, go to command line and just type this text for reinstall db_governor :

yum update governor-mysql --enablerepo=cloudlinux-updates-testing

 

[globcom]

Great royalredover

It works perfectly!

Thx

 

[cPanelMichael]

I am happy to see the issue was resolved. Thank you for updating us with the outcome.