Guest User!

You are not Sophos Staff.

This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Cannot remove AD user

Hi all,

I cannot remove an AD user from the users tab. This user has no firewall rule attached, nor is any VPN enabled, and no web policy active.

I am on version 18.5.2

csc.log shows this:

MESSAGE   Mar 01 17:40:19Z  [worker:26569]: {"request":{"method":"opcode","name":"delete_user","version":"1.6","type":"json","length":367,"data":{ "___serverip": "10.0.0.254", "currentlyloggedinuserip": "10.0.0.2", "APIVersion": "1805.2", "___component": "GUI", "___meta": { "sessionType": 1 }, "mode": 33, "transactionid": "17609", "___username": "admin", "currentlyloggedinuserid": 3, "userIds": [ "username@domain.org" ], "___serverprotocol": "HTTP", "___serverport": 4444, "Entity": "user", "Event": "DELETE" }}}
ERROR     Mar 01 17:40:19Z  [delete_user:26569]: get_query_status: DB has returned error code: 23503
ERROR     Mar 01 17:40:19Z  [delete_user:26569]: get_query_status:Query Error: ERROR:  update or delete on table "tbluser" violates foreign key constraint "tblwafauth_profile_user_rel_userid_fkey" on table "tblwafauth_profile_user_rel"
DETAIL:  Key (userid)=(8) is still referenced from table "tblwafauth_profile_user_rel".
CRITICAL  Mar 01 17:40:19Z  [delete_user:26569]: csc_prep_query: execute_prepare_query failed for Execute Query.
ERROR     Mar 01 17:40:19Z  [delete_user:26569]: do_prep_query: Failed PREPSTMT: 'delete from tbluser where userId = ?'
ERROR     Mar 01 17:40:19Z  [delete_user:26569]: get_query_status: DB has returned error code: 25P02
ERROR     Mar 01 17:40:19Z  [delete_user:26569]: get_query_status:Query Error: ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR     Mar 01 17:40:19Z  [delete_user:26569]: csc_prep_query: execute_prepare_query failed for SELECT txid_current().
ERROR     Mar 01 17:40:19Z  [delete_user:26569]: delete_userid: input has no array elements
ERROR     Mar 01 17:40:19Z  [delete_user:26569]: delete_ugrel_cache: input has no array elements
WARNING   Mar 01 17:40:19Z  [delete_user:26569]: Action with NOFAIL Failed.

Could this have to do with the issue I had recently with the WAF rules? I double checked all rules and there is nowhere this user.



This thread was automatically locked due to age.