Re: [Ejbca-develop] EJBCA 3.2.x to 3.11.x direct upgrade

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Isn't that just the JBoss 5 bug? You need to remove deploy/tmp and
deploy/work when JBoss doesn't realize things have changed.

/Tomas

On 03/13/2012 10:26 PM, Randy Yu wrote:
> Thanks Tomas, I will keep database backups for each version that involves db changes and do comparisons.
> 
> When going from EJBCA 3.6.4 to 3.7.5 now I am seeing the following when trying to reach the administrative interface.  Was a method name changed for administrative access?
> 
> java.lang.NoSuchMethodError: org.ejbca.core.model.log.Admin.(Ljava/security/cert/Certificate;)V : org.ejbca.core.model.log.Admin.(Ljava/security/cert/Certificate;)V
> 
> --
> Randy Yu
> 
> -----Original Message-----
> From: to...@pr... [mailto:to...@pr...] 
> Sent: March-13-12 10:47 AM
> To: ejb...@li...; ejb...@li...
> Subject: Re: [Ejbca-develop] EJBCA 3.2.x to 3.11.x direct upgrade
> 
> Hi,
> 
> Yeah that is a very long upgrade to do in one shot. Probably some admin group id got messed up in that upgrade. Either try to figure out what to fix in the database tables (accessrules, adminentity, admin groups), or create new admins using the cli.
> 
> If you are lucky your server log will give you some hints.
> 
> Cheers,
> Tomas
> 
> 
> Randy Yu <yu...@ec...> wrote:
> 
>> When doing the upgrade incrementally through all the minor version, I 
>> am successful in my testing up to version 3.6.4.  When I get the this 
>> version the upgrade steps perform correctly but when I try to login 
>> with the EJBCA superadmin user I am unable to do so.  I was able to 
>> login with the EJBCA superadmin user from 3.2.x to 3.5.x.
>>
>> --
>> Randy Yu
>>
>>
>> -----Original Message-----
>> From: Tomas Gustavsson [mailto:to...@pr...]
>> Sent: March-02-12 11:10 AM
>> To: ejb...@li...
>> Subject: Re: [Ejbca-develop] EJBCA 3.2.x to 3.11.x direct upgrade
>>
>>
>> They are not in the upgrade scripts because the upgrade scripts do not 
>> create new tables, only changes to existing tables are handled by the 
>> upgrade scripts.
>>
>> A search in the changelogs (https://jira.primekey.se/) for when 
>> "Approvals" was added, tells it was probably in EJBCA 3.3. That was 
>> more than 5 years ago.
>>
>>
>> Cheers,
>> Tomas
>> -----
>> PrimeKey Solutions offers commercial EJBCA and SignServer support 
>> subscriptions and training courses. Please see www.primekey.se or 
>> contact in...@pr... for more information.
>> http://www.primekey.se/Services/Support/
>> http://www.primekey.se/Services/Training/
>>
>>
>> On 03/02/2012 05:03 PM, Randy Yu wrote:
>>> I have been following the steps from this upgrade document but I
>> don't see the ApprovalData, ServiceData, UserDataSourceData tables on 
>> my existing EJBCA 3.2.1 database.  I was wondering at what version 
>> these were introduced as I don't see them in the scripts upgrading from 
>> 3.2.x to 3.11.x.
>>>
>>> --
>>> Randy Yu
>>> 416-226-8615 | www.echoworx.com
>>>
>>>
>>> -----Original Message-----
>>> From: Tomas Gustavsson [mailto:to...@pr...]
>>> Sent: March-02-12 2:18 AM
>>> To: ejb...@li...
>>> Subject: Re: [Ejbca-develop] EJBCA 3.2.x to 3.11.x direct upgrade
>>>
>>>
>>> You should follow the upgrade instructions in doc/UPGRADE.
>>>
>>> The tables are created when EJBCA, i.e. the new version, is deployed.
>>>
>>> /Tomas
>>>
>>> On 03/01/2012 07:35 PM, Randy Yu wrote:
>>>> Thanks...follow up to this...I can't seem to locate where the tables
>> are that the alter statements in the 310_311-upgrade-oracle.sql script 
>> are trying to apply.  In which EJBCA version were these tables 
>> introduced as I had applied all the scripts consecutively from 3.2.x.
>>>>
>>>> Connected to:
>>>> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit 
>>>> Production With the Partitioning, OLAP and Data Mining options
>>>>
>>>> SQL>   SQL>   SQL>   SQL>   ALTER TABLE ApprovalData ADD
>> tmpapprovaldata
>>>> SQL>  CLOB DEFAULT NULL
>>>> *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>>
>>>> SQL>   UPDATE ApprovalData SET tmpapprovaldata=approvaldata
>>>>          *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>>
>>>> SQL>   ALTER TABLE ApprovalData DROP COLUMN approvaldata
>>>> *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>>
>>>> SQL>   ALTER TABLE ApprovalData ADD approvaldata CLOB DEFAULT NULL
>>>> *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>>
>>>> SQL>   UPDATE ApprovalData SET approvaldata=tmpapprovaldata
>>>>          *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>>
>>>> SQL>   ALTER TABLE ApprovalData DROP COLUMN tmpapprovaldata
>>>> *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>>
>>>> SQL>   SQL>   SQL>   ALTER TABLE ServiceData ADD nextRunTimeStamp
>>>> SQL>  NUMBER(19) DEFAULT 0 NOT NULL
>>>> *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>>
>>>> SQL>   ALTER TABLE ServiceData ADD runTimeStamp NUMBER(19) DEFAULT 0
>>
>>>> SQL> NOT NULL
>>>> *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>>
>>>> SQL>   SQL>   SQL>
>>>> Table altered.
>>>>
>>>> SQL>
>>>> Table altered.
>>>>
>>>> SQL>
>>>> Table altered.
>>>>
>>>> SQL>
>>>> Table altered.
>>>>
>>>> SQL>   ALTER TABLE ApprovalData ADD rowVersion NUMBER(10) DEFAULT 0 
>>>> SQL> NOT  NULL
>>>> *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>>
>>>> SQL>
>>>> Table altered.
>>>>
>>>> SQL>
>>>> Table altered.
>>>>
>>>> SQL>
>>>> Table altered.
>>>>
>>>> SQL>   ALTER TABLE ServiceData ADD rowProtection CLOB DEFAULT NULL
>>>> *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>> SQL>
>>>> Table altered.
>>>>
>>>> SQL>   ALTER TABLE UserDataSourceData ADD rowProtection CLOB DEFAULT
>>
>>>> SQL> NULL
>>>> *
>>>> ERROR at line 1:
>>>> ORA-00942: table or view does not exist
>>>>
>>>> --
>>>> Randy Yu
>>>> 416-226-8615 | www.echoworx.com
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: Tomas Gustavsson [mailto:to...@pr...]
>>>> Sent: March-01-12 10:50 AM
>>>> To: ejb...@li...
>>>> Subject: Re: [Ejbca-develop] EJBCA 3.2.x to 3.11.x direct upgrade
>>>>
>>>>
>>>> Check the system requirements in the EJBCA 3.11 documentation.
>>>>
>>>> http://ejbca.org/older_releases/ejbca_3_11/htdocs/index.html
>>>>
>>>> Cheers,
>>>> Tomas
>>>>
>>>>
>>>> On 03/01/2012 04:42 PM, Randy Yu wrote:
>>>>> I'm attempting the direct upgrade from 3.2.x to 3.11.x. Am I able
>> to
>>>>> isolate this upgrade and not have to upgrade Java from 5 to 6 and 
>>>>> Jboss from 4 to 5?
>>>>>
>>>>> --
>>>>>
>>>>> Randy Yu
>>>>>
>>>>>
>>>>>
>>>>>
>> ----------------------------------------------------------------------
>>>>> -------- Virtualization&    Cloud Management Using Capacity
>> Planning
>>>>> Cloud computing makes use of virtualization - but cloud computing 
>>>>> also focuses on allowing computing to be delivered as a service.
>>>>> http://www.accelacomm.com/jaw/sfnl/114/51521223/
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Ejbca-develop mailing list
>>>>> Ejb...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/ejbca-develop
>>>>
>>>>
>>>>
>> ----------------------------------------------------------------------
>>>> -------- Virtualization&   Cloud Management Using Capacity Planning
>>>> Cloud computing makes use of virtualization - but cloud computing
>> also focuses on allowing computing to be delivered as a service.
>>>> http://www.accelacomm.com/jaw/sfnl/114/51521223/
>>>> _______________________________________________
>>>> Ejbca-develop mailing list
>>>> Ejb...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/ejbca-develop
>>>>
>>>>
>> ----------------------------------------------------------------------
>>>> -------- Virtualization&   Cloud Management Using Capacity Planning
>>>> Cloud computing makes use of virtualization - but cloud computing 
>>>> also focuses on allowing computing to be delivered as a service.
>>>> http://www.accelacomm.com/jaw/sfnl/114/51521223/
>>>> _______________________________________________
>>>> Ejbca-develop mailing list
>>>> Ejb...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/ejbca-develop
>>>
>>>
>>>
>> ----------------------------------------------------------------------
>>> -------- Virtualization&  Cloud Management Using Capacity Planning 
>>> Cloud computing makes use of virtualization - but cloud computing
>> also focuses on allowing computing to be delivered as a service.
>>> http://www.accelacomm.com/jaw/sfnl/114/51521223/
>>> _______________________________________________
>>> Ejbca-develop mailing list
>>> Ejb...@li...
>>> https://lists.sourceforge.net/lists/listinfo/ejbca-develop
>>>
>>>
>> ----------------------------------------------------------------------
>>> -------- Virtualization&  Cloud Management Using Capacity Planning 
>>> Cloud computing makes use of virtualization - but cloud computing
>> also
>>> focuses on allowing computing to be delivered as a service.
>>> http://www.accelacomm.com/jaw/sfnl/114/51521223/
>>> _______________________________________________
>>> Ejbca-develop mailing list
>>> Ejb...@li...
>>> https://lists.sourceforge.net/lists/listinfo/ejbca-develop
>>
>>
>> -----------------------------------------------------------------------
>> ------- Virtualization & Cloud Management Using Capacity Planning Cloud 
>> computing makes use of virtualization - but cloud computing also 
>> focuses on allowing computing to be delivered as a service.
>> http://www.accelacomm.com/jaw/sfnl/114/51521223/
>> _______________________________________________
>> Ejbca-develop mailing list
>> Ejb...@li...
>> https://lists.sourceforge.net/lists/listinfo/ejbca-develop
>>
>> -----------------------------------------------------------------------
>> ------- Keep Your Developer Skills Current with LearnDevNow!
>> The most comprehensive online learning library for Microsoft developers 
>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, 
>> MVC3, Metro Style Apps, more. Free future releases when you subscribe 
>> now!
>> http://p.sf.net/sfu/learndevnow-d2d
>> _______________________________________________
>> Ejbca-develop mailing list
>> Ejb...@li...
>> https://lists.sourceforge.net/lists/listinfo/ejbca-develop
> 
> 
> ------------------------------------------------------------------------------
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> _______________________________________________
> Ejbca-develop mailing list
> Ejb...@li...
> https://lists.sourceforge.net/lists/listinfo/ejbca-develop
> 
> ------------------------------------------------------------------------------
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> _______________________________________________
> Ejbca-develop mailing list
> Ejb...@li...
> https://lists.sourceforge.net/lists/listinfo/ejbca-develop