Erweiterte Suche
Suchergebnisse
405 Ergebnisse gesamt
Apache Reverse Proxy and Firewall
Install apache2 sudo apt install apache2 Activate modules sudo a2enmod headers rewrite proxy proxy_html proxy_http ssl vhost_alias Apache Reverse Proxy Configuration sudo vim /etc/apache2/sites-available/dms.yourdomain.de_httpd.conf <VirtualHost YOURPUBL...
Teedy with PostgreSQL
Teedy 1was tested sucessfully with PostgreSQL Version 16 and lower Install and configure PostgreSQL Teedy requires at least PSQL 9.4 (PostgreSQL94Dialect) PostgreSQL 10 and upwards are configured to deliver SSL by standard! You will need to configure it's S...
Manually fix broken document relations in database
Find documents which have relations to other documents which already were deleted Sometimes documents link to other documents but the links are invalid because the linked document is not available anymore. We can manually reset those links only because there ...
Icons in document titles
Inside Teedy we can use funny icons, if we know the correct Unicode number. Copy + Paste. Just select the one's you need and paste them into Teedy. It works for title and description ☀ ☁ ☂ ☃ ☄ ★ ☆ ☇ ☈ ☉ ☊ ☋ ☌ ☍ ☎ ☏ ☐ ☑ ☒ ☓ ☔ ☕ ☖ ☗ ☘ ☙ ☚ ☛ ☜ ☝ ☞ ☟ ☠ ☡ ☢ ☣ ...
Fix Preview Bug
In case the file preview is erroneous/empty but the file can be processed and it can be downloaded by URL like https://dms.yourdomain.de/api/file/:FILE_ID/data: Root Cause: unkown. Seems to happen after migration from H2 to PostgreSQL Fixing proposal Remo...
Grafana Monitoring / Statistics
Description A Grafana monitoring dashboard for Teedy (Sismics Docs) statistics. Helpful to have a look over security things and the effort you put in your instance. Please check if this is okay for your own use - regarding privacy protection of the mates work...
Check index integrity / recompute quota
Sometimes the used space is wrong and may look like this: See also: https://github.com/sismics/docs/issues/345 Checks on file system cd /var/docs/ find ./ -type f -name '*' -exec du -ch {} + | grep total$ find ./ -type f -name '*_web' -exec du -ch {}...
Importer for Windows
The Bulk file importer tool is based on NodeJS Documentation also available under https://github.com/sismics/docs/tree/master/docs-importer Download the importer See Downloads for recent compiled setups. The importer can be also downloaded at Github. ...
Optical Character Recognition (OCR) and Scanning
Handling OCR data is stored in Teedy database table t_file which containts the string column fil_content_c. In H2 the data is stored als plaintext string. In PostgreSQL the column is filled as datatype ::text. A normal select returns number. The unecrypted OC...
Basic installation with Jetty and H2 Database
Install Required Software #install a lot of stuff sudo apt update sudo apt install tesseract-ocr tesseract-ocr-deu tesseract-ocr-eng libtesseract-dev ffmpeg mediainfo mediainfo-gui openjdk-11-jdk #install Jetty Web Server sudo apt install jetty11 #...
Build web application server from Source
This short tutorial shows how to build Teedy. Finally you will get a ready-to-deploy dms.war java archive file. Pre-Requisites sudo add-apt-repository ppa:openjdk-r/ppa sudo apt update sudo apt install openjdk-11-jdk maven npm jetty11 sudo ln -s /usr/b...
Auto-delete guest comments
In case you have a guest login enabled and don't want to accept guest spamming you can prevent it using the following bash script with cron trigger (running every 10 minutes). Guest comments are even useless because each guest can delete the guest commen...
Auto-delete guest documents
In case you have a guest login enabled and don't want to accept guest spamming you can prevent it using the following bash script with cron trigger (running every 10 minutes). Guest documents are even useless because each guest can delete the guest documents ...
Auto-delete guest tags
In case you have a guest login enabled and don't want to accept guest spamming you can prevent it using the following bash script with cron trigger (running every 10 minutes). Guest tags are even useless because each guest can delete the guest tags from anothe...
Change owner of tags/files/documents
Within Teedy, there is no function to change the owner of a document. So we cannot transfer docs from one user to another. In case we want to keep documents in the system, we may not delete the author of the document. We can only deactivate the user. Under so...
Undelete document
Once a document was deleted, we can restore most information except document files: SELECT * FROM t_document WHERE doc_id_c = 'b9a538d2-906f-4566-b00d-ee4aa70d8ff8'; UPDATE t_document SET doc_deletedate_d = NULL WHERE doc_id_c = 'b9a538d2-906f-4566-b00d-ee...
Scan for users without groups
To have better control about users, which logged in first time by LDAP and did not get mapped to default group, we use some SQL / bash script to inform the webmaster about that: vim /opt/teedy-unmapped-users.sh #!/bin/bash #check for new users which have be...
Create new documents which act as collectors
This is an example for document names with german titles. We call this script once per month to automatically create new documents. We can use https://crontab.guru/ to generate a time schedule. vim /etc/cron.d/teedy-prepare-monthly.sh SHELL=/bin/sh PATH=/us...
Find ugly document titles
This statement looks for titles with unrequired whitespace duplicates /*title which contain doubled whitespaces*/ SELECT doc_title_c FROM t_document WHERE LENGTH(RTRIM(LTRIM(doc_title_c))) <> LENGTH(doc_title_c) OR doc_title_c LIKE '% %' AN...
Reindex / index repairing script
This script is for use as cron for example. By teedy username and password #!/bin/bash BASE_URL="https://dms.yourdomain.de" AUTH_TOKEN=$(curl -i -X POST -d username="username" -d password="password" "$BASE_URL/api/user/login" -k|grep "auth_token"|cut -...