Jun 24 2023

SQL Server Configuration Manager

Version Path
SQL Server 2022 C:\Windows\SysWOW64\SQLServerManager16.msc
SQL Server 2019 C:\Windows\SysWOW64\SQLServerManager15.msc
SQL Server 2017 C:\Windows\SysWOW64\SQLServerManager14.msc
SQL Server 2016 C:\Windows\SysWOW64\SQLServerManager13.msc
SQL Server 2014 (12.x) C:\Windows\SysWOW64\SQLServerManager12.msc
SQL Server 2012 (11.x) C:\Windows\SysWOW64\SQLServerManager11.msc
Jun 17 2023

openDKIM – no signature data

if you see this message

2023-06-17T21:18:24.773384+02:00 git opendkim[317371]: BADFE5FE6B: [192.168.1.25] [192.168.1.25] not internal
2023-06-17T21:18:24.773568+02:00 git opendkim[317371]: BADFE5FE6B: not authenticated
2023-06-17T21:18:24.774566+02:00 git opendkim[317371]: BADFE5FE6B: no signature data

Add to /etc/postfix/main.cf

milter_connect_macros = j {daemon_name} v {if_name} _
milter_mail_macros="i {mail_addr} {client_addr} {client_name} {auth_type} {auth_authen}"

 

Jun 16 2023

PHP install extensions

apt -y install php8.2-{apcu,bcmath,bz2,cgi,cli,common,curl,fpm,gd,gmp,igbinary,imagick,imap,intl,ldap,mbstring,mysql,opcache,pgsql,readline,redis,soap,sqlite3,xml,zip}

a2enmod proxy_fcgi setenvif

a2enconf php8.2-fpm

a2disconf php8.1-fpm

systemctl reload apache2

Mar 26 2023

Rsync copy

rsync -azP -e "ssh -p PORT_NUMBER" source destination

Mar 25 2023

KVM Snapshot with only one disk

virsh snapshot-create-as --domain ${VM}
--name "backup-${VM}" \
--atomic \
--disk-only \
--no-metadata \
--diskspec vda,file=${SNAP}/backup-snapshot-${VM} \
--diskspec vdb,snapshot=no

Feb 26 2023

Boot blocks with “Gave up waiting for suspend/resume device”

usually after swap changed
update-initramfs -u

Feb 25 2023

Validate /etc/network/interfaces

ifup --no-act eth0

Feb 24 2023

blank console screen after 5 min

add to /etc/default/grub
GRUB_CMDLINE_LINUX="consoleblank=300"

I was able to turn off the display of the laptop by putting this command physically on to the machine and not via SSH:

setterm –blank force

Feb 24 2023

Disable Consistent Interface Device Naming ethX instead ens

GRUB_CMDLINE_LINUX="net.ifnames=0 biosdevname=0"

Feb 24 2023

Customized boot in Zbook

Add in bios
\EFI\debian\shimx64.efi