Server: Dedicated, 16GB DDR3, Intel Core i7-4770 ( 4 Cores x 3.4GHz )
Managed Hosting provided by KnownHost
Backend: WHM cPanel / Apache
Website: Coded in all PHP and using a MySQL database.
Website causing crash: www. police $chedule .com (no spaces and the $ is a S)
I need to pay someone to diagnose the issues with this website and prevent the server from crashing when 50-100 people are trying to login to the website.
The website is using a cron job in order to process some tasks. What happens is that since it is a scheduling website is that at a certain date/time approximately 50 users at one time are trying to access and login to the website to signup for shifts. While at the same time the server is processing a cron job. This is causing the website to generate emails of "suspicious processes" and then I will get an "excessive resources" email before the website crashes. I then have to reboot the server before the website can be access again. I attached copies of the email messages and here is some communication between my hosting provider and myself. The following is the opinion of the hosting providers help desk but may not be the issue:
ME: Could you please take a look at Police $chedule .com and see why the server is crashing? I have to reboot the server typically every 2 months when this problem occurs. The other websites load fine but that domain crashes I have to reboot. I am trying to see if I need to upgrade my server or if it is a script issue.
HOSTING PROVIDER: I'm seeing a lot of errors that look very similar to the following:
[proxy_fcgi:error] [pid 10534:tid 140416183539456] (70007)The timeout specified has expired: [client [login to view URL]] AH01075: Error dispatching request to : (polling)
In addition, I'm seeing a lot of other errors, all of which tie back to proxy_fcgi. Its errors were also the only ones leading into the forced restart that you did of the whole server. The fcgi system is know to be very buggy for cPanel, and diagnosing its issues can be very problematic and would require going through code and running PHP files using the CLI to see if you can trace what's causing the delays with fcgi. It may just be better to remove it at this point. Would you prefer we do that?
ME: What happens if I disable fcgi?
HOSTING PROVIDER: The importance of proxy_fcgi is that it allows use of PHP-FPM with your sites. As it looks like you use PHP-FPM on a lot of your sites, it may be instead that PHP-FPM has to be properly re-adjusted and the code carefully sifted through and debugged. The ultimate issue is that PHP-FPM isn't getting back the responses is wants, and issues then occur. As to which end (code or pool configuration) is causing this issue, it's difficult to ascertain, and requires careful investigation and debugging of your code. Really, it comes down to whether you need PHP-FPM for your sites or not. If you do, then you'll need to tackle some reconfiguration and debugging. If not, then we can just move your sites over off of PHP-FPM and go from there. I'd recommend talking it over with your developers what direction you want to go, and if you want to switch over or need help adjusting PHP configurations, you can let us know.
ME: Not sure what happened but Police $chedule .com crashed. I have been running this website for several months without any issues and had the same amount of users logging on at the same time.
HOSTING PROVIDER: It looks like the user has added some cronjobs that are triggering the firewall.
These were the crons before:
/var/spool/cron/ps:* * * * * wget --quiet -O /dev/null https://police$[login to view URL]
cP/DEDI root@[login to view URL] [~]#
I've updated these as follows:
* * * * * wget -O- https://police$[login to view URL] > /dev/null 2>&1
We could also try whitelisting the process if the notification persists.
I can investigate and fix the crash issue for you. I am a skilled server admin and php developer with over 10 years experience. let discuss more via private messages, thanks.
Hello checked your website We can assist in this, Let me know if I am on your shortlist, I will do some rechecks and submit my detailed proposal estimate. Thanks, Sebastian
Hi, I will check complete dedicated server configuration, find the fcgi configuration issue and website crashing issue and will fix the issue. Please discuss to start. Thank you.