+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Trouble with ispcp-rqst-mngr (/thread-15138.html)
RE: Trouble with ispcp-rqst-mngr - ewestlake - 09-27-2011 11:22 AM
I have added these items. It is still not working. Where would this log?
I really need to get this fixed. I can connect through PHP but this one tool is not working. Please let me know what is up here. How can I fix this issue?
RE: Trouble with ispcp-rqst-mngr - joximu - 09-27-2011 06:31 PM
Logfile in /var/log/ispcp/*
or on screen if you run ispcp-rqst-mngr manually...
maybe set DEBUG = 1 in /etc/ispcp/ispcp.conf (bottom of file...)
/J
RE: Trouble with ispcp-rqst-mngr - ewestlake - 09-27-2011 11:34 PM
(09-27-2011 06:31 PM)joximu Wrote: Logfile in /var/log/ispcp/*
or on screen if you run ispcp-rqst-mngr manually...
maybe set DEBUG = 1 in /etc/ispcp/ispcp.conf (bottom of file...)
/J
DEBUG is on. The Log File tells me nothing. I have posted the logs many times here. I need help. I cannot figure out WHY the ispcp-rqst-mngr file is not connecting to the database while PHP IS!?...
I have been fighting with this for a week. please help...
RE: Trouble with ispcp-rqst-mngr - joximu - 09-27-2011 11:37 PM
did you add the line
push_el(\@main::el, 'setup_main_vars()', "DBI:mysql:$main::db_name:$main::db_host $main::db_user $main::db_pwd");
where I told?
then there should be at least an additional line in the log telling the credentials ispcp is using.
Depending on the result of this test further actions may be developped...
/J
RE: Trouble with ispcp-rqst-mngr - ewestlake - 09-28-2011 12:53 AM
(09-27-2011 11:37 PM)joximu Wrote: did you add the line
push_el(\@main::el, 'setup_main_vars()', "DBI:mysql:$main::db_name:$main::db_host $main::db_user $main::db_pwd");
where I told?
then there should be at least an additional line in the log telling the credentials ispcp is using.
Depending on the result of this test further actions may be developped...
/J
I thought I did. What line number should I place this in?
okay I have it fixed. and got the log to work now.
[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: [ERROR] Unable to connect SQL server !
[DEBUG] pop_el() sub_name: doHashSQL(), msg: [ERROR] Unable to connect SQL server !
[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: setup_main_vars(), msg: DBI:mysql:ispcp:127.0.0.1 ispcp mypasswordhere...
[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: setup_main_vars(), msg: DBI:mysql::
[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...
RE: Trouble with ispcp-rqst-mngr - joximu - 09-28-2011 09:26 AM
ok, at least this seems to be correct.
Now please check if you can connect to mysql via mysql client.
In server console/shell:
mysql -h 127.0.0.1 -u ispcp -pmypasswordhere -D ispcp
tell us the result.
/J
RE: Trouble with ispcp-rqst-mngr - ewestlake - 09-29-2011 09:46 PM
I can log in through the console. Though for security reasons I do the following command.
mysql -h 127.0.0.1 -u ispcp -p -D ispcp
This makes the password not be logged on the system
But that works. What is my next step?
RE: Trouble with ispcp-rqst-mngr - joximu - 09-30-2011 06:24 PM
Hm - too bad...
I assume you have installed the dbi lib for perl "libdbi-perl"... and then... I have no more ideas at the moment.
Obviously perl cannot connect using the correct credentials...
Do you have other security software installed which prevents certain programs to connect to certain ports?
Maybe you can enable mysql logging to see if there is a problem or a more helpful explanation...
/J
RE: Trouble with ispcp-rqst-mngr - ewestlake - 10-05-2011 12:21 AM
I have not removed anything. The system used to work. Now it does not. I will look for the libdbi-perl though.
No security software is there. How would I enable mysql logging?
RE: Trouble with ispcp-rqst-mngr - ewestlake - 10-08-2011 12:32 AM
Nothing on this at all? This is really getting me angry now. I need to get this fixed!