Hi Sergio, about some points below: > First point about AnyTypeClasses worked flawlessly. (Although I'm still trying > to figure out why I cannot reuse those schemata pre-loaded there).
The pre-loaded Schemas are already assigned to some AnyTypeClass - and each Schema might be assigned to an AnyTypeClass instance at most. > 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" Logically, the MySQL JDBC driver is used by the Core, not by the Enduser UI, so the correct procedure is to add the dependency to core/pom.xml, rebuild everything from the root directory via "mvn clean install" or "mvn -Pall clean install", then move back to the enduser subdirectory and start as reported by the Getting Started guide. Regards. On 19-ago-17, at 2:37, Sergio Muriel <[email protected]> wrote: > 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 <[email protected]> > Sent: Friday, August 18, 2017 3:06 PM > To: [email protected] > 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 </dependencies> occurrence in core/pom.xml ) : > .... > <dependency> > <groupId>mysql</groupId> > <artifactId>mysql-connector-java</artifactId> > <version>5.1.42</version> > </dependency> > <dependency> > <groupId>com.microsoft.sqlserver</groupId> > <artifactId>sqljdbc4</artifactId> > <version>4.0</version> > </dependency> > </dependencies> > Since I'm trying to connect to sqlserver as well. > Suggestions will be greatly appreciated. > Thank you! > Best Regards, > Sergio > From: Francesco Chicchiriccò <[email protected]> > Sent: Friday, August 18, 2017 1:32 AM > To: [email protected] > 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 </dependencies> occurrence): > <dependency> > <groupId>mysql</groupId> > <artifactId>mysql-connector-java</artifactId> > <version>5.1.42</version> > </dependency> > for MySQL, or > <dependency> > <groupId>org.mariadb.jdbc</groupId> > <artifactId>mariadb-java-client</artifactId> > <version>1.6.1</version> > </dependency> > 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ò <[email protected]> >> Sent: Friday, August 11, 2017 5:14 AM >> To: [email protected] >> 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/
