Linux remove last newline from file
karloperl -pi -e 'chomp if eof' macaroon newline remove
nc in powershell (test remote open port/tcp)
Test-NetConnection -Port 80 -InformationLevel "Detailed" -ComputerName example.com
Simple wireshark filter host+port
ip.src == 10.1.72.1 and tcp.port == 12228
Excel return text right of last occurrence of string
=TRIM(RIGHT(SUBSTITUTE(A1;" ";REPT(" ";LEN(A1)));LEN(A1)))
Update RHEL/CentOS from local repo (iso/cd)
sudo -i mount -o loop /tmp/*77*.iso /mnt cat > /etc/yum.repos.d/cd.repo [cd] name=cd baseurl=file:///mnt/ enabled=1 gpgcheck=0 #[PRESS enter and CTRL-d] yum clean all; rm -rf rm -rf /var/cache/yum; yum makecache fast…
Pihole CORS problems
Fix: edit /var/www/html/admin/scripts/pi-hole/php/auth.php add your host names to AUTHORIZED_HOSTNAMES array
Move cygwin to different disk, including services
Stop all services, log out other users, in process explorer, add command line column, stop all in old pathIn cygwin, go to /cygdrive, cp -vR c/cygwin* d/mount -m > /usr/bin/mountCommands.bat…
ubnt / ubiquiti edgerouter passwordless login ssh keys
ubnt@er4gw:~$ configure [edit] ubnt@er4gw# set system login user ubnt authentication public-keys lb7 type ssh-rsa [edit] ubnt@er4gw# set system login user ubnt authentication public-keys lb7 key AAAA****3tfv0vaEUl ubnt@er4gw# commit ubnt@er4gw# exit…
Convert m4b to mp3 on Centos/Fedora using ffmpeg
for m4b in *.m4b; do ffmpeg -i $m4b -acodec libmp3lame -ar 22050 ${m4b}.mp3; done
Bash remove spaces from file names
find . -depth -name '* *' \ | while IFS= read -r f ; do mv -i "$f" "$(dirname "$f")/$(basename "$f"|tr ' ' _)" ; done
AWK print longest line in file
awk '{ if (length($0) > max) {max = length($0); maxline = $0} } END { print maxline }' YOURFILE
Outlook unblock “unsafe” attachments
Regedit, find: Outlook 2007 [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\Security] Outlook 2010 [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\Security] Outlook 2013 [HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\Security] Outlook 2016, Outlook 2019 and Office 365 [HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\Security] Level1Remove string Value .cer;.exe;.xxx for the stuff you want to unblock.
NPM (node) install fail as root
Do not install as root, or use --unsafe-perm
Windows “File is open in another program” (lsof in windows)
First get handle: https://docs.microsoft.com/en-us/sysinternals/downloads/handle Run handle once without searching for anything, to accept license. Run in a CMD AS ADMIN: handle64.exe > output.txt . Find the file you want. Then…
Extend a LVM-based swap partition
Sometimes your swap is not large enough [root@server ~]# free -g total used free shared buff/cache available Mem: 23 3 13 0 7 19 Swap: 1 0 1 [root@server ~]#…
Fix bricked firmware update jabra (evolve)
Get firmware from support site. Then update via "C:\Program Files (x86)\Jabra\SDKFirmwareUpdater\JabraFwUpdater.exe"
Tmux save all output (history) to file
bind-key P command-prompt -p 'save history to filename:' -I '~/tmux.history' 'capture-pane -S -32768 ; save-buffer %1 ; delete-buffer' Add above in tmux.conf. Then do Prefix+Shift+P
Upgrade dumb shell to interactive shell (tty)
python -c 'import pty; pty.spawn("/bin/bash")' yay python
Excel return last line of multi line cell
=TRIM(RIGHT(SUBSTITUTE(B5,CHAR(10),REPT(" ";200));200)) Especially useful for project trackers. Add a LEFT(XXX;10) for returning dates.
Keeping a (GitHub) fork up to date with upstream master
1. Clone your fork: git clone git@github.com:YOUR-USERNAME/YOUR-FORKED-REPO.git 2. Add remote from original repository in your forked repository: cd into/cloned/fork-repo git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git git fetch upstream 3. Updating your…
MySQL / MariaDB DB and user creation
create user 'nextcloud'@'localhost' identified by 'xxx'; create database nextcloud; grant all privileges on nextcloud.* to 'nextcloud'@'localhost' identified by 'xxx'; FLUSH PRIVILEGES;
AutoRecon over proxychains
Since we have no icmp/ping over proxychains, we have to change syntax a bit ~/svn/proxychains-ng/proxychains4 -f ~/proxychains.conf ~/svn/AutoRecon/autorecon.py --nmap '\-sT \-Pn' 10.1.1.{1,224,235,246,248}
Set scp port
scp -P 80 … yes, capital P