zodman

[zodman]

Reproducir películas de mega.nz sin descargarlas...

ese sin descargarlas es con comillas, por que mientras descargas estas reproduciendo, por lo que te da la sensación de que no se descarga.

megadl [url mega] --path - | mpv -

Par esto necesitas tener instalado

megatools de megus https://megatools.megous.com/

Y el mpv http://mpv.io

[zodman]

Waifu App

Waifu app es una aplicación que nos permitirá ver un montón de animes tanto clásicos como recientes casi todas las series animes se ven con subtítulos en varios idiomas tan sólo tendremos que activar la opción de subtitulado y elegir el idioma que queramos además podemos cambiar el tamaño de las letras de sus tutelados Es una exelente herramienta de reproducción de anime la aplicación ofrece una calidad de 720p.

ver Waifu

[zodman]

When I accept to code in PHP

/* by Stichoza */

[zodman]

[zodman]

mail #python

[zodman]

decorator

[zodman]

What the hell is executing on mysql

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST order by time;

[zodman]

Stoping spam with postfix

Well Ihad some small troubles with spamers on postfix I found some commands to parse logs and get the user. Sometimes the user password was compromised, we need search the users what is sending spam like:

zgrep 'sasl_method' /var/log/mail.log* | grep "postfix/smtpd" | awk '{print $9}' | sort -n | uniq -c | sort -n | tail

that return is

4342 sasl_username=tania.perez@xxxx.com 20980 sasl_username=veroa@xxxxx.com

Wow i see that two users login alot of times with the mailserver. That users are sending spam!

Lets check the ips was autheticating:

zgrep $1 /var/log/mail.log* | grep "postfix/smtpd"| grep -v reject | awk '{print $7}' |uniq -c | sort -n | tail 127 client=unknown[180.249.13.35], 127 client=unknown[5.34.35.160], 127 client=unknown[95.46.242.232], 128 client=ip-46-73-42-28.bb.netbynet.ru[46.73.42.28], 131 client=host-static-89-35-202-29.moldtelecom.md[89.35.202.29], 134 client=unknown[78.175.102.232], 136 client=unknown[124.227.149.62], 137 client=unknown[176.196.97.244], 137 client=unknown[187.4.82.244], 139 client=ip-552f.proline.net.ua[93.126.85.47],

that ips are very strange, lets check the country from comes with whois or with geoiplookup

geoiplookup 93.126.85.47 GeoIP Country Edition: UA, Ukraine

That ip is not from mexico lets ban with this script:

#!/bin/bash IPT=/sbin/iptables SPAMLIST="spamlist" SPAMDROPMSG="SPAM LIST DROP" BADIPS=$(egrep -v -E "^#|^$" blocked.ips) # create a new iptables list $IPT -N $SPAMLIST for ipblock in $BADIPS do $IPT -A $SPAMLIST -s $ipblock -j LOG --log-prefix "$SPAMDROPMSG" $IPT -A $SPAMLIST -s $ipblock -j DROP done $IPT -I INPUT -j $SPAMLIST $IPT -I OUTPUT -j $SPAMLIST $IPT -I FORWARD -j $SPAMLIST

[zodman]

varnish!

[zodman]

Beautiful form to explain raft algorithm

[zodman]


[zodman]

Since a few months all the PHP developer’s community is quite in turmoil about everything that’s going on. PHP 5.3 is becoming very standard, Zend is in heavy development for his new version and Sy...

[zodman]

Obener peso de una tabla

[zodman]

[18:33:44] Andres Vargas: claro

[18:33:49] Andres Vargas: hay un script

[18:33:50] Andres Vargas: mauro

[18:33:52] Andres Vargas: q se llama

[18:33:55] Andres Vargas: publish.bash

[18:33:57] Carlos Hoyos: tu tienes para todo script

[18:33:58] Andres Vargas: correlo con

[18:34:02] Andres Vargas: bash publish.bash

[18:34:05] Andres Vargas: siiiiiiii

[18:34:07] Carlos Hoyos: y listo

[18:34:10] Carlos Hoyos: a ver pruebo

[18:34:20] Andres Vargas: si una tarea se ejectuta mas 2 veces tengo que hacerle un script

[18:34:29] Carlos Hoyos: jajajajjaja sino no serias ingeniero

[zodman]

Gabriel mv - Electronic Like Music 1.- Coldplay - (Magic Sebastien Edit) [CDR] 2.- Capital Cities - One Minute More (The Madison Deep Bootleg) [CDR] 3.- Bastille - Things We Lost In The Fire (Franz Fango Edit)[CDR] 4.- Sam Smith - Stay With Me (Florian Paetzold Edit) [CDR] 5.- The Lumineers Stubborn Love (Steve Semtex with Brian & Noise Bootleg)[CDR] 6.- Gnarls Barkley - Crazy (Fapples) [ABCDeep Rec] 7.- Beatles - Come together (Vintage Culture Remix)[CDR] 8.- A Great Big World Say Something (Andy Lansky Remix)[CDR] 9.- Bruno Mars Just The Way You Are (Mark Duran Remix)[CDR] 10.- John Legend - All Of Me (Tiësto Remix)[CDR] 11.- London Grammar - Darling Are You Gonna Leave Me (LCAW Remix)[CDR] 12.- Banks - Waiting Game (Judah Remix)[CDR] 13.- Snow Patrol If Theres A Rocket Tie Me To It (Marcus Schossow Remix) [CDR] 14.- 30 Seconds To Mars City Of Angels (Markus Schulz Remix) [Coldharbour Recordings] 15.- Naughty Boy feat. Sam Smith - La La La (Maor Levi Bootleg Mix) [CDR] 16.- Capital Cities Safe & Sound (Markus Schulz vs Grube & Hovsepian) [Capitol Records] 17.- Coldplay Midnight (Marcus Schossow Remix)[CDR] Time: 78:27 *NO EDM!! Yes good music. Enjoy :)

[zodman]

Convert tables to other Engine

La ultima vez que trate de convertir todas las tablas de engine a otro fue un dolor de cabeza.

Esto lo hace mas facil:

SET @DATABASE_NAME = 'name_of_your_db'; SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = @DATABASE_NAME AND `ENGINE` = 'MyISAM' AND `TABLE_TYPE` = 'BASE TABLE' ORDER BY table_name DESC;

http://stackoverflow.com/questions/3856435/how-to-convert-all-tables-from-myisam-into-innodb