$ php-win --version
PHP 7.3.7 (cli) (built: Jul 3 2019 14:34:13) ( ZTS MSVC15 (Visual C++ 2017) x64 )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.7, Copyright (c) 1998-2018 Zend Technologies
with Xdebug v2.7.2, Copyright (c) 2002-2019, by Derick Rethans
$ httpd -v
Server version: Apache/2.4.38 (Win64)
Apache Lounge VC15 Server built: Jan 18 2019 14:26:34
mysql.exe --version
c:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe Ver 8.0.15 for Win64 on x86_64 (MySQL Community Server - GPL)
More cleanly, my order of steps is like so:
- Go to http://localhost/osticket/scp/login.php
- Enter my previously known good username and password
- get Access denied error
Troubleshooting
- For this specific action (logging in) there are NO Apache/PHP errors in logs
- Developer Tools in Mozilla gives me HTTP Status Code of 422: Unprocessable Entity. Response body states "Authentication Required" and repeats the login screen.
- MySQL Log is as such
mysql> SELECT COUNT(*) FROM (SELECT A1.`id` FROM `config` A1 WHERE A1.`namespace` = 'core') __;
ERROR 1054 (42S22): Unknown column 'A1.namespace' in 'where clause'
mysql> SELECT * FROM config WHERE id = 1;
[full output in last post]
mysql> SELECT * FROM plugin;
ERROR 1146 (42S02): Table 'support.plugin' doesn't exist
mysql> SELECT COUNT(*) FROM (SELECT A1.`id` FROM `config` A1 WHERE A1.`namespace` = 'mysqlsearch') __;
ERROR 1054 (42S22): Unknown column 'A1.namespace' in 'where clause'
In the code, this is the Access denied message that I get:
https://github.com/osTicket/osTicket/blob/develop/include/class.auth.php#L253
For $result in https://github.com/osTicket/osTicket/blob/develop/include/class.auth.php#L235
There are attempts to authenticate on two backends, with $result respectively:
StaffAuthStrikeBackend => NULL
PasswordResetTokenBackend => bool(false)
