Re: Any tutorials?

[Sergio Muriel]

> Looks like you need a PostgreSQL database instance to connect to

Yep. I followed instructions and configured it with MySQL. I thought it was 
able to run with H2 in persistent mode, but apparently not.


> I'd say that the DEB packages would have been much more easy for you to set 
> up, at this point.
It might have been but I'm not on Deb distributions.


Anyways most important thing is that got a clean exception-free startup. :-)

Big thanks  for you!


Best Regards,
Sergio Muriel

From: Francesco Chicchiriccò <ilgro...@apache.org>
Sent: Tuesday, August 29, 2017 11:50 PM
To: user@syncope.apache.org
Subject: Re: Any tutorials?

On 29/08/2017 22:26, Sergio Muriel wrote:

Aha! I was having this exception:
Could not load JDBC driver class [org.postgresql.Driver]

Then I solved it with:
CATALINA_HOME/lib/postgresql-42.1.4.jar

Of course...

I restarted Tomcat but ran into this new exception:

org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check 
that the hostname and port are correct and that the postmaster is accepting 
TCP/IP connections.
[...]

Looks like I need to configure something else somewhere.

Looks like you need a PostgreSQL database instance to connect to:

1. install PostgreSQL (if you haven't done that so far)
2. create a database named 'syncope', owned by a user 'syncope' with password 
'syncope', as explained in

https://syncope.apache.org/docs/reference-guide.html#postgresql


I'd say that the DEB packages would have been much more easy for you to set up, 
at this point.

Hope this finally solves.
Regards.


From: ilgrosso <ilgro...@apache.org><mailto:ilgro...@apache.org>
Sent: Tuesday, August 29, 2017 2:52 AM
To: user@syncope.apache.org<mailto:user@syncope.apache.org>
Subject: Re: Any tutorials?


>From my project root I ran:

mvn clean verify -Dconf.directory=/opt/syncope/conf
-Dbundles.directory=/opt/syncope/bundles -Dlog.directory=/opt/syncope/log

Then I copied the respective *.properties into /opt/syncope/conf
and the respective *.war into Tomcat (CATALINA_HOME/webapps)

Tried with both 8080 and 9080 on these files:

CATALINA_HOME\conf\server.xml (

Ok, please move step by step.

First, since you have 9080 configured on $CATALINA_HOME/conf/server.xml (but
why?), then it's ok to have that port also on

/opt/syncope/conf/console.properties
/opt/syncope/conf/enduser.properties

Now:

1. shut down Tomcat
2. tail -f (or xtail, better) on $CATALINA_HOME/logs/catalina.out and
/opt/syncope/log/*.log
3. startup Tomcat
4. watch the logs and see if any exception occurs

If any exception is raised, please report; if not, try to access

http://localhost:9080/syncope/

and see if any error is reported there.

If no error, then there is no reason why the Admin Console should not be
working; anyway, keep watching the logs and access

http://localhost:9080/syncope-console/

and see if any error is reported.

HTH
Regards.

--
View this message in context: 
http://syncope-user.1051894.n5.nabble.com/Any-tutorials-tp5709363p5709429.html

Sent from the syncope-user mailing list archive at Nabble.com.


--
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?

[Sergio Muriel]

(ContainerBase.java:728) 
~[catalina.jar:8.5.16]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) 
~[catalina.jar:8.5.16]
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:988) 
~[catalina.jar:8.5.16]
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1860) 
~[catalina.jar:8.5.16]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) 
~[?:1.8.0_71]
at java.util.concurrent.FutureTask.run(Unknown Source) ~[?:1.8.0_71]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) 
[?:1.8.0_71]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) 
[?:1.8.0_71]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_71]
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) ~[?:1.8.0_71]
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source) ~[?:1.8.0_71]
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) ~[?:1.8.0_71]
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) 
~[?:1.8.0_71]
at java.net.AbstractPlainSocketImpl.connect(Unknown Source) ~[?:1.8.0_71]
at java.net.PlainSocketImpl.connect(Unknown Source) ~[?:1.8.0_71]
at java.net.SocksSocketImpl.connect(Unknown Source) ~[?:1.8.0_71]
at java.net.Socket.connect(Unknown Source) ~[?:1.8.0_71]
at org.postgresql.core.PGStream.(PGStream.java:68) 
~[postgresql-42.1.4.jar:42.1.4]
at 
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
 ~[postgresql-42.1.4.jar:42.1.4]
... 70 more


Looks like I need to configure something else somewhere.

As always, help is very appreciated.


Best Regards,
Sergio Muriel


From: ilgrosso <ilgro...@apache.org>
Sent: Tuesday, August 29, 2017 2:52 AM
To: user@syncope.apache.org
Subject: Re: Any tutorials?


>From my project root I ran:

mvn clean verify -Dconf.directory=/opt/syncope/conf
-Dbundles.directory=/opt/syncope/bundles -Dlog.directory=/opt/syncope/log

Then I copied the respective *.properties into /opt/syncope/conf
and the respective *.war into Tomcat (CATALINA_HOME/webapps)

Tried with both 8080 and 9080 on these files:

CATALINA_HOME\conf\server.xml (

Ok, please move step by step.

First, since you have 9080 configured on $CATALINA_HOME/conf/server.xml (but
why?), then it's ok to have that port also on

/opt/syncope/conf/console.properties
/opt/syncope/conf/enduser.properties

Now:

1. shut down Tomcat
2. tail -f (or xtail, better) on $CATALINA_HOME/logs/catalina.out and
/opt/syncope/log/*.log
3. startup Tomcat
4. watch the logs and see if any exception occurs

If any exception is raised, please report; if not, try to access

http://localhost:9080/syncope/

and see if any error is reported there.

If no error, then there is no reason why the Admin Console should not be
working; anyway, keep watching the logs and access

http://localhost:9080/syncope-console/

and see if any error is reported.

HTH
Regards.

--
View this message in context: 
http://syncope-user.1051894.n5.nabble.com/Any-tutorials-tp5709363p5709429.html

Sent from the syncope-user mailing list archive at Nabble.com.

Re: Any tutorials?

[ilgrosso]

>From my project root I ran:

mvn clean verify -Dconf.directory=/opt/syncope/conf
-Dbundles.directory=/opt/syncope/bundles -Dlog.directory=/opt/syncope/log

Then I copied the respective *.properties into /opt/syncope/conf
and the respective *.war into Tomcat (CATALINA_HOME/webapps)

Tried with both 8080 and 9080 on these files:

CATALINA_HOME\conf\server.xml (

Ok, please move step by step.

First, since you have 9080 configured on $CATALINA_HOME/conf/server.xml (but
why?), then it's ok to have that port also on 

/opt/syncope/conf/console.properties
/opt/syncope/conf/enduser.properties

Now:

1. shut down Tomcat
2. tail -f (or xtail, better) on $CATALINA_HOME/logs/catalina.out and
/opt/syncope/log/*.log
3. startup Tomcat
4. watch the logs and see if any exception occurs

If any exception is raised, please report; if not, try to access

http://localhost:9080/syncope/

and see if any error is reported there.

If no error, then there is no reason why the Admin Console should not be
working; anyway, keep watching the logs and access

http://localhost:9080/syncope-console/

and see if any error is reported.

HTH
Regards.

--
View this message in context: 
http://syncope-user.1051894.n5.nabble.com/Any-tutorials-tp5709363p5709429.html
Sent from the syncope-user mailing list archive at Nabble.com.

Re: Any tutorials?

[Sergio Muriel]

>From my project root I ran:

mvn clean verify -Dconf.directory=/opt/syncope/conf 
-Dbundles.directory=/opt/syncope/bundles -Dlog.directory=/opt/syncope/log

Then I copied the respective *.properties into /opt/syncope/conf
and the respective *.war into Tomcat (CATALINA_HOME/webapps)


Tried with both 8080 and 9080 on these files:

CATALINA_HOME\conf\server.xml (
Sent: Friday, August 25, 2017 1:36 AM
To: user@syncope.apache.org
Subject: Re: Any tutorials?

On 24/08/2017 21:29, Sergio Muriel wrote:

I have followed the steps as you (and the guide) mention, nevertheless I ran 
into this problem:

javax.xml.ws.WebServiceException: Remote exception with status code: 
NOT_FOUND.

It happens when I call http://localhost:9080/syncope-console/

Exactly as described in:

http://www.mail-archive.com/user@syncope.apache.org/msg02058.html


It does not look like solved (do you guys have Jira or something similar?) 
indeed. As always, help is appreciated.

It is not solved, because it is not an issue :-)

Simply, the configuration files assume that you are running Tomcat on port 
8080: if your port is different (9080 as I read above), you should simply go 
and change such settings in

/opt/syncope/conf/console.properties

and

/opt/syncope/conf/enduser.properties (if you also plan to use the Enduser UI)

then restart Tomcat.

FYI: http://syncope.apache.org/issue-tracking.html
Apache Syncope – Issue Management<http://syncope.apache.org/issue-tracking.html>
syncope.apache.org
Issue Management. Issues, bugs, and feature requests should be submitted to the 
following issue management system for this project.




Regards.

From: Francesco Chicchiriccò <ilgro...@apache.org><mailto:ilgro...@apache.org>
Sent: Thursday, August 24, 2017 2:26 AM
To: user@syncope.apache.org<mailto:user@syncope.apache.org>
Subject: Re: Any tutorials?

On 23/08/2017 18:53, Sergio Muriel wrote:

Don't worry! Actually this solution for embedded mode works like a charm!! 
Thank you!!

Good to hear this :-)


On the other hand, I'm having an issue when I deploy it to an external 
container (Tomcat): In Topology view, it shows no connectors in between the 
resources and Connid (connid://testconnectorserver@localhost:4554 for me); in 
other words it looses all connectors.


Do you know what is wrong?



PD: I'm using same war files generated for embedded mode. I just copy them in 
webapps/.

This won't work: as the big warning at the end of

http://syncope.apache.org/docs/getting-started.html#maven-project


says: "Before actual deployment onto a standalone Java EE container, you need 
to further check the Customization chapter of the Apache Syncope Reference 
Guide", e.g.

https://syncope.apache.org/docs/reference-guide.html#customization


You'll need to (as indicated in the Reference Guide):

1. create /opt/syncope and its subdirectories as suggested
2. build with all the indicated switches (-Dconf.directory=... etc)
3. copy the filtered property files
4. only at this point deploy the generated WAR files

HTH
Regards.


From: Francesco Chicchiriccò <ilgro...@apache.org><mailto:ilgro...@apache.org>
Sent: Tuesday, August 22, 2017 10:33 AM
To: user@syncope.apache.org<mailto:user@syncope.apache.org>
Subject: Re: Any tutorials?

Hi Sergio,
sorry, my bad.

You need to:

1. declare the JDBC driver dependency in enduser/pom.xml (not core/pom.xml as 
said initially), as follows:


  mysql
  mysql-connector-java
  5.1.42
  test


right after


  com.h2database
  h2
  test


2. add the JDBC driver as Tomcat dependency, via cargo:

  
mysql
mysql-connector-java
  

right after

  
com.h2database
h2
  

I have just tried to be sure, and it worked in embedded mode.

In case of deployment onto an external container (rather than in embedded 
mode), you'll have to copy the JDBC Driver JAR onto the container's classpath 
($CATALINA_HOME/lib for Tomcat).

HTH
Regards.

On 21/08/2017 23:42, Sergio Muriel wrote:

com.mysql.jdbc.Driver for MySQL

com.microsoft.sqlserver.jdbc.SQLServerDriver for SQL Server


Yes, I'm trying to configure a DBTable Connector Bundle?



From: Francesco Chicchiriccò <ilgro...@apache.org><mailto:ilgro...@apache.org>
Sent: Sunday, August 20, 2017 1:02 AM
To: user@syncope.apache.org<mailto:user@syncope.apache.org>
Subject: Re: Any tutorials?

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.]"

Re: Any tutorials?

[Francesco Chicchiriccò]

On 24/08/2017 21:29, Sergio Muriel wrote:


I have followed the steps as you (and the guide) mention, nevertheless 
I ran into this problem:


javax.xml.ws.WebServiceException: Remote exception with status code: 
NOT_FOUND.

It happens when I call http://localhost:9080/syncope-console/

Exactly as described in:

http://www.mail-archive.com/user@syncope.apache.org/msg02058.html


It does not look like solved (do you guys have Jira or something 
similar?) indeed. As always, help is appreciated.




It is not solved, because it is not an issue :-)

Simply, the configuration files assume that you are running Tomcat on 
port 8080: if your port is different (9080 as I read above), you should 
simply go and change such settings in


/opt/syncope/conf/console.properties

and

/opt/syncope/conf/enduser.properties (if you also plan to use the 
Enduser UI)


then restart Tomcat.

FYI: http://syncope.apache.org/issue-tracking.html

Regards.


*From:* Francesco Chicchiriccò <ilgro...@apache.org>
*Sent:* Thursday, August 24, 2017 2:26 AM
*To:* user@syncope.apache.org
*Subject:* Re: Any tutorials?
On 23/08/2017 18:53, Sergio Muriel wrote:


Don't worry! Actually this solution for embedded mode works like a 
charm!! Thank you!!




Good to hear this :-)

On the other hand, I'm having an issue when I deploy it to an 
external container (Tomcat): In Topology view, it shows no connectors 
in between the resources and Connid 
(connid://testconnectorserver@localhost:4554 for me); in other words 
it looses all connectors.



Do you know what is wrong?



PD: I'm using same war files generated for embedded mode. I just copy 
them in webapps/.




This won't work: as the big warning at the end of

http://syncope.apache.org/docs/getting-started.html#maven-project


says: "Before actual deployment onto a standalone Java EE container, 
you need to further check the Customization chapter of the Apache 
Syncope Reference Guide", e.g.


https://syncope.apache.org/docs/reference-guide.html#customization


You'll need to (as indicated in the Reference Guide):

1. create /opt/syncope and its subdirectories as suggested
2. build with all the indicated switches (-Dconf.directory=... etc)
3. copy the filtered property files
4. only at this point deploy the generated WAR files

HTH
Regards.



*From:* Francesco Chicchiriccò <ilgro...@apache.org>
*Sent:* Tuesday, August 22, 2017 10:33 AM
*To:* user@syncope.apache.org
*Subject:* Re: Any tutorials?
Hi Sergio,
sorry, my bad.

You need to:

1. declare the JDBC driver dependency in enduser/pom.xml (not 
core/pom.xml as said initially), as follows:



  mysql
mysql-connector-java
  5.1.42
  test


right after


com.h2database
  h2
  test


2. add the JDBC driver as Tomcat dependency, via cargo:

  
mysql
mysql-connector-java
  

right after

  
com.h2database
h2
  

I have just tried to be sure, and it worked in embedded mode.

In case of deployment onto an external container (rather than in 
embedded mode), you'll have to copy the JDBC Driver JAR onto the 
container's classpath ($CATALINA_HOME/lib for Tomcat).


HTH
Regards.

On 21/08/2017 23:42, Sergio Muriel wrote:


com.mysql.jdbc.Driver for MySQL

com.microsoft.sqlserver.jdbc.SQLServerDriver for SQL Server


Yes, I'm trying to configure a DBTable Connector Bundle?




*From:* Francesco Chicchiriccò <ilgro...@apache.org>
*Sent:* Sunday, August 20, 2017 1:02 AM
*To:* user@syncope.apache.org
*Subject:* Re: Any tutorials?
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

Re: Any tutorials?

[Sergio Muriel]

I have followed the steps as you (and the guide) mention, nevertheless I ran 
into this problem:<http://localhost:9080/syncope-console/>

javax.xml.ws.WebServiceException: Remote exception with status code: 
NOT_FOUND.

It happens when I call http://localhost:9080/syncope-console/

Exactly as described in:

http://www.mail-archive.com/user@syncope.apache.org/msg02058.html


It does not look like solved (do you guys have Jira or something similar?) 
indeed. As always, help is appreciated.



Sergio

From: Francesco Chicchiriccò <ilgro...@apache.org>
Sent: Thursday, August 24, 2017 2:26 AM
To: user@syncope.apache.org
Subject: Re: Any tutorials?

On 23/08/2017 18:53, Sergio Muriel wrote:

Don't worry! Actually this solution for embedded mode works like a charm!! 
Thank you!!

Good to hear this :-)


On the other hand, I'm having an issue when I deploy it to an external 
container (Tomcat): In Topology view, it shows no connectors in between the 
resources and Connid (connid://testconnectorserver@localhost:4554 for me); in 
other words it looses all connectors.


Do you know what is wrong?



PD: I'm using same war files generated for embedded mode. I just copy them in 
webapps/.

This won't work: as the big warning at the end of

http://syncope.apache.org/docs/getting-started.html#maven-project


says: "Before actual deployment onto a standalone Java EE container, you need 
to further check the Customization chapter of the Apache Syncope Reference 
Guide", e.g.

https://syncope.apache.org/docs/reference-guide.html#customization


You'll need to (as indicated in the Reference Guide):

1. create /opt/syncope and its subdirectories as suggested
2. build with all the indicated switches (-Dconf.directory=... etc)
3. copy the filtered property files
4. only at this point deploy the generated WAR files

HTH
Regards.



From: Francesco Chicchiriccò <ilgro...@apache.org><mailto:ilgro...@apache.org>
Sent: Tuesday, August 22, 2017 10:33 AM
To: user@syncope.apache.org<mailto:user@syncope.apache.org>
Subject: Re: Any tutorials?

Hi Sergio,
sorry, my bad.

You need to:

1. declare the JDBC driver dependency in enduser/pom.xml (not core/pom.xml as 
said initially), as follows:


  mysql
  mysql-connector-java
  5.1.42
  test


right after


  com.h2database
  h2
  test


2. add the JDBC driver as Tomcat dependency, via cargo:

  
mysql
mysql-connector-java
  

right after

  
com.h2database
h2
  

I have just tried to be sure, and it worked in embedded mode.

In case of deployment onto an external container (rather than in embedded 
mode), you'll have to copy the JDBC Driver JAR onto the container's classpath 
($CATALINA_HOME/lib for Tomcat).

HTH
Regards.

On 21/08/2017 23:42, Sergio Muriel wrote:

com.mysql.jdbc.Driver for MySQL

com.microsoft.sqlserver.jdbc.SQLServerDriver for SQL Server


Yes, I'm trying to configure a DBTable Connector Bundle?



From: Francesco Chicchiriccò <ilgro...@apache.org><mailto:ilgro...@apache.org>
Sent: Sunday, August 20, 2017 1:02 AM
To: user@syncope.apache.org<mailto:user@syncope.apache.org>
Subject: Re: Any tutorials?

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><mailto:ilgro...@apache.org>
> SENT: Saturday, August 19, 2017 7:39 AM
> TO: user@syncope.apache.org<mailto: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

Re: Any tutorials?

[Sergio Muriel]

Don't worry! Actually this solution for embedded mode works like a charm!! 
Thank you!!


On the other hand, I'm having an issue when I deploy it to an external 
container (Tomcat): In Topology view, it shows no connectors in between the 
resources and Connid (connid://testconnectorserver@localhost:4554 for me); in 
other words it looses all connectors.


Do you know what is wrong?



PD: I'm using same war files generated for embedded mode. I just copy them in 
webapps/.

Best Regards,
Sergio Muriel




From: Francesco Chicchiriccò <ilgro...@apache.org>
Sent: Tuesday, August 22, 2017 10:33 AM
To: user@syncope.apache.org
Subject: Re: Any tutorials?

Hi Sergio,
sorry, my bad.

You need to:

1. declare the JDBC driver dependency in enduser/pom.xml (not core/pom.xml as 
said initially), as follows:


  mysql
  mysql-connector-java
  5.1.42
  test


right after


  com.h2database
  h2
  test


2. add the JDBC driver as Tomcat dependency, via cargo:

  
mysql
mysql-connector-java
  

right after

  
com.h2database
h2
  

I have just tried to be sure, and it worked in embedded mode.

In case of deployment onto an external container (rather than in embedded 
mode), you'll have to copy the JDBC Driver JAR onto the container's classpath 
($CATALINA_HOME/lib for Tomcat).

HTH
Regards.

On 21/08/2017 23:42, Sergio Muriel wrote:

com.mysql.jdbc.Driver for MySQL

com.microsoft.sqlserver.jdbc.SQLServerDriver for SQL Server


Yes, I'm trying to configure a DBTable Connector Bundle?



From: Francesco Chicchiriccò <ilgro...@apache.org><mailto:ilgro...@apache.org>
Sent: Sunday, August 20, 2017 1:02 AM
To: user@syncope.apache.org<mailto:user@syncope.apache.org>
Subject: Re: Any tutorials?

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><mailto:ilgro...@apache.org>
> SENT: Saturday, August 19, 2017 7:39 AM
> TO: user@syncope.apache.org<mailto: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><mailto: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"
>
>

Re: Any tutorials?

[Francesco Chicchiriccò]

Hi Sergio,
sorry, my bad.

You need to:

1. declare the JDBC driver dependency in enduser/pom.xml (not 
core/pom.xml as said initially), as follows:



  mysql
mysql-connector-java
  5.1.42
  test


right after


  com.h2database
  h2
  test


2. add the JDBC driver as Tomcat dependency, via cargo:

  
mysql
mysql-connector-java
  

right after

  
com.h2database
h2
  

I have just tried to be sure, and it worked in embedded mode.

In case of deployment onto an external container (rather than in 
embedded mode), you'll have to copy the JDBC Driver JAR onto the 
container's classpath ($CATALINA_HOME/lib for Tomcat).


HTH
Regards.

On 21/08/2017 23:42, Sergio Muriel wrote:


com.mysql.jdbc.Driver for MySQL

com.microsoft.sqlserver.jdbc.SQLServerDriver for SQL Server


Yes, I'm trying to configure a DBTable Connector Bundle?




*From:* Francesco Chicchiriccò <ilgro...@apache.org>
*Sent:* Sunday, August 20, 2017 1:02 AM
*To:* user@syncope.apache.org
*Subject:* Re: Any tutorials?
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 
<https://syncope.apache.org/docs/getting-started.html>
Apache Syncope 2.0.4 - Getting Started 
<https://syncope.apache.org/docs/getting-started.html>

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 ...




>
> 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: R

Re: Any tutorials?

[Sergio Muriel]

com.mysql.jdbc.Driver for MySQL

com.microsoft.sqlserver.jdbc.SQLServerDriver for SQL Server


Yes, I'm trying to configure a DBTable Connector Bundle?



From: Francesco Chicchiriccò <ilgro...@apache.org>
Sent: Sunday, August 20, 2017 1:02 AM
To: user@syncope.apache.org
Subject: Re: Any tutorials?

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<https://syncope.apache.org/docs/getting-started.html>
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 ...



>
> 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  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ò <ilgro...@apache.org>
>> Sent: Friday, August 18, 2017 1:32 AM
>> To:

Re: Any tutorials?

[Francesco Chicchiriccò]

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  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ò <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  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?

Re: Any tutorials?

[Sergio Muriel]

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:

  1.  Added the dependency to core/pom.xml
  2.  Rebuilt everything from the root directory via "mvn -Pall clean install".
  3.  Ran it from enduser via "mvn -P embedded,all"

I don't know what is wrong.

Best Regards,
Sergio

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<https://syncope.apache.org/docs/getting-started.html>
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  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ò <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  occurrence):

> 
> mysql
> mysql-connector-java
> 5.1.42
> 

> for

Re: Any tutorials?

[Francesco Chicchiriccò]

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

> 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  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ò <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  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ò <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

Re: Any tutorials?

[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 <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  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ò <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  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ò <ilgro...@apache.org><mailto:ilgro...@apache.org>
Sent: Friday, August 11, 2017 5:14 AM
To: user@syncope.apache.org<mailto: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<http://syncope.apache.org/docs/reference-guide.html> 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?

[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ò <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  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ò <ilgro...@apache.org><mailto:ilgro...@apache.org>
Sent: Friday, August 11, 2017 5:14 AM
To: user@syncope.apache.org<mailto: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<http://syncope.apache.org/docs/reference-guide.html> 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?

[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ò <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 
<http://syncope.apache.org/docs/reference-guide.html> 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?

[Sergio Muriel]

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.
  2.  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.


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<http://syncope.apache.org/docs/reference-guide.html> 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?

[Francesco Chicchiriccò]

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/

Any tutorials?

[Sergio Muriel]

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.

Thank you for your answer.