forked from RainerW/Sonferenz
-
Notifications
You must be signed in to change notification settings - Fork 1
Installation
RainerW edited this page Apr 1, 2012
·
2 revisions
- Download the latest Apache Tomcat : http://tomcat.apache.org/download-70.cgi and extract it. (For this tutorial 7.0.26 was used, but tomcat 6 should also work)
- Download the latest sonferenz war file https://github.com/Seitenbau/Sonferenz/downloads ( eg 0.3.0 )
- But the war inside tomcat's webapps folder
- start tomcat : bin/startup.bat
- Open sonferenz at http://localhost:8080/sonferenz-web-0.3.0
- login as : admin/admin
Derby is the default Database, so Step 1 uses derby allready. It's configured via "application.properties" located at "WEB-INF/config" :
## Apache Derby
db.driver=org.apache.derby.jdbc.EmbeddedDriver
db.url=jdbc:derby:../db;create=true
db.user=sa
db.password=
db.jpa.dialect=DERBY
The default config creates a file based derby database at "../db" (../db;create=true), which should be "${your-tomcat-root}/db".
To use MySQL you need to uncomment the mysql part in "WEB-INF/config/application.properties":
## ## MYSQL
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/sdcdb?characterEncoding=utf-8
db.user=sdcdb
db.password=sdcdb
db.jpa.dialect=MYSQL
This would connect to a empty Database at localhost with the user "sdcdb". After Tomcat (re)start the empty Database will be detected ( log message:"# Database seems to be empty ... initializing"), then all tables and a default dataset will be created (including the admin user).