I pulled the latest docker compose for xwiki version 14 mysql-tomcat variant.
during the installation, when you go to the initial page and then offers a choice of flavors to install and then adds a bunch of plugins.
I got 400+ errors like this
SQL Error: 1366, SQLState: HY000
Incorrect string value: ‘\xC4\x8Clana…’ for column ‘XWD_CONTENT’ at row 1
Incorrect string value: ‘\xC4\x8Clana…’ for column ‘XWD_CONTENT’ at row 1
when searching for this i found the following ( java - How to handle SQL state [HY000]; error code [1366]; Incorrect string value? - Stack Overflow ) which seems to suggest these are unicode surrogate characters which are not supported by mysql but this is my first docker installation so I am likely to be very wrong.
the installation did complete but now I have another problem right on the dashboard.
I have seen several other posts here about this issue but all of them were for older versions. Once post said to un install notifications and re install it. Sounds good but to uninstall notifications there is a whole list of dependencies that would also have to be uninstalled and it seems like a lot of work for a brand new installation.
information that may help:
docker version 24.0.6
portainer 2.19.0
xwiki 14.10.16 mysql-tomcat variant.
my compose file looks like this
version: ‘3.8’
networks:
bridge:
driver: bridge
services:
web:
image: “xwiki:lts-mysql-tomcat”
container_name: xwiki-mysql-tomcat-web
depends_on:
- db
ports:
- “8080:8080”
environment:
- DB_USER=xwiki
- DB_PASSWORD=<password_1>
- DB_HOST=xwiki-mysql-db
volumes:
- /docker/xwiki/xwiki-data:/usr/local/xwiki
networks:
- bridge
db:
image: “mysql:5”
container_name: xwiki-mysql-db
volumes:
- /docker/xwiki/xwiki.cnf:/etc/mysql/conf.d/xwiki.cnf
- /docker/xwiki/mysql-data:/var/lib/mysql
- /docker/xwiki/init.sql:/docker-entrypoint-initdb.d/init.sql
environment:
- MYSQL_ROOT_PASSWORD=<password_2>
- MYSQL_USER=xwiki
- MYSQL_PASSWORD=<password_1>
- MYSQL_DATABASE=xwiki
networks:
- bridge
volumes:
mysql-data: {}
xwiki-data: {}
so I thought if mysql can’t deal with unicode surrogate characters, then installing the postgres-tomcat version should fix it. I could not get them to deploy. but i’ll open that in a new post.
Any suggestions about a) are those 400+ errors really about unsupported characters? and b) how can I resolve the notifications macro errors showing on my dashboard?
if there is other information I can provide to help, just let me know.
Thanks for your time,
GF