Hello Everyone!
I have installed osTicket as below on the LAMP server below. Immediately, after installation I am unable to login with the Username and Password supplied to the installer.
- I have search this forum and tried the MD5 update of the user as below, no joy.
- Have not found any other articles with "fixes" that relate to this issue.
- I have re-installed several time with different usernames, password lengths (6-8 chars - alpha only, numbers, combination, no "special characters").
-
Error Message: Access Denied
Is this a bug? or a known issue?
Any assistance would be greatly appreciated.
Thank you.
Server Configuration
---------------------------------------------------------------------
- AWS LightSail Bitnami LAMP (7.2.32-0)
- 512 MB RAM, 1 vCPU, 20 GB SSD
- Debian 10
- PHP 7
- MySQL Ver 8.0.18 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)
- osTicket Core, v1.14.2 (Latest Stable Release)
MySQL Session details
---------------------------------------------------------------------
` mysql> select username, change_passwd, passwd from ost_staff;
+----------+---------------+--------------------------------------------------------------+
| username | change_passwd | passwd
+----------+---------------+--------------------------------------------------------------+
| ostadmin | 0 | $2a$08$04UzNXO7Estlw9xvWnVmp.oe5wdB49KAQSaVy/JawIaTKMAilltrm |+----------+---------------+--------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> update ost_staff set passwd=MD5('123456') where username
='ostadmin';
Query OK, 1 row affected (0.01 sec)Rows matched: 1 Changed: 1 Warnings: 0
mysql> select username, change_passwd, passwd from ost_staff;
+----------+---------------+----------------------------------+
| username | change_passwd | passwd |
+----------+---------------+----------------------------------+
| ostadmin | 0 | e10adc3949ba59abbe56e057f20f883e |
+----------+---------------+----------------------------------+
1 row in set (0.00 sec)
mysql> select * from ost_syslog;
+--------+----------+-----------------------------+------------------------------------------------------------------------------------------+--------+-----------------+---------------------+---------------------+
| log_id | log_type | title | log | logger | ip_address | created | updated |
+--------+----------+-----------------------------+------------------------------------------------------------------------------------------+--------+-----------------+---------------------+---------------------+
| 1 | Debug | osTicket installed! | Congratulations osTicket basic installation completed!Thank you for choosing osTicket! | | xxx.xxx.xxx.xxx | 2020-07-30 05:48:18 | 2020-07-30 05:48:18 || 2 | Warning | Failed login attempt (user) | Username: ostadmin IP: xxx.xxx.xxx.xxx Time: Jul 30, 2020, 5:51 am UTC Attempts: 3 | | xxx.xxx.xxx.xxx | 2020-07-30 05:51:44 | 2020-07-30 05:51:44 |
+--------+----------+-----------------------------+------------------------------------------------------------------------------------------+--------+-----------------+---------------------+---------------------+`