[Ejbca-develop] Super Administrator certificate expired

[Marco P. <mar...@un...>]

Hello, 

as writed in the Subject my Super Administrator certificate is expired. ... 

I generated a new administrator.p12 certificate and imported it in my Firefox, but I'm not able to access Administration page: 
Authorization Denied 
Cause : You are not authorized to view this page. 
I think the problem is the certificate serial number that is different. Is it right ? 

How can i change this value to set the new one ? 

I've tried with: 

mysql> select * from AdminEntityData; 
+------------+----------+------------+------------------+-----------+---------------+------------+------------------------------+ 
| pK | cAId | matchType | matchValue | matchWith | rowProtection | rowVersion | AdminGroupData_adminEntities | 
+------------+----------+------------+------------------+-----------+---------------+------------+------------------------------+ 
| 329358383 | 0 | 2003 | UNUSED | 11 | NULL | 0 | 699462851 | 
| 329358381 | 0 | 2001 | UNUSED | 11 | NULL | 0 | 699462851 | 
| 329358382 | 0 | 2002 | UNUSED | 11 | NULL | 0 | 699462851 | 
| 329358376 | 0 | 2004 | UNUSED | 11 | NULL | 0 | 699462851 | 
| 1346258728 | 0 | 2000 | UNUSED | 11 | NULL | 0 | 1992513559 | 
| 1638101299 | 10711734 | 1000 | 0DD01925A61C6AB2 | 11 | NULL | 0 | 1666727782 | 
+------------+----------+-----------+------------------+-----------+---------------+------------+------------------------------+ 

and changed the last line with the new value: 

UPDATE AdminEntityData SET matchValue='45DD9929D269FC85' WHERE pK=1638101299; 

but nothing. 

Please help. 

Thank you very much. 

Marco 
-- 
Marco Pirovano 
Infrastrutture e Tecnologie 
Area Sistemi Informatici e Telematici 
Universita' Bocconi 
via Gobbi, 5 - 20136 Milano 
Tel. +39 02 5836.3173 Fax. +39 02 5836.3160