Skip to content

Instantly share code, notes, and snippets.

View isyutaro's full-sized avatar
🏠
Working from home

Jean Sanchez isyutaro

🏠
Working from home
  • Mexico
  • 02:49 (UTC -06:00)
View GitHub Profile
@isyutaro
isyutaro / create_ssl_certificate.md
Last active December 13, 2018 21:37
create ssl certificate

Generacion de Request.

Para solicitar un certificado, necesitamos crear la peticion y al mismo tiempo la llave que tendra nuestro certificado.

Creamos unas variables para el dominio

DOMAIN=midominio.com

Keybase proof

I hereby claim:

  • I am isyutaro on github.
  • I am isyutaro (https://keybase.io/isyutaro) on keybase.
  • I have a public key whose fingerprint is 2BE2 A089 8358 3579 A3B8 75A7 49A8 7829 03C8 D39A

To claim this, I am signing this object:

@isyutaro
isyutaro / URLwordpress.bash
Created May 19, 2014 21:51
Cambiar URL Wordpress
# Para cambiar URL en wordpress, con agregar dos variables en wp-config.php es suficiente
define('WP_HOME','http://example.com');
define('WP_SITEURL','http://example.com');
# y en base de datos hacemos lo siguiente:
UPDATE wp_options SET option_value = replace(option_value, 'http://old-domain.com', 'http://new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://old-domain.com', 'http://new-domain.com');
@isyutaro
isyutaro / dump_alldatabases.bash
Last active December 27, 2017 20:33
backup all mysql databases as separate files
#!bash
#!/bin/bash
#
# Script to backup all mysql databases as separate files
#
# $BACKUP_PATH/<date>/<db_name>-<date>.gz
# set env variables for this script
DATESTAMP=$(date +%Y-%m-%d)
USER="backup"
@isyutaro
isyutaro / iptables.sh
Created February 26, 2014 16:36
iptables
# iptables config file
*nat
:PREROUTING ACCEPT [0:0]
:INPUT ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
:POSTROUTING ACCEPT [0:0]
-A PREROUTING -p tcp -s 10.0.0.30 --dport 22 -j DNAT --to 10.0.0.10:22
-A POSTROUTING -p tcp -s 10.0.0.30 --dport 22 -j MASQUERADE
@isyutaro
isyutaro / jmeter-example.xml
Last active August 29, 2015 13:56
jmeter basic example
<?xml version="1.0" encoding="UTF-8"?>
<jmeterTestPlan version="1.2" properties="2.1">
<hashTree>
<TestPlan guiclass="TestPlanGui" testclass="TestPlan" testname="Test Plan" enabled="true">
<stringProp name="TestPlan.comments"></stringProp>
<boolProp name="TestPlan.functional_mode">false</boolProp>
<boolProp name="TestPlan.serialize_threadgroups">false</boolProp>
<elementProp name="TestPlan.user_defined_variables" elementType="Arguments" guiclass="ArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true">
<collectionProp name="Arguments.arguments"/>
</elementProp>
@isyutaro
isyutaro / alias_iRedMail.sql
Last active August 29, 2015 13:56
Para crear un alias en iredMail con la versión libre utilizando MySQL, hacemos lo siguiente en la base de datos:
use vmail
INSERT INTO alias (address, goto, domain) values ('orig@domain.ltd', 'user01@gmail.com,user02@hotmail.com', 'domain.ltd');

Cuando tenemos uwsgi + nginx + https e intentamos hacer el siguiente request:

https://dominio.com/admin
(notar que no tiene slash al final)

Nos hace un redirect hacia http

http://dominio.com/admin/
@isyutaro
isyutaro / mysql.md
Last active December 20, 2018 16:49
MySQL

Size DB

ALL

mysql> SELECT sum( data_length + index_length ) / (1024 * 1024)  "Size in MB" FROM information_schema.TABLES;

By DB

SELECT table_schema "Data Base Name", sum( data_length + index_length ) / (1024 * 1024) as Size FROM information_schema.TABLES GROUP BY table_schema;