Re: I desperately require assistance getting my Syncore installation to work in windows

[Eric-R82]

Here's what I have discovered that helped resolve my issue.

1. I had created a dedicated named instance for the Syncope database, but
that wasn't working so I moved it over to the default instance.

2. Authentication using a domain account didn't seem to work, so I set the
SQL installation to mixed mode and created a SQL user for the application to
connect as.



--
Sent from: http://syncope-user.1051894.n5.nabble.com/

Re: I desperately require assistance getting my Syncore installation to work in windows

[Eric-R82]

I think I have potentially resolved the issue. I have it working using this
example webapp I found. I will now deploy the Syncope webapp and see if it
works.

--
Sent from: http://syncope-user.1051894.n5.nabble.com/

Re: I desperately require assistance getting my Syncore installation to work in windows

[Eric-R82]

Yes, I do see the file there.

 

I uninstalled tomcat and put on Java 8 instead then re-installed Tomcat. I
also moved the database to the SQL server default instance instead of a
named instance.

I still have no luck though. I will create a post in Tomcat forums (I know I
should have done that a while ago).

--
Sent from: http://syncope-user.1051894.n5.nabble.com/

Re: I desperately require assistance getting my Syncore installation to work in windows

[ilgrosso]

Just double-click on the downloaded JAR: you should find a directory
hierarchy as follows:

com/
  microsoft/
sqlserver/
  jdbc/

and in the inner folder, a file named

SQLServerDriver.class

Can you confirm?

--
Sent from: http://syncope-user.1051894.n5.nabble.com/

Re: I desperately require assistance getting my Syncore installation to work in windows

[Eric-R82]

I don't suppose you could direct me to way to check that. I am noob when it
comes to writing software and the last time I wrote java was years ago. I
will do the googling in the mean time.

--
Sent from: http://syncope-user.1051894.n5.nabble.com/

Re: I desperately require assistance getting my Syncore installation to work in windows

[Eric-R82]

I located an example webapp to test using a datasource.

I added the following to my Tomcat\conf\context.xml file

/"
url="jdbc:sqlserver://localhost:1433;databaseName=TestDB;"
removeAbandoned="true"
removeAbandonedTimeout="30"
logAbandoned="true" />/

The database TestDB has been created and populated. However I get the
following error:

/Unable to get connection, DataSource invalid: "java.sql.SQLException: No
suitable driver found for jdbc/TestDB"/

I need to research how to install the JDBC driver. I thought it was just as
simple as placing the .jar file that I downloaded from microsoft and placing
it in the Tomcat\lib folder.

--
Sent from: http://syncope-user.1051894.n5.nabble.com/

Re: I desperately require assistance getting my Syncore installation to work in windows

[Francesco Chicchiriccò]

On 16/02/2018 17:31, Eric-R82 wrote:

I am using 2.0.7. I didn't go with the standalone, because of the of the 
following note:

/Target Audience
First approach, especially with administration console and end-user; does
not require technical skills.
*Not meant for any production environment.*/

If I can ignore it and go use it in a production environment, I will try it.


I confirm that standalone is for product evaluation, not for production.


I originally tried this link:

http://syncope.apache.org/docs/getting-started.html#gui-installer

but I syncope wouldn't start in tomcat.I found

https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments#RunSyncopeinrealenvironments-MicrosoftSQLServer


If you scroll up that page you will notice:

The content below is for Apache Syncope <= 1.2 - for later versions 
check the "System Administration" chapter of the Reference Guide.


Why ignore such warning?


with the hope that I could use that to determine why the syncope webapp 
wouldn't start. In particular I was looking to found out how to setup a 
datasource in tomcat as the GUI installer warned that I need to have that 
setup, but I don't know how to setup a datasource in tomcat.


To setup a DataSource in  Tomcat is not exactly stuff for Syncope, but 
Google can help:


* 
https://stackoverflow.com/questions/15498851/configure-sql-server-connection-pool-on-tomcat
* 
https://confluence.atlassian.com/conf59/configuring-a-sql-server-datasource-in-apache-tomcat-792499577.html


Essentially, you need to adapt the sample provided at

https://syncope.apache.org/docs/reference-guide.html#apache-tomcat-8-and-8-5

to MS SQL Server.

Hence:

1. place the SQL Server JDBC driver under Tomcat's lib directory
2. add to Tomcat's conf/server.xml:



3. restart Tomcat

4. start again the Syncope GUI installer


I will re-install from scratch and continue searching how to setup a Microsoft 
SQL datasource in Tomcat.


--
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: I desperately require assistance getting my Syncore installation to work in windows

[Eric-R82]

I am using 2.0.7. I didn't go with the standalone, because of the of the
following note:

/Target Audience
First approach, especially with administration console and end-user; does
not require technical skills.
*Not meant for any production environment.*/

If I can ignore it and go use it in a production environment, I will try it.

I originally tried this link:

http://syncope.apache.org/docs/getting-started.html#gui-installer
  
but I syncope wouldn't start in tomcat. I found 
https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments#RunSyncopeinrealenvironments-MicrosoftSQLServer

  
with the hope that I could use that to determine why the syncope webapp
wouldn't start. In particular I was looking to found out how to setup a
datasource in tomcat as the GUI installer warned that I need to have that
setup, but I don't know how to setup a datasource in tomcat.

I will re-install from scratch and continue searching how to setup a
Microsoft SQL datasource in Tomcat.

--
Sent from: http://syncope-user.1051894.n5.nabble.com/

Re: I desperately require assistance getting my Syncore installation to work in windows

[Francesco Chicchiriccò]

Hi Eric,
first of all, do not despair :-)

Short answer: if it is for initial evaluation, just download the 2.0.7 
standalone distribution ZIP from


http://syncope.apache.org/downloads.html

then follow instructions at

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

and you're all set.

If instead you really want to go through the GUI installer, then 
download the 2.0.7 from the same link as above, then follow instructions at


http://syncope.apache.org/docs/getting-started.html#gui-installer

No need for further instructions.

Note: I see below that you have been following some old pages in the 
project wiki, each of which clearly shows a disclaimer on the top saying:


> The content below is for Apache Syncope <= 1.2 - for later versions 
check the "System Administration" chapter of the Reference Guide.


If you have been downloading 2.0.something, then you should better trust 
such disclaimer, and follow the updated documentation instead.


HTH
Regards.

On 16/02/2018 00:24, Eric-R82 wrote:

I installed Tomcat 8.5, Microsoft SQL Server 2017, Java SDK 9.0.4 and that
latest Maven.

I used the GUI installer. The installation completes successfully, but the
syncore core webapp won't start.

I tried following suggestions from here:
https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments

I added the following to the persistence.properties file:

/jpa.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jpa.url=jdbc:sqlserver://localhost:1344;database=Syncope;selectMethod=cursor;sendStringParametersAsUnicode=false
jpa.username=syncope
jpa.password=Chick3n82
jpa.dialect=org.apache.openjpa.jdbc.sql.SQLServerDictionary
jpa.pool.validationQuery=SELECT 1
#note: other connection pool settings can also be configured here, see
persistenceContext.xml
quartz.jobstore=org.quartz.impl.jdbcjobstore.MSSQLDelegate
quartz.sql=tables_sqlServer.sql
audit.sql=audit_sqlserver.sql
database.schema=/

I renamed spring-orm-sqlserver.xml to orm.xml in the META-INF folder.

I created a batch file in 'C:\Program Files\Apache Software
Foundation\Tomcat 8.5\bin' named setenv.bat with:
/set JAVA_OPTS=-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server
-Xms1536m -Xmx1536m -XX:NewSize=256m -XX:MaxNewSize=256m -XX:PermSize=256m
-XX:MaxPermSize=256m -XX:+DisableExplicitGC/

(I know the page says for Tomcat 7, but Tomcat 8.5 wasn't working, so I
thought I'd try it)

In context.xml, I uncommented ' // ' and added the
following underneath:

/
jdbcInterceptors=org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer

 username=syncope password=password>"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

url="jdbc:sqlserver://localhost:1344;database=syncope;selectMethod=cursor;sendStringParametersAsUnicode=false"

 />/

The example on the website has the name as jdbc/syncopeDataSource, but the
GUI installer had a note about this and called it syncopeMainDataSource. I
tried both ways, but neither work.

I uncommented the following in the glassfish-web.xml file:
   
 jdbc/syncopeMasterDataSource
 jdbc/syncopeMasterDataSource
   

I also tried changing it to syncopeDataSource, but that didn't help either.

The document says to change a  tag in web.xml under core, but
there are no xml files with entries like that in it except for the
glassfish-web.xml, so I ignored this the instruction to change:
/
   jdbc/syncopeDataSource
   javax.sql.DataSource
   Container
/

to
/
   jdbc/syncopeDataSource
   javax.sql.DataSource
   Container
   java:/syncopeDataSource
/

The site talks about adding a JBoss MySQL module, so I assume I must need to
do that with the MS SQL, but don't know how. I download the jar file from
microsoft and put it in the Tomcat\lib folder though...

Since this is what my C:\Program Files\Apache Software Foundation\Tomcat
8.5\webapps\syncope\WEB-INF\classes directory looks like:


I made the following changes to the web.xml file in C:\Program Files\Apache
Software Foundation\Tomcat 8.5\webapps\syncope\WEB-INF

/
 contextConfigLocation
 
   classpath*:/*Context.xml
   classpath*:/indexes.xml
   classpath*:/log4j2.xml
   classpath*:/security.xml
   classpath*:/persistence-enhance.xml
   classpath*:/views.xml
 
   /

There is no weblogic.xml file anywhere in the syncore webapp directory, so I
ignored what to do there.

I am really fumbling here as I have never worked with Tomcat before. I am
totally clueless as to what is going on or what I need to to to make this
work.
--
Sent from: http://syncope-user.1051894.n5.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/

I desperately require assistance getting my Syncore installation to work in windows

[Eric-R82]

I installed Tomcat 8.5, Microsoft SQL Server 2017, Java SDK 9.0.4 and that
latest Maven.

I used the GUI installer. The installation completes successfully, but the
syncore core webapp won't start.

I tried following suggestions from here:
https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments

I added the following to the persistence.properties file:

/jpa.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jpa.url=jdbc:sqlserver://localhost:1344;database=Syncope;selectMethod=cursor;sendStringParametersAsUnicode=false
jpa.username=syncope
jpa.password=Chick3n82
jpa.dialect=org.apache.openjpa.jdbc.sql.SQLServerDictionary
jpa.pool.validationQuery=SELECT 1
#note: other connection pool settings can also be configured here, see
persistenceContext.xml
quartz.jobstore=org.quartz.impl.jdbcjobstore.MSSQLDelegate
quartz.sql=tables_sqlServer.sql
audit.sql=audit_sqlserver.sql
database.schema=/

I renamed spring-orm-sqlserver.xml to orm.xml in the META-INF folder.

I created a batch file in 'C:\Program Files\Apache Software
Foundation\Tomcat 8.5\bin' named setenv.bat with: 
/set JAVA_OPTS=-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server
-Xms1536m -Xmx1536m -XX:NewSize=256m -XX:MaxNewSize=256m -XX:PermSize=256m
-XX:MaxPermSize=256m -XX:+DisableExplicitGC/

(I know the page says for Tomcat 7, but Tomcat 8.5 wasn't working, so I
thought I'd try it)

In context.xml, I uncommented ' // ' and added the
following underneath:

/"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
   
url="jdbc:sqlserver://localhost:1344;database=syncope;selectMethod=cursor;sendStringParametersAsUnicode=false"
/>/

The example on the website has the name as jdbc/syncopeDataSource, but the
GUI installer had a note about this and called it syncopeMainDataSource. I
tried both ways, but neither work.

I uncommented the following in the glassfish-web.xml file:
  
jdbc/syncopeMasterDataSource
jdbc/syncopeMasterDataSource
  

I also tried changing it to syncopeDataSource, but that didn't help either.

The document says to change a  tag in web.xml under core, but
there are no xml files with entries like that in it except for the
glassfish-web.xml, so I ignored this the instruction to change:
/
  jdbc/syncopeDataSource
  javax.sql.DataSource
  Container
/

to 
/
  jdbc/syncopeDataSource
  javax.sql.DataSource
  Container
  java:/syncopeDataSource
/

The site talks about adding a JBoss MySQL module, so I assume I must need to
do that with the MS SQL, but don't know how. I download the jar file from
microsoft and put it in the Tomcat\lib folder though...

Since this is what my C:\Program Files\Apache Software Foundation\Tomcat
8.5\webapps\syncope\WEB-INF\classes directory looks like:
 

I made the following changes to the web.xml file in C:\Program Files\Apache
Software Foundation\Tomcat 8.5\webapps\syncope\WEB-INF

/
contextConfigLocation

  classpath*:/*Context.xml
  classpath*:/indexes.xml
  classpath*:/log4j2.xml
  classpath*:/security.xml
  classpath*:/persistence-enhance.xml
  classpath*:/views.xml

  /

There is no weblogic.xml file anywhere in the syncore webapp directory, so I
ignored what to do there.

I am really fumbling here as I have never worked with Tomcat before. I am
totally clueless as to what is going on or what I need to to to make this
work.



--
Sent from: http://syncope-user.1051894.n5.nabble.com/