Problems with special Characters in openkm / docker
PostPosted:Mon Jul 12, 2021 1:15 pm
Hi,
we recently switched from openkm 6.3.2 (windows installer, hsqldb) to openkm 6.3.9 (docker, mysql). Eveything works fine expect the file import where we are missing a couple of files having ampersands (R&D.pdf), etc.) in their filenames.
Exported Files (From Admin Panel):
This behaviour can simply be reproduced by starting openkm via docker
- add document 'R&D.pdf'
- edit 'R&D.pdf' (download filename is 'R&D.pdf')
- update 'R&D.pdf' (using file with original filename throws file not found error)
- update 'R&D.pdf' (using downloaded file with filename 'R&D.pdf' works)
I think tomcat didn't correctly en- or decoded the filenames. I've tried to add the tag URIEncoding="UTF-8" to all connectors in my server.xml and enable the setCharacterFilter ind web.xml as explained here https://javavids.com/video/apache-tomcat-utf-8 but without any changes.
Hopefully someone can help me with this Issue.
Best regards
jlg
we recently switched from openkm 6.3.2 (windows installer, hsqldb) to openkm 6.3.9 (docker, mysql). Eveything works fine expect the file import where we are missing a couple of files having ampersands (R&D.pdf), etc.) in their filenames.
Exported Files (From Admin Panel):
Code: Select all
-rw-r----- 1 root root 0 Jul 12 13:52 'R&D.pdf'
-rw-r----- 1 root root 663 Jul 12 13:52 'R&D.pdf.okm'Code: Select all
The problem is the difference between the filename and their database entry and can be solved by renaiming the files to "R\u0026amp;D.pdf" and "/okm:root/R\u0026amp;D.pdf" as stored in the database. After that the import works and the filename in openKM Desktop is correct 'R&D.pdf'. But if the file is downloaded its download name is 'R&D.pdf'. The Problem is Edit and Update of this file only works with this filename. Using a file named 'R&D.pdf' throws a file not found error.nano 'R&D.pdf.okm'
{"uuid":"fec594d8-2c52-4f21-8632-23fdbbbb2b55","author":"okmAdmin","name":"R\u0026amp;D.pdf","path":"/okm:root/R\u0026amp;D.pdf",...This behaviour can simply be reproduced by starting openkm via docker
Code: Select all
- Logindocker run --name openkm-ce -p 8080:8080 openkm/openkm-ce- add document 'R&D.pdf'
- edit 'R&D.pdf' (download filename is 'R&D.pdf')
- update 'R&D.pdf' (using file with original filename throws file not found error)
- update 'R&D.pdf' (using downloaded file with filename 'R&D.pdf' works)
I think tomcat didn't correctly en- or decoded the filenames. I've tried to add the tag URIEncoding="UTF-8" to all connectors in my server.xml and enable the setCharacterFilter ind web.xml as explained here https://javavids.com/video/apache-tomcat-utf-8 but without any changes.
Hopefully someone can help me with this Issue.
Best regards
jlg