Matt Posted November 9, 2017 Share Posted November 9, 2017 Hi We've just purchased PS and I'm trying to figure out the best way to configure the load balancing. We were planning to use SSL Offloading, so the certificate is installed on the LB only and it redirects traffic to one of two web servers to http. From reading on another topic here, PS does an automatic redirect from HTTP to HTTPS. Is there a way to stop it doing this and remove the self signed certificate binding from the webservers? I've just realised I have this problem as I have a load balanced CNAME which doesn't work at the moment so I can't complete the initial setup. Thanks Link to comment Share on other sites More sharing options...
support Posted November 9, 2017 Share Posted November 9, 2017 Hi Matt, You can turn off the SSL redirection on the System Settings screen in Passwordstate - maybe if you RDP'd into the server. Or, using SQL Server Management Studio, you can execute the following command to do this also: USE Passwordstate UPDATE SystemSettings SET ForceSSL = 0 Regards Click Studios Link to comment Share on other sites More sharing options...
Matt Posted November 10, 2017 Author Share Posted November 10, 2017 Yep, that worked. Thank you. Link to comment Share on other sites More sharing options...
support Posted November 10, 2017 Share Posted November 10, 2017 Excellent - thanks Matt. Link to comment Share on other sites More sharing options...
dkraklan Posted February 17, 2018 Share Posted February 17, 2018 I ran into this problem tonight, however I had to runn the following query SELECT ForceSSL FROM SystemSettings then change the value from True to False , not sure if you guys are using the numbers anymore or if that is something SQL studio does but running your command did not work. Link to comment Share on other sites More sharing options...
support Posted February 17, 2018 Share Posted February 17, 2018 Hi dkraklan, Are you also using Load Balancers as well? If not, there should be no need to turn of SSL redirection. If you are not using Load Balancers, can you share screenshots of your bindings in IIS, and what certificate is being used? Thanks Click Studios Link to comment Share on other sites More sharing options...
dkraklan Posted February 19, 2018 Share Posted February 19, 2018 I'am not using load balancers. I'm sorry but I'm not very familiar with IIS, where can I find the bindings you are looking for ? Link to comment Share on other sites More sharing options...
support Posted February 20, 2018 Share Posted February 20, 2018 Here you go: Link to comment Share on other sites More sharing options...
dkraklan Posted February 20, 2018 Share Posted February 20, 2018 Hello, Following your screenshot I was able to determine it had not created the binding for https on 443, I created the binding and selected the correct SSL cert. Changed the database back to force SSL, and it all seems to be loading fine. One question, should it have created this binding during installation? As I did not see any step indicating I needed to do this. Also I have port 9119 in there and it was an option during install to chose this port. However that port doesn't seem to load anything ? What is it used for, is it necessary to leave this port open ? Link to comment Share on other sites More sharing options...
support Posted February 20, 2018 Share Posted February 20, 2018 Hello, During the install, the default port specified is 9119 - and this should have created a binding with your certificate on this port. I believe the reason port 443 was not created, was because you did not change the default binding of 9119 to 443. You can now delete 9119 since you have 443 working. Regards Click Studios Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now