Re: [Ejbca-develop] Super Administrator certificate expired

[Tomas G. <to...@pr...>]

You should check out the "bin/ejbca.sh admins" CLI command. It gives you 
good access to administrator configuration.

Cheers,
Tomas

** VISIT US AT RSA EXPO - BOOTH #459 **
**** FREE EXPO PASS CODE: FXE13PKS ****
https://ae.rsaconference.com/US13/portal/login.ww

**********
PrimeKey Solutions AB
Anderstorpsvägen 16, 171 54 Solna, Sweden
Mob: +46 (0)707421096
Internet: www.primekey.se
Twitter: twitter.com/primekeyPKI
**********

On 02/20/2013 04:20 PM, Marco Pirovano wrote:
> 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
>
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_feb
>
>
>
> _______________________________________________
> Ejbca-develop mailing list
> Ejb...@li...
> https://lists.sourceforge.net/lists/listinfo/ejbca-develop
>