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
- 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" )
- 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
