[midPoint] Locked out of administrative account in midpoint

Shawn McKinney smckinney at symas.com
Wed Jun 21 15:59:02 CEST 2017


Hi Oskar, thanks for replying.

> On Jun 21, 2017, at 8:01 AM, Oskar Butovič - AMI Praha a.s. <oskar.butovic at ami.cz> wrote:
> 
> If you have access to midpoint database you can delete administrator from m_user and m_object table. After midpoint restart fresh administrator with default midpoint password should be created.

Yep this worked, thanks.  There was a bit more to it.  I used psql, retrieved the oid and then removed all traces of the administrator in the following way.

Now able to log in with administrator.

select oid, name_norm, name_orig from m_object where name_norm like 'admin%';
delete from m_assignment where owner_oid = '00000000-0000-0000-0000-000000000002';
delete from m_operation_execution where owner_oid = '00000000-0000-0000-0000-000000000002';
delete from m_reference where owner_oid = '00000000-0000-0000-0000-000000000002';
delete from m_object where oid = '00000000-0000-0000-0000-000000000002';
delete from m_focus where oid = '00000000-0000-0000-0000-000000000002';
delete from m_user where oid = '00000000-0000-0000-0000-000000000002’;

Shawn




More information about the midPoint mailing list