http://fortytwo.adurias.org/ 2026-04-11T19:30:51+00:00 http://fortytwo.adurias.org/ http://fortytwo.adurias.org/_media/wiki/dokuwiki.svg text/html 2017-08-24T05:44:51+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/active-directory-step-by-step-guides?rev=1503553491&do=diff Active Directory Step-by Step-Guides <http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/directory/activedirectory/stepbystep/default.mspx> kb windows active-directory text/html 2023-09-03T08:13:21+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/add-socks5-proxy-to-sshconfig?rev=1693728801&do=diff Add socks5 proxy to .ssh/config $ cat .ssh/config Host ssh-proxy Hostname ssh-proxy.domain.net DynamicForward 9999 Host ssh-host-with-proxy Hostname host.domain.com ProxyCommand nc -x localhost:9999 %h %p $ ssh ssh-proxy [ ... ] <new terminal> $ ssh ssh-host-with-proxy [ ... ] # Alternative with SSH in Background $ ssh -f -N ssh-proxy [ ... ] <same terminal> $ ssh ssh-host-with-proxy [ ... ] text/html 2018-08-23T08:38:28+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/android-calendar?rev=1535013508&do=diff Android calendar events shown outlined not solid Caused by appointment acceptance - deactivate “Sync Attendees” in CalDAV or take care that the acceptence state is correct. kb android text/html 2018-06-05T13:27:23+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/apache-mod_ldap-ad?rev=1528205243&do=diff Apache mod_ldap with Active Directory Authentication AuthName "AD Authentication" AuthType Basic AuthBasicProvider ldap AuthLDAPUrl ldap://domain.com:389/dc=domain,dc=com?sAMAccountName?sub?(objectClass=User) AuthLDAPBindDN "ldap_userj@domain.com" AuthLDAPBindPassword "secret" LDAPReferrals off require ldap-group CN=group name,OU=ou2,OU=ou1,DC=domain,DC=com text/html 2021-06-12T09:02:20+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/arpspoof?rev=1623488540&do=diff Arpspoof #!/bin/bash victim=192.168.18.100 gw=192.168.18.254 echo 1 > /proc/sys/net/ipv4/ip_forward iptables -I FORWARD -j ACCEPT arpspoof -t $victim $gw & arpspoof -t $gw $victim & kb linux text/html 2017-08-21T17:16:02+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/banana-pi-r1-stop-green-led-from-blinking?rev=1503335762&do=diff Banana-PI-R1: Stop green LED from blinking root@pi:~# grep led /etc/rc.local # stop green led from blinking echo none > /sys/class/leds/green\:ph24\:led1/trigger kb linux banana-pi text/html 2017-08-21T17:16:40+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/banana-pi-r1-vlan-configuration-script?rev=1503335800&do=diff Banana PI-R1: VLAN Configuration Script #!/bin/sh #---------------------------# # BPI-R1 VLAN configuration # #---------------------------# # # This will create the following ethernet ports: # - eth0.101 = WAN (single port) # - eth0.102 = LAN (4 port switch) # # The swconfig port number are: # |2|1|0|4| |3| # (looking at front of ports) # # You have to adjust your /etc/network/interfaces # ifconfig eth0 up swconfig dev eth0 set reset 1 swconfig dev eth0 set enable_vlan 1 swconfig dev et… text/html 2022-07-15T06:24:51+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/bind9-pinpoint-zone?rev=1657866291&do=diff DNS Pinpoint Zone with Bind9 Add zone definition to /etc/bind/named.conf.local zone "somehost.domain.tld" { notify no; type master; file "/etc/bind/somehost.domain.tld.zone"; }; Create pinpoint zone file /etc/bind/somehost.domain.tld.zone text/html 2021-07-10T09:09:00+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/checkpoint-mobile-command-line?rev=1625908140&do=diff Check Point Mobile (trac.exe) command line arguments Connect using preconfigured site, P12 File and password # This is powershell $VPNSite="gw.site.com" $VPNP12File="C:\User.p12" $VPNP12Password='sec ret' cd "C:\Program Files (x86)\Checkpont\Endpoint Connect" .\trac connect -s $VPNSite -f $VPNP12File -p $VPNP12Password text/html 2024-03-30T08:24:37+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/cisco-cheat-sheet?rev=1711787077&do=diff CISCO Cheat Sheet Configure SPAN Port Capture Traffic for VLAN configure terminal monitor session 1 source vlan 10 monitor session 1 destination interface gi7 Capture Traffic from specific interface configure terminal monitor session 1 source interface gi8 monitor session 1 destination interface gi7 text/html 2017-09-11T13:49:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/clamav-whitelist-signatures?rev=1505137758&do=diff ClamAV Signature Whitelisting <https://www.clamav.net/documents/how-do-i-ignore-whitelist-a-clamav-signature> $ cat /var/lib/clamav/local_whitelist.ign2 Signature1.Ignore Signature2.Ignore Signature3.Ignore kb linux clamav text/html 2017-12-03T10:35:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/configure-smbclient-for-smbv2?rev=1512297318&do=diff Configure (lib)smbclient for SMBv2 Specify in $HOME/.smb/smb.conf: [global] client min protocol = SMB2 client max protocol = SMB3 client NTLMv2 auth = yes Successfully tested with Kodi and Mint 17.2 kb linux samba smbclient text/html 2017-11-13T16:34:37+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/create-custom-debian-live-usb-stick-stretch?rev=1510590877&do=diff Create custom debian live usb-stick (stretch, amd64) Install necessary packages on the build system root@host:~# apt-get install debootstrap syslinux isolinux squashfs-tools genisoimage memtest86+ rsync [ ... ] Create directory structure & install base image text/html 2019-04-20T08:10:43+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/create-custom-debian-live-usb-stick-uefi?rev=1555747843&do=diff Create custom debian live usb-stick (uefi / bios dual boot) Install necessary packages on the build system root@host:~# apt-get install debootstrap squashfs-tools rsync xorriso grub-pc-bin grub-efi-amd64-bin mtools [ ... ] Create directory structure & install base image text/html 2017-09-08T17:31:27+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/create-custom-debian-live-usb-stick?rev=1504891887&do=diff Create custom debian live usb-stick (jessie) Updated Version for Debian Stretch Install necessary packages on the build system root@host:~# apt-get install debootstrap syslinux isolinux squashfs-tools genisoimage memtest86+ rsync dosfstools Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: mtools syslinux-common Suggested packages: wodim cdrkit-doc hwtools memtester kernel-patch-badram memtest86… text/html 2017-08-24T05:14:28+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/db2-32bit-odbc-windows78-64bit?rev=1503551668&do=diff Installation des DB2 ODBC 32bit Treibers unter Windows 7 bzw. 8 64bit * Download des “Driver for ODBC and CLI (32-bit)” Pakets von <http://www-01.ibm.com/support/docview.wss?uid=swg27016878> - IBM ID erforderlich. * Entpacken nach “C:\Program Files (x86)\IBM\clidriver” * Die folgenden Schritte unbedingt aus einer text/html 2022-06-17T07:18:09+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/decode-utf8-mail-subject?rev=1655450289&do=diff Decode UTF-8 & Base64 Mail Subject Input: Subject:=?utf-8?B?44CQIFdpY2h0aWdlIEluZm9ybWF0aW9uZW7jgJE=?= Take the string from the 2nd “?” to the last “?” - in this case 44CQIFdpY2h0aWdlIEluZm9ybWF0aW9uZW7jgJE= and paste it into <https://www.base64decode.org/> - Hit Decode text/html 2017-11-05T10:53:50+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/default-workgroup-for-smbclient?rev=1509879230&do=diff Default workgroup for smbclient Create the file $HOME/.smb/smb.conf with the following contents: [global] workgroup = MYWORKGROUP Taken from the libsmbclient documentation: " When libsmbclient is invoked by an application it searches for a directory called .smb in the $HOME directory that is specified in the users shell environment. It then searches for a file called smb.conf which, if present, will fully over-ride the system /etc/samba/smb.conf file. If instead libsmbclient finds a f… text/html 2020-11-22T17:17:13+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/dhcp-client-dns?rev=1606065433&do=diff Override DNS Settings when using dhclient root@dns01:/etc/dhcp# grep ^supersede /etc/dhcp/dhclient.conf supersede domain-name-servers 127.0.0.1; supersede domain-name "domain.local"; kb linux network dhcp text/html 2022-05-29T15:50:17+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/disconnect-and-reconnect-network-adapter?rev=1653839417&do=diff Disconnect and Reconnect Network Adapter set ADAPTER=Ethernet0 powershell "&{ Disable-NetAdapter %ADAPTER% -Confirm:$False; Sleep 30; Enable-NetAdapter %ADAPTER% -Confirm:$False }" kb windows powershell text/html 2022-07-15T06:25:01+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/dnsmasq?rev=1657866301&do=diff dnsmasq Stuff Resolution Problems Symptoms * Resolution does not work from other subnets than the one, the dnsmasq host is located in Confirmation * Log entry “Ignoring query from non-local network” Resolution * Remove “--local-service text/html 2020-04-25T16:48:12+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/docker-config?rev=1587833292&do=diff Docker Configuration via /etc/docker/daemon.json Prevent Creation of dynamic iptables rules, disable userland proxy { "iptables": false, "ip-masq": false, "userland-proxy": false } Create iptables rules manually iptables -A FORWARD -s $dockernetwork -m tcp -p tcp -m conntrack --ctstate NEW -j ACCEPT text/html 2024-09-14T08:22:24+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/docker-debian?rev=1726302144&do=diff Docker Installation on Debian sudo apt-get update && \ sudo apt-get -y install ca-certificates curl gnupg && \ sudo install -m 0755 -d /etc/apt/keyrings && \ sudo curl -fsSL https://download.docker.com/linux/debian/gpg | sudo gpg --dearmor -o /etc/apt/keyrings/docker.gpg && \ sudo chmod a+r /etc/apt/keyrings/docker.gpg && \ echo \ "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.gpg] https://download.docker.com/linux/debian \ $(. /etc/os-release && echo "$VERSION_… text/html 2020-04-25T16:47:57+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/docker-lvm?rev=1587833277&do=diff Docker & LVM <https://docs.docker.com/storage/storagedriver/device-mapper-driver/#configure-direct-lvm-mode-for-production> Install prerequisites apt-get install -y lvm2 thin-provisioning-tools && reboot Set variables export device=/dev/xvdf export vgname=docker export lvname=thinpool Create physical Volume pvcreate $device Create volume group text/html 2024-02-06T08:18:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/docker-rhel9?rev=1707207498&do=diff Docker Installation on RHEL (Red Hat Enterprise Linux) Installation Copied from: <https://www.linkedin.com/pulse/step-by-step-guide-installing-docker-rhel-9-locally-ujjawal-kumar> * sudo yum update * sudo yum remove docker \ docker-client \ docker-client-latest \ docker-common \ docker-latest \ docker-latest-logrotate \ docker-logrotate \ docker-engine text/html 2017-08-21T17:13:46+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/duplicity?rev=1503335626&do=diff duplicity Installation * Download from <http://duplicity.nongnu.org/> * Unpack & build – python setup.py build – several libraries + development tools are necessary * To install use “python setup.py install” * To run duplicity the following packages are required: librsync1 python-boto python-lockfile python-setuptools text/html 2017-09-16T10:09:22+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/e2fsck-metatdata_csum-error?rev=1505556562&do=diff e2fsk - metadata_csum error To remove the metadata_csum feature from a filesystem use the following command: e2fsck -f $FS tune2fs -O ^metadata_csum $FS e2fsck -f $FS When booting from such a filesystem, the initrd may complain about incompatible feature flag found - needs to be fixed by fsck in the initrd. text/html 2020-11-08T11:41:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/elasticsearch-tls?rev=1604835694&do=diff Configure Elasticsearch/Kibana for TLS and Authentication Create Certificates * Shutdown elk-cluster * Add certificate path to elasticsearch config in docker-compose.yml services: elasticsearch: volumes: - ./certs:/certs * Start elasticsearch text/html 2021-08-29T09:33:40+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/elasticsearch?rev=1630229620&do=diff Elasticsearch Cheat Sheet update_by_query POST /index/_update_by_query { "script": "ctx._source.field = 'correct value'", "query": { "term": { "field": "wrong value" } } } backup Add backup directory to repository $ grep backup /srv/elk/elasticsearch/config/elasticsearch.yml path.repo: [ "/backup" ] text/html 2017-08-22T06:22:41+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/exim-und-smtp-authentication-via-imap?rev=1503382961&do=diff EXIM und SMTP Authentication via IMAP Nachdem der externe Zugriff auf die IMAP Boxen eingerichtet ist, ging es nun darum, wie man den Externen den Mailversand über den öffentlichen Mailserver ermöglichen konnte. Folgende Dinge sollten dabei erreicht werden: text/html 2017-08-21T17:12:01+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/fix-missing-menu-in-workstation-on-linux-mint?rev=1503335521&do=diff Fix missing menu in VMware Workstation on Linux Mint To fix this error: add the following line export VMWARE_USE_SHIPPED_GTK="yes" to the file /etc/vmware/bootstrap kb linux vmware mint text/html 2017-11-12T18:31:00+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/fix-twrp-boot-loop?rev=1510511460&do=diff Fixing TWRP boot loop on Wileyfox Swift Situation LineageOS 14.1 installed, TWRP 3.0.0 installed, phone working properly. After an OTA update gone wrong, the phone did not boot into system but only into TWRP recovery. 1st Try Based on <https://www.reddit.com/r/LineageOS/comments/5riech/how_fix_twrp_recovery_boot_loop_after_lineageos/> the first try was to install a newer version of TWRP. This resulted in the phone unable to boot at all. text/html 2025-12-09T17:30:07+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/git?rev=1765301407&do=diff GIT Cheat Sheet Remote Repository hinzufügen remote# git init --bare /srv/git/repositories/$reponame local$ git init local$ git add .. local$ git commit local$ git remote add origin https://git.domain.com/$reponame local$ git push --set-upstream origin master text/html 2023-10-07T07:26:26+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/github-api?rev=1696663586&do=diff Github API Releases Get Download Link for latest release of a given repository url=$(curl -s https://api.github.com/repos/${USER}/${REPOSITORY}/releases/latest \ | jq -r '.assets[0].browser_download_url') Get Download Link for a tagged release of a given repository text/html 2025-09-11T07:44:58+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/gitlab?rev=1757576698&do=diff Gitlab Check Background Migrations from CLI gitlab-psql -c "SELECT job_class_name, table_name, column_name, job_arguments FROM batched_background_migrations WHERE status NOT IN(3, 6);" Garbage Collection Container Registry gitlab-ctl registry-garbage-collect -m text/html 2017-08-24T05:45:12+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/how-to-view-and-_dows-server-2003?rev=1503553512&do=diff How to view and transfer FSMO roles in Windows Server 2003 <http://support.microsoft.com/kb/324801/en-us> kb windows server 2003 active-directory text/html 2017-08-22T06:22:57+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/imaps-proxy-mit-perdition?rev=1503382977&do=diff IMAPS Proxy mit Perdition Ich hatte die Herausforderung, IMAP Mailboxen, die auf einem Server hinter der Firewall liegen und lokal bzw. über Webmail erreichbar waren auch nativ über IMAPS im Internet anzubieten. Ich sträubte mich gegen das stupide Port-Forwarding des IMAP Ports vom externen Interface der Firewall auf den Mailserver und entschied mich für den Einsatz eines IMAP Proxies – die Wahl fiel auf text/html 2021-05-05T05:01:30+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/install-ubuntu-18.04-pxe?rev=1620190890&do=diff Unattended Installation of Ubuntu Server 18.04 via PXE Preface export P=/ubuntu/18.04 export TFTPROOT=/var/lib/tftp export WEBROOT=/var/lib/www/html export HTTP_URL=http://192.168.1.1 Directory Structure mkdir -p $TFTPROOT/$P mkdir -p $WEBROOT/$P text/html 2017-08-22T05:57:48+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/installation-maxdb-7-5-0-26-auf-debian-6-0-squeeze?rev=1503381468&do=diff Installation MaxDB 7.5.0.26 auf Debian 6.0 (squeeze) Die Installation einer älteren Version von MaxDB in meinem Fall 7.5.0.26 für Linux, hat so ihre Tücken, zumal Debian nicht unbedingt zu den bevorzugten Plattformen der SAP zählt. Der erste Stolperstein ist eine in Debian 6.0 nicht mehr verfügbare Version libstdc++2.10 Unangenehmerweise beschwert sich erst “dbmcli” in einem späteren Schritt der Installation, das etwas nicht passt und dann ist es schon zu spät, denn selbst nach der Nachinstall… text/html 2022-05-28T08:40:58+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/ip-address-watchdog?rev=1653727258&do=diff Simple IP-Address Watchdog $ crontab -l @reboot /usr/bin/sleep 60 && /usr/bin/curl -kso /dev/null https://domain.com/watchdog?hostname=$(hostname)\&address=$(/usr/sbin/ip -4 route get 1.0.0.0 | /usr/bin/awk '/dev/ { print $7 }') Results are seen in the access.log of the webserver placed in the curl call text/html 2017-08-22T05:59:55+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/jdownloader2-on-raspbian-and-ffmpeg-issue?rev=1503381595&do=diff JDownloader2 on Raspbian and FFmpeg Issue To fix the “FFmpeg is missing” issue arising when downloading 1080p Videos from Youtube, firstly install libav-tools + dependencies root@ef2085fe0fed:~# apt-get update; apt-get install libav-tools text/html 2019-12-29T11:26:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/jpgraph-antialiasing-error?rev=1577618778&do=diff Fix JpGraph Error 25128 on Debian Systems 1. Download this file to the “src/” directory --- gd_image.inc.orig 2019-12-29 12:08:59.320754190 +0100 +++ gd_image.inc.php 2019-12-29 12:21:49.570063291 +0100 @@ -106,10 +106,12 @@ $this->use_anti_aliasing = $aFlg; if( function_exists('imageantialias') ) { imageantialias($this->img,$aFlg); - } + } +/* Do not throw exception if function "imageantialias" does not exist else { JpG… text/html 2022-07-15T07:30:23+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/kali-no-gui?rev=1657870223&do=diff Debian based Systems GUI vs. No-Gui Switch Kali/Debian/Ubuntu Linux to No-Gui Mode: $ sudo systemctl set-default multi-user.target $ sudo reboot Switch Kali/Debian/Ubuntu Linux to Gui-Mode: $ sudo systemctl set-default graphical.target $ sudo reboot text/html 2017-08-22T06:42:41+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/kodi-json-rpc-interface?rev=1503384161&do=diff Kodi JSON-RPC Interface Access interface $ telnet kodi-host 9090 Initiate video library scan for specific directory { "jsonrpc": "2.0", "method": "VideoLibrary.Scan", "params": { "directory": "smb://server/share/Directory/Subdirectory" }, "id": "test" } text/html 2022-08-10T16:30:55+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/letsencrypt-java?rev=1660149055&do=diff letsencrypt & JAVA Seit 3.12.2015 befindet sich letsencrypt.org in der offenen Beta Phase, das heißt, es gibt Zertifikate für alle. Leider fehlt das Root Zertifikat, mit dem das CA Zertifikat der Intermediate CAs, die die Zertifikate dann letztendlich ausstellen im Default JAVA Truststore. Das kann aber geändert werden: text/html 2022-01-29T10:27:59+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/linux-packet-forwarding?rev=1643452079&do=diff Linux Packet Forwarding Basic outgoing masquerding script #!/bin/bash network=192.168.3.0/24 ext_if=eth0 ext_ip=$(ip address show $ext_if | awk -F "[ /]" '/inet / { print $6 }') # Turn off forwarding echo 0 > /proc/sys/net/ipv4/ip_forward # Create NAT rule iptables -t nat -I POSTROUTING -s $network -o $ext_if -j SNAT --to-source $ext_ip # Create FW rules to allow traffic iptables -I FORWARD -s $network -j ACCEPT iptables -I FORWARD -m conntrack --ctstate ESTABLISHED -j ACCEPT # Turn on forwa… text/html 2017-08-22T06:03:33+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/logwatch?rev=1503381813&do=diff Logwatch no http/404/errors in log $ cat /etc/logwatch/conf/services/http.conf # do not print all the 404 errors $http_rc_detail_rep_404 = 20 hostname in output $ grep hostname /etc/cron.daily/00logwatch /usr/sbin/logwatch --output mail --hostname host.domain.com text/html 2017-09-08T13:02:06+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/microsoft-sql-server-user-einem-login-zuordnen?rev=1504875726&do=diff Microsoft SQL Server – User einem Login zuordnen Alte Version – wird mit SQL Server 2012 noch unterstützt: USE [dbname]; GO EXEC sp_change_users_login 'Update_One' 'dbuser' 'login'; GO <http://msdn.microsoft.com/en-us/library/ms174378.aspx> Neue Version: USE [dbname]; GO ALTER USER dbuser WITH LOGIN = login; GO text/html 2017-08-22T06:05:01+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/mkv-in-mp4-umwandeln-mit-avconv?rev=1503381901&do=diff MKV in MP4 umwandeln mit avconv Wenn es nur darum geht, den Containertyp von MKV auf MP4 zu ändern, hilft folgende commandline $ avconv -i FILENAME.mkv -c:v copy -c:a copy FILENAME.mp4 kb linux avconf text/html 2017-09-01T08:16:21+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/msda-effective-policy?rev=1504253781&do=diff Show effective DNS resolution policy in Microsoft Direct Access C:\>netsh namespace show effectivepolicy Only works when not connected to company network kb windows direct-access text/html 2020-11-23T15:16:57+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/msmtp-and-cron?rev=1606144617&do=diff MSMTP and Cron Ohne Patch kommen Mails vom Cron Daemon mit folgender From Zeile an: From: root (Cron Daemon) und werden dann gern mal vom Mailserver nicht angenommen. Folgender Patch behebt das: # mv /usr/bin/msmtp /usr/bin/msmtp.bin && \ cat << EOF > /usr/bin/msmtp #!/bin/bash /bin/sed -e "s/root .Cron Daemon./Cron Daemon \<root@\$(/bin/hostname -f)\>/" | /usr/bin/msmtp.bin "\$@" EOF && \ chmod +x /usr/bin/msmtp text/html 2024-09-06T16:20:55+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/mysql-useful-commands?rev=1725639655&do=diff MySQL useful commands User & Permissions Create Database User CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; Delete Database User DROP USER 'username'@'localhost'; Grant Permissions GRANT ALL privileges ON dbname.* TO 'username'@'localhost'; FLUSH privileges; text/html 2022-10-22T09:50:51+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/netfilter?rev=1666432251&do=diff Linux Netfilter Useful commands Get list of netfilter tables # nft list tables ip | awk '{ print $3 }' filter nat mangle raw Get list of netfilter chains # nft list table ip filter | awk '/\tchain/ { print $2 }' INPUT FORWARD OUTPUT LOCAL-BLOCK-DROP LOG-ACCEPT LOG-DROP BOGUS-DROP BOGUS text/html 2025-06-23T04:45:50+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/netshoot?rev=1750653950&do=diff Netshoot (Troubleshooting Networking Issues with Docker Repository Image Basic Usage Start Container with Network Namespace of a running container docker run -it --net container:<container_name> nicolaka/netshoot Start Container with Host Network Namespace docker run -it --net host nicolaka/netshoot text/html 2023-10-07T07:27:07+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/nextcloud?rev=1696663627&do=diff Nextcloud WebDAV WebDAV Uploads mit Shared Files * Leeres File mit richtigem Namen uploaden * Dieses File sharen mit “Allow Editing” * Token aus Share Link extrahieren (Url: <https://cloud.domain.com/index.php/s/abcdefghijklmno> -> Token: abcdefghijklmno) * Upload File curl -T /local/path/file.ext --user <token>: https://cloud.domain.com/public.php/webdav text/html 2023-04-28T05:07:36+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/noscript?rev=1682658456&do=diff NoScript sat1.at * sim-technik.de * tiqcdn.com * p7s1.com * glomex.com * sat1.at atv.at * atv.at * 71i.de * akamai.com * p7s1.io * p7s1video.net * zomap.de sat1.at * sat1.at * 71i.de * akamai.com * akamaized.net * text/html 2025-12-09T17:30:24+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/openldap?rev=1765301424&do=diff OpenLDAP Cheat Sheet Output ACLs ldapsearch -Y EXTERNAL -H ldapi:// -o ldif-wrap=no -b "olcDatabase={1}mdb,cn=config" olcAccess Output entire config ldapsearch -Y EXTERNAL -H ldapi:// -o ldif-wrap=no -b "cn=config" kb text/html 2025-12-09T17:30:38+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/openssl?rev=1765301438&do=diff OpenSSL Cheat Sheet Zertifikat anzeigen openssl x509 -text -noout -in $certfile CSR anzeigen openssl req -text -noout -in $csrfile Self Signed Zertifikat erzeugen (one liner) openssl req -x509 -nodes -days 365 -subj '/C=AT/ST=/L=/O=/OU=/CN=' -sha256 -newkey rsa:2048 -keyout $keyfile -out $certfile text/html 2017-08-25T10:59:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/owncloud-mint?rev=1503658754&do=diff Owncloud Client & Linux Mint Icon not visible in Tray Area Set the startup delay to 20 seconds. kb linux mint text/html 2023-04-28T05:10:12+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/pdftk?rev=1682658612&do=diff Common usecases for some tools exiftool rename files to creation date/copy number/lowecase extensions exiftool '-filename<CreateDate' -d %Y%m%d_%H%M%S%%-c.%%le -ext jpg -r /mnt/Drive/Folder/ pdftk Attach files to PDF file pdftk in.pdf attach_files ^ file1.txt ^ file2.txt ^ file3.txt ^ output out.pdf text/html 2022-11-20T09:19:50+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/powershell?rev=1668935990&do=diff Useful Powershell Commands Get Systemboot/Reboot/Shutdown Events Get-EventLog System -Newest 10000 | ` Where EventId -In 41,1074,1076,6005,6006,6008,6009,6013 | ` Format-Table TimeGenerated,EventId,UserName,Message -AutoSize -Wrap text/html 2018-10-07T06:34:54+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/putty-and-line-characters?rev=1538894094&do=diff PuTTY Line Characters export NCURSES_NO_UTF8_ACS=1 or export TERM=linux pageant "C:\Program Files (x86)\Utilities\pageant.exe" C:\ssh.ppk kb linux windows putty text/html 2017-08-22T06:21:45+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/restartable-sha256deep?rev=1503382905&do=diff Restartable sha256deep Create checksums find . -type f > /tmp/filelist while read file; do if ! fgrep "$file" incomplete.sha256; then echo "$file" sha256sum "$file" >> incomplete.sha256 fi done < /tmp/filelist Verify checksums text/html 2017-08-22T06:27:23+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/retrieve-windows-key-from-acpi-tables-in-linux?rev=1503383243&do=diff Retrieve Windows Key from ACPI tables in linux $ sudo xxd /sys/firmware/acpi/tables/MSDM 00000000: 4d53 444d 5500 0000 03c5 4c45 4e4f 564f MSDMU.....LENOVO 00000010: 5450 2d47 4a20 2020 7022 0000 5054 4543 TP-GJ p"..PTEC 00000020: 0200 0000 0100 0000 0000 0000 0100 0000 ................ 00000030: 0000 0000 1d00 0000 324d 504b 4e2d 4236 ........2****-B* 00000040: 3438 322d 424b 4356 392d 3637 4758 432d ***-B****-6****- 00000050: 5732 5042 43 text/html 2017-08-24T05:17:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/retrieve-windows-key-from-registry?rev=1503551876&do=diff Retrieve Windows Key from Registry Set WshShell = CreateObject("WScript.Shell") MsgBox ConvertToKey(WshShell.RegRead("HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\DigitalProductId")) Function ConvertToKey(Key) Const KeyOffset = 52 i = 28 Chars = "BCDFGHJKMPQRTVWXY2346789" Do Cur = 0 x = 14 Do Cur = Cur * 256 Cur = Key(x + KeyOffset) + Cur Key(x + KeyOffset) = (Cur \ 24) And 255 Cur = Cur Mod 24 … text/html 2017-08-22T11:44:45+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/robocopy-und-uc4?rev=1503402285&do=diff Robocopy und UC4 Eine unangenehme Eigenschaft von Robocopy – seine Returncodes, die als Bitmaske ausgeprägt sind – wenn überhaupt ein File kopiert wurde ist der RC = 1. UC4 behandelt in der Standardeinstellung alle Exit-Codes > 0 als ENDED_NOT_OK. text/html 2017-08-22T06:34:03+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/rsyslogd-logs-action-action-nn-suspended?rev=1503383643&do=diff rsyslogd logs “action ‘action nn’ suspended” Might be caused by nothing listening on /dev/xconsole – remediation: Comment out the relevant entries in /etc/rsyslogd.conf: Change: daemon.*;mail.*;\ news.err;\ *.=debug;*.=info;\ *.=notice;*.=warn |/dev/xconsole text/html 2017-08-22T06:37:49+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/run-own-firefox-sync-1-5-server?rev=1503383869&do=diff Run own Firefox Sync 1.5 Server <https://mozilla-services.readthedocs.io/en/latest/howtos/run-sync-1.5.html> Install prerequisites # apt-get install python-dev git-core python-virtualenv g++ Create Database & Database User CREATE DATABASE ffsync15; CREATE USER 'ffsync15'@'localhost' IDENTIFIED BY 'dbpassword'; GRANT ALL privileges ON ffsync15.* TO 'ffsync15'@'localhost'; FLUSH privileges; text/html 2026-02-13T10:25:50+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/schedule-reboot-once?rev=1770978350&do=diff Schedule a reboot once via cron root@host:/# cat /etc/cron.d/reboot 42 3 * * * root rm /etc/cron.d/reboot && /usr/sbin/reboot kb linux text/html 2018-12-31T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/sftp-batch?rev=1546244118&do=diff SFTP Batch Upload (echo "cd $LOCAL_DIRECTORY"; echo "put $FILENAME"; echo "quit") | sftp -v -P $PORT -i $IDENTITY $SSH_OPTIONS -b - $USER@$HOST kb linux ssh sftp text/html 2017-08-24T09:57:40+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/sha256deep?rev=1503568660&do=diff Verify integrity of entire directory structures Install sha256deep apt-get install md5deep Create checksums cd ${DIRECTORY} sha256deep -lr > ${DIRECTORY}.sha256 Verify checksums cd ${DIRECTORY} sha256sum --quiet --check ${DIRECTORY}.sha256 text/html 2019-04-26T13:46:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/shodan?rev=1556286394&do=diff Shodan Suchbegriffe * port:5901 authentication disabled * webcamxp kb text/html 2017-10-21T16:33:35+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/simple-iptables-firwall?rev=1508603615&do=diff Simple iptables Firewall #!/bin/bash # Set default policy iptables -P INPUT DROP iptables -P OUTPUT DROP iptables -P FORWARD DROP # Flush existing rules iptables -F -t nat iptables -F -t mangle iptables -F -t filter iptables -X # Allow localhost traffic iptables -A INPUT -i lo -j ACCEPT iptables -A OUTPUT -o lo -j ACCEPT # Allow related traffic iptables -A INPUT -m conntrack --state ESTABLISHED -j ACCEPT iptables -A OUTPUT -m conntrack --state ESTABLISHED -j ACCEPT # Allow icmp traffic ip… text/html 2020-12-15T15:12:35+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/smartconsole-port-forwards?rev=1608045155&do=diff Ports to forward to use Check Point Smart Console R80.20 via SSH tunnel * tcp/443 * tcp/18184 * tcp/18190 * tcp/18191 * tcp/19009 kb checkpoint text/html 2024-10-15T03:26:38+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/splunk-queries?rev=1728962798&do=diff Splunk Queries Indexes & Events List Indexes | eventcount summarize=false index=* | dedup index | fields index Count Events per Index | tstats count WHERE index=* OR index=_* by index | tstats count where index=<indexname> by _time host span=1h prestats=true | timechart count span=1h | addtotals text/html 2024-01-11T08:41:04+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/splunk?rev=1704962464&do=diff Splunk Installation Install Indexer / Heavy Forwarder sudo useradd -m -d /opt/splunk -s /bin/bash -U splunk && \ sudo tar xzvf ~/splunk.tgz -C /opt && \ sudo chown -R splunk:splunk /opt/splunk && \ sudo su -c "/opt/splunk/bin/splunk start --accept-license" splunk text/html 2022-05-02T07:23:00+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/ssh-key-login-not-working?rev=1651476180&do=diff Things to check, if SSH key login is not working Permission issues * authorized_keys contains correct public key * authorized_keys file has permisions 600 * .ssh directory has permissions 755 or more restrictive Key Exchange Issues * Newer versions of openssh do no longer accept ssh-rsa as public key algorithm text/html 2020-04-25T16:49:26+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/start?rev=1587833366&do=diff Linux Windows Check Point Android Miscellaneous text/html 2019-07-13T09:11:08+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/supervisord?rev=1563009068&do=diff Supervisord Fun Enable Service cd /etc/supervisor/conf.d mv sshd.off sshd.conf supervisorctl reread # reload config supervisorctl update # start New services kb linux supervisord docker text/html 2017-08-21T17:09:46+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/toggle-mobile-data-rooted?rev=1503335386&do=diff Toggle Mobile Data (rooted) Turn On # setenforce permissive # svc data enable # setenforce enforcing Turn Off # setenforce permissive # svc data disable # setenforce enforcing kb android text/html 2022-07-15T08:07:15+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/ubuntu-xrdp?rev=1657872435&do=diff Install XRDP and XFCE * Install XFCE & XRDP sudo apt-get -y install xrdp xfce4 * Fix Policy Kit to Avoid Color Manager Error Message cat << EOF | sudo tee /etc/polkit-1/localauthority.conf.d/02-allow-colord.conf polkit.addRule(function(action, subject) { if ((action.id == "org.freedesktop.color-manager.create-device" || action.id == "org.freedesktop.color-manager.create-profile" || action.id == "org.freedesktop.color-manager.delete-device" || action.id == "org.freedesktop.color-manag… text/html 2021-09-17T06:55:19+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/vim-stuff?rev=1631861719&do=diff vim Stuff Windows CTRL-W <arrow left / arrow right> switch window Open files in windows: $ vim -o file1 file2 # horizontal split $ vim -O file1 file2 # vertical split Tabs :tabnew neuer Tab gT, gt Tab wechseln $ vim -p <file1> <file2> files in Tabs öffnen text/html 2017-12-09T16:12:49+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/vmware_piix4_smbus?rev=1512835969&do=diff Fix piix4_smbus error in Linux running in VMWare # echo blacklist i2c_piix4 >> /etc/modprobe.d/blacklist.conf kb linux vmware text/html 2017-12-08T13:42:52+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/vmware-missing-3d-hardware-acceleration?rev=1512740572&do=diff Fix missing 3D Hardware Acceleration in VMWare To fix the problems “No 3D support available from the host.” or “Hardware graphics acceleration is not available.” add mks.gl.allowBlacklistedDrivers = "TRUE" to ~/.vmware/preferences or the respective vmx file. text/html 2022-09-06T09:59:51+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/windows-defender?rev=1662458391&do=diff Windows Defender Get Exclusion List Get-MpPreference | Select-Object -ExpandProperty ExclusionPath Get-MpPreference | Select-Object -ExpandProperty ExclusionProcess kb windows defender text/html 2022-05-29T15:56:43+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/windows-firewall?rev=1653839803&do=diff Windows Firewall Powershell Commands Get Firewall Status Get-NetFirewallProfile Disable Firewall in all profiles Set-NetFirewallProfile -Enabled false Enable Firewall in all profiles Set-NetFirewallProfile -Enabled true Further commands text/html 2021-05-05T05:01:15+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/windows-gpo?rev=1620190875&do=diff Interessante GPO Settings für Windows 10 One Drive deaktivieren Computerkonfiguration\Administrative Vorlagen\Windows-Komponenten\OneDrive * Verwendung von OneDrive zur Datenspeicherung verhindern -> Aktiviert Disable Autorun Computerkonfiguration\Administrative Vorlagen\Windows-Komponenten\Richtlinen für die automatische Wiedergabe text/html 2017-08-24T05:47:33+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/windows-server-2003cookbook-folder-redirection?rev=1503553653&do=diff Windows Server 2003: Cookbook Folder Redirection <http://techgenix.com/Profile-Folder-Redirection-Windows-Server-2003/> kb windows server 2003 text/html 2017-11-12T08:42:21+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/windows-update-katalog?rev=1510476141&do=diff Windows Update Katalog Website Vordefinierte Suchen * Kumulatives Update für Windows 10 * Monatliches Sicherheitsqualitätsrollup für Windows 7 kb windows text/html 2021-05-05T05:00:36+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/windows10-einstellungen?rev=1620190836&do=diff Windows 10 - Diverse Einstellungen und wo sie zu finden sind ... Größe der Icons am Desktop Desktop -> Kontext Menü -> Ansicht -> Große / Mittlegroße / Kleine Symbole Standard Desktop Symbole einblenden Desktop -> Kontext Menü -> Anpassen text/html 2021-05-05T05:00:23+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/windows10-spotlight?rev=1620190823&do=diff Reset Windows 10 Spotlight / Blickpunkt Get-AppxPackage Microsoft.Windows.ContentDeliveryManager -allusers | foreach {Add-AppxPackage -register "$($_.InstallLocation)\appxmanifest.xml" -DisableDevelopmentMode} kb windows windows10 text/html 2025-10-17T15:48:30+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/windows11-einstellungen?rev=1760716110&do=diff Windows 11 - Diverse Einstellungen Taskleiste linksbündig Einstellungen -> Personalisierung -> Taskleiste -> Verhalten der Taskleiste -> Taskleistenausrichtung: Linksbündig Zuletzt benutze Dateien aus Startmenü entfernen Einstellungen -> Personalisierung text/html 2021-05-09T08:31:24+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/wireguard?rev=1620549084&do=diff Wireguard Install Wireguard on Debian 9.x and Raspbian 10.x # echo "deb http://deb.debian.org/debian/ unstable main" > /etc/apt/sources.list.d/unstable.list # echo -e "Package: *\nPin: release a=unstable\nPin-Priority: 150\n" > /etc/apt/preferences.d/limit-unstable # apt-get update && apt-get install wireguard-dkms wireguard-tools # modprobe wireguard && lsmod | grep wireguard text/html 2023-04-28T07:04:52+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/wordpress-permalinks?rev=1682665492&do=diff Wordpress Things to check, if WordPress Permalinks do not work: * mod_rewrite enabled * AllowOverride FileInfo set for DocumentRoot (or WordPress subdirectory) * .htaccess File is correctly generated (include potential WordPress subdirectory) text/html 2017-08-24T09:53:36+00:00 Anonymous (anonymous@undisclosed.example.com) http://fortytwo.adurias.org/x-server-desktop-panning?rev=1503568416&do=diff X server desktop panning If you have a small screen but want a larger desktop - for instance to see otherwise hidden buttons as in Linux Mint issue the following command: xrandr --fb 1024x768 --output LVDS1 --panning 1024x768 To return to the native resolution issue: