{"id":941,"date":"2020-08-08T14:16:57","date_gmt":"2020-08-08T17:16:57","guid":{"rendered":"http:\/\/www.tech-nico.com\/blog\/?p=941"},"modified":"2020-08-08T14:17:01","modified_gmt":"2020-08-08T17:17:01","slug":"automatizacion-de-backups-con-mikrotik-y-google-drive-parte-1","status":"publish","type":"post","link":"http:\/\/www.tech-nico.com\/blog\/automatizacion-de-backups-con-mikrotik-y-google-drive-parte-1\/","title":{"rendered":"Automatizacion de Backups con Mikrotik y Google Drive Parte 1"},"content":{"rendered":"\n

1) CONFIGURAR sNTP Client<\/h3>\n\n\n\n

Para que nuestro backup se ejecute correctamente lo primero es que nuestro RouterOS se mantenga siempre con la hora correcta por mas que se reinicie. Entonces pegamos esto en la consola:<\/p>\n\n\n\n

\/system ntp client
set enabled=yes primary-ntp=216.239.35.12<\/code><\/p>\n\n\n\n

Solo aceptaremos en nuestro firewall el servidor NTP de google, ya que estos puertos suelen estar dentro de los mas atacados. Para ellos pegamos nuevamente lo siguiente en la consola:<\/p>\n\n\n\n

\/ip firewal filter
add action=accept chain=input comment=\"NTP Admitir solo a time.google.com\" dst-port=123 protocol=tcp src-address=\\
216.239.35.12
add action=accept chain=input dst-port=123 protocol=udp src-address=216.239.35.12
add action=drop chain=input dst-port=123 protocol=udp<\/code><\/p>\n\n\n\n

2) CONFIGURAR E-MAIL<\/h3>\n\n\n\n

Las siguientes lineas corresponden al seteo del servicio de correo. La direccion IP es de smtp.google.com: Lo editas en tu notepad reemplazando tu contrase\u00f1a y la direccion de correo y lo pegamos en la consola:<\/p>\n\n\n\n

\/tool e-mail
set address=172.217.192.109 from= password=\"TU_CONTRASE\u00d1A_FUERTE\" port=587 start-tls=yes user=\\
TUMAIL@GMAIL.com<\/code><\/p>\n\n\n\n

NOTA IMPORTANTE: recorda que Gmail bloquea el envio de mails de cualquier aplicacion externa (que se considera poco segura) como por ejemplo Outlook, (y cualquier otros), y por supuesto el envio de mails a traves de RouterOS. Para resolverlo loggearse con la cuenta que usaran para backups y luego hacen click en el siguiente este enlace: https:\/\/myaccount.google.com\/lesssecureapps<\/a><\/p>\n\n\n\n

\"\"
Cambiar de NO a SI<\/figcaption><\/figure>\n\n\n\n

3) PROBAR EL ENVIO DE EMAIL<\/h3>\n\n\n\n

Para saber si el envio es correcto probamos el envio desde consola con la siguiente linea:<\/p>\n\n\n\n

\/tool e-mail send to=\"TUMAIL@GMAIL.com\" subject=\"soy tech-nico backups\"<\/code><\/p>\n\n\n\n

4) IMPORTAR SCRIPTS DE BACKUPS<\/h3>\n\n\n\n

A continuacion tenemos 2 scripts que debemos pegar en la consola (previo a editar la direccion de e-mail). El primer script envia el binario completo. \u00ab.backup\u00bb y el segundo script envia un export completo \u00ab.rsc\u00bb. Por ahora no editen el asunto porque es importante mantener el doble slash \u00ab\/\/\u00bb. (en la parte 2 te daras cuenta del por que). Recueden que al pegar en la consola hay que presionar enter.<\/em><\/strong><\/p>\n\n\n\n

\/system script add name=backup_binary source={\/system backup save name=([\/system identity get name] . \"-\" . \\
[:pick [\/system clock get date] 7 11] . [:pick [\/system clock get date] 0 3] . [:pick [\/system clock get date] 4 6]); \\
\/tool e-mail send to=\"TUMAIL@GMAIL.com\" subject=([\/system identity get name] . \"_BACKUP\/\/\" . \\
[\/system clock get date]) file=([\/system identity get name] . \"-\" . [:pick [\/system clock get date] 7 11] . \\
[:pick [\/system clock get date] 0 3] . [:pick [\/system clock get date] 4 6] . \".backup\"); :delay 10; \\
\/file rem [\/file find name=([\/system identity get name] . \"-\" . [:pick [\/system clock get date] 7 11] . \\
[:pick [\/system clock get date] 0 3] . [:pick [\/system clock get date] 4 6] . \".backup\")]; \\
:log info (\"System Backup emailed at \" . [\/sys cl get time] . \" \" . [\/sys cl get date])}<\/code><\/p>\n\n\n\n

Y este otro:<\/p>\n\n\n\n

\/system script add name=backup_export source={\/export file=([\/system identity get name] . \"-\" . \\
[:pick [\/system clock get date] 7 11] . [:pick [\/system clock get date] 0 3] . [:pick [\/system clock get date] 4 6]); :delay 2; \\
\/tool e-mail send to=\"TUMAIL@GMAIL.com\" subject=([\/system identity get name] . \"_BACKUP\/\/\" . \\
[\/system clock get date]) file=([\/system identity get name] . \"-\" . [:pick [\/system clock get date] 7 11] . \\
[:pick [\/system clock get date] 0 3] . [:pick [\/system clock get date] 4 6] . \".rsc\"); :delay 10; \\
\/file rem [\/file find name=([\/system identity get name] . \"-\" . [:pick [\/system clock get date] 7 11] . \\
[:pick [\/system clock get date] 0 3] . [:pick [\/system clock get date] 4 6] . \".rsc\")]; \\
:log info (\"System Backup emailed at \" . [\/sys cl get time] . \" \" . [\/sys cl get date])}<\/code><\/p>\n\n\n\n

5) AGREGARLO AL CALENDARIO DE EJECUCION<\/h3>\n\n\n\n

Y finalmente lo ejecutamos cada 5 dias. O como ustedes prefieran. Esto hara que se envien 2 mails. 1 con el .backup y el otro con el export .rsc.<\/p>\n\n\n\n

\/system scheduler
add interval=5d name=backup_binary on-event=\"\/sys script run backup_binary\" policy=\\
ftp,reboot,read,write,policy,test,password,sniff,sensitive,romon start-date=aug\/03\/2020 start-time=16:35:00
add interval=5d name=backup_export on-event=\"\/sys script run backup_export\" policy=\\
ftp,reboot,read,write,policy,test,password,sniff,sensitive,romon start-date=aug\/03\/2020 start-time=16:35:00<\/code><\/p>\n\n\n\n


En la segunda parte de este post te ense\u00f1are como volcar estos mails a un Google Drive. <\/p>\n","protected":false},"excerpt":{"rendered":"

1) CONFIGURAR sNTP Client Para que nuestro backup se ejecute correctamente lo primero es que nuestro RouterOS se mantenga siempre con la hora correcta por mas que se reinicie. Entonces pegamos esto en la consola: \/system ntp clientset enabled=yes primary-ntp=216.239.35.12 … Sigue leyendo →<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":943,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[74,73],"tags":[],"class_list":["post-941","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mikrotik","category-scripts"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2020\/08\/image-1.png?fit=703%2C303","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/phA9Q-fb","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":318,"url":"http:\/\/www.tech-nico.com\/blog\/como-detectar-botnet-torpig-en-una-red-desde-mikrotik\/","url_meta":{"origin":941,"position":0},"title":"Como detectar BOTNET Torpig en una Red desde Mikrotik","author":"soporte","date":"junio 29, 2012","format":false,"excerpt":"Torpig\u00a0o tambi\u00e9n conocido como Sinowal o Anserin es un tipo de botnet (variedad de troyano que pueden afectar a los equipos que utilizan Microsoft Windows). Torpig evita aplicaciones anti-virus a trav\u00e9s del uso de rootkits y busca en el sistema infectado para robar credenciales, las cuentas y contrase\u00f1as de home\u2026","rel":"","context":"En \u00abredes\u00bb","block_context":{"text":"redes","link":"http:\/\/www.tech-nico.com\/blog\/category\/redes\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=1050%2C600 3x"},"classes":[]},{"id":929,"url":"http:\/\/www.tech-nico.com\/blog\/port-forwarding-vpn-l2tp-con-mikrotik\/","url_meta":{"origin":941,"position":1},"title":"Port Forwarding VPN L2TP con Mikrotik","author":"soporte","date":"julio 29, 2020","format":false,"excerpt":"La semana pasada instale un rack para fibra al hogar en Rolon - La Pampa, y me encontre con la particularidad de que el carreir entrega una sola direccion IP Publica, para lo cual tuve que hacer Port Forwarding de la VPN. Hace mucho tiempo que no escribo y no\u2026","rel":"","context":"En \u00abmikrotik\u00bb","block_context":{"text":"mikrotik","link":"http:\/\/www.tech-nico.com\/blog\/category\/mikrotik\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2020\/07\/83260865_143235593811587_7172731732122510352_n.jpg?fit=640%2C640&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2020\/07\/83260865_143235593811587_7172731732122510352_n.jpg?fit=640%2C640&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2020\/07\/83260865_143235593811587_7172731732122510352_n.jpg?fit=640%2C640&resize=525%2C300 1.5x"},"classes":[]},{"id":590,"url":"http:\/\/www.tech-nico.com\/blog\/mikrotik-bloquear-actualizaciones-de-android-en-firewall\/","url_meta":{"origin":941,"position":2},"title":"Mikrotik bloquear actualizaciones de Android en firewall","author":"soporte","date":"abril 22, 2015","format":false,"excerpt":"Estoy implementando algunas reglas para mejorar el ancho de banda de un colegio. Esta me parece una muy buena practica. Aqu\u00ed la dejamos anotada por si acaso. Ir a la consola y ejecutar esto. Luego, si sos tan amable, arrastra las reglas para arriba de tu firewall y tener la\u2026","rel":"","context":"En \u00abProgramaci\u00f3n\u00bb","block_context":{"text":"Programaci\u00f3n","link":"http:\/\/www.tech-nico.com\/blog\/category\/programacion\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=1050%2C600 3x"},"classes":[]},{"id":777,"url":"http:\/\/www.tech-nico.com\/blog\/routeros-6-41-incorpora-tls-host-para-controlar-sitios-https-que-usen-tcp\/","url_meta":{"origin":941,"position":3},"title":"RouterOS 6.41 incorpora TLS-Host para controlar sitios HTTPS que usen TCP","author":"soporte","date":"febrero 2, 2018","format":false,"excerpt":"Alternativa para poder manejar fitros o queues en sitios con HTTPS En la version 6.42rc (release candidate) segun afirman en el foro oficial de Mikrotik, ya esta en funcionamiento el parametro TLC-Host desde los filtros del firewall, con lo cual permite marcar\/controlar o filtrar ciertos sitios HTTPS que corran en\u2026","rel":"","context":"En \u00abmikrotik\u00bb","block_context":{"text":"mikrotik","link":"http:\/\/www.tech-nico.com\/blog\/category\/mikrotik\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=1050%2C600 3x"},"classes":[]},{"id":613,"url":"http:\/\/www.tech-nico.com\/blog\/script-mikrotik-mandar-backup-por-ftp\/","url_meta":{"origin":941,"position":4},"title":"Script Mikrotik, mandar backup por FTP","author":"soporte","date":"junio 2, 2015","format":false,"excerpt":"Un usuario del foro oficial de mikrotik\u00a0publico un peque\u00f1o script\u00a0para enviar un backup de\u00a0nuestro RouterOS por FTP. Muy bueno para automatizar nuestros routers y enviar todos los backups a una caja NAS. _________ publicado en tech-nico.com","rel":"","context":"En \u00abProgramaci\u00f3n\u00bb","block_context":{"text":"Programaci\u00f3n","link":"http:\/\/www.tech-nico.com\/blog\/category\/programacion\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=1050%2C600 3x"},"classes":[]},{"id":954,"url":"http:\/\/www.tech-nico.com\/blog\/mikrotik-como-direccionar-trafico-pppoe-por-interfaz-sin-balancear-3-wan-3-lan\/","url_meta":{"origin":941,"position":5},"title":"Mikrotik: Como direccionar trafico PPPoE por interfaz (sin balancear): 3 WAN \/ 3 LAN","author":"soporte","date":"agosto 24, 2020","format":false,"excerpt":"No quiero extenderme explicando por que tuve que elegir esta configuracion, pero si quiero decir que fue una solucion muy buena en su momento. Por supuesto que tienen que darse condiciones muy similiares para que te sirva hacer lo mismo. Pero somos tantos en el mundo que seguro mi aporte\u2026","rel":"","context":"En \u00abmikrotik\u00bb","block_context":{"text":"mikrotik","link":"http:\/\/www.tech-nico.com\/blog\/category\/mikrotik\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=1050%2C600 3x"},"classes":[]}],"_links":{"self":[{"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/posts\/941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/comments?post=941"}],"version-history":[{"count":1,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/posts\/941\/revisions"}],"predecessor-version":[{"id":944,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/posts\/941\/revisions\/944"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/media\/943"}],"wp:attachment":[{"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/media?parent=941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/categories?post=941"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/tags?post=941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}