ispcp-rqst-mngr problems [SOLVED]

[ArcAiN6]

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?

[ArcAiN6]

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...

[ArcAiN6]

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)

[ArcAiN6]

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

[ArcAiN6]

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

[joximu]

Hey - a self-helper :-)

in one hour - great!

;-) cheers Joximu