Install xwiki on debian 10 error 500

Help / Discuss
1

Hey everyone !

I try to install xwiki on a debian 10 with java 11, tomcat 9 and mysql.
When i run my tomcat service, i have this error :
error 500.txt (44.8 KB)

Anyone have an idea, please ?
Thank you in advance !

2

Hi @Mipmo! Please search for last ‘Root cause’ in your log. Usually problem clearly described there.

3

@amadis, thanks for your idea, Okay ! So this my error in logs :
logs.txt (9.6 KB)
This logs appear when i stop/start my service tomcat and when i refresh my url "http://Ip_Address:8080/xwiki/bin/view/Main/

4

@Mipmo, I see in your log string Cannot load JDBC driver class 'org.hsqldb.jdbcDriver'. I think that you missed something during installation. Please describe your installation steps…

5

@amadis Yeah i think i miss the install…

Package Deb
wget -q “https://maven.xwiki.org/public.gpg” -O- | sudo apt-key add -
sudo wget “https://maven.xwiki.org/stable/xwiki-stable.list” -P /etc/apt/sources.list.d/

sudo apt-get update
apt-cache search xwiki

Java & JDK
apt update
apt install default-jre
java -version
apt install default-jdk
javac -version

[Tomcat9
(mkdir /opt/tomcat)
(tar zxvf apache-tomcat-9.0.31)] /optionnal

Install xwiki
apt-get install xwiki-tomcat9-mysql

xwiki.war
“xwiki-platform-distribution-war-12.1.war” in webapps
mv xwiki-platform-distribution-war-12.1 xwiki.war

Memory
JAVA_OPTS=“-Djava.awt.headless=true -Xmx1024m”
JAVA_OPTS=“${JAVA_OPTS} -Djava.security.egd=file:/dev/./urandom”

I think is Tomcat 9, or not… ^^’

6

@Mipmo you need follow this instruction to make correct installation. Tomcat installs automatically, not need to install it by hand. war installs automatically, not need to install it by hand.

7

@amadis Okay I try with this, sometimes i just don’t understand all the things to install or not…

10

@amadis Hey so I configured , Tomcat9, Mysql and xwiki so it’s ok but now i don’t think is my install the real problem : ERROR.txt (19.3 KB)
Can I just have a little help, please

11

@Mipmo please look at your logs:

Caused by: org.hibernate.HibernateException: Could not create a DBCP pool. There is an error in the Hibernate configuration file, please review it.
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user ‘root’@‘localhost’)
Caused by: java.sql.SQLException: Access denied for user ‘root’@‘localhost’

you did not configure xwiki properly, see docs, find where to set up ‘hibernate’ settings

12

Thanks for your help.
I restarted the onstallation and it’s worked !