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.
Parents
  • Hi : Thanks for sharing the logs. Based on shared logs seems the user is selected under "Authentication Policies" under Web server settings.

    Can you please check the same and confirm if any of them including that user/user group there? If yes then remove it from there and delete the use to confirm the status.

    Reference snapshot:

Reply
  • Hi : Thanks for sharing the logs. Based on shared logs seems the user is selected under "Authentication Policies" under Web server settings.

    Can you please check the same and confirm if any of them including that user/user group there? If yes then remove it from there and delete the use to confirm the status.

    Reference snapshot:

Children