You go back to the same place that you enabled it.
Admin panel -> Settings -> System
uncheck "Force HTTPS".
Click Save Changes.

-OR-
presuming you also have access to the database (MySQL/Mariadb in this case.)

MariaDB [(none)]> use osticket;
MariaDB [osticket]> SELECT * FROM ost_config WHERE ID=118;
+-----+-----------+-------------+-------+---------------------+
| id  | namespace | key         | value | updated             |
+-----+-----------+-------------+-------+---------------------+
| 118 | core      | force_https |       | 2022-10-11 00:28:43 |
+-----+-----------+-------------+-------+---------------------+
1 row in set (0.000 sec)
MariaDB [(none)]> UPDATE ost_config SET VALUE = '' WHERE ID=118;
MariaDB [(none)]> exit;

Double check the table id setting key, then zero out the entry.

Then go and fix the web server for proper SSL and publicly signed certs for use before forcing https.

I'm trying to disable https as well. But when i run the command you give i don't see "force_https".

MariaDB [osticket_db]> show tables;
+--------------------------+
| Tables_in_osticket_db |
+--------------------------+
| ost__search |
| ost_api_key |
| ost_attachment |
| ost_audit |
| ost_canned_response |
| ost_config |
| ost_content |
| ost_department |
| ost_draft

MariaDB [osticket_db]> SELECT * FROM ost_config WHERE ID=118;
+-----+-----------+----------------------+-------+---------------------+
| id | namespace | key | value | updated |
+-----+-----------+----------------------+-------+---------------------+
| 118 | core | allow_client_updates | 0 | 2022-06-13 15:00:32 |
+-----+-----------+----------------------+-------+---------------------+
1 row in set (0.001 sec)

Help?

erik2282

Your IDs will be different so his query will not work for you. As he stated: "Double check the table id setting key, then zero out the entry.".

Cheers.

Or you can update it using the key.

UPDATE ost_config SET VALUE = '' WHERE key='force_https';

for my case it was MariaDB [osticket_db]> UPDATE ost_config SET VALUE = "" WHERE ID=100
and i was back on;;

Also be careful on how you write your mysql commands, for my case i was not well with databases but asking someone that knows databases can help you with the syntax
but this is how the commands follow each other

1. log on to your computer hosting osticket {for my case am using ubuntu 24.04)
   2.Run the mysql command to open the database
   mysql -u root -p. {enter database password that you set while installing osticket you can try the default 'root" )
2. Assuming you have entered your database you should be able to see something like this
   _Welcome to the MariaDB monitor. Commands end with ; or \g.
   Your MariaDB connection id is 16381
   Server version: 10.6.18-MariaDB-0ubuntu0.22.04.1 Ubuntu 22.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement._

3b) enter the command to show databases
SHOW DATABASES;
This will help you to get the database names that you're having
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| osticket_db |
| performance_schema |
| sys |
+--------------------+

4) Now select the osticket dabase { for my case it is "osticket_db " as you can see above}
command to select database; {this will help u to display all tables in os_config} ,
SELECT * FROM ost_config;
5) go through all the tables and verify the ID number related to "force_https"
for my case it was ID=100 , it may be different from yours
5b) verify the identified ID to be sure by using the below command { the command wil display the table of that ID}
SELECT * FROM ost_config WHERE ID=100; {replace 100 with your ID you identified above)

| id | namespace | key | value | updated |
+-----+-----------+-------------+-------+---------------------+
| 100 | core | force_https | on | 2024-08-15 08:23:28 |
+-----+-----------+-------------+-------+---------------------+

6) NO update the record
UPDATE ost_config SET VALUE = "" WHERE ID=100;

after record update, repeat the database SELECT * FROM ost_config WHERE ID=100; to be sure

in my case
+-----+-----------+-------------+-------+---------------------+
| id | namespace | key | value | updated |
+-----+-----------+-------------+-------+---------------------+
| 100 | core | force_https | | 2024-08-15 08:23:28 |
+-----+-----------+-------------+-------+---------------------+
where force_https has no value..

if you are at this stage you are good to go. refresh your browers and access osticket as you were previously accessing it . you should be able to smile