• Des commandes et autres astuces en vrac…

find * -mtime +10 -exec rm -rf {} \; 2>/dev/null

find . -name .svn -print0 | xargs -0 rm -rf

rm !(*.log)

passwd="VOTRE-PASSWD"
crypt=`perl -e 'print crypt("$passwd", "password"),"\n"'`
useradd --shell /bin/false --gid VOTRE-GROUP --home-dir "SON-HOME-DIR" --password $crypt LE-USER

:g/^$/d

wget http://test-debit.free.fr/16384.rnd -O /dev/null

rmmod pcspkr

• Dynamiquement (disparait au reboot) :

echo 1 > /proc/sys/net/ipv4/ip_forward

• Persistant (définitif) :

vi /etc/sysctl.conf

net.ipv4.ip_forward=1

grep -E -v '^(#|$)'  /etc/squid/squid.conf

mysqlcheck --repair --all-databases -v -p

mysqladmin -u root -p'OLDPASSWD' password 'NEWPASSWD'

ldapsearch -b "CN=Users,DC=test,DC=local" -H ldap://dc1.test.local:389 -D 'administrateur' -w 'Pa$$w0rd'

• Supprimer tout le reste de la ligne après le motif “:”:

sed "s/:.*$//"

• Donner le privilège SUPER:

grant SUPER on *.* to 'user'@'IP' identified by 'password';

• Donner le droit de création de vue:

grant CREATE VIEW on *.* to 'user'@'IP' identified by 'password';

• Check permissions:

mysql -Bse 'SELECT * FROM `information_schema`.`USER_PRIVILEGES`;' | grep "CREATE VIEW"

• Donner les privilèges d'insertion, modif, suppression et exécution sur la bdd:

GRANT SELECT,INSERT,UPDATE,DELETE,EXECUTE ON BDD.* to 'user'@'IP' identified by 'password';

• Donner un droit spécifique requis sur la table proc de la bdd mysql:

GRANT SELECT ON mysql.proc to 'user'@'IP';

ps -u www-data -o user,size | sed 1d | awk '{ SUM += $2 } END { print $1" " SUM }'

dmesg|perl -ne 'BEGIN{$a= time()- qx!cat /proc/uptime!};s/\[(\d+)\.\d+\]/localtime($1 + $a)/e; print $_;'

shred -n 50 -z -v /dev/sdaX

SELECT table_schema, table_name, engine FROM INFORMATION_SCHEMA.TABLES where table_schema like "BDD";

rsync -avz $SOURCE -e 'ssh -p $PORT' $DEST

strace `ps -ef | grep php-fpm | grep -v "grep" | awk '{print "-p" $2}' | xargs`

• POST

tcpdump -s 0 -A 'tcp dst port 80 and (tcp[((tcp[12:1] & 0xf0) >> 2):4] = 0x504f5354)'

• GET

tcpdump -s 0 -A 'tcp[((tcp[12:1] & 0xf0) >> 2):4] = 0x47455420'

• Dans le shell MySQL :

show variables where Variable_name like "%log%";
SET GLOBAL general_log="ON";

• Désactiver :

SET GLOBAL general_log="OFF";

sed -n '/MOTIF1/,/MOTIF2/{//d;p}' dump.sql

find $PATH -maxdepth 1 -type d -print0 | xargs -0 -I % sh -c 'echo -n "% : "; find "%" -type f | wc -l'

ps axo pid,user,rss --sort -rss | head -11

mtr -c1 -r www.googel.fr

#!/usr/bin/perl -s -wnl
#extract a single table from a mysql dump
BEGIN {
    $table or warn
    "Usage: $0 -table=TABLE_TO_EXTRACT mysqldumpfile.sql"
    and exit 1;
}
 
/^DROP TABLE IF EXISTS `$table`/ .. /^UNLOCK TABLES;$/ and print;

• Configuration de Kibana si c'est ES embarqué de logstash :

elasticsearch: "https://kibana.exemple.com/9200",

• Configuration du ReverseProxy avec Authentification de votre choix (CAS dans mon contexte) :

<Location /9200>
                AuthType CAS
                Require valid-user
                ProxyPass http://10.1.1.1:9200
                ProxyPassReverse http://10.1.1.1:9200
        </Location>

• Fermer le port 9200 sur l'interface publique du serveur ES.

rsync --bwlimit=23040 

find Storage/ -type f ! -perm 644 -exec stat -c "%a %U:%G %n" {} \;
find Storage/ -type d ! -perm 755 -exec stat -c "%a %U:%G %n" {} \;

df -i
find ./ -type f -o -type d | cut -d '/' -f 1-2 | uniq -c

php -r "mail('mail_to@exemple.com', 'subject', 'body', null, '-fmail_from@exemple.com');"