Groups memberships

[Filipe Silva]

Hi

In 
https://syncope.apache.org/docs/reference-guide.html#users-groups-and-any-objects 
we read:


"A User or an Any Object can be members of Groups in the same realm or 
in one of the sub-realms."


But it appear that a user in a realm B in defined as /A/B only "sees" 
the groups in / , A and B and not a group in C defined as a sub-realm of 
B (as in /A/B/C).


Am I understanding this correctly?



Thanks
FS

Re: Scripted SQL Pull Task Error

[Sergio Muriel]

Hi Matteo,

I replaced "username:it.eid" with "username:it.EID" but no luck, still same 
result, same exceptions.


I'm getting this on core-connid.log:



11:05:59.298 DEBUG Enter: {Uid=Attribute: {Name=__UID__, 
Value=[abcdefgh-04a9-4181-9d4d-e3a812345678]}, ObjectClass=ObjectClass: 
__ACCOUNT__, Attributes=[Attribute: {Name=__NAME__, 
Value=[abcdefgh-04a9-4181-9d4d-e3a812345678]}, Attribute: {Name=__UID__, 
Value=[ffe5c419-04a9-4181-9d4d-e3a8a09a8305]}, Attribute: {Name=email, 
Value=[validem...@yahoo.com]}], Name=Attribute: {Name=__NAME__, 
Value=[ffe5c419-04a9-4181-9d4d-e3a8a09a8305]}} Method: handle
11:05:59.346 DEBUG Return: true Method: handle
.

11:08:56.979 DEBUG 
d:\\syncope-standalone-2.0.4\\project\\myproject\\core\\src\\test\\resources\\scriptedsql\\SakaiUserSearchScript.groovy
 is readable Method: checkFileIsReadable
11:08:56.979 INFO  Checking Sync Script filename Method: validate
11:08:56.980 DEBUG 
d:\\syncope-standalone-2.0.4\\project\\myproject\\core\\src\\test\\resources\\scriptedsql\\SakaiUserSyncScript.groovy
 is readable Method: checkFileIsReadable
11:08:56.980 INFO  Checking Test Script filename Method: validate



Is there anything else you want to see from scripts?

Where can I find it?


Thank you


Best Regards,
Sergio Muriel



From: Matteo Alessandroni 
Sent: Monday, September 18, 2017 2:25 AM
To: user@syncope.apache.org
Subject: Re: Scripted SQL Pull Task Error

Hi Sergio,

have you already tried to replace "username:it.eid" with "username:it.EID"?
The problem is that I'd need to see some logs from your groovy script to be 
sure that all username EID values are not empty.

Regards,
Matteo


On 15/09/2017 18:29, Sergio Muriel wrote:

Hi Matteo,

Sure!


SELECT * FROM sakai_user u, sakai_user_id_map m WHERE u.USER_ID = m.USER_ID


"USER_ID"; "EMAIL"; "EMAIL_LC"; "FIRST_NAME";"LAST_NAME";"TYPE"; "PW"; 
"CREATEDBY"; "MODIFIEDBY"; "CREATEDON"; "MODIFIEDON"; "USER_ID"; "EID"
"-62e7-425e-be28-12345678abcd"; 
"sampl...@abc.com"; 
"sampl...@abc.com"; "Vi"; "Du"; "guest"; 
"pRCclQ==:KzTo0T9rfw45tgrsegfdCh/x3QJu/kragzJi4a8tCNk="; "admin"; "admin"; 
"2016-08-08 14:04:53"; "2017-07-29 03:46:08"; 
"-62e7-425e-be28-12345678abcd"; "987854"
"-54ae-418e-95ce-12345678abcd"; 
"sampl...@abc.com"; 
"sampl...@abc.com"; "Bar"; "Than"; "guest"; 
"pfAqaw==:wx5Wc/M5msdfgdffsdffgf+mGPSSiFzs/omJF+wIFYU="; "admin"; "admin"; 
"2015-02-17 15:54:17"; "2017-07-29 03:44:55"; 
"-54ae-418e-95ce-12345678abcd"; "987655"
"-20e7-4905-b044-12345678abcd"; 
"sampl...@abc.com"; 
"sampl...@abc.com"; "Joseph"; "Donovan"; "guest"; 
"psLZjA==:pNYul7adfadfadfasdfadssaPEIPTzrFLPdxC346gro="; 
"-f21d-4179-85e5-12345678abcd"; "-20e7-4905-b044-12345678abcd"; 
"2013-04-01 14:05:11"; "2013-04-02 14:47:23"; 
"-20e7-4905-b044-12345678abcd"; "987656"
"-9e65-41ce-a434-12345678abcd"; 
"sampl...@abc.com"; 
"sampl...@abc.com"; "Habibah"; "Assisi"; "guest"; 
"AvC7MQ==:2WCl8JQTasdfafeg452fgsgr45gsfsdg+XOMOUCLcfQ="; 
"-f21d-4179-85e5-12345678abcd"; "-f21d-4179-85e5-12345678abcd"; 
"2013-08-26 19:42:24"; "2013-08-26 19:42:24"; 
"-9e65-41ce-a434-12345678abcd"; "987657"
"-f75c-42df-beaf-12345678abcd"; 
"sampl...@abc.com"; 
"sampl...@abc.com"; "Keith"; "Roberts"; "guest"; 
"k/R8Mg==:vyM1Adfgsdfgsdget4563457tryeetyr1xSAHJXcqWk="; 
"-f21d-4179-85e5-12345678abcd"; "-fe13-4bcc-84a7-12345678abcd"; 
"2015-03-30 22:34:04"; "2017-05-06 13:09:25"; 
"-f75c-42df-beaf-12345678abcd"; "987658"


...

/* Affected rows: 0  Found rows: 5,103  Warnings: 0  Duration for 1 query: 
0.000 sec. (+ 0.125 sec. network) */


Yes, my MySQL is case insensitive.
SELECT *,m.EID FROM .
and
SELECT *,m.eid FROM .
both work the same.

Best Regards,
Sergio Muriel



From: Matteo Alessandroni 

Sent: Friday, September 15, 2017 10:45 AM
To: user@syncope.apache.org
Subject: Re: Scripted SQL Pull Task Error

Hi Sergio,

could you please add a little piece of the result of your query:

SELECT * FROM sakai_user u, sakai_user_id_map m WHERE u.USER_ID = m.USER_ID ...

from your "SakaiUserSearchScript.groovy" script?
Also please check that your mysql is case insensitive, otherwise ensure that 
"it.eid" values are always set.

Regards,
Matteo



On 15/09/2017 17:17, Sergio Muriel wrote:

Hi Matteo,

please find the scripts attached to this email.

Thank you again!


Best Regards,
Sergio Muriel



From: Matteo Alessandroni