XWiki setup with Tomcat and MySQL

Help / Discuss
1

Hello,
I am trying to do a first time setup of XWiki with Tomcat, MySQL and WAR file distribution.
could someone please share any guideline for the same.

Thanks in advance for the help.

Best Regards
Kishore Vadivel

2

That’s what we use - been a while since I set it up, so it’d be hard to walk through that process, but I can try to answer questions you have.

3

@vadivelkishore

Hope this will help you out,

Apache Tomcat

  1. Download: Xwiki (war package)
  2. Install Apache Tomcat
  3. Install Java 7 or later(If not available in your machine)
  4. Extract the XWiki WAR into a directory named xwiki in TOMCAT_HOME/webapps/
    Ex path: C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps
  5. Edit the conf/server.xml file to set the UTF-8 encoding:
    <Connector port="8080" to
    <Connector port="8080" URIEncoding="UTF-8"/>
    image

MySql

  1. Install MySql
  2. Create DB using this below commands,

mysql -u root -e “create database xwiki default character set utf8 collate utf8_bin”
mysql -u root -e “grant all privileges on . to xwiki@localhost identified by ‘xwiki’”

  1. Download the driver jar package from this link, http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.17/
  2. Place the jar file in the path: C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\xwiki\WEB-INF\lib
  3. Make the necessary changes like below in hibernate.cfg.xml,
    image
  4. Comment out the other connections,
    image
  5. Restart Tomcat server :slight_smile:

Note: Path i have provided is based on windows machine.

1 Like
4

Why not follow the doc:

If you really want to use the manual way (not recommended, we recommend using the debian install when possible) then:

Hope it helps

1 Like