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" }}}
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.
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.
This thread was automatically locked due to age.