UDP Soporte y Comunicaciones

noviembre 15, 2016diciembre 1, 2016

Virtualbox en Suse

Añadir las siguientes lineas en el archivo:

vi /etc/zypp/repos.d/repo-virtualbox

1	vi /etc/zypp/repos.d/repo-virtualbox

[virtualbox]
name=VirtualBox for openSUSE 11.4
baseurl=http://download.virtualbox.org/virtualbox/rpm/opensuse/11.4
type=yum
enabled=1
priority=120
autorefresh=1
gpgcheck=1
gpgkey=https://www.virtualbox.org/download/oracle_vbox.asc
keeppackages=0

[virtualbox]

name=VirtualBox for openSUSE 11.4

baseurl=http://download.virtualbox.org/virtualbox/rpm/opensuse/11.4

type=yum

enabled=1

priority=120

autorefresh=1

gpgcheck=1

gpgkey=https://www.virtualbox.org/download/oracle_vbox.asc

keeppackages=0

Instalar los siguientes paquetes

sudo zypper in virtualbox
sudo zypper in python-gobject-pygtkcompat

1 2	sudo zypper in virtualbox sudo zypper in python-gobject-pygtkcompat

Se ejecuta con

vboxgtk

vboxgtk

Continuar leyendo «Virtualbox en Suse»

noviembre 8, 2016

MySQL crear registros consecutivos

Para crear registros por medio de un loop

DELIMITER $$
 
DROP PROCEDURE IF EXISTS insert_ell_rows $$
 
CREATE PROCEDURE insert_ell_rows ()
BEGIN
DECLARE crs INT DEFAULT 0;

WHILE crs < 11 DO
SET crs = crs + 1;
Insert into events (id,Valor) Values(crs,0);
END WHILE;
END $$

DELIMITER $$

DROP PROCEDURE IF EXISTS insert_ell_rows $$

CREATE PROCEDURE insert_ell_rows ()

BEGIN

DECLARE crs INT DEFAULT 0;

WHILE crs < 11 DO

SET crs = crs + 1;

Insert into events (id,Valor) Values(crs,0);

END WHILE;

END $$

Para ejecutar la funcion

call insert_ell_rows;

1	call insert_ell_rows;

noviembre 8, 2016

MariaDB on CentOS 7 – “Error in accept: Too many open files”

By default is seems the soft and hard open files limits on MariaDB in CentOS 7 are 1024 and 4096 respectfully. You can see these limits by first getting the process ID:

cat /var/run/mariadb/mariadb.pid

1	cat /var/run/mariadb/mariadb.pid

And then looking at the limits in the proc filesystem:

[root@web1 ~]# cat /proc/7688/limits
Limit                     Soft Limit           Hard Limit           Units
Max cpu time              unlimited            unlimited            seconds
Max file size             unlimited            unlimited            bytes
Max data size             unlimited            unlimited            bytes
Max stack size            8388608              unlimited            bytes
Max core file size        0                    unlimited            bytes
Max resident set          unlimited            unlimited            bytes
Max processes             31209                31209                processes
Max open files            1024                 4096                 files
Max locked memory         65536                65536                bytes
Max address space         unlimited            unlimited            bytes
Max file locks            unlimited            unlimited            locks
Max pending signals       31209                31209                signals
Max msgqueue size         819200               819200               bytes
Max nice priority         0                    0
Max realtime priority     0                    0
Max realtime timeout      unlimited            unlimited            us

[root@web1 ~]# cat /proc/7688/limits

Limit Soft Limit Hard Limit Units

Max cpu time unlimited unlimited seconds

Max file size unlimited unlimited bytes

Max data size unlimited unlimited bytes

Max stack size 8388608 unlimited bytes

Max core file size 0 unlimited bytes

Max resident set unlimited unlimited bytes

Max processes 31209 31209 processes

Max open files 1024 4096 files

Max locked memory 65536 65536 bytes

Max address space unlimited unlimited bytes

Max file locks unlimited unlimited locks

Max pending signals 31209 31209 signals

Max msgqueue size 819200 819200 bytes

Max nice priority 0 0

Max realtime priority 0 0

Max realtime timeout unlimited unlimited us

Notice the numbers for “Max open files”.

If you run into problems with MariaDB failing and you see errors like this in the log:

systemctl daemon-reload

1	systemctl daemon-reload

and restart the MariaDB service:

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

septiembre 8, 2016mayo 8, 2019

Contar extensiones que se desconectan

Con este comando podemos ver las extensiones que tienen problemas en el full, ya sean porque estan Lagged o porque estan UNREACHABLE

Las caidas

tail -20000 /var/log/asterisk/full | grep UNREACHABLE | cut -d' ' -f6 | sort | uniq -c

1	tail -20000 /var/log/asterisk/full \| grep UNREACHABLE \| cut -d' ' -f6 \| sort \| uniq -c

Solo para las de pings altos

tail -20000 /var/log/asterisk/full | grep Lagged | cut -d' ' -f6 | sort | uniq -c

1	tail -20000 /var/log/asterisk/full \| grep Lagged \| cut -d' ' -f6 \| sort \| uniq -c

julio 27, 2016diciembre 20, 2017

HOWTO: Boot your Raspberry Pi into a fullscreen browser kiosk | Wired Watershed

Origen: HOWTO: Boot your Raspberry Pi into a fullscreen browser kiosk | Wired Watershed

Software for the Project:

The CanaKit comes with a pre-loaded SD card that includes the same version of Debian Wheezy that I used for this project. However, in an effort to get a little more speed out of the system, I used the 95MB/s Sandisk extreme listed above. It seemed to help, but I did not bench mark it beyond observation.

Anyway, lets get down to building a Raspberry Pi Web Kiosk.

Continuar leyendo «HOWTO: Boot your Raspberry Pi into a fullscreen browser kiosk | Wired Watershed»

julio 13, 2016julio 31, 2019

Asterisk con WEBRTC (obsoleto)

Nuevo articulo

Primero los paquetes necesarios

yum update

yum install gcc-c++ make gnutls-devel kernel-devel libxml2-devel ncurses-devel subversion doxygen texinfo curl-devel net-snmp-devel neon-devel

yum install uuid-devel libuuid-devel sqlite-devel sqlite git speex-devel gsm-devel

yum update

yum install gcc-c++ make gnutls-devel kernel-devel libxml2-devel ncurses-devel subversion doxygen texinfo curl-devel net-snmp-devel neon-devel

yum install uuid-devel libuuid-devel sqlite-devel sqlite git speex-devel gsm-devel

Continuar leyendo «Asterisk con WEBRTC (obsoleto)»

julio 8, 2016noviembre 17, 2020

Instalar SSL en EC2 con certbot

Usaremos Let’s Encrypt para esto, primero debemos tener en cuenta:

Certificados duran solo 90 dias.
Hay que automatizar el proceso.
No tienen certificados con wildcard.

Continuar leyendo «Instalar SSL en EC2 con certbot»

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.

junio 15, 2016octubre 11, 2018

Cliente VPN en Centos 7

Se crean los certificados

cd /etc/openvpn/easy-rsa/
source ./vars 
./build-key cliente 
tar cvf /var/www/html/zabbix/vpn/cliente.tar keys/cliente.*

cd /etc/openvpn/easy-rsa/

source ./vars

./build-key cliente

tar cvf /var/www/html/zabbix/vpn/cliente.tar keys/cliente.*

Se instala el servicio openvpn

yum install openvpn

1	yum install openvpn

Copiar los certificados a la carpeta openvpn

Para que el servicio inicie se debe ejecutar

systemctl -f enable openvpn@client.service

1	systemctl -f enable openvpn@client.service

Para subir el servicio

systemctl start openvpn@client

1	systemctl start openvpn@client

Si sale que el certificado no es valido «not yet valid» verificar la fecha del servidor y arreglarla.

No package openvpn available

Si te sale este error, debes activar el siguiente repositorio

wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -ivh epel-release-latest-7.noarch.rpm
yum update
yum install openvpn

wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

rpm -ivh epel-release-latest-7.noarch.rpm

yum update

yum install openvpn