Changing from http to https

In this article

    If you want to change from http://support.company.com to https://support.company.com, this article explains what you need to be aware of.

    Here is a guide that explains how to change from HTTP to HTTPS on your website.

    https://docs.microsoft.com/en-us/iis/manage/configuring-security/how-to-set-up-ssl-on-iis

    In addition you need to update the database so it knows to use HTTPS instead of HTTP, this is done in the <prefix>.config table the two fields cgi_url and cgi_url_internal:

    select cgi_url, cgi_url_internal from crm7.config

    Please note - you need to make sure you have a backup of your database before you run any query directly on the database. If something goes wrong, the backup is your only way back to the original state.

    In addition there may be references to http://support.company.com in your reply templates, knowledge base or any message posted on your current request. These will either fail, must be redirected or updated in the database.

    For reply templates, these will be found with this query:

    select * from crm7.REPLY_TEMPLATE_BODY where body_plain like '%http://support.company.com%' or body_html like '%http://support.company.com%' or subject like '%http://support.company.com%'

    For the knowledge base / FAQ entries, use this query to locate entries that needs to be updated:

    select * from crm7.kb_entry where title like '%http://support.company.com%' or question like '%http://support.company.com%' or answer like '%http://support.company.com%'

    For any message in an existing ticket:

    select * from crm7.ej_message where body like '%http://support.company.com%' or body_html like '%http://support.company.com%'