nitro Posted May 4, 2007 Share Posted May 4, 2007 I've posted a ticket to support relating to this problem, but was wondering if anyone else has experienced this: At the moment I am adding new clients to my WHMCS system from the admin area and am experiencing a strange delay when adding a new account. I enter all the client's details and click the "Add Client" button, then have a five minute wait until the new account details screen is shown. During this period all access to the WHMCS system is held up from my browser. If I open another browser I am able to navigate the front end and back end with no problems whilst the original browser window is locked up. I have noticed that there are a couple of MySQL processes related to the WHMCS install in a "Sleep" state for 300 seconds. As soon as these time out the admin page proceeds to the next step. I have no such delay issues when adding a client via the front end (ie. ordering page). 0 Quote Link to comment Share on other sites More sharing options...
Adamski Posted May 4, 2007 Share Posted May 4, 2007 yes also had this - just this morning in fact as I was adding a client! Ad 0 Quote Link to comment Share on other sites More sharing options...
nitro Posted May 4, 2007 Author Share Posted May 4, 2007 ah cool - so it's not just me going mad! well I guess I can get on with configuring other areas whilst waiting on a fix. 0 Quote Link to comment Share on other sites More sharing options...
Joweb Posted May 4, 2007 Share Posted May 4, 2007 I also get this only when in https:// in the admin area but not in http:// I am using IE 7 0 Quote Link to comment Share on other sites More sharing options...
nitro Posted May 4, 2007 Author Share Posted May 4, 2007 Ah ok - that could be a clue, I have put a https redirect clause in the .htaccess for the admin system. 0 Quote Link to comment Share on other sites More sharing options...
nitro Posted May 4, 2007 Author Share Posted May 4, 2007 yep, thanks for that - I have removed the https and the timeout is resolved. 0 Quote Link to comment Share on other sites More sharing options...
Joweb Posted May 4, 2007 Share Posted May 4, 2007 This only seems to happen with IE 7 also you can set https in config area in WHMCS try that instead of .htaccess. 0 Quote Link to comment Share on other sites More sharing options...
Adamski Posted May 4, 2007 Share Posted May 4, 2007 you can't set https for admin in the config areas. Also, I use safari, firefox and opera and it happens in all of them! Ad 0 Quote Link to comment Share on other sites More sharing options...
Joweb Posted May 4, 2007 Share Posted May 4, 2007 Sorry, I was talking about the client area https:// I also have issues at times with IE 7 timming out when in client https:// pages 0 Quote Link to comment Share on other sites More sharing options...
nitro Posted May 5, 2007 Author Share Posted May 5, 2007 I have implemented a temporary workaround until we get a WHMCS where we can force SSL for the whole admin section via a general configuration option. I have disabled the https rewrite in ./admin/.htaccess for the ./admin/clientsadd.php script and this has stopped the timeout issue with clientsadd.php while allowing all other pages to be forced to SSL: RewriteEngine On RewriteCond %{HTTPS} off RewriteCond %{REQUEST_URI} !^clientsadd.php$ RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} If timeouts are found in other areas of the admin system I will have to keep adding them to the exclusion conditions shown above. 0 Quote Link to comment Share on other sites More sharing options...
s1rk3ls Posted May 5, 2007 Share Posted May 5, 2007 I placed the above code into a new .htaccess file in my whmcs/admin directory (minus the clientsadd.php exclusion) and tested adding a client. It added just fine and took me to the clientsummary page without any problems. Something else must be messing you up. 0 Quote Link to comment Share on other sites More sharing options...
nitro Posted May 5, 2007 Author Share Posted May 5, 2007 I placed the above code into a new .htaccess file in my whmcs/admin directory (minus the clientsadd.php exclusion) and tested adding a client. It added just fine and took me to the clientsummary page without any problems. Something else must be messing you up. Hmmn, well it seems that the bug is only evident on certain user's setups. I now have the .htaccess as in the end of my previous post (it's been edited a couple of times but now correct) and I am able to add new clients in the admin area with no timeout delays. If I remove the clientsadd.php exclusion then I get a tedious 5 minute wait while the two MySQL threads sleep and time out. I wonder if any of these factors in my hosting setup are different to yours: WHMCS 3.1.2 installed at root of domain (ie. http://wmcs.domain.com/ not http://domain.com/whmcs/)Linux (cPanel / WHM 10.8.0) serverApache 1.3.xPHP 4.4.4 - running as cgi / PHPSuexecMySQL 4.1.21 Should we be comparing anything else? 0 Quote Link to comment Share on other sites More sharing options...
Adamski Posted May 5, 2007 Share Posted May 5, 2007 Now I don't use .htaccess to redirect my admin pages. I just have a bookmark set to go to https://.../admin so in my case this can't be a htaccess issue. 0 Quote Link to comment Share on other sites More sharing options...
s1rk3ls Posted May 5, 2007 Share Posted May 5, 2007 See the reply below from this post - moving discussion here to make it simpler to follow. I tested the clientsadd page from a ssl connection and it worked fine, without any apparent redirect to an insecured page... I then tried the original .htaccess info you provided in my whmcs admin folder and verified that going to the non ssl version of any admin page redirected me to the secure page. So next, I tested the clientsadd page again, same thing - worked like a charm. I looked in my general configuration and noticed I had an SSL address for "domain" so I changed that back to a non ssl address, tested, no problems. I changed the WHMCS SSL System URL under general config to a non SSL url and tested, no problems. I change the WHMCS System URL under general config to an SSL url (just for kicks and giggles) then tested and much to my surprise, no problems. I am unable to reproduce the problem you are experiencing, and your htaccess appears to be correct... Perhaps there is a problem with your apache build, or PHP? Sorry I can't offer you much more help than that. You replied above with: I placed the above code into a new .htaccess file in my whmcs/admin directory (minus the clientsadd.php exclusion) and tested adding a client. It added just fine and took me to the clientsummary page without any problems. Something else must be messing you up. Hmmn, well it seems that the bug is only evident on certain user's setups. I now have the .htaccess as in the end of my previous post (it's been edited a couple of times but now correct) and I am able to add new clients in the admin area with no timeout delays. If I remove the clientsadd.php exclusion then I get a tedious 5 minute wait while the two MySQL threads sleep and time out. I wonder if any of these factors in my hosting setup are different to yours: WHMCS 3.1.2 installed at root of domain (ie. http://wmcs.domain.com/ not http://domain.com/whmcs/)Linux (cPanel / WHM 10.8.0) serverApache 1.3.xPHP 4.4.4 - running as cgi / PHPSuexecMySQL 4.1.21 Should we be comparing anything else? I have 3.1.2 installed in a subdirectory of my domain. CentOS - WHM X v3.1.0 WHM 10.8.0 PHP 4.4.3 (suEXEC) MySQL 4.1.21 0 Quote Link to comment Share on other sites More sharing options...
s1rk3ls Posted May 5, 2007 Share Posted May 5, 2007 Upgraded php to 4.4.4 just to test - no change, sorry. 0 Quote Link to comment Share on other sites More sharing options...
nitro Posted May 5, 2007 Author Share Posted May 5, 2007 I have 3.1.2 installed in a subdirectory of my domain.CentOS - WHM X v3.1.0 WHM 10.8.0 PHP 4.4.3 (suEXEC) MySQL 4.1.21 Damn this is a good community! Since I'm still setting up I was able to test further by moving my WHMCS installation to a subdirectory (https://domain.com/whmcs/) and now the admin system works fine forced to SSL without the clientsadd.php excusion in the admin .htaccess So - the bug appears to be when WHMCS is running from the root of the domain. Hopefully if someone else is able to confirm this it can be fixed soon. 0 Quote Link to comment Share on other sites More sharing options...
SpookedOut Posted May 5, 2007 Share Posted May 5, 2007 Mine's absolutely fine. 0 Quote Link to comment Share on other sites More sharing options...
nitro Posted May 5, 2007 Author Share Posted May 5, 2007 Mine's absolutely fine. as a subdirectory of your domain I see: http://www.spookedout.com/hosting anyone else running WHMCS at root level of domain? 0 Quote Link to comment Share on other sites More sharing options...
Adamski Posted May 5, 2007 Share Posted May 5, 2007 I have it in support.domain.com which just reads folder domain.com/support. If I access through domain.com/support I still have the same problem although this time after hanging it goes to "An upgrade is currently in progress". I don't still have the install diretory on the server Version 3.1.2 PHP 4.4.3 MySQL 4.1.20 Ad 0 Quote Link to comment Share on other sites More sharing options...
nitro Posted May 5, 2007 Author Share Posted May 5, 2007 I think I just worked it out. My general config settings were: WHMCS System URL: [url]http://whmcs.domain.com/[/url] WHMCS SSL System URL: [url]https://whmcs.domain.com/[/url] I just removed the trailing slash from both: WHMCS System URL: [url]http://whmcs.domain.com[/url] WHMCS SSL System URL: [url]https://whmcs.domain.com[/url] And now I have no timeouts, even with my admin/.htaccess file being this: RewriteEngine On RewriteCond %{HTTPS} off RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} Joy! 0 Quote Link to comment Share on other sites More sharing options...
Adamski Posted May 5, 2007 Share Posted May 5, 2007 Interesting.. I don't have the trailing slashes and it doesn't work. Might pop in the htaccess file and see if that solves it 0 Quote Link to comment Share on other sites More sharing options...
Adamski Posted May 5, 2007 Share Posted May 5, 2007 Nope doesn't work for me 0 Quote Link to comment Share on other sites More sharing options...
Adamski Posted May 5, 2007 Share Posted May 5, 2007 Add I've not noticed that it hangs when deleting clients as I'm deleting my test accounts ! 0 Quote Link to comment Share on other sites More sharing options...
SpookedOut Posted May 5, 2007 Share Posted May 5, 2007 Running WHMCS in the root of your domain is not really an ideal solution. 0 Quote Link to comment Share on other sites More sharing options...
Adamski Posted May 5, 2007 Share Posted May 5, 2007 Well I'm not I run it in a subdomain which points to a directory. 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.