Pegasi Wiki

This wiki acts as a memo for our own work so why not share them? Feel free to browse and use out notes and leave a note while at it.

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
syncope_on_centos7 [2015/12/08 15:51]
Pekka Kuronen
syncope_on_centos7 [2017/11/06 10:11] (current)
Line 67: Line 67:
 </​code>​ </​code>​
  
-Get JDBC connector for MariaDB to use with Tomcat. Latest can be found [[https://​mariadb.com/​kb/​en/​mariadb/​about-mariadb-connector-j/​|here]]. Copy .jar file to /​usr/​share/​tomcat/​.+Get JDBC connector for MariaDB to use with Tomcat. Latest can be found [[https://​mariadb.com/​kb/​en/​mariadb/​about-mariadb-connector-j/​|here]]. Copy .jar file to /​usr/​share/​tomcat/lib/.
 <​code>​ <​code>​
-cp mariadb-java-client-x.x.x.jar /​usr/​share/​tomcat/​+cp mariadb-java-client-x.x.x.jar /​usr/​share/​tomcat/lib/
 </​code>​ </​code>​
  
Line 158: Line 158:
 </​code>​ </​code>​
  
-==== Test ====+After installation stop Tomcat 
 + 
 +<​code>​ 
 +systemctl tomcat stop 
 +</​code>​ 
 + 
 +And change persistent connectivity from MySQL to Mariadb by editing files 
 +  * <​install-prefix>/​syncope/​core/​src/​main/​resources/​persistence.properties 
 +  * <​install-prefix>/​core/​target/​classes/​persistence.properties 
 +  * <​install-prefix>/​core/​target/​syncope/​WEB-INF/​classes/​persistence.properties 
 + 
 +and replacing the contents with following (REMEMBER USERNAME/​PASSWORD/​DB NAME) 
 + 
 +<​code>​ 
 +jpa.driverClassName=org.mariadb.jdbc.Driver 
 +jpa.url=jdbc:​mariadb://​localhost:​3306/​syncope?​characterEncoding=UTF-8 
 +jpa.username=syncope 
 +jpa.password=syncope 
 +jpa.dialect=org.apache.openjpa.jdbc.sql.MariaDBDictionary 
 +jpa.pool.validationQuery=SELECT 1 
 +quartz.jobstore=org.quartz.impl.jdbcjobstore.StdJDBCDelegate 
 +quartz.sql=tables_mariadb.sql 
 +audit.sql=audit.sql 
 +database.schema=  
 +</​code>​ 
 + 
 +==== Test Syncope console access ​====
  
 Access the Syncope console at  Access the Syncope console at 
 <​code>​ <​code>​
 http://<​ip address>:​8080/​syncope-console http://<​ip address>:​8080/​syncope-console
 +</​code>​
 +
 +==== Forgot admin password? ;) ====
 +
 +Set up a new admin password by sha1summing it and changing it to security.properties file
 +
 +Firstly grab the sha1sum of your password with command
 +<​code>​
 +unset HISTFILE
 +echo -n "​new_password"​ | sha1sum
 +</​code>​
 +
 +And modify it to the security.properties file
 +<​code>​
 +vim /​var/​lib/​tomcat/​webapps/​syncope/​WEB-INF/​classes/​security.properties
 +</​code>​
 +
 +And restart tomcat
 +<​code>​
 +systemctl restart tomcat
 </​code>​ </​code>​
  
 {(rater>​id=syncope_on_centos7|type=rate|trace=ip|headline=off)} {(rater>​id=syncope_on_centos7|type=rate|trace=ip|headline=off)}
  
-~~DISCUSSION|Leave a comment~~+~~DISCUSSION|Leave a comment~~~~NOCACHE~~ 
 +~~QUICKSTATS:​@syncope_on_centos7&​basics~~ 
 +~~QUICKSTATS:​@syncope_on_centos7&​ip~~ 

  //check if we are running within the DokuWiki environment if (!defined("DOKU_INC")){ die(); } //place the needed HTML source codes BELOW this line