Direkt zum Hauptinhalt
Erweiterte Suche
Suchbegriffe
Inhaltstyp

Exakte Treffer
Schlagwort-Suchen
Datums Optionen
Aktualisiert nach
Aktualisiert vor
Erstellt nach
Erstellt vor

Suchergebnisse

405 Ergebnisse gesamt

Apache Reverse Proxy and Firewall

Inventar und Handbücher Teedy Installation and Configuration

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

Inventar und Handbücher Teedy Installation and Configuration

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

Inventar und Handbücher Teedy File and Document Processing

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

Inventar und Handbücher Teedy File and Document Processing

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

Inventar und Handbücher Teedy File and Document Processing

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

Inventar und Handbücher Teedy File and Document Processing

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

Inventar und Handbücher Teedy File and Document Processing

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

Inventar und Handbücher Teedy File and Document Processing

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

Inventar und Handbücher Teedy File and Document Processing

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

Inventar und Handbücher Teedy Installation and Configuration

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

Inventar und Handbücher Teedy Installation and Configuration

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

Inventar und Handbücher Teedy API Scripts / database queries

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

Inventar und Handbücher Teedy API Scripts / database queries

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

Inventar und Handbücher Teedy API Scripts / database queries

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

Inventar und Handbücher Teedy API Scripts / database queries

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

Inventar und Handbücher Teedy API Scripts / database queries

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

Inventar und Handbücher Teedy API Scripts / database queries

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

Inventar und Handbücher Teedy API Scripts / database queries

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

Inventar und Handbücher Teedy API Scripts / database queries

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

Inventar und Handbücher Teedy API Scripts / database queries

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 -...