Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- ubuntu:navidrome [2026/04/24 11:44] – [Installation der Pakete] Sebastian Hetzel
+++ ubuntu:navidrome [2026/07/29 22:28] (aktuell) – [Kennzahlen] Sebastian Hetzel
@@ Zeile 52: / Zeile 52: @@
 </code>
+==== Logrotate ====
+<file bash /etc/logrotate.d/navidrome>
+/var/log/navidrome.log
+{
+        rotate 14
+        daily
+        missingok
+        notifempty
+        delaycompress
+        compress
+        create 640 navidrome navidrome
+        postrotate
+                if service navidrome status > /dev/null 2>&1; then \
+                    touch /var/log/navidrome.log; \
+                    chown navidrome:navidrome /var/log/navidrome.log; \
+                    service navidrome restart > /dev/null 2>&1; \
+                fi;
+        endscript
+        sharedscripts
+}
+</file>
 ==== Daten wiederherstellen (bei Migration) ====
@@ Zeile 518: / Zeile 540: @@
 <IfModule mod_ssl.c>
 <VirtualHost *:443>
-    ServerName music.example.com
+        ServerName music.example.de
-    DocumentRoot /var/www/navidrome/html
+        ServerAlias music.example.net
+        DocumentRoot /var/www/navidrome/html
-    # Logs
+        ErrorLog /var/www/navidrome/logs/error.log
-    ErrorLog /var/www/navidrome/logs/error.log
+        CustomLog /var/www/navidrome/logs/access.log combined
-    CustomLog /var/www/navidrome/logs/access.log combined
-    # Proxy Settings
+        ProxyPreserveHost On
-    ProxyPreserveHost On
+        Protocols http/1.1
-    Protocols http/1.1   # HTTP/1.1 erzwingen für stabile Streaming-Verbindungen
+        #ProxyPass "/.well-known/" "!"
-    # WebSocket Support (Rewrites nur für Upgrade)
+        # WebSocket-Unterstützung
-    RewriteEngine On
+        RewriteEngine On
-    RewriteCond %{HTTP:Upgrade} =websocket [NC]
+        RewriteCond %{HTTP:Upgrade} =websocket [NC]
-    RewriteRule /(.*) ws://127.0.0.1:4533/$1 [P,L]
+        RewriteRule /(.*)           ws://127.0.0.1:4533/$1 [P,L]
-    # Normaler Proxy für alle anderen Requests
+        # Alles andere Proxy
-    ProxyPass / http://127.0.0.1:4533/ nocanon
+        ProxyPass / http://127.0.0.1:4533/ nocanon
-    ProxyPassReverse / http://127.0.0.1:4533/
+        ProxyPassReverse / http://127.0.0.1:4533/
-    # Forwarded Headers
+        RequestHeader set X-Forwarded-Proto "https"
-    RequestHeader set X-Forwarded-Proto "https"
+        RequestHeader set X-Forwarded-Port "443"
-    RequestHeader set X-Forwarded-Port "443"
+        RequestHeader set X-Forwarded-For "%{REMOTE_ADDR}s"
-    RequestHeader set X-Forwarded-For "%{REMOTE_ADDR}s"
+        Header always set X-XSS-Protection "1; mode=block"
-    # Connection / Timeout Optimierungen
+        KeepAlive On
-    KeepAlive On
+        MaxKeepAliveRequests 100
-    MaxKeepAliveRequests 100
+        KeepAliveTimeout 5
-    KeepAliveTimeout 5
+        ProxyTimeout 300
-    ProxyTimeout 300
-    # Security Headers
-    # X-XSS-Protection ist veraltet, kann optional drinbleiben oder entfernt werden
-    # Header always set X-XSS-Protection "1; mode=block"
-    Header always set X-Content-Type-Options "nosniff"
-    Header always set Strict-Transport-Security "max-age=31536000"
-    # SSL Certs
-    Include /etc/letsencrypt/options-ssl-apache.conf
-    SSLCertificateFile /etc/letsencrypt/live/music.example.com/fullchain.pem
-    SSLCertificateKeyFile /etc/letsencrypt/live/music.example.com/privkey.pem
+        Include /etc/letsencrypt/options-ssl-apache.conf
+        Include /etc/modsecurity/navidrome-exclusions.conf
+        SSLCertificateFile  /etc/letsencrypt/live/music.example.de/fullchain.pem
+        SSLCertificateKeyFile  /etc/letsencrypt/live/music.example.de/privkey.pem
+        Header always set Strict-Transport-Security "max-age=31536000"
 </VirtualHost>
 </IfModule>
@@ Zeile 582: / Zeile 597: @@
 | Test | DetectionOnly |
 | Produktion | On + gezielte Exclusions |
+===== Datenbank =====
+==== Tools ====
+<code |shell>
+sudo apt update
+sudo apt install sqlite3
+</code>
+==== Kennzahlen ====
+<code |bash>
+sqlite3 /var/lib/navidrome/navidrome.db
+</code>
+<code |sql>
+sqlite> select count(*) from media_file;
+sqlite> select count(*) from album;
+sqlite> SELECT COUNT(*) FROM artist;
+</code>