Upgrade dumb shell to interactive shell (tty)
karlopython -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