Urgent: updated pull using dbscript

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Urgent: updated pull using dbscript

Tech

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

Reply | Threaded
Open this post in threaded view
|

Re: Urgent: updated pull using dbscript

mdisabatino



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/
Reply | Threaded
Open this post in threaded view
|

Re: Urgent: updated pull using dbscript

Tech
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/

Reply | Threaded
Open this post in threaded view
|

Re: Urgent: updated pull using dbscript

mdisabatino



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/
Reply | Threaded
Open this post in threaded view
|

Re: Urgent: updated pull using dbscript

Tech

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/

Reply | Threaded
Open this post in threaded view
|

Re: Urgent: updated pull using dbscript

mdisabatino



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/