Chris74 Posted April 6, 2016 Share Posted April 6, 2016 (edited) Hi, I've got a support ticket logged with WHMCS - (no reply so far). I'm really desperate for any advice anyone here could offer. Suddenly yesterday customers started complaining that their logins were getting stuck. When trying to login, the process would essentially hang and in turn this would prevent anyone else from being able to login too. I tested this and while I was able to login as admin, logging in as any client from cleintarea.php or from the admin via dologin.php would result in the process just taking forever it isn't timing out - just sitting there. If I kill the PHP process via the command line, it resets the problem until one of the affected users attempts to login again. I suspected database corruption so I checked tables in WHMCS - no problems. I ran a table check in phpmyadmin and got this error... Problems with indexes of table tblhosting The indexes PRIMARY and serviceid seem to be equal and one of them could possibly be removed. I removed the serviceid index and this didn't have any negative effects, but it didn't resolve the problem. Thought that an upgrade to the latest version might help, so I upgraded WHMCS to 6.3. This didn't resolve it. I recompiled Apache and PHP - no joy. I've had display errors on and the error checking in WHMCS enabled - there are no PHP errors, no MySQL errors at all. I've moved the website to another server. Still having this problem. I've just exported the database and imported it into a new fresh one. Same problem. It seems to be specific users that trigger this issue. I can login as my test user and thats fine but if I login as any of the users that have reported that they cant login - it just hangs. I've had to put the site into maintenance mode and it has been like this for over 24 hours now. I think I've tried everything and I'm really worried now. I have 4000 customers and the complaints are now stacking up. Any advice anyone can offer at this point would be greatly appreciated! Edited April 6, 2016 by Chris74 0 Quote Link to comment Share on other sites More sharing options...
Damo Posted April 6, 2016 Share Posted April 6, 2016 What add ons or hooks do you have installed? Sounds like something is running at login that is failing and not timing out. Maybe a firewall IP check and clear? Try enabling logging for add ons and see what they show. Any pho error_log entries? 0 Quote Link to comment Share on other sites More sharing options...
Chris74 Posted April 6, 2016 Author Share Posted April 6, 2016 Oh man, I feel so stupid. I didn't think I had any addon modules installed that would cause any problems at login and I had already checked everything - I've had the hooks logging enabled - but your reply made me double check everything again. I remembered that some time ago I enabled the option in the unblock IP module to check for blocks when the client logs in. I'd completely forgotten about that. I've disabled that and I was immediately able to login as any of the clients with this problem. The common factor being that they all had multiple hosting plans. Considering the huge amount of work I've done to try and resolve this and despite my 20 years experience in IT, I was defeated by a single tick box. I feel like an idiot but I'm very glad it's resolved. Thank you. 0 Quote Link to comment Share on other sites More sharing options...
Damo Posted April 6, 2016 Share Posted April 6, 2016 Great The auto unblock IP can be very slow with multiple servers being checked. We ended up disabling it and let clients unblock manually if needed. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.