On 2017-08-20 01:20 Sergio Muriel wrote:
Although I can see now the drivers in:
core/target/syncope/WEB-INF/lib/mssql-jdbc-6.1.0.jre8.jar
core/target/syncope/WEB-INF/lib/mysql-connector-java-5.1.42.jar
I still get the same error "InvalidExternalResource [JDBC Driver is not
found on classpath.]" when I try to create a new resource.
I did as you suggest:
* Added the dependency to core/pom.xml
* Rebuilt everything from the root directory via "mvn -Pall clean
install".
* Ran it from enduser via "mvn -P embedded,all"
I don't know what is wrong.
Which value did you provide for the "JDBC Driver" property? Are you
attempting to configure the DBTable Connector Bundle?
https://connid.atlassian.net/wiki/spaces/BASE/pages/360497/Database+Table#DatabaseTable-ConfigurationProperties
Regards.
FROM: Francesco Chicchiriccò <ilgro...@apache.org>
SENT: Saturday, August 19, 2017 7:39 AM
TO: user@syncope.apache.org
SUBJECT: Re: Any tutorials?
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 <sergio...@hotmail.com> 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
Apache Syncope 2.0.4 - Getting Started
syncope.apache.org
Apache Syncope is an Open Source system for managing digital identities
in enterprise environments, implemented in Java EE technology and
released under the Apache 2 ...
From: Sergio Muriel <sergio...@hotmail.com>
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 </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ò <ilgro...@apache.org>
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 </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ò <ilgro...@apache.org>
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
Pulling users and groups from LDAP into Apache Syncope 2.0.0
coheigea.blogspot.it
A previous tutorial showed how to synchronize (pull) users and roles
into Apache Syncope 1.2.x from an LDAP backend (Apache Directory).
Int...
Also, someone started a primer a while ago
https://cwiki.apache.org/confluence/display/SYNCOPE/Apache+Syncope+2.0+Primer
Apache Syncope 2.0 Primer - Apache Software Foundation
cwiki.apache.org
Often, when Apache Syncope is used to store user data, it becomes
important to customize the fields that can be added to user. For
example, if we needed to include an ...
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/
