I’m trying to install xwiki in tomcat9, java 1.8.0_201 y mariadb/mysql.
Tomcat9 config:
Server.xml:
<Connector port="8080" URIEncoding="UTF-8"
protocol="HTTP/1.1"
compression="on"
compressionMinSize="2048"
compressableMimeType="text/html,text/xml,text/css,text/javascript,application/x-javascript"
maxParameterCount="10000"
connectionTimeout="20000"
redirectPort="8443" />
catalina.policy:
grant codeBase "file:${catalina.base{color:#bc7a00}}/webapps/xwiki/WEB-INF/lib/-" {
// for mySQL connection
permission java.net.SocketPermission "127.0.0.1:3306", "connect,resolve";
// XWiki must have access to all properties in read/write
permission java.util.PropertyPermission "*", "read, write";
// Generic detected permissions
permission java.lang.reflect.ReflectPermission "suppressAccessChecks";
permission java.lang.RuntimePermission "createClassLoader";
permission java.lang.RuntimePermission "setContextClassLoader";
permission java.lang.RuntimePermission "accessClassInPackage.org.apache.catalina.loader";
permission java.lang.RuntimePermission "accessDeclaredMembers";
permission java.lang.RuntimePermission "getenv.ProgramFiles";
permission java.lang.RuntimePermission "getenv.APPDATA";
permission java.lang.RuntimePermission "accessClassInPackage.sun.reflect";
permission java.lang.RuntimePermission "getClassLoader";
permission java.lang.RuntimePermission "accessClassInPackage.org.apache.catalina.connector";
permission java.lang.RuntimePermission "accessClassInPackage.org.apache.tomcat.util.threads";
permission java.lang.RuntimePermission "reflectionFactoryAccess";
permission java.lang.RuntimePermission "accessClassInPackage.com.sun.jmx.interceptor";
permission java.lang.RuntimePermission "accessClassInPackage.com.sun.jmx.mbeanserver";
permission java.lang.RuntimePermission "modifyThread";
permission java.lang.RuntimePermission "getProtectionDomain";
// JAXB permissions
permission javax.xml.bind.JAXBPermission "setDatatypeConverter";
// Serialization related permissions
permission java.io.SerializablePermission "allowSerializationReflection";
permission java.io.SerializablePermission "creator";
permission java.io.SerializablePermission "enableSubclassImplementation";
// Internal resources access permissions
permission java.io.FilePermission "synonyms.txt", "read";
permission java.io.FilePermission "lang/synonyms_en.txt", "read";
permission java.io.FilePermission "quartz.properties", "read";
permission java.io.FilePermission "/templates/-", "read";
permission java.io.FilePermission "/skins/-", "read";
permission java.io.FilePermission "/resources/-", "read";
// MBean related permissions
permission javax.management.MBeanServerPermission "createMBeanServer";
permission javax.management.MBeanPermission "*", "registerMBean";
permission javax.management.MBeanPermission "*", "unregisterMBean";
permission javax.management.MBeanTrustPermission "register";
permission javax.management.MBeanPermission "#[-]", "queryNames";
permission javax.management.MBeanServerPermission "findMBeanServer";
// LibreOffice/OpenOffice related permissions
permission java.io.FilePermission "/opt/openoffice.org3/program/soffice.bin", "read";
permission java.io.FilePermission "/opt/libreoffice/program/soffice.bin", "read";
permission java.io.FilePermission "/usr/lib/openoffice/program/soffice.bin", "read";
permission java.io.FilePermission "/usr/lib/libreoffice/program/soffice.bin", "read";
// Allow file storage directory reading - for directory and everything underneath
// This is dependent on the setting of environment.permanentDirectory in xwiki.properties
permission java.io.FilePermission "${catalina.base{color:#bc7a00}}$color}file.separator{color:#bc7a00}}xwikidata${{color:#008000}file.separator{color:#bc7a00", "read,write,delete";
permission java.io.FilePermission "${catalina.base{color:#bc7a00}}$color}file.separator{color:#bc7a00}}xwikidata${{color:#008000}file.separator{color:#bc7a00-", "read,write,delete";
// Allow file storage directory reading - temporary directory and everything underneath
// This is dependent on the setting of environment.temporaryDirectory in xwiki.properties.
permission java.io.FilePermission "${catalina.base{color:#bc7a00}}$color}file.separator{color:#bc7a00}}temp${{color:#008000}file.separator{color:#bc7a00", "read,write,delete";
permission java.io.FilePermission "${catalina.base{color:#bc7a00}}$color}file.separator{color:#bc7a00}}temp${{color:#008000}file.separator{color:#bc7a00-", "read,write,delete";
};
MariaDB configuration:
MariaDB [(none)]> show databases;
<ins>--------------------</ins>
Database
<ins>--------------------</ins>
information_schema
mysql
performance_schema
xwiki
<ins>--------------------</ins>
4 rows in set (0.04 sec)
mysql -u root -e "create database xwiki default character set utf8 collate utf8_bin"
CREATE USER 'xwiki' IDENTIFIED BY 'xwiki';
GRANT USAGE ON **.** TO 'xwiki'@localhost IDENTIFIED BY 'xwiki';
FLUSH PRIVILEGES;
mysql -u root -e "grant all privileges on **.** to xwiki@localhost identified by 'xwiki'"
mysql -u root -p -e "uninstall plugin validate_password;"
hibernate.cfg.xml
<property name="connection.url">jdbc:mysql://localhost/xwiki</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">meolvide</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
<property name="connection.useUnicode">true</property>
<property name="connection.characterEncoding">UTF-8</property><property name="connection.url">jdbc:mysql://localhost/xwiki</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">meolvide</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
<property name="connection.useUnicode">true</property>
<property name="connection.characterEncoding">UTF-8</property>
mysql-connector-java-5.1.17.jar in /var/tomcat9-xwiki/webapps/xwiki/WEB-INF/lib and /var/tomcat9-xwiki/lib
error in attachment
error.txt (27.6 KB)