Trouble with ispcp-rqst-mngr

[ewestlake]

I am using the most recent version of ispCP with PHP5.3.2 / Apache 2.2.14 on Ubuntu 10.04.3 LTS.

I was having problems before with the database access on the GUI. Now I cannot add new domains to my server. I have tried a lot of things and came to the conclusion that something within ispcp-rqst-mngr is causing the error.

As you can see from the log below I am hitting the error on doHashSQL() which it is not connecting to the DB. How can I fix this error? I need to fix this as I have a site that needs to be up in less than a week and without the ability to add them to the system it makes my life hard and I will have to set the site up manually (which I prefer not to do because I lose all possible control on it through ispCP.

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


Please help me. I need to get this fixed right away...

[RatS]

It looks more, that your mySQL connection could not be established. Please check this first.

[ewestlake]

My SQL is working. I just need to know where I find all the SQL stuff for that script

Also I need to know the hashing used on the password and the likes so I can double check that.

[joximu]

Try to put some log-commands in the "sub setup_main_vars()" in ispcp_common_methods.pl

eg:
push_el(\@main::el, 'setup_main_vars() - 1', $main::db_pwd);

@main::db_connect = (
"DBI:mysql:$main::db_name:$main::db_host", $main::db_user, $main::db_pwd
);

/J

[LindaGordon]

I faced the same problem as that faced by Ewestlake.I tried to solve my problem by applying the commands you provided but still am facing the same problem.The solution you provided didn't worked.Can you provide some more guidelines.

[joximu]

(09-21-2011 09:30 PM)LindaGordon Wrote:  I faced the same problem as that faced by Ewestlake.I tried to solve my problem by applying the commands you provided but still am facing the same problem.The solution you provided didn't worked.Can you provide some more guidelines.

be more specific... - it sounds like a bot....

[ewestlake]

I put those into the system. Nothing has changed. Here is the log from right 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: 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() - 1, msg:
[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...

How do I change the $main::db_pwd? where is it pulling from?

(09-21-2011 09:56 PM)joximu Wrote:  

(09-21-2011 09:30 PM)LindaGordon Wrote:  I faced the same problem as that faced by Ewestlake.I tried to solve my problem by applying the commands you provided but still am facing the same problem.The solution you provided didn't worked.Can you provide some more guidelines.

be more specific... - it sounds like a bot....

[joximu]

the $main::db_pwd is created like this:

read crypted string from config file /etc/ispcp/ispcp.conf - uncrypt using the keys in the db-keys.pl file (engine/db-keys.pl or similar).

You may add a logging line just before the connection command to see the used login name and pw...

or set a new db password - I think there should be a doc in the wiki howto change the password for the mysql connection.

/J

[ewestlake]

I already went through the work. I will look at the files.

---

How can you tell if the isp-db-keys.pl file has the correct information in it?

How can it be re-written?

---

The ispcp-db-keys.pl has the same as the ispcp-db-keys.php in the values. and the PHP version works. Any thoughts on this? I cannot add to the server. I need this fixed. I have already reset the password to get access to the PHP side of the site.

[joximu]

db-keys are ok?
-> if they do not contain {KEY} etc - then they should be ok (32 chars and 8chars)
try this script to decrypt the mail passwords
http://isp-control.net/forum/thread-5495.html
then you know that the php-keys are ok.

So I really think you need to check with what credentials the request manager is trying to connect...
in ispcp_common_methods.pl there's a sub setup_main_vars where you have

@main::db_connect = (
"DBI:mysql:$main::db_name:$main::db_host", $main::db_user, $main::db_pwd
);

maybe add a
push_el(\@main::el, 'setup_main_vars()', "DBI:mysql:$main::db_name:$main::db_host $main::db_user $main::db_pwd");
before...

/J