Trouble with ispcp-rqst-mngr

[ewestlake]

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?

[joximu]

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

[ewestlake]

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

[joximu]

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

[ewestlake]

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

[joximu]

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

[ewestlake]

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?

[joximu]

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

[ewestlake]

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?

[ewestlake]

Nothing on this at all? This is really getting me angry now. I need to get this fixed!