UDP Soporte y Comunicaciones

septiembre 26, 2014mayo 8, 2019

Configurar Asterisk para Enviar Voicemail Email via Gmail

Tutorial para remplazar el gestor de correo en los servidores asterisk

Continuar leyendo «Configurar Asterisk para Enviar Voicemail Email via Gmail»

septiembre 25, 2014mayo 8, 2019

Cambiar la fecha y hora del servidor

Fecha

date +%Y%m%d -s "20141128"

1	date +%Y%m%d -s "20141128"

Hora

date +%T -s "16:45:00"

1	date +%T -s "16:45:00"

Grabar los datos en el board

hwclock --systohc

1	hwclock --systohc

Sincronizar el reloj con un Time Servers

Revisar la hora actual

timedatectl nos dice la hora del sistema

timedatectl status

1	timedatectl status

Sincronizar la hora del Sistema

The chronyd command lets you check the time by which your system clock is off. If you run a chronyd command without installing the utility first, you will get the following message:

The chronyd command

Please install the Chrony utility as follows:

sudo apt install chrony

1	sudo apt install chrony

You can then use the following command to see how much your time varies from the internet server. The “System clock wrong by” line in the output indicates this thing.

sudo chronyd -Q

1	sudo chronyd -Q

You can also synchronize the system time and see the “System clock wrong by” information in one go through the following command:

sudo chronyd -q

1	sudo chronyd -q

In the following example, you can see that when I first ran the chronyd -q command, my system was off by 95.9 seconds. After running the command, my internet time was reset and that can be observed when I re-ran the command. This time my system clock is only off by -0.001446 seconds which is an ignorable difference.

septiembre 25, 2014mayo 8, 2019

Como hacer tuneles desde ssh

ssh root@10.210.1.90 -L 10081:192.168.2.1:81

1	ssh root@10.210.1.90 -L 10081:192.168.2.1:81

10.210.1.90:Ip del cliente
10081:Puerto Local
192.168.2.1: Equipo a conectarse
81: Puerto del equipo a conectarse

10.210.1.90:Ip del cliente

10081:Puerto Local

192.168.2.1: Equipo a conectarse

81: Puerto del equipo a conectarse

septiembre 25, 2014

Detectar ocupado en un FXO

En el zaptel.con se debe anexar lo siguiente:

callprogress=yes 
busydetect=yes

1 2	callprogress=yes busydetect=yes

septiembre 25, 2014abril 25, 2016

Instalar ODBC en Linux

Primero instalar el unixODBC

yum install unixODBC*
yum install php-odbc*
yum install freetds

yum install unixODBC*

yum install php-odbc*

yum install freetds

Probar la conexion

tsql -S SERVIDOR –U USUARIO

1	tsql -S SERVIDOR –U USUARIO

Editar /etc/odbc.ini

[solsaludtds]
Description	= TDS
Driver		= TDS
Server		= 192.168.1.252
Database 	= solsalud
UID 		= callcenter
PWD 		= call.cn.sol.2007
port 		= 1433

[solsaludtds]

Description = TDS

Driver = TDS

Server = 192.168.1.252

Database = solsalud

UID = callcenter

PWD = call.cn.sol.2007

port = 1433

Editar /etc/odbcinst.ini

[TDS]
Description     =  v0.60 with Protocol v7.0
Driver          = /usr/lib/libtdsodbc.so.0
Setup           = /usr/lib/libtdsS.so.1
FileUsage       = 1

[TDS]

Description = v0.60 with Protocol v7.0

Driver = /usr/lib/libtdsodbc.so.0

Setup = /usr/lib/libtdsS.so.1

FileUsage = 1

Si el sistema esta a 64bits

[TDS]
Description     =  v0.60 with Protocol v7.0
Driver          = /usr/lib64/libtdsodbc.so.0
Setup           = /usr/lib64/libtdsS.so.1
FileUsage       = 1

[TDS]

Description = v0.60 with Protocol v7.0

Driver = /usr/lib64/libtdsodbc.so.0

Setup = /usr/lib64/libtdsS.so.1

FileUsage = 1

Probar la conexion

isql -v solsalud USUARIO CLAVE

1	isql -v solsalud USUARIO CLAVE

Para probar el PHP

#!/usr/bin/php -q
<?php

$sql="select * from ips";
$conn=odbc_connect('solsaludtds','sa','password');
if (!$conn) {exit("Connection Failed -: " . $conn);}

$rs=odbc_exec($conn,$sql);
if (!$rs) {
        echo "Error en SQL";
}

$i=0;
if (odbc_fetch_row($rs))
{
        $compname18=odbc_result($rs,18);
        $i=1;
}

if ($i==1)
{
        echo "REGISTRO ENCONTRADO";
        if($compname18=="1")
        {
                echo "CLAVE OK";
        }else
        {
                echo "CLAVE ERRONEA";
        }
}
else
{
        echo "REGISTRO NO ENCONTRADO";
}

odbc_close($conn);

?>