STAS 2.2.2.8
When i click Show Live Users I seem to get 6 entries that are all the same user going back at least 3 years !!
When I click on the delete button I get a warning saying "User could not be deleted from the database" and when I refresh its back again.
DEBUG [0x844] 18/04/2019 06:19:04 : dead_entry_timeout_workerthread: Checking for expired users...
DEBUG [0x844] 18/04/2019 06:19:04 : dead_entry_findExpiredUsers: Username s.o'toole+10.1.0.27, CurrentTime 132000419443380000, Stored Time 131515010304820000
DEBUG [0x844] 18/04/2019 06:19:04 : dead_entry_findExpiredUsers: Username s.o'toole+10.1.0.30, CurrentTime 132000419443380000, Stored Time 131722584745650000
DEBUG [0x844] 18/04/2019 06:19:04 : dead_entry_findExpiredUsers: Username s.o'toole+10.1.0.66, CurrentTime 132000419443380000, Stored Time 0
DEBUG [0x844] 18/04/2019 06:19:04 : dead_entry_findExpiredUsers: Username s.o'toole+10.1.0.85, CurrentTime 132000419443380000, Stored Time 131540435430440000
DEBUG [0x844] 18/04/2019 06:19:04 : dead_entry_findExpiredUsers: Username s.o'toole+10.1.1.26, CurrentTime 132000419443380000, Stored Time 131169445828624383
DEBUG [0x844] 18/04/2019 06:19:04 : dead_entry_findExpiredUsers: Username s.o'toole+10.1.1.95, CurrentTime 132000419443380000, Stored Time 131357092949786623
DEBUG [0x844] 18/04/2019 06:19:04 : dead_entry_findExpiredUsers: 6 expired users found...
DEBUG [0x844] 18/04/2019 06:19:04 : dead_entry_timeout_workerthread: DeadEntry time expired for the user s.o'toole Workstation IP 10.1.0.27
DEBUG [0x844] 18/04/2019 06:19:04 : userdb_delete_userinfo: delete query: DELETE FROM UserInfo WHERE user=='s.o'toole' AND wrkst_ip=='10.1.0.27';
ERROR [0x844] 18/04/2019 06:19:04 : userdb_exec_query: prepare statement failed: near "toole": syntax error
ERROR [0x844] 18/04/2019 06:19:04 : userdb_delete_userinfo: delete query failed
DEBUG [0x844] 18/04/2019 06:19:04 : list_add_tail: first element added
DEBUG [0x844] 18/04/2019 06:19:04 : dead_entry_timeout_workerthread: DeadEntry time expired for the user s.o'toole Workstation IP 10.1.0.30
DEBUG [0x844] 18/04/2019 06:19:04 : userdb_delete_userinfo: delete query: DELETE FROM UserInfo WHERE user=='s.o'toole' AND wrkst_ip=='10.1.0.30';
ERROR [0x850] 18/04/2019 06:19:04 : USERINFO WAITING INFINITE
ERROR [0x844] 18/04/2019 06:19:04 : userdb_exec_query: prepare statement failed: near "toole": syntax error
DEBUG [0x850] 18/04/2019 06:19:04 : list_remove_head: last element removed
ERROR [0x844] 18/04/2019 06:19:04 : userdb_delete_userinfo: delete query failed
any suggestions on how to delete these entries?
Thanks
Lee
This thread was automatically locked due to age.