Saber quien ha utilizada una memoria USB en tu computador

La herramienta que vamos a utilizar es USBDeview, esta puede ser utilizada en Windows 7, 8 o 10. Es de uso gratuito.

Continuar leyendo «Saber quien ha utilizada una memoria USB en tu computador»

noviembre 7, 2018enero 15, 2019

Navegar con un tunel SSH Socks

Crearemos un túnel SSH que reenviará de manera segura el tráfico de su máquina local en el puerto 9090 al servidor SSH en el puerto 22. Puede usar cualquier número de puerto mayor que 1024.

Continuar leyendo «Navegar con un tunel SSH Socks»

abril 18, 2017noviembre 10, 2017

How to Install and Use the Linux Bash Shell on Windows 10

Origen: How to Install and Use the Linux Bash Shell on Windows 10

febrero 9, 2017mayo 21, 2018

Bloqueo de puertos USB para discos externos

Utilizando el Registro

Para desactivar los puertos usb para las memorias externas solo debemos seguir estos pasos.

Ejecutar el comando regedit
Ir a la ruta:
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\USBSTOR
Cambiar el valor de la variable Start que esta en 3 por el numero 4

Desactivar los puertos USB desde el Device Manager

Por el Device Manager tambien se puede realizar el bloqueo de los puertos.

Origen: 5 Ways to enable or disable USB Drives or Ports in Windows

octubre 21, 2016octubre 11, 2018

OpenVPN en Windows

Instalar el cliente de OpenVPN para windows

https://openvpn.net/index.php/open-source/downloads.html

Copiar los certificados a la siguiente carpeta (O donde quede instalado)

C:\Program Files\OpenVPN\config

Ediar el client.conf con los parametros del cliente

Cambiar la extension del client.conf a client.ovpn

Ejecutar el programa

julio 7, 2016

Como convertir un PEM a PPK para que putty entre a un servidor linux

Primero ejecutamos All Programs > PuTTY > PuTTYgen

Under Type of key to generate, select SSH-2 RSA.

Click Load. By default, PuTTYgen displays only files with the extension .ppk. To locate your .pem file, select the option to display files of all types.
Select your .pem file for the key pair that you specified when you launch your instance, and then click Open. Click OK to dismiss the confirmation dialog box.
Click Save private key to save the key in the format that PuTTY can use. PuTTYgen displays a warning about saving the key without a passphrase. Click Yes.

Note

A passphrase on a private key is an extra layer of protection, so even if your private key is discovered, it can’t be used without the passphrase. The downside to using a passphrase is that it makes automation harder because human intervention is needed to log on to an instance, or copy files to an instance.
Specify the same name for the key that you used for the key pair (for example, my-key-pair). PuTTY automatically adds the .ppk file extension.

marzo 8, 2016septiembre 6, 2018

Backup a Bases de Datos en SQL

Se debe crear un archivo llamado SQLBackups.sql

BACKUP DATABASE Integrado_UDP TO  DISK = N'D:\BACKUP-SQL\Integrado_UDP.bak' 
WITH NOFORMAT, INIT,  NAME = N'MyDataBase1 Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

BACKUP DATABASE Integrado_Marketing TO  DISK = N'D:\BACKUP-SQL\Integrado_Marketing.bak' 
WITH NOFORMAT, INIT,  NAME = N'MyDataBase2 Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

BACKUP DATABASE Integrado_Antonio TO  DISK = N'D:\BACKUP-SQL\Integrado_Antonio.bak' 
WITH NOFORMAT, INIT,  NAME = N'MyDataBase2 Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

GO

BACKUP DATABASE Integrado_UDP TO DISK = N'D:\BACKUP-SQL\Integrado_UDP.bak'

WITH NOFORMAT, INIT, NAME = N'MyDataBase1 Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

BACKUP DATABASE Integrado_Marketing TO DISK = N'D:\BACKUP-SQL\Integrado_Marketing.bak'

WITH NOFORMAT, INIT, NAME = N'MyDataBase2 Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

BACKUP DATABASE Integrado_Antonio TO DISK = N'D:\BACKUP-SQL\Integrado_Antonio.bak'

WITH NOFORMAT, INIT, NAME = N'MyDataBase2 Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

En el indicamos las bases de datos que queremos sabar Backup y la ubicacion del archivo .bak

Despues creamos un archivo llamada backup.bat

"C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\SQLCMD.EXE" -S SRVSQLDMS\SQLEXPRESS -i D:\SQLBackups.sql

for /f %%x in ('wmic path win32_localtime get /format:list ^| findstr "="') do set %%x
set mydate=%Year%-%Month%-%Day%

"C:\7-Zip\7z.exe" a D:\BACKUP-SQL\SQL-DMS-%mydate%.zip D:\*.bak

xcopy D:\BACKUP-SQL\SQL-DMS-%mydate%.zip D:\BACKUP-SQL\SQL-DMS-ULTIMO.zip /Y

net use "\\10.25.50.9\nas" win2011 /user:win2011
:copy

xcopy D:\BACKUP-SQL\SQL-DMS-%mydate%.zip "\\10.25.50.9\nas\" /Y
xcopy D:\BACKUP-SQL\SQL-DMS-ULTIMO.zip "\\10.25.50.9\nas\" /Y

IF ERRORLEVEL 0 goto disconnect
goto end
:disconnect 
net use "\\10.25.50.9\nas" /delete
goto end
:end

"C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\SQLCMD.EXE" -S SRVSQLDMS\SQLEXPRESS -i D:\SQLBackups.sql

for /f %%x in ('wmic path win32_localtime get /format:list ^| findstr "="') do set %%x

set mydate=%Year%-%Month%-%Day%

"C:\7-Zip\7z.exe" a D:\BACKUP-SQL\SQL-DMS-%mydate%.zip D:\*.bak

xcopy D:\BACKUP-SQL\SQL-DMS-%mydate%.zip D:\BACKUP-SQL\SQL-DMS-ULTIMO.zip /Y

net use "\\10.25.50.9\nas" win2011 /user:win2011

:copy

xcopy D:\BACKUP-SQL\SQL-DMS-%mydate%.zip "\\10.25.50.9\nas\" /Y

xcopy D:\BACKUP-SQL\SQL-DMS-ULTIMO.zip "\\10.25.50.9\nas\" /Y

IF ERRORLEVEL 0 goto disconnect

goto end

:disconnect

net use "\\10.25.50.9\nas" /delete

goto end

:end

Para comprimir nuestro backup debemos tener instalado el 7-Zip.

Para que la tarea se ejecute automaticamente todos los dias, realizamos los siguientes pasos:

Abrimos: Administrador del Servidor – Configuracion – Programador de Tareas

Clic derecho, Crear Tarea Basica.

Damos, el nombre de la tarea, diariamente, la hora, Iniciar Programa, Escogemos nuestro script, Finalizar.

octubre 19, 2015

Usar WinSCP para sincronizar archivos entre Windows y Linux

Crear el archivo ‘pull_changes.txt’ :

#Pull changes from the remote folder to the local folder

#http://winscp.net/eng/docs/scriptcommand_synchronize
#open a connection to the server specifying the name of the server
#open scp://server.home.com:3687 -privatekey=C:\location\to\private\key.ppk

#open a connection to the server using a saved winscp session
open troy@server.home.com -privatekey=C:\location\to\private\key.ppk

#local folder: C:\Users\troy.williams\Documents\home sync
#remote folder: /home/troy/home sync

# Synchronize my folders, pulling changes from the remote to the local
synchronize local "C:\Users\troy.williams\Documents\home sync" "/home/troy/home sync"


#close the session
close

#exit the scripting environment
exit

#Pull changes from the remote folder to the local folder

#http://winscp.net/eng/docs/scriptcommand_synchronize

#open a connection to the server specifying the name of the server

#open scp://server.home.com:3687 -privatekey=C:\location\to\private\key.ppk

#open a connection to the server using a saved winscp session

open troy@server.home.com -privatekey=C:\location\to\private\key.ppk

#local folder: C:\Users\troy.williams\Documents\home sync

#remote folder: /home/troy/home sync

# Synchronize my folders, pulling changes from the remote to the local

synchronize local "C:\Users\troy.williams\Documents\home sync" "/home/troy/home sync"

#close the session

#exit the scripting environment

exit

Para enviar archivos crear ‘push_changes.txt’:

#push changes from the local folder to the remote folder

#http://winscp.net/eng/docs/scriptcommand_synchronize

#open a connection to the server specifying the name of the server
#open scp://server.home.com:10000 -privatekey=C:\location\to\private\key.ppk

#open a connection to the server using a saved session
open troy@server.home.com -privatekey=C:\location\to\private\key.ppk

#local folder: C:\Users\troy.williams\Documents\home sync
#remote folder: /home/troy/home sync

# Synchronize my folders, pushing changes from the local to the remote
synchronize remote "C:\Users\troy.williams\Documents\home sync" "/home/troy/home sync"

#close the session
close

#exit the scripting environment
exit

#push changes from the local folder to the remote folder

#http://winscp.net/eng/docs/scriptcommand_synchronize

#open a connection to the server specifying the name of the server

#open scp://server.home.com:10000 -privatekey=C:\location\to\private\key.ppk

#open a connection to the server using a saved session

open troy@server.home.com -privatekey=C:\location\to\private\key.ppk

#local folder: C:\Users\troy.williams\Documents\home sync

#remote folder: /home/troy/home sync

# Synchronize my folders, pushing changes from the local to the remote

synchronize remote "C:\Users\troy.williams\Documents\home sync" "/home/troy/home sync"

#close the session

#exit the scripting environment

exit

Ejemplo de archivo bash

@rem --------------------------------
@rem created 2011-08-08 copyright (c) 2011 Troy Williams
@rem This file will pull changes from my server at home

@ECHO OFF

SET WINSCPHOME=C:\Program Files (x86)\WinSCP
SET CWOLDPATH=%PATH%
SET PATH=%WINSCPHOME%;%PATH%

echo Pulling changes from the server

winscp.com /script=pull_changes.txt

pause

@rem --------------------------------

@rem This file will pull changes from my server at home

@ECHO OFF

SET WINSCPHOME=C:\Program Files (x86)\WinSCP

SET CWOLDPATH=%PATH%

SET PATH=%WINSCPHOME%;%PATH%

echo Pulling changes from the server

winscp.com /script=pull_changes.txt

pause