ispCP - Board - Support
ispcp-rqst-mngr problems [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: ispcp-rqst-mngr problems [SOLVED] (/thread-1961.html)



ispcp-rqst-mngr problems [SOLVED] - ArcAiN6 - 12-08-2007 08:06 AM

After a HDD failure, and replacement, i noticed after the rebuild of the scsi array, i've been having issues adding new domains / subdmains, and have tracekd it down to something within the ispcp-rgst-mngr script... i set the conf for debug mode and this is the output:

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: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('`which touch` /var/run/ispcp.lock'), msg: Ending...
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: get_conf(), 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: setup_main_vars(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: ERROR: Unable to connect SQL server !
DEBUG: pop_el() sub_name: doSQL(), msg: ERROR: Unable to connect SQL server !
DEBUG: pop_el() sub_name: doSQL(), 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() 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: sys_command('`which touch` /var/run/ispcp.lock'), msg: Ending...
DEBUG: pop_el() sub_name: sys_command(), msg: Starting...
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: unlock_system(), msg: Starting...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('`which rm` -rf /var/run/ispcp.lock'), msg: Ending...
DEBUG: push_el() sub_name: unlock_system(), msg: Ending...
DEBUG: push_el() sub_name: mngr_shut_down(), msg: Ending...

notice i'm getting an error conencting to the database... any way to reset the mysql password within ispcp without completely reinstalling?


RE: ispcp-rqst-mngr problems - ArcAiN6 - 12-08-2007 08:21 AM

ok... so i changed the pw using the info foud on the wiki... now i recieve this error when i run the script:

Code:
ERROR: External command '/var/www/ispcp/engine/ispcp-dmn-mngr 1 1>/var/log/ispcp/ispcp-dmn-mngr.stdout 2>/var/log/ispcp/ispcp-dmn-mngr.stderr' returned '2' status !
DEBUG: pop_el() sub_name: sys_command(), msg: ERROR: External command '/var/www/ispcp/engine/ispcp-dmn-mngr 1 1>/var/log/ispcp/ispcp-dmn-mngr.stdout 2>/var/log/ispcp/ispcp-dmn-mngr.stderr' returned '2' status !

i don't know what these mean...


RE: ispcp-rqst-mngr problems [SOLVED] - ArcAiN6 - 12-08-2007 08:33 AM

Problem solved... seems it was a two-fold issue..

1) change the db password to match current pass...

2) unknown to me , i needed to install libnet-libidn-perl (Debian ETCH )
(must not have read this part in documentation)


RE: ispcp-rqst-mngr problems - ArcAiN6 - 12-08-2007 08:43 AM

ok... so the problem wasn't completely solved as i had earlier stated... now i cannot access the domains, nor the administration gui for ispcp...

Code:
Notice: Undefined index: LOGIN_TEMPLATE_PATH in /var/www/ispcp/gui/include/system-message.php on line 37

Notice: Undefined index: LOGIN_TEMPLATE_PATH in /var/www/ispcp/gui/include/system-message.php on line 41
ERROR: Unable to connect to SQL server !
SQL returned: Access denied for user 'root'@'localhost' (using password: YES)

ok... line 37 of that file looks like this:
Code:
// If we are on the login page, path will be like this
    $template = $cfg['LOGIN_TEMPLATE_PATH'].'/system-message.tpl';

and line 41:
Code:
// But if we're inside the panel it will be like this
        $template = '../'.$cfg['LOGIN_TEMPLATE_PATH'].'/system-message.tpl';
hrm... something isn't right with the path... where is it set?
l
now i am pretty sure everything is OK with the password... where else is it storing passwords? or am i missing something here, as i didn't recieve any errors when using the ispcp-rqst-mngr, so the db password is working from there, yet the ispcp site itself is complaining...


any help would be much appreciated Smile


RE: ispcp-rqst-mngr problems - ArcAiN6 - 12-08-2007 09:08 AM

blah... forgot to copy the new tpl files over as well as set the permissions... i'm such a nub...


RE: ispcp-rqst-mngr problems [SOLVED] - joximu - 12-08-2007 09:36 AM

Hey - a self-helper :-)

in one hour - great!

;-) cheers Joximu