ispCP - Board - Support
Problem Deleting alias [SOLVED] - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Problem Deleting alias [SOLVED] (/thread-13186.html)

Problem Deleting alias [SOLVED] - paranoidcookie - 04-03-2011 03:00 AM

I tried to delete an alias, however it stuck in the "deletion in progress stage".

If I run /var/www/ispcp/engine/ispcp-rqst-mngr
I get the following, any ideas?
Code:
[DEBUG] push_el() sub_name: mngr_start_up(), msg: Starting...
[DEBUG] push_el() sub_name: lock_system(), msg: Starting...
[DEBUG] push_el() sub_name: lock_system(), msg: Ending...
[DEBUG] push_el() sub_name: del_file(), msg: Starting...
[DEBUG] push_el() sub_name: del_file(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_start_up(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine(), msg: Starting...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: processing type dmn.
[DEBUG] push_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] push_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: processing type sub.
[DEBUG] push_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] push_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: processing type als.
[DEBUG] push_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] push_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: processing type alssub.
[DEBUG] push_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] push_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: processing type mbox.
[DEBUG] push_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] push_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: processing type htusers.
[DEBUG] push_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] push_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: processing type htgroups.
[DEBUG] push_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] push_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] push_el() sub_name: mngr_engine_process(), msg: processing 38, 32, change.
[DEBUG] push_el() sub_name: sys_command(), msg: Starting...
[DEBUG] push_el() sub_name: getCmdExitValue(), msg: Starting...
[DEBUG] push_el() sub_name: getCmdExitValue(), msg: [DEBUG] External command exited with value 1
[DEBUG] push_el() sub_name: getCmdExitValue(), msg: Ending...
[DEBUG] push_el() sub_name: sys_command(), msg: [ERROR] External command '/var/www/ispcp/engine/ispcp-htgroups-mngr 38 1>/var/log/ispcp/ispcp-htgroups-mngr.stdout 2>/var/log/ispcp/ispcp-htgroups-mngr.stderr' exited with value 1 !
[DEBUG] pop_el() sub_name: sys_command(), msg: [ERROR] External command '/var/www/ispcp/engine/ispcp-htgroups-mngr 38 1>/var/log/ispcp/ispcp-htgroups-mngr.stdout 2>/var/log/ispcp/ispcp-htgroups-mngr.stderr' exited with value 1 !
[DEBUG] push_el() sub_name: get_el_error(), msg: Starting...
[DEBUG] push_el() sub_name: get_file(), msg: Starting...
[DEBUG] push_el() sub_name: get_file(), msg: Ending...
[DEBUG] push_el() sub_name: get_el_error(), msg: Ending...
[DEBUG] push_el() sub_name: /var/www/ispcp/engine/ispcp-htgroups-mngr, msg: ERROR htaccess_users with 9 does not exits.
[DEBUG] pop_el() sub_name: /var/www/ispcp/engine/ispcp-htgroups-mngr, msg: ERROR htaccess_users with 9 does not exits.
[DEBUG] pop_el() sub_name: get_el_error(), msg: Ending...
[DEBUG] pop_el() sub_name: get_file(), msg: Ending...
[DEBUG] pop_el() sub_name: get_file(), msg: Starting...
[DEBUG] pop_el() sub_name: get_el_error(), msg: Starting...
[DEBUG] pop_el() sub_name: getCmdExitValue(), msg: Ending...
[DEBUG] pop_el() sub_name: getCmdExitValue(), msg: [DEBUG] External command exited with value 1
[DEBUG] pop_el() sub_name: getCmdExitValue(), msg: Starting...
[DEBUG] pop_el() sub_name: sys_command(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: processing 38, 32, change.
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: processing type htgroups.
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: processing type htusers.
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: processing type mbox.
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: processing type alssub.
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: processing type als.
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: processing type sub.
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Ending...
[DEBUG] pop_el() sub_name: doHashSQL(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: processing type dmn.
[DEBUG] pop_el() sub_name: mngr_engine_process(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_engine(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_start_up(), msg: Ending...
[DEBUG] pop_el() sub_name: del_file(), msg: Ending...
[DEBUG] pop_el() sub_name: del_file(), msg: Starting...
[DEBUG] pop_el() sub_name: lock_system(), msg: Ending...
[DEBUG] pop_el() sub_name: lock_system(), msg: Starting...
[DEBUG] pop_el() sub_name: mngr_start_up(), msg: Starting...
[DEBUG] pop_el() sub_name: get_conf(), msg: Ending...
[DEBUG] pop_el() sub_name: setup_main_vars(), msg: Ending...
[DEBUG] pop_el() sub_name: decrypt_db_password(), msg: Ending...
[DEBUG] pop_el() sub_name: decrypt_db_password(), msg: Starting...
[DEBUG] pop_el() sub_name: setup_main_vars(), msg: Starting...
[DEBUG] pop_el() sub_name: get_file(), msg: Ending...
[DEBUG] pop_el() sub_name: get_file(), msg: Starting...
[DEBUG] pop_el() sub_name: get_conf(), msg: Starting...
[DEBUG] pop_el() Empty 'EL' Stack !
[DEBUG] push_el() sub_name: mngr_shut_down(), msg: Starting...
[DEBUG] push_el() sub_name: mngr_shut_down(), msg: Ending...

Found the issue;

[DEBUG] push_el() sub_name: /var/www/ispcp/engine/ispcp-htgroups-mngr, msg: ERROR htaccess_users with 9 does not exits.

I opened up /var/www/ispcp/engine/ispcp-htgroups-mngr and found that is worked through lists of members held in htaccess_groups. It was complaining about '9' so I opened mysql
Code:
mysql
use ispcp;
select  id, members from htaccess_groups;
| 32 | 9,10,14
Code:
update htaccess_groups set members= '10,14' where id = 32;
Rerun /var/www/ispcp/engine/ispcp-rqst-mngr no errors

It must have been a reference to a domain which had been deleted some time ago.