davecummins Posted June 8, 2011 Share Posted June 8, 2011 hi all i was updating the general settings to show our dns name and since then i can access the front customer page but can't click through to any option. The /admin area is also now completely not responding at all. is there a config file I can revert to if anyone knows? cheers Dave 0 Quote Link to comment Share on other sites More sharing options...
davecummins Posted June 8, 2011 Author Share Posted June 8, 2011 i even tried accessing locally or using public ip but same issue (obviously having to renew the whmcs license). 0 Quote Link to comment Share on other sites More sharing options...
Alistair Posted June 8, 2011 Share Posted June 8, 2011 What is your site? Have you checked on another computer? 0 Quote Link to comment Share on other sites More sharing options...
davecummins Posted June 8, 2011 Author Share Posted June 8, 2011 i can see in the mysql there is a table called tblconfiguration in which we have AdminForceSSL set to on. I think this is the issue but can't see to get the correct sql command to change this value to off. don't really want to wipe the entire db. 0 Quote Link to comment Share on other sites More sharing options...
davecummins Posted June 8, 2011 Author Share Posted June 8, 2011 yes, checked on a number of pcs/web browsers. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted June 8, 2011 WHMCS Support Manager Share Posted June 8, 2011 The settings you change via General Settings are stored in tblconfiguration in the database, so use phpmyadmin to revert your changes. 0 Quote Link to comment Share on other sites More sharing options...
davecummins Posted June 8, 2011 Author Share Posted June 8, 2011 thanks John, I noted that that table had the settings, but would prefer not to install phpmyadmin as it has been full of bugs from past installs. and we also have a soap application which stops working when this is installed. if you can advise on the command to change the AdminForceSSL to off would solve my problem. anyone? help please! 0 Quote Link to comment Share on other sites More sharing options...
davecummins Posted June 8, 2011 Author Share Posted June 8, 2011 i have phpmyadmin installed on a local pc but it won't connect, can't see why.... 0 Quote Link to comment Share on other sites More sharing options...
striddy Posted June 9, 2011 Share Posted June 9, 2011 i have phpmyadmin installed on a local pc but it won't connect, can't see why.... Firewall ??? 0 Quote Link to comment Share on other sites More sharing options...
laszlof Posted June 9, 2011 Share Posted June 9, 2011 Generally mysql isnt configured to be accessed remotely. Its very insecure at the very least. 0 Quote Link to comment Share on other sites More sharing options...
laszlof Posted June 9, 2011 Share Posted June 9, 2011 To answer your question, here is the query: UPDATE `tblconfiguration` SET `value`='off' WHERE `setting`='AdminForceSSL' 0 Quote Link to comment Share on other sites More sharing options...
davecummins Posted June 9, 2011 Author Share Posted June 9, 2011 thanks Laszof, that was the answer i was looking for. however, did this but still failed to load. i managed to find an old whmcs database so replaced with this and all worked fine, well enough to log in and change setttings. thanks to all 0 Quote Link to comment Share on other sites More sharing options...
stumblrmonk3 Posted July 29, 2011 Share Posted July 29, 2011 Just a note to anyone running into the same issue: I was experimenting with SSL and turned Admin SSL to "ON" via web admin and then there was chaos. I tried to set the value to "off" via PhpMyAdmin but it wouldn't work. Then I remebered that maybe WHMCS wants that value set to empty (""). I tried it and it worked wonderfully! Hope this helps someone 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.