Re: Any tutorials?

2017-08-18 Thread Sergio Muriel 
Hi again Francesco,

I take back part of what I said on the second point. The dependency addition 
actually works and downloads the drivers, but I did it on enduser/pom.xml 
instead of core/pom.xml because the Getting Started page [1] suggests to run it 
from there:


" .. then, from the enduser subdirectory, execute:
mvn -P embedded,all"


Is it okay?


[1] https://syncope.apache.org/docs/getting-started.html




From: Sergio Muriel 
Sent: Friday, August 18, 2017 3:06 PM
To: user@syncope.apache.org
Subject: Re: Any tutorials?


Hi Francesco,

First point about AnyTypeClasses worked flawlessly. (Although I'm still trying 
to figure out why I cannot reuse those schemata pre-loaded there).

Second point about dependency still throws same error: 
"InvalidExternalResource. JDBC Driver is not found on classpath." This is what 
I added (right before the first  occurrence in core/pom.xml):


   


  mysql
  mysql-connector-java
  5.1.42


  com.microsoft.sqlserver
  sqljdbc4
  4.0

  


Since I'm trying to connect to sqlserver as well.
Suggestions will be greatly appreciated.

Thank you!

Best Regards,
Sergio

From: Francesco Chicchiriccò 
Sent: Friday, August 18, 2017 1:32 AM
To: user@syncope.apache.org
Subject: Re: Any tutorials?

Hi Sergio,
see my replies embedded below.

Regards.

On 17/08/2017 23:28, Sergio Muriel wrote:

Thank you Francesco.


I'm trying to accomplish what you say, however I'm having two issues at the 
moment:


  1.  I log in to syncope-console/ as admin, click on Types -> AnyTypeClasses 
-> New AnyTypeClass but I find no schema to add because all lists are empty.

Of course, you need first to create new schemas that are not assigned yet to 
any AnyTypeClass.


  1.  I was able to create a connector in Topology -> connid -> Add New 
Connector, but when I try to create a resource for that connector it shows this 
error message: InvalidExternalResource. JDBC Driver is not found on classpath.

This happens because you are likely attempting to create a DBTable or 
ScriptedSQL connector for a DBMS (MySQL / MariaDB? PostgreSQL? other?), for 
which you'll need to include the related JDBC driver.

Since it seems you're running the Maven project, just add the related 
dependency to core/pom.xml (right before the first  occurrence):


  mysql
  mysql-connector-java
  5.1.42


for MySQL, or


  org.mariadb.jdbc
  mariadb-java-client
  1.6.1


for MariaDB, and so on.


I created my project with maven archetype and run it with

mvn -P embedded,all


Any clue of what I'm doing wrong here?

Your help is very appreciated.


Sergio


From: Francesco Chicchiriccò 
Sent: Friday, August 11, 2017 5:14 AM
To: user@syncope.apache.org
Subject: Re: Any tutorials?

On 10/08/2017 19:16, Sergio Muriel wrote:

Hi,

does anyone know about any easy to follow Syncope tutorials or documentation?

I have been reading the reference 
guide but I find it hard 
to follow.


This is what I need to do: Synchronize db2db fields, web service to web service 
and database fields to web service and vice versa.

Hi Sergio, and welcome to Apache Syncope!

We don't have much "from 0 to ready" tutorials out there; you might want to 
read this post by Colm about pulling users from LDAP:

http://coheigea.blogspot.it/2016/08/pulling-users-and-groups-from-ldap-into.html

Also, someone started a primer a while ago

https://cwiki.apache.org/confluence/display/SYNCOPE/Apache+Syncope+2.0+Primer

but it's in the very early stages.

At a high level, for your own use case you'll need to:

1. define all the plain schemas you want to model for the Internal Storage
2. create one or more Connectors
3. for each Connector, create one or more External Resource where you define 
the mapping between Internal Storage's schemas and External Resource's 
attributes
4. for each Resource you want to pull users from, create a Pull Task

I'd suggest to start with one Connector / Resource (maybe for the DB you want 
to pull users from) and then proceed incrementally.

If the users you want to pull from the external DB fit in a single table, you 
can use the DBTable connector, otherwise you'll need the ScriptedSQL, which 
also requires to code / adjust some Groovy scripts to work.

Maybe it's also an idea for you to start with the Standalone Distribution, 
which is full of test data, and look at how things are configured there.

HTH
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: Any tutorials?

2017-08-18 Thread Sergio Muriel 
Hi Francesco,

First point about AnyTypeClasses worked flawlessly. (Although I'm still trying 
to figure out why I cannot reuse those schemata pre-loaded there).

Second point about dependency still throws same error: 
"InvalidExternalResource. JDBC Driver is not found on classpath." This is what 
I added (right before the first  occurrence in core/pom.xml):


   


  mysql
  mysql-connector-java
  5.1.42


  com.microsoft.sqlserver
  sqljdbc4
  4.0

  


Since I'm trying to connect to sqlserver as well.
Suggestions will be greatly appreciated.

Thank you!

Best Regards,
Sergio

From: Francesco Chicchiriccò 
Sent: Friday, August 18, 2017 1:32 AM
To: user@syncope.apache.org
Subject: Re: Any tutorials?

Hi Sergio,
see my replies embedded below.

Regards.

On 17/08/2017 23:28, Sergio Muriel wrote:

Thank you Francesco.


I'm trying to accomplish what you say, however I'm having two issues at the 
moment:


  1.  I log in to syncope-console/ as admin, click on Types -> AnyTypeClasses 
-> New AnyTypeClass but I find no schema to add because all lists are empty.

Of course, you need first to create new schemas that are not assigned yet to 
any AnyTypeClass.


  1.  I was able to create a connector in Topology -> connid -> Add New 
Connector, but when I try to create a resource for that connector it shows this 
error message: InvalidExternalResource. JDBC Driver is not found on classpath.

This happens because you are likely attempting to create a DBTable or 
ScriptedSQL connector for a DBMS (MySQL / MariaDB? PostgreSQL? other?), for 
which you'll need to include the related JDBC driver.

Since it seems you're running the Maven project, just add the related 
dependency to core/pom.xml (right before the first  occurrence):


  mysql
  mysql-connector-java
  5.1.42


for MySQL, or


  org.mariadb.jdbc
  mariadb-java-client
  1.6.1


for MariaDB, and so on.


I created my project with maven archetype and run it with

mvn -P embedded,all


Any clue of what I'm doing wrong here?

Your help is very appreciated.


Sergio


From: Francesco Chicchiriccò 
Sent: Friday, August 11, 2017 5:14 AM
To: user@syncope.apache.org
Subject: Re: Any tutorials?

On 10/08/2017 19:16, Sergio Muriel wrote:

Hi,

does anyone know about any easy to follow Syncope tutorials or documentation?

I have been reading the reference 
guide but I find it hard 
to follow.


This is what I need to do: Synchronize db2db fields, web service to web service 
and database fields to web service and vice versa.

Hi Sergio, and welcome to Apache Syncope!

We don't have much "from 0 to ready" tutorials out there; you might want to 
read this post by Colm about pulling users from LDAP:

http://coheigea.blogspot.it/2016/08/pulling-users-and-groups-from-ldap-into.html

Also, someone started a primer a while ago

https://cwiki.apache.org/confluence/display/SYNCOPE/Apache+Syncope+2.0+Primer

but it's in the very early stages.

At a high level, for your own use case you'll need to:

1. define all the plain schemas you want to model for the Internal Storage
2. create one or more Connectors
3. for each Connector, create one or more External Resource where you define 
the mapping between Internal Storage's schemas and External Resource's 
attributes
4. for each Resource you want to pull users from, create a Pull Task

I'd suggest to start with one Connector / Resource (maybe for the DB you want 
to pull users from) and then proceed incrementally.

If the users you want to pull from the external DB fit in a single table, you 
can use the DBTable connector, otherwise you'll need the ScriptedSQL, which 
also requires to code / adjust some Groovy scripts to work.

Maybe it's also an idea for you to start with the Standalone Distribution, 
which is full of test data, and look at how things are configured there.

HTH
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: Any tutorials?

2017-08-18 Thread Francesco Chicchiriccò 

Hi Sergio,
see my replies embedded below.

Regards.

On 17/08/2017 23:28, Sergio Muriel wrote:


Thank you Francesco.


I'm trying to accomplish what you say, however I'm having two issues 
at the moment:



 1. I log in to syncope-console/ as admin, click on Types ->
AnyTypeClasses -> New AnyTypeClass but I find no schema to add
because all lists are empty.



Of course, you need first to create new schemas that are not assigned 
yet to any AnyTypeClass.



 1. I was able to create a connector in Topology -> connid -> Add New
Connector, but when I try to create a resource for that connector
it shows this error message: InvalidExternalResource. JDBC Driver
is not found on classpath.



This happens because you are likely attempting to create a DBTable or 
ScriptedSQL connector for a DBMS (MySQL / MariaDB? PostgreSQL? other?), 
for which you'll need to include the related JDBC driver.


Since it seems you're running the Maven project, just add the related 
dependency to core/pom.xml (right before the first  
occurrence):



  mysql
  mysql-connector-java
  5.1.42


for MySQL, or


  org.mariadb.jdbc
  mariadb-java-client
  1.6.1


for MariaDB, and so on.


I created my project with maven archetype and run it with

mvn -P embedded,all


Any clue of what I'm doing wrong here?

Your help is very appreciated.


Sergio


*From:* Francesco Chicchiriccò 
*Sent:* Friday, August 11, 2017 5:14 AM
*To:* user@syncope.apache.org
*Subject:* Re: Any tutorials?
On 10/08/2017 19:16, Sergio Muriel wrote:


Hi,

does anyone know about any easy to follow Syncope tutorials or 
documentation?


I have been reading the reference guide 
 but I find it 
hard to follow.



This is what I need to do: Synchronize db2db fields, web service to 
web service and database fields to web service and vice versa.




Hi Sergio, and welcome to Apache Syncope!

We don't have much "from 0 to ready" tutorials out there; you might 
want to read this post by Colm about pulling users from LDAP:


http://coheigea.blogspot.it/2016/08/pulling-users-and-groups-from-ldap-into.html

Also, someone started a primer a while ago

https://cwiki.apache.org/confluence/display/SYNCOPE/Apache+Syncope+2.0+Primer

but it's in the very early stages.

At a high level, for your own use case you'll need to:

1. define all the plain schemas you want to model for the Internal Storage
2. create one or more Connectors
3. for each Connector, create one or more External Resource where you 
define the mapping between Internal Storage's schemas and External 
Resource's attributes

4. for each Resource you want to pull users from, create a Pull Task

I'd suggest to start with one Connector / Resource (maybe for the DB 
you want to pull users from) and then proceed incrementally.


If the users you want to pull from the external DB fit in a single 
table, you can use the DBTable connector, otherwise you'll need the 
ScriptedSQL, which also requires to code / adjust some Groovy scripts 
to work.


Maybe it's also an idea for you to start with the Standalone 
Distribution, which is full of test data, and look at how things are 
configured there.


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