No Upgrade but getting Errors

[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 accessing the system just fine until the other day when I started getting the error below.
Error: Configuration variable `USER_INITIAL_THEME` is missing!

I made no changes and this is not a nice thing to see IMO.


Another thing is I have a few WordPress Sites hosted on this server. One of them is using up the CPU to the limit when ever I do anything to the site.
It has 100 pages which is not a lot. The server is a 2.0GHz CPU with 1GB RAM. I do not know why this is happening. It maxes out the CPU when I attempt to add a new page. The database is only 4.0MB so this is nothing for a Wordpress Server. Any thoughts on this?

This is an image of the top processes of the server.

[ewestlake]

no one has an idea on this? the use vu2005 is the one that runs the one site. I have optimized the dickens out of the database. I am out of ideas. and I cannot get into the system to turn off CGI

[kilburn]

php5-cgi sucking up all the CPU time means that the problem is at the php side, not at the database (otherwise you would see mysql sucking up the time).

Therefore, what you should do is try to discover *why* is this website (php side) consuming sooo much CPU. This usually turns out to be either generating thumbnails over and over again (which is processor intensive), sorting/filtering of data at the php level (instead of the db), or a piece of really stupid code.

For instance, I saw a client's code once that tried to select 10 ads from those that were introduced in the database, by doing (pseudo-php+mysql):

Code:

$ads = array();
$available_ads = 'select count(*) from ads'
while (count($ads) < 10) {
$rnd = rand(0, $available_ads);
$ads[$rnd] = 'select * from ads where id = $rnd'
}

Guess what happened when there were few ads in the database? Slow load and duplicated queries all the time. We finally discovered the problem the day that he got less than 10 ads in the database, and the website stopped working altogether...

[ewestlake]

okay, it is a WordPress site that is causing the problem. I do not know what it is. I have checked the WP site and nothing there.
What about the Control Panel side of things? I cannot access the CP so I cannot really do anything.

[kilburn]

Quote:Error: Configuration variable `USER_INITIAL_THEME` is missing!

Does this variable exist in your /etc/ispcp/ispcp.conf file? Check the modification date of this file, and recover a backup before that (because yes, somebody has touched it).

[ewestlake]

is there somewhere I can find a base ispcp.conf file that belongs here? I do not want to have a reinstall as I have 7 sites hosted already.

[ewestlake]

okay, I found the error, but now I need to fix the ispcp.conf file. I have found a clean version of it, but how can i ensure that it is correct without a reinstall? what lines need editing?

I am now getting the error "An error occured! Please, contact your administrator!"

All help will be greatly appreciated.

---

PUT DEBUGGING ON AND THIS IS WHAT I AM GETTING.

Error: Unable to establish connection to the database! SQL returned: SQLSTATE[28000] [1045] Access denied for user 'usernamehere'@'localhost' (using password: YES)

I double checked the username and privileges to the user and they work just fine. Any thoughts?

[kilburn]

Your new /etc/ispcp/ispcp.conf has a wrong (encrypted) password, or you lost your key files. Follow steps 4 to 6 of the how to change the database password guide to ensure that the password is correct.

[ewestlake]

THANK YOU SOOOOOOO MUCH! THAT ONE WORKED! You are a life saver. Loving the software, keep up the development

[ewestlake]

now I have a new glitch...getting the message domainname's account status is not ok! and I cannot clear that. Any thoughts?

---

I am running the manual /var/www/ispcp/engine/ispcp-rqst-mngr and this is the output.

[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 serv er !
[DEBUG] pop_el() sub_name: doHashSQL(), msg: [ERROR] Unable to connect SQL serve r !
[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...

Why is it giving me an SQL error?