Sébastien Barbieri scips

SSH Tunnel

ssh -D 8123 -f -C -q -N <remoteuser@remotehost>

Proxy

Configure your Proxy Socks in the network settings of:

your browser
your DB Client

Parse XML file and return a node text value

elementValue=`cat somefile.xml | python -c 'import sys, xml.etree.cElementTree as et;\
 tree = et.parse(sys.stdin); print tree.find("elementValue").text'`

XML 2 secret gist + oauth

Why

I wanted to automatically retrieve an xml file (phpunit junit log) from a travis server.

I don't know why but rsync and scp failed so I assumed I could post it to pastebin but the pulbic api shut down years ago.

So I tried with github and gist...

	#!/bin/bash
	# count node
	for i in `ls brol.xml`; do
	xmllint --xpath 'count(//segmentation/segment)' ${i} >> temp.text;
	echo " ${i}" >> temp.text;
	done;
	# concat multiple field matching some text
	for i in `ls LATROISxml`; do
	xmllint --xpath 'concat(//maxEpisode[text()='0']/../titre/text(), "-", //maxEpisode[text()='0']/../genre/text())' ${i};
	echo "";

	#!/bin/bash
	TITLE="$@"
	printf '\e]2;%s\a' "$TITLE";

	while true
	do
	"$@"
	sleep 30
	done

	SAVEIFS=$IFS
	IFS=$(echo -en "\n\b")
	for i in `ls \| grep 360p`; do
	NEWNAME=`echo $i \| sed 's/ \[360p\]//'`;
	echo $i " -> " $NEWNAME;
	mv "$i" "$NEWNAME";
	done
	IFS=$SAVEIFS

	# Usage Get base64 decoded from dump: cat searchd.* \| awk -f crash.awk \| base64 -d
	# Usage Get specific term that caused the crash: cat searchd.* \| awk -f crash.awk \| base64 -d \| awk 'match($0, /.\^(\w+)\$./, a) {print a[1]}' \| sort \| uniq -c

	BEGIN { RS=""; FS="\n" }
	{
	keep=0
	for(i=1;i<=NF;i++) {
	if ( $i ~ /request dump end/ ) {
	keep=0
	print temp

	<script src="https://unpkg.com/vue"></script>
	<style>
	.done {
	text-decoration: line-through;
	}
	</style>

	<div id="app">
	<p>
	<label v-for="m in modes">

	# Tunnel the 443 port of your host to the vagrant machine you have
	sudo ssh -g -L 443:localhost:443 -f -N vagrant@192.168.33.10

	export VISUAL=vim
	export EDITOR="$VISUAL"