net-addicts - Wiki
https://doku.net-addicts.de/
2026-07-06T04:45:56+0200net-addicts - Wiki
https://doku.net-addicts.de/
https://doku.net-addicts.de/lib/tpl/dokuwiki/images/favicon.icotext/html2025-07-24T18:28:20+0200Marcel Blenkers (marcel@undisclosed.example.com)Exim4: Kleines Mailqueue HowTo
https://doku.net-addicts.de/exim4?rev=1753374500&do=diff
Exim4: Kleines Mailqueue HowTo
Mails die im Queue warten anzeigen lassen
mailq
oder
exim4 -bp
Tabelle des Mailqueues aufrufen
mailq | exiqsumm
Anzahl der Mails im Queue ausgeben
exim4 -bpc
Mails die Serverintern ausgeliefert werden sollen verschickentext/html2023-11-23T16:54:13+0200Marcel Blenkers (marcel@undisclosed.example.com)MySQL Connection Abfrage
https://doku.net-addicts.de/mysql_connection?rev=1700754853&do=diff
MySQL Connection Abfrage
SELECT
tmp.ipAddress,
-- Calculate how many connections are being held by this IP address.
COUNT( * ) AS ipAddressCount,
-- For each connection, the TIME column represent how many SECONDS it has been in
-- its current state. Running some aggregates will give us a fuzzy picture of what
-- the connections from this IP address is doing.
FLOOR( AVG( tmp.time ) ) AS timeAVG,
MAX( tmp.time ) AS timeMAX
FROM
-- Let's create an intermediary table that inc…text/html2023-11-23T16:54:01+0200Marcel Blenkers (marcel@undisclosed.example.com)MySQL
https://doku.net-addicts.de/tag:mysql?rev=1700754841&do=diff
MySQL
Folgendes gibt es im Bereich MySQL:
kategorietext/html2023-10-30T17:08:25+0200Marcel Blenkers (marcel@undisclosed.example.com)ssh config
https://doku.net-addicts.de/ssh_config?rev=1698682105&do=diff
ssh config
Host *
User blenkers
IdentityFile /home/marcel/.ssh/id_rsa
PubkeyAcceptedKeyTypes +ssh-rsa
#HostKeyAlgorithms +ssh-dss
HostKeyAlgorithms +ssh-rsa,ssh-dss
KexAlgorithms +diffie-hellman-group1-sha1
Host jitsi
HostName jitsi.net-addicts.de
User root
Port 22898
IdentityFile /home/marcel/.ssh/id_rsa
Host netback
HostName backup.net-addicts.de
User root
Port 22898
IdentityFile /home/marcel/.ssh/id_rsa
Host mail
H…text/html2016-03-06T21:28:09+0200Marcel Blenkers (marcel@undisclosed.example.com)Postfix relay gmail
https://doku.net-addicts.de/postfix_relay_gmail?rev=1457296089&do=diff
Postfix relay gmail
relayhost = [smtp.gmail.com]:587 smtp_sasl_auth_enable = yes smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd smtp_sasl_security_options = noanonymous smtp_tls_CAfile = /etc/postfix/cacert.pem smtp_use_tls = yes
sasl_passwd