You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@syncope.apache.org by John Ellinwood <jo...@gmail.com> on 2015/03/19 21:56:19 UTC

REST fails to add roles after removing them

I am trying to use the rest api for syncope.  I'm trying this on syncope
1.2.2.  My rest client is Jersey, but this happens just using RestClient
from Firefox as well.


I have a user, "user1" id 101.
I have a roles.  "role1" id 100

Request:
  POST http://localhost:9080/syncope/rest/users/101
  {"id":101,"membershipsToAdd":[{"role":100}]}
Response
  200 Succes

Request:
  POST http://localhost:9080/syncope/rest/users/101
  {"id":101,"membershipsToRemove":[100]}
Response
  200 Success

Request:
  POST http://localhost:9080/syncope/rest/users/101
  {"id":101,"membershipsToAdd":[{"role":100}]}
Response
  409 Conflict, DataIntegrityViolation. The transaction has been rolled
back. See the nested exception for details on the errors that occurred.

Log:
...Caused by: org.apache.openjpa.lib.jdbc.ReportinSQLException: Unique
index or pimary key violation: "U_MMBRSHP_SYNCOPEUSER_ID_INDEX_C ON PUBLIC.

Re: REST fails to add roles after removing them

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

On 2015-03-20 18:59 John Ellinwood wrote: 

> Thanks. the error with my code was that I was trying to remove the ROLE ID, and not the MEMBERSHIP ID. They are different.

Correct :-) 

> Even with the syncope-client, in order to successfully add, then remove, then add again... I have to do a lot of code:
> 
> // Create syncope client and services 
> SyncopeClient sclient = new SyncopeClientFactoryBean().setAddress(address).create(adminUser, adminPassword); 
> UserService userService = sclient.getService(UserService.class); 
> RoleService roleService = sclient.getService(RoleService.class); // Create a user 
> UserTO user = new UserTO(); user.setUsername("test"); user.setPassword("test"); userService.create(user, false); 
> // Find the user ID because the userService methods don't work with name, and I don't know the ID UserTO newUser = userService.search("(username==test)").getResult().get(0);

You can avoid all such search() calls: when calling user's create(), for
example, a Response object is returned which contains a Location header
for the newly created object + the whole UserTO (including the generated
id) as entity; more details at 

http://syncope.apache.org/apidocs/1.2/org/apache/syncope/common/services/UserService.html#create(org.apache.syncope.common.to.UserTO,%20boolean)
[4] 

Moreover, for Users it is also available a service returning user id
from username 

http://syncope.apache.org/apidocs/1.2/org/apache/syncope/common/services/UserService.html#getUsername(java.lang.Long)


More details in the Javadocs or the REST API reference:
http://syncope.apache.org/rest/1.2/index.html 

HTH 
Regards. 

> // Find the role because of the same reason RoleTO role = roleService.search("(name=testrole)").getResult().get(0); // Add the role UserMod userMod = new UserMod(); MembershipMod mod1 = new MembershipMod(); mod1.setRole(role.getId()); userMod.getMembershipsToAdd().add(mod1); userService.update(newUser.getId(), userMod); // Find the updated user so I can get the membership id to delete because it doesn't work on role ids newUser = userService.search("(username==test)").getResult().get(0); MembershipTO membership = newUser.getMembershipMap().get(role.getId()); // Remove the role userMod = new UserMod(); userMod.getMembershipsToRemove().add(membership.getId()); //this is the key here.. membership id userService.update(newUser.getId(), userMod); // Add the same role back again userMod = new UserMod(); userMod.getMembershipsToAdd().add(mod1); userService.update(newUser.getId(), userMod);
> 
> On Fri, Mar 20, 2015 at 6:08 AM, Francesco Chicchiriccò <il...@apache.org> wrote:
> 
> On 19/03/2015 22:00, John Ellinwood wrote: 
> 
> Sorry, problem including the rest of the log:
> 
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unique index or primary key violation: "U_MMBRSHP_SYNCOPEUSER_ID_INDEX_C ON PUBLIC.MEMBERSHIP(SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (101, 100, 151)"; SQL statement: INSERT INTO PUBLIC.Membership (ID, CREATIONDATE, CREATOR, LASTCHANGEDATE, LASTMODIFIER, SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (?, ?, ?, ?, ?, ?, ?) [23505-185] {prepstmnt 1618806582 INSERT INTO PUBLIC.Membership (ID, CREATIONDATE, CREATOR, LASTCHANGEDATE, LASTMODIFIER, SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (?, ?, ?, ?, ?, ?, ?)} [code=23505, state=23505]
> 
> I also can't add or remove roles through the UI now. I can't delete the user either. 
> 
> On Thu, Mar 19, 2015 at 4:56 PM, John Ellinwood <jo...@gmail.com> wrote:
> 
> I am trying to use the rest api for syncope. I'm trying this on syncope 1.2.2. My rest client is Jersey, but this happens just using RestClient from Firefox as well. 
> 
> I have a user, "user1" id 101. I have a roles. "role1" id 100
> 
> Request: POST http://localhost:9080/syncope/rest/users/101 [1] {"id":101,"membershipsToAdd":[{"role":100}]} Response
> 200 Succes
> 
> Request:
> POST http://localhost:9080/syncope/rest/users/101 [1]
> {"id":101,"membershipsToRemove":[100]} Response 200 Success
> 
> Request: POST http://localhost:9080/syncope/rest/users/101 [1]
> {"id":101,"membershipsToAdd":[{"role":100}]}
> Response 
> 409 Conflict, DataIntegrityViolation. The transaction has been rolled back. See the nested exception for details on the errors that occurred.
> 
> Log: 
> ...Caused by: org.apache.openjpa.lib.jdbc.ReportinSQLException: Unique index or pimary key violation: "U_MMBRSHP_SYNCOPEUSER_ID_INDEX_C ON PUBLIC.
 Hi John,
 I've performed the same operations using Syncope client API (which are
CXF-based) and everything worked flawlessly.
 I assume you are using some 1.2.X release.

 Here's the detail:

 1. created an user (id 103) and a role (id 100) via admin console

 2. run the following code snippet in my sample Syncope client
application [1] (placed it after the "*do* something" comment on
App#main)

 MembershipMod membMod = new MembershipMod();
 membMod.setRole(100);

 UserMod userMod = new UserMod();
 userMod.setId(103);
 userMod.getMembershipsToAdd().add(membMod);

 Response response = userService.update(userMod.getId(), userMod);
 Assert.assertEquals(200, response.getStatus());

 userMod.getMembershipsToAdd().clear();
 userMod.getMembershipsToRemove().add(100L);
 response = userService.update(userMod.getId(), userMod);
 Assert.assertEquals(200, response.getStatus());

 userMod.getMembershipsToRemove().clear();
 userMod.getMembershipsToAdd().add(membMod);
 response = userService.update(userMod.getId(), userMod);
 Assert.assertEquals(200, response.getStatus());

 FYI, here's the generated HTTP calls and responses: [2]

 HTH
 Regards.

 [1] https://github.com/ilgrosso/syncopeRestClient [5]
 [2] https://paste.apache.org/a4iq [6]

-- 
Francesco Chicchiriccò

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

Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC
http://people.apache.org/~ilgrosso/ [3]

-- 
 Francesco Chicchiriccò

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

 Involved at The Apache Software Foundation:
 member, Syncope PMC chair, Cocoon PMC, Olingo PMC
 http://people.apache.org/~ilgrosso/ [3] 

Links:
------
[1] http://localhost:9080/syncope/rest/users/101
[2] http://www.tirasa.net/
[3] http://people.apache.org/~ilgrosso/
[4]
http://syncope.apache.org/apidocs/1.2/org/apache/syncope/common/services/UserService.html#create(org.apache.syncope.common.to.UserTO,%20boolean)
[5] https://github.com/ilgrosso/syncopeRestClient
[6] https://paste.apache.org/a4iq

Re: REST fails to add roles after removing them

Posted by John Ellinwood <jo...@gmail.com>.
Thanks.  the error with my code was that I was trying to remove the *role
id*, and not the *membership id*.  They are different.

Even with the syncope-client, in order to successfully add, then remove,
then add again... I have to do a lot of code:

// Create syncope client and services
SyncopeClient sclient = new
SyncopeClientFactoryBean().setAddress(address).create(adminUser,
adminPassword);
UserService userService = sclient.getService(UserService.class);
RoleService roleService = sclient.getService(RoleService.class);
// Create a user
UserTO user = new UserTO();
user.setUsername("test");
user.setPassword("test");
userService.create(user, false);
// Find the user ID because the userService methods don't work with name,
and I don't know the ID
UserTO newUser = userService.search("(username==test)").getResult().get(0);
// Find the role because of the same reason
RoleTO role = roleService.search("(name=testrole)").getResult().get(0);
// Add the role
UserMod userMod = new UserMod();
MembershipMod mod1 = new MembershipMod();
mod1.setRole(role.getId());
userMod.getMembershipsToAdd().add(mod1);
userService.update(newUser.getId(), userMod);
// Find the updated user so I can get the membership id to delete because
it doesn't work on role ids
newUser = userService.search("(username==test)").getResult().get(0);
MembershipTO membership = newUser.getMembershipMap().get(role.getId());
// Remove the role
userMod = new UserMod();
userMod.getMembershipsToRemove().add(membership.getId()); //this is the key
here.. membership id
userService.update(newUser.getId(), userMod);
// Add the same role back again
userMod = new UserMod();
userMod.getMembershipsToAdd().add(mod1);
userService.update(newUser.getId(), userMod);




On Fri, Mar 20, 2015 at 6:08 AM, Francesco Chicchiriccò <ilgrosso@apache.org
> wrote:

>  On 19/03/2015 22:00, John Ellinwood wrote:
>
>  Sorry, problem including the rest of the log:
>
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unique index
> or primary key violation: "U_MMBRSHP_SYNCOPEUSER_ID_INDEX_C ON
> PUBLIC.MEMBERSHIP(SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (101, 100, 151)";
> SQL statement: INSERT INTO PUBLIC.Membership (ID, CREATIONDATE, CREATOR,
> LASTCHANGEDATE, LASTMODIFIER, SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (?, ?,
> ?, ?, ?, ?, ?) [23505-185] {prepstmnt 1618806582 INSERT INTO
> PUBLIC.Membership (ID, CREATIONDATE, CREATOR, LASTCHANGEDATE, LASTMODIFIER,
> SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (?, ?, ?, ?, ?, ?, ?)} [code=23505,
> state=23505]
>
>  I also can't add or remove roles through the UI now.  I can't delete the
> user either.
>
> On Thu, Mar 19, 2015 at 4:56 PM, John Ellinwood <jo...@gmail.com>
> wrote:
>
>>     I am trying to use the rest api for syncope.  I'm trying this on
>> syncope 1.2.2.  My rest client is Jersey, but this happens just using
>> RestClient from Firefox as well.
>>
>>
>>  I have a user, "user1" id 101.
>>  I have a roles.  "role1" id 100
>>
>>  Request:
>>    POST http://localhost:9080/syncope/rest/users/101
>>    {"id":101,"membershipsToAdd":[{"role":100}]}
>>  Response
>>   200 Succes
>>
>>  Request:
>>   POST http://localhost:9080/syncope/rest/users/101
>>   {"id":101,"membershipsToRemove":[100]}
>>  Response
>>    200 Success
>>
>>  Request:
>>    POST http://localhost:9080/syncope/rest/users/101
>>   {"id":101,"membershipsToAdd":[{"role":100}]}
>> Response
>>    409 Conflict, DataIntegrityViolation. The transaction has been rolled
>> back. See the nested exception for details on the errors that occurred.
>>
>>  Log:
>>  ...Caused by: org.apache.openjpa.lib.jdbc.ReportinSQLException: Unique
>> index or pimary key violation: "U_MMBRSHP_SYNCOPEUSER_ID_INDEX_C ON PUBLIC.
>>
>
> Hi John,
> I've performed the same operations using Syncope client API (which are
> CXF-based) and everything worked flawlessly.
> I assume you are using some 1.2.X release.
>
> Here's the detail:
>
>  1. created an user (id 103) and a role (id 100) via admin console
>
>  2. run the following code snippet in my sample Syncope client application
> [1] (placed it after the "*do* something" comment on App#main)
>
>         MembershipMod membMod = new MembershipMod();
>         membMod.setRole(100);
>
>         UserMod userMod = new UserMod();
>         userMod.setId(103);
>         userMod.getMembershipsToAdd().add(membMod);
>
>         Response response = userService.update(userMod.getId(), userMod);
>         Assert.assertEquals(200, response.getStatus());
>
>         userMod.getMembershipsToAdd().clear();
>         userMod.getMembershipsToRemove().add(100L);
>         response = userService.update(userMod.getId(), userMod);
>         Assert.assertEquals(200, response.getStatus());
>
>         userMod.getMembershipsToRemove().clear();
>         userMod.getMembershipsToAdd().add(membMod);
>         response = userService.update(userMod.getId(), userMod);
>         Assert.assertEquals(200, response.getStatus());
>
> FYI, here's the generated HTTP calls and responses: [2]
>
> HTH
> Regards.
>
> [1] https://github.com/ilgrosso/syncopeRestClient
> [2] https://paste.apache.org/a4iq
>
> --
> Francesco Chicchiriccò
>
> Tirasa - Open Source Excellencehttp://www.tirasa.net/
>
> Involved at The Apache Software Foundation:
> member, Syncope PMC chair, Cocoon PMC, Olingo PMChttp://people.apache.org/~ilgrosso/
>
>

Re: REST fails to add roles after removing them

Posted by Francesco Chicchiriccò <il...@apache.org>.
On 19/03/2015 22:00, John Ellinwood wrote:
> Sorry, problem including the rest of the log:
>
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unique 
> index or primary key violation: "U_MMBRSHP_SYNCOPEUSER_ID_INDEX_C ON 
> PUBLIC.MEMBERSHIP(SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (101, 100, 
> 151)"; SQL statement: INSERT INTO PUBLIC.Membership (ID, CREATIONDATE, 
> CREATOR, LASTCHANGEDATE, LASTMODIFIER, SYNCOPEUSER_ID, SYNCOPEROLE_ID) 
> VALUES (?, ?, ?, ?, ?, ?, ?) [23505-185] {prepstmnt 1618806582 INSERT 
> INTO PUBLIC.Membership (ID, CREATIONDATE, CREATOR, LASTCHANGEDATE, 
> LASTMODIFIER, SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (?, ?, ?, ?, ?, 
> ?, ?)} [code=23505, state=23505]
>
> I also can't add or remove roles through the UI now.  I can't delete 
> the user either.
>
> On Thu, Mar 19, 2015 at 4:56 PM, John Ellinwood 
> <john.ellinwood@gmail.com <ma...@gmail.com>> wrote:
>
>     I am trying to use the rest api for syncope.  I'm trying this on
>     syncope 1.2.2.  My rest client is Jersey, but this happens just
>     using RestClient from Firefox as well.
>
>
>     I have a user, "user1" id 101.
>     I have a roles.  "role1" id 100
>
>     Request:
>       POST http://localhost:9080/syncope/rest/users/101
>       {"id":101,"membershipsToAdd":[{"role":100}]}
>     Response
>       200 Succes
>
>     Request:
>       POST http://localhost:9080/syncope/rest/users/101
>       {"id":101,"membershipsToRemove":[100]}
>     Response
>       200 Success
>
>     Request:
>       POST http://localhost:9080/syncope/rest/users/101
>       {"id":101,"membershipsToAdd":[{"role":100}]}
>     Response
>       409 Conflict, DataIntegrityViolation. The transaction has been
>     rolled back. See the nested exception for details on the errors
>     that occurred.
>
>     Log:
>     ...Caused by: org.apache.openjpa.lib.jdbc.ReportinSQLException:
>     Unique index or pimary key violation:
>     "U_MMBRSHP_SYNCOPEUSER_ID_INDEX_C ON PUBLIC.
>

Hi John,
I've performed the same operations using Syncope client API (which are 
CXF-based) and everything worked flawlessly.
I assume you are using some 1.2.X release.

Here's the detail:

  1. created an user (id 103) and a role (id 100) via admin console

  2. run the following code snippet in my sample Syncope client 
application [1] (placed it after the "*do* something" comment on App#main)

         MembershipMod membMod = new MembershipMod();
         membMod.setRole(100);

         UserMod userMod = new UserMod();
         userMod.setId(103);
         userMod.getMembershipsToAdd().add(membMod);

         Response response = userService.update(userMod.getId(), userMod);
         Assert.assertEquals(200, response.getStatus());

         userMod.getMembershipsToAdd().clear();
         userMod.getMembershipsToRemove().add(100L);
         response = userService.update(userMod.getId(), userMod);
         Assert.assertEquals(200, response.getStatus());

         userMod.getMembershipsToRemove().clear();
         userMod.getMembershipsToAdd().add(membMod);
         response = userService.update(userMod.getId(), userMod);
         Assert.assertEquals(200, response.getStatus());

FYI, here's the generated HTTP calls and responses: [2]

HTH
Regards.

[1] https://github.com/ilgrosso/syncopeRestClient
[2] https://paste.apache.org/a4iq

-- 
Francesco Chicchiriccò

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

Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC
http://people.apache.org/~ilgrosso/


Re: REST fails to add roles after removing them

Posted by John Ellinwood <jo...@gmail.com>.
Sorry, problem including the rest of the log:

Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unique index
or primary key violation: "U_MMBRSHP_SYNCOPEUSER_ID_INDEX_C ON
PUBLIC.MEMBERSHIP(SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (101, 100, 151)";
SQL statement: INSERT INTO PUBLIC.Membership (ID, CREATIONDATE, CREATOR,
LASTCHANGEDATE, LASTMODIFIER, SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (?, ?,
?, ?, ?, ?, ?) [23505-185] {prepstmnt 1618806582 INSERT INTO
PUBLIC.Membership (ID, CREATIONDATE, CREATOR, LASTCHANGEDATE, LASTMODIFIER,
SYNCOPEUSER_ID, SYNCOPEROLE_ID) VALUES (?, ?, ?, ?, ?, ?, ?)} [code=23505,
state=23505]

I also can't add or remove roles through the UI now.  I can't delete the
user either.

On Thu, Mar 19, 2015 at 4:56 PM, John Ellinwood <jo...@gmail.com>
wrote:

> I am trying to use the rest api for syncope.  I'm trying this on syncope
> 1.2.2.  My rest client is Jersey, but this happens just using RestClient
> from Firefox as well.
>
>
> I have a user, "user1" id 101.
> I have a roles.  "role1" id 100
>
> Request:
>   POST http://localhost:9080/syncope/rest/users/101
>   {"id":101,"membershipsToAdd":[{"role":100}]}
> Response
>   200 Succes
>
> Request:
>   POST http://localhost:9080/syncope/rest/users/101
>   {"id":101,"membershipsToRemove":[100]}
> Response
>   200 Success
>
> Request:
>   POST http://localhost:9080/syncope/rest/users/101
>   {"id":101,"membershipsToAdd":[{"role":100}]}
> Response
>   409 Conflict, DataIntegrityViolation. The transaction has been rolled
> back. See the nested exception for details on the errors that occurred.
>
> Log:
> ...Caused by: org.apache.openjpa.lib.jdbc.ReportinSQLException: Unique
> index or pimary key violation: "U_MMBRSHP_SYNCOPEUSER_ID_INDEX_C ON PUBLIC.
>
>
>