Re: Adding new fields over a MariaDB

2017-04-27 Thread Francesco Chicchiriccò 

On 26/04/2017 19:16, Tech wrote:


Hello,

using the Syncope 203, when we try to add a new type, we get this 
error at the moment of saving the change.


Here we just try to add an additional email with an EmailValidator, 
but this happen with any new field that we try to add.


Regars

[...]
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: 
(conn:34) Incorrect arguments to mysqld_stmt_execute
Query is: INSERT INTO PlainSchema (id, cipherAlgorithm, 
conversionPattern, enumerationKeys, enumerationValues, 
mandatoryCondition, mimeType, multivalue, readonly, secretKey, type, 
uniqueConstraint, validatorClass, ANYTYPECLASS_ID) VALUES (?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?), parameters 
['psy_p_emailWork',,,,,'false',,0,0,,'String',0,'org.apache.syncope.core.persistence.jpa.attrvalue.validation.EmailAddressValidator',] 
{prepstmnt 894668994 INSERT INTO PlainSchema (id, cipherAlgorithm, 
conversionPattern, enumerationKeys, enumerationValues, 
mandatoryCondition, mimeType, multivalue, readonly, secretKey, type, 
uniqueConstraint, validatorClass, ANYTYPECLASS_ID) VALUES (?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1210, state=HY000]




Just google a bit and you will find that such error is often caused by 
some versions of the MySQL JDBC driver (I assume that is applicable to 
MariaDB) as well.


More generally, I do believe that most of the troubles you are 
experiencing lately are due to bad MySQL / MariaDB versions, tuning and 
configuration, as your errors are hardly reproducible with recent 
versions of MySQL, MariaDB or their respective JDBC drivers.


Regards.

--
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: Urgent: updated pull using dbscript

2017-04-27 Thread Marco Di Sabatino Di Diodoro 



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 085973
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 085973
http://www.tirasa.net

Apache Syncope PMC Member
http://people.apache.org/~mdisabatino/

Re: Urgent: updated pull using dbscript

2017-04-27 Thread 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 085973
http://www.tirasa.net

Apache Syncope PMC Member
http://people.apache.org/~mdisabatino/

Re: Urgent: updated pull using dbscript

2017-04-27 Thread Marco Di Sabatino Di Diodoro 



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 085973
http://www.tirasa.net

Apache Syncope PMC Member
http://people.apache.org/~mdisabatino/