Saturday, September 28, 2019

revisar la velocidad de escritura de un disco en raspberry pi

#en este caso revisaremos la micro SD
sync; dd if=/dev/zero of=tempfile bs=1M count=1024; sync

#para probar la velocidad de un disco USB
sudo mkdir -m 1777 /media/usb
#Este comando establece el bit fijo (1) para evitar que sea eliminado accidentalmente
#y da acceso a leer / escribir / ejecutar (777) permisos en él.

#si tenemos un disco NTFS
sudo apt-get install ntfs-3g
#revisamos el disco a instalar
sudo fdisk -l

#para mi caso el SDA1 y lo montamos en la ruta creada
sudo mount /dev/sda1 /media/usb
#posterior a esto ejecutamos este comando
sync; dd if=/dev/zero of=/media/usb/tempfile bs=1M count=1024; sync

#el resultado seria este
pi@raspberrypi:/media/usb $ dd if=/dev/zero of=/media/usb/tempfile bs=1M count=1024 oflag=direct
1024+0 records in
1024+0 records out
1073741824 bytes (1.1 GB, 1.0 GiB) copied, 15.8819 s, 67.6 MB/s

Leer temperatura - Velocidad y Voltage en rapberry pi

sudo nano temp.sh


#!/bin/bash
 # Shell script: temp.sh
 # Autor: Santiago Crespo
 cpu=$(cat /sys/class/thermal/thermal_zone0/temp)
 echo "$(date) @ $(hostname)"
 echo "-------------------------------------------"
 echo "Temp.CPU => $((cpu/1000))'Cº"
# echo "Temp.GPU => $(/opt/vc/bin/vcgencmd measure_temp)"
 echo "-------------------------------------------"
 cat /sys/devices/system/cpu/cpu0/cpufreq/scaling_max_freq
#vcgencmd measure_volts
#bastante util es conocer el espacio en disco para eso usamos df y el -h es human value

echo "-------------disk space -------------"
df -h -t ext4

echo "------------top 6 procesos que estan utilizando CPU-------------"
ps -Ao user,uid,comm,pid,pcpu,tty --sort=-pcpu | head -n 6
echo "-------------------last 5----------------"
last -5
#free -h
echo "-----------------Ip connected-------------"
netstat -tn 2>/dev/null | grep :443 | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -nr | head
#netstat -an | grep :443 | grep ESTABLISHED | wc -l


#posterior a esto lo dejamos ejecutable
chmod 755 temp.sh

instalar XMR Rig Raspbian

instalar XMR Rig Raspbian 10 Buster

sudo apt-get install git build-essential cmake libuv1-dev libssl-dev libhwloc-dev
sudo apt-get install gcc-5 g++-5
sudo update-alternatives --install /usr/bin/gcc gcc /usr/bin/gcc-5 60 --slave /usr/bin/g++ g++ /usr/bin/g++-5
sudo update-alternatives --set gcc "/usr/bin/gcc-5"

git clone https://github.com/xmrig/xmrig.git
cd xmrig && mkdir build && cd build
cmake ..
make
#Crear Archivo Json de configuracion
sudo nano config.json
#despues pegar este codigo
{
    "algo": "cryptonight",  // cryptonight (default) or cryptonight-lite
    "av": 0,                // algorithm variation, 0 auto select
    "background": true,    // true to run the miner in the background
    "colors": true,         // false to disable colored output
    "cpu-affinity": null,   // set process affinity to CPU core(s), mask "0x3" for cores 0 and 1
    "cpu-priority": null,   // set process priority (0 idle, 2 normal to 5 highest)
    "donate-level": 1,      // donate level, mininum 1%
    "log-file": null,       // log all output to a file, example: "c:/some/path/xmrig.log"
    "max-cpu-usage": 100,    // maximum CPU usage for automatic mode, usually limiting factor is CPU cache not this option.
    "print-time": 20,       // print hashrate report every N seconds
    "retries": 5,           // number of times to retry before switch to backup server
    "retry-pause": 5,       // time to pause between retries
    "safe": false,          // true to safe adjust threads and av settings for current CPU
    "threads": 3,        // number of miner threads
    "pools": [
        {
            "url": "stratum+tcp://xmr.pool.minergate.com:45700",// "url": "",   // URL of mining server
            "user": "TuCuenta",// username for mining server
            "pass": "TuPasswd",// password for mining server
            "keepalive": true,// send keepalived for prevent timeout (need pool support)
            "nicehash": false // enable nicehash/xmrig-proxy support
        }
    ],
    "api": {
        "port": 0,                             // port for the miner API https://github.com/xmrig/xmrig/wiki/API
        "access-token": null,                  // access token for API
        "worker-id": null                      // custom worker-id for API
    }
}
#agregar al inicio la ejecucion del programa sudo nano /etc/rc.local # y aca pegar el codigo /home/pi/xmrig/build/./xmrig -t 3

Friday, September 6, 2019

reducir el tamaño del log.

ALTER DATABASE TUBBDD
SET RECOVERY SIMPLE;
GO

DBCC SHRINKFILE(TUBBDD_Log, 1);
GO

ALTER DATABASE TUBBDD
SET RECOVERY FULL;
GO

Monday, September 2, 2019

Desbloquear una cuenta
use master
go

ALTER LOGIN $LaCuentaADesbloquear$ with password=N'TuClave_Segura.2019' unlock
go