You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@syncope.apache.org by Lionel SCHWARZ <li...@in2p3.fr> on 2023/08/17 13:27:46 UTC

Re: [ANN] Apache Syncope 3.0.4

Dear all,

After upgrading my Syncope 3.0.3 setup (Maven, MariaDB) to 3.0.4, it does not start anymore, something seems to be wrong in the database:

java.sql.SQLException: Table "OIDCRPClientApp" has a foreign key to table "TicketExpiration" that has not been generated.  You must run the schema generator on all inter-related tables at once.

I also have seen the same error with tables "Realm" and "SAML2SPClientApp"... Is there anything more to do than what is described at https://s.apache.org/a0bl5 ?

Best regards
Lionel

----- Le 10 Juil 23, à 13:45, Francesco Chicchiriccò ilgrosso@apache.org a écrit :

> The Apache Syncope team is pleased to announce the release of Syncope 3.0.4
> 
> Apache Syncope is an Open Source system for managing digital identities in
> enterprise environments, implemented in Java EE technology .
> 
> Syncope 3.0 Maggiore is now a full-fledged IAM system covering provisioning,
> reconciliation and reporting needs (as with earlier releases), access
> management and API management.
> 
> The release will be available within 24h from:
> https://syncope.apache.org/downloads
> 
> Read the full change log available here:
> https://s.apache.org/syncope304
> 
> Upgrading from 3.0.3? There are some notes about this process:
> https://s.apache.org/a0bl5
> 
> We welcome your help and feedback. For more information on how to report
> problems, and to get involved, visit the project website at
> 
> http://syncope.apache.org/
> 
> The Apache Syncope Team

Re: [ANN] Apache Syncope 3.0.4

Posted by Lionel SCHWARZ <li...@in2p3.fr>.
Thanks Francesco, I could successfully start Syncope.

However, on MariaDB, I had to run
ALTER TABLE AnyObject DROP INDEX U_NYOBJCT_NAME;
instead of 
ALTER TABLE AnyObject DROP INDEX AnyObject_name;
as stated in the doc.

Regards
Lionel

----- Le 18 Aoû 23, à 11:21, Francesco Chicchiriccò ilgrosso@apache.org a écrit :

> The table
> 
> TicketExpiration
> 
> was renamed to
> 
> TicketExpirationPolicy
> 
> to follow the convention of all other policies.
> 
> Thanks for reporting.
> Regards.
> 
> On 17/08/23 15:27, Lionel SCHWARZ wrote:
>> Dear all,
>>
>> After upgrading my Syncope 3.0.3 setup (Maven, MariaDB) to 3.0.4, it does not
>> start anymore, something seems to be wrong in the database:
>>
>> java.sql.SQLException: Table "OIDCRPClientApp" has a foreign key to table
>> "TicketExpiration" that has not been generated.  You must run the schema
>> generator on all inter-related tables at once.
>>
>> I also have seen the same error with tables "Realm" and "SAML2SPClientApp"... Is
>> there anything more to do than what is described at https://s.apache.org/a0bl5
>> ?
>>
>> Best regards
>> Lionel
>>
>> ----- Le 10 Juil 23, à 13:45, Francesco Chicchiriccò ilgrosso@apache.org a écrit
>> :
>>
>>> The Apache Syncope team is pleased to announce the release of Syncope 3.0.4
>>>
>>> Apache Syncope is an Open Source system for managing digital identities in
>>> enterprise environments, implemented in Java EE technology .
>>>
>>> Syncope 3.0 Maggiore is now a full-fledged IAM system covering provisioning,
>>> reconciliation and reporting needs (as with earlier releases), access
>>> management and API management.
>>>
>>> The release will be available within 24h from:
>>> https://syncope.apache.org/downloads
>>>
>>> Read the full change log available here:
>>> https://s.apache.org/syncope304
>>>
>>> Upgrading from 3.0.3? There are some notes about this process:
>>> https://s.apache.org/a0bl5
>>>
>>> We welcome your help and feedback. For more information on how to report
>>> problems, and to get involved, visit the project website at
>>>
>>> http://syncope.apache.org/
>>>
>>> The Apache Syncope Team
> 
> 
> --
> Francesco Chicchiriccò
> 
> Tirasa - Open Source Excellence
> http://www.tirasa.net/
> 
> Member at The Apache Software Foundation
> Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
> http://home.apache.org/~ilgrosso/

Re: [ANN] Apache Syncope 3.0.4

Posted by Francesco Chicchiriccò <il...@apache.org>.
The table

TicketExpiration

was renamed to

TicketExpirationPolicy

to follow the convention of all other policies.

Thanks for reporting.
Regards.

On 17/08/23 15:27, Lionel SCHWARZ wrote:
> Dear all,
>
> After upgrading my Syncope 3.0.3 setup (Maven, MariaDB) to 3.0.4, it does not start anymore, something seems to be wrong in the database:
>
> java.sql.SQLException: Table "OIDCRPClientApp" has a foreign key to table "TicketExpiration" that has not been generated.  You must run the schema generator on all inter-related tables at once.
>
> I also have seen the same error with tables "Realm" and "SAML2SPClientApp"... Is there anything more to do than what is described at https://s.apache.org/a0bl5 ?
>
> Best regards
> Lionel
>
> ----- Le 10 Juil 23, à 13:45, Francesco Chicchiriccò ilgrosso@apache.org a écrit :
>
>> The Apache Syncope team is pleased to announce the release of Syncope 3.0.4
>>
>> Apache Syncope is an Open Source system for managing digital identities in
>> enterprise environments, implemented in Java EE technology .
>>
>> Syncope 3.0 Maggiore is now a full-fledged IAM system covering provisioning,
>> reconciliation and reporting needs (as with earlier releases), access
>> management and API management.
>>
>> The release will be available within 24h from:
>> https://syncope.apache.org/downloads
>>
>> Read the full change log available here:
>> https://s.apache.org/syncope304
>>
>> Upgrading from 3.0.3? There are some notes about this process:
>> https://s.apache.org/a0bl5
>>
>> We welcome your help and feedback. For more information on how to report
>> problems, and to get involved, visit the project website at
>>
>> http://syncope.apache.org/
>>
>> The Apache Syncope Team


-- 
Francesco Chicchiriccò

Tirasa - Open Source Excellence
http://www.tirasa.net/

Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/