Hi all,
I recently updated my osTicket from version 1.10.4 to version 1.14.3. The update has been successfully.
Then I installed the Help Desk Audit plugin because I want to track all user/agent access events to the system, but unfortunately I am not able to see such logs into the "Audit Logs dashboard" nor in the "User/Agent audit dashboard".
I guess, I don't know for which reason, that the login/logout event have not been included into my 'ost_event' table.
mysql> select * from ost_event;
+----+-------------+-------------+
| id | name | description |
+----+-------------+-------------+
| 1 | created | |
| 2 | closed | |
| 3 | reopened | |
| 4 | assigned | |
| 5 | released | |
| 6 | transferred | |
| 7 | referred | |
| 8 | overdue | |
| 9 | edited | |
| 10 | viewed | |
| 11 | error | |
| 12 | collab | |
| 13 | resent | |
| 14 | deleted | |
| 15 | merged | |
| 16 | unlinked | |
| 17 | linked | |
+----+-------------+-------------+
In fact, when I log into the platform, the 'ost_audit' table stores a record with event_id=NULL:
mysql> select * from ost_audit where event_id IS NULL;
+----+-------------+-----------+----------+----------+---------+----------------------------------+---------+---------------------+
| id | object_type | object_id | event_id | staff_id | user_id | data | ip | timestamp |
+----+-------------+-----------+----------+----------+---------+----------------------------------+---------+---------------------+
| 9 | U | 13 | NULL | 0 | 13 | {"person":"Luigi Pino","msg":""} | X.X.X.X | 2020-11-12 17:12:38 |
| 10 | U | 13 | NULL | 0 | 13 | {"person":"Luigi Pino","msg":""} | X.X.X.X | 2020-11-12 17:12:46 |
| 15 | S | 16 | NULL | 16 | 0 | {"person":"Luigi Pino","msg":""} | X.X.X.X | 2020-11-12 17:18:19 |
| 16 | S | 16 | NULL | 16 | 0 | {"person":"Luigi Pino","msg":""} | X.X.X.X | 2020-11-12 17:19:57 |
| 23 | S | 16 | NULL | 16 | 0 | {"person":"Luigi Pino","msg":""} | X.X.X.X | 2020-11-12 17:59:27 |
| 24 | S | 16 | NULL | 16 | 0 | {"person":"Luigi Pino","msg":""} | X.X.X.X | 2020-11-12 17:59:38 |
| 26 | S | 16 | NULL | 16 | 0 | {"person":"Luigi Pino","msg":""} | X.X.X.X | 2020-11-12 18:07:23 |
| 27 | S | 16 | NULL | 16 | 0 | {"person":"Luigi Pino","msg":""} | X.X.X.X | 2020-11-12 18:07:36 |
+----+-------------+-----------+----------+----------+---------+----------------------------------+---------+---------------------+
Did anybody have the same issue? Who can help me to solve it?
Thanks in advance.