You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@syncope.apache.org by Tech <te...@psynd.net> on 2017/04/26 21:10:05 UTC
Urgent: updated pull using dbscript
Hello,
we are using the dbscripts to pull information from a database, but we
detected that if any change occurs, for example an email address has
been modified, the pull task is no able to detect the change and to
re-update the new value into Syncope.
Is there any parameter somewhere that should be configure to have this done?
Thanks
Re: Urgent: updated pull using dbscript
Posted by Marco Di Sabatino Di Diodoro <ma...@tirasa.net>.
Il 28/04/2017 11:55, Tech ha scritto:
>
> Hello,
>
> to update and to create users from the DB to Syncope we use the same
> script, the Search one.
>
> We know that the script is working because we are able to create new
> users.
>
> The database is returning an email address and the email field is
> provided by the DB and correctly displayed at creation time on Syncope.
>
> The Pull task configuration is configured as matching rule to update,
> and we allowed creation and update operations.
>
>
> We detected the problem, the only key that is accepted is the
> username, any other field used as key looks not working.
>
So, you are saying that you change the key from username to email (in
the search groovy script and in the mapping) and during then pull task
users are not updated.
Can you send your search script and mapping configuration?
Regards
M
>
> Is there any way to match anything else as username?
>
> Thanks
>
>
>
>
>
> On 27/04/17 09:24, Marco Di Sabatino Di Diodoro wrote:
>>
>>
>>
>> Il 27/04/2017 09:14, Tech ha scritto:
>>> Full
>>>
>> Is your groovy search script correct? Does the script return the
>> email address? Is the email field present in the resource mapping?
>> In the pull task configuration, do you allow create and update
>> operation? Do you set "Matching Rule" to "Update"?
>>
>> During your pull task try to look the core-connid.log and check
>> what's happening.
>>
>> Regards
>> Marco
>>
>>>
>>>
>>> On 27/04/17 09:09, Marco Di Sabatino Di Diodoro wrote:
>>>>
>>>>
>>>>
>>>> Il 26/04/2017 23:10, Tech ha scritto:
>>>>>
>>>>> Hello,
>>>>>
>>>>> we are using the dbscripts to pull information from a database,
>>>>> but we detected that if any change occurs, for example an email
>>>>> address has been modified, the pull task is no able to detect the
>>>>> change and to re-update the new value into Syncope.
>>>>>
>>>>> Is there any parameter somewhere that should be configure to have
>>>>> this done?
>>>>>
>>>> Which kind of pull are you doing? Full or incremental?
>>>>
>>>> Regards
>>>> M
>>>>>
>>>>> Thanks
>>>>>
>>>>
>>>> --
>>>> Dott. Marco Di Sabatino Di Diodoro
>>>> Tel. +39 3939065570
>>>>
>>>> Tirasa S.r.l.
>>>> Viale D'Annunzio 267 - 65127 Pescara
>>>> Tel +39 0859116307 / FAX +39 0859111173
>>>> http://www.tirasa.net
>>>>
>>>> Apache Syncope PMC Member
>>>> http://people.apache.org/~mdisabatino/
>>>
>>
>> --
>> Dott. Marco Di Sabatino Di Diodoro
>> Tel. +39 3939065570
>>
>> Tirasa S.r.l.
>> Viale D'Annunzio 267 - 65127 Pescara
>> Tel +39 0859116307 / FAX +39 0859111173
>> http://www.tirasa.net
>>
>> Apache Syncope PMC Member
>> http://people.apache.org/~mdisabatino/
>
--
Dott. Marco Di Sabatino Di Diodoro
Tel. +39 3939065570
Tirasa S.r.l.
Viale D'Annunzio 267 - 65127 Pescara
Tel +39 0859116307 / FAX +39 0859111173
http://www.tirasa.net
Apache Syncope PMC Member
http://people.apache.org/~mdisabatino/
Re: Urgent: updated pull using dbscript
Posted by Tech <te...@psynd.net>.
Hello,
to update and to create users from the DB to Syncope we use the same
script, the Search one.
We know that the script is working because we are able to create new users.
The database is returning an email address and the email field is
provided by the DB and correctly displayed at creation time on Syncope.
The Pull task configuration is configured as matching rule to update,
and we allowed creation and update operations.
We detected the problem, the only key that is accepted is the username,
any other field used as key looks not working.
Is there any way to match anything else as username?
Thanks
On 27/04/17 09:24, Marco Di Sabatino Di Diodoro wrote:
>
>
>
> Il 27/04/2017 09:14, Tech ha scritto:
>> Full
>>
> Is your groovy search script correct? Does the script return the email
> address? Is the email field present in the resource mapping?
> In the pull task configuration, do you allow create and update
> operation? Do you set "Matching Rule" to "Update"?
>
> During your pull task try to look the core-connid.log and check what's
> happening.
>
> Regards
> Marco
>
>>
>>
>> On 27/04/17 09:09, Marco Di Sabatino Di Diodoro wrote:
>>>
>>>
>>>
>>> Il 26/04/2017 23:10, Tech ha scritto:
>>>>
>>>> Hello,
>>>>
>>>> we are using the dbscripts to pull information from a database, but
>>>> we detected that if any change occurs, for example an email address
>>>> has been modified, the pull task is no able to detect the change
>>>> and to re-update the new value into Syncope.
>>>>
>>>> Is there any parameter somewhere that should be configure to have
>>>> this done?
>>>>
>>> Which kind of pull are you doing? Full or incremental?
>>>
>>> Regards
>>> M
>>>>
>>>> Thanks
>>>>
>>>
>>> --
>>> Dott. Marco Di Sabatino Di Diodoro
>>> Tel. +39 3939065570
>>>
>>> Tirasa S.r.l.
>>> Viale D'Annunzio 267 - 65127 Pescara
>>> Tel +39 0859116307 / FAX +39 0859111173
>>> http://www.tirasa.net
>>>
>>> Apache Syncope PMC Member
>>> http://people.apache.org/~mdisabatino/
>>
>
> --
> Dott. Marco Di Sabatino Di Diodoro
> Tel. +39 3939065570
>
> Tirasa S.r.l.
> Viale D'Annunzio 267 - 65127 Pescara
> Tel +39 0859116307 / FAX +39 0859111173
> http://www.tirasa.net
>
> Apache Syncope PMC Member
> http://people.apache.org/~mdisabatino/
Re: Urgent: updated pull using dbscript
Posted by Marco Di Sabatino Di Diodoro <ma...@tirasa.net>.
Il 27/04/2017 09:14, Tech ha scritto:
> Full
>
Is your groovy search script correct? Does the script return the email
address? Is the email field present in the resource mapping?
In the pull task configuration, do you allow create and update
operation? Do you set "Matching Rule" to "Update"?
During your pull task try to look the core-connid.log and check what's
happening.
Regards
Marco
>
>
> On 27/04/17 09:09, Marco Di Sabatino Di Diodoro wrote:
>>
>>
>>
>> Il 26/04/2017 23:10, Tech ha scritto:
>>>
>>> Hello,
>>>
>>> we are using the dbscripts to pull information from a database, but
>>> we detected that if any change occurs, for example an email address
>>> has been modified, the pull task is no able to detect the change and
>>> to re-update the new value into Syncope.
>>>
>>> Is there any parameter somewhere that should be configure to have
>>> this done?
>>>
>> Which kind of pull are you doing? Full or incremental?
>>
>> Regards
>> M
>>>
>>> Thanks
>>>
>>
>> --
>> Dott. Marco Di Sabatino Di Diodoro
>> Tel. +39 3939065570
>>
>> Tirasa S.r.l.
>> Viale D'Annunzio 267 - 65127 Pescara
>> Tel +39 0859116307 / FAX +39 0859111173
>> http://www.tirasa.net
>>
>> Apache Syncope PMC Member
>> http://people.apache.org/~mdisabatino/
>
--
Dott. Marco Di Sabatino Di Diodoro
Tel. +39 3939065570
Tirasa S.r.l.
Viale D'Annunzio 267 - 65127 Pescara
Tel +39 0859116307 / FAX +39 0859111173
http://www.tirasa.net
Apache Syncope PMC Member
http://people.apache.org/~mdisabatino/
Re: Urgent: updated pull using dbscript
Posted by Tech <te...@psynd.net>.
Full
On 27/04/17 09:09, Marco Di Sabatino Di Diodoro wrote:
>
>
>
> Il 26/04/2017 23:10, Tech ha scritto:
>>
>> Hello,
>>
>> we are using the dbscripts to pull information from a database, but
>> we detected that if any change occurs, for example an email address
>> has been modified, the pull task is no able to detect the change and
>> to re-update the new value into Syncope.
>>
>> Is there any parameter somewhere that should be configure to have
>> this done?
>>
> Which kind of pull are you doing? Full or incremental?
>
> Regards
> M
>>
>> Thanks
>>
>
> --
> Dott. Marco Di Sabatino Di Diodoro
> Tel. +39 3939065570
>
> Tirasa S.r.l.
> Viale D'Annunzio 267 - 65127 Pescara
> Tel +39 0859116307 / FAX +39 0859111173
> http://www.tirasa.net
>
> Apache Syncope PMC Member
> http://people.apache.org/~mdisabatino/
Re: Urgent: updated pull using dbscript
Posted by Marco Di Sabatino Di Diodoro <ma...@tirasa.net>.
Il 26/04/2017 23:10, Tech ha scritto:
>
> Hello,
>
> we are using the dbscripts to pull information from a database, but we
> detected that if any change occurs, for example an email address has
> been modified, the pull task is no able to detect the change and to
> re-update the new value into Syncope.
>
> Is there any parameter somewhere that should be configure to have this
> done?
>
Which kind of pull are you doing? Full or incremental?
Regards
M
>
> Thanks
>
--
Dott. Marco Di Sabatino Di Diodoro
Tel. +39 3939065570
Tirasa S.r.l.
Viale D'Annunzio 267 - 65127 Pescara
Tel +39 0859116307 / FAX +39 0859111173
http://www.tirasa.net
Apache Syncope PMC Member
http://people.apache.org/~mdisabatino/