En cours

issue shell command from mysql and parse log

Need a script which will monitor db changes

When it detect changes, issues some commands from shell and parse a log file.

You will be working with 2 tables from 2 differnt db

DB

asterisk

sim_bank

every X times trunks_trunk.in_dial changes from 1 to 0 or 0 to 1 (X is a variable defined on top of script)

issue

asterisk -rx "dongle ussd [[url removed, login to view]] [carrier.ussd_balance]

asterisk -rx "dongle show devices"

In result you will get name and IMSI

mark IMSI in [url removed, login to view] for matching [url removed, login to view]

parse

/var/log/asterisk/sms-ussd

for values based on db ie

if carrier.balance_string is

Principal @balance@;

and you find in log

USB715: Saldo Principal 0.00;Mensajes 20;

mark trunks_trunk.balance=0.00 where name = USB715

keep track of where u last parsed log so u dont parse that part again

log file has datetime stamped for every line

Compétences : Linux, MySQL, Perl, PHP, Administration Système

Voir plus : asterisk-perl, asterisk mark, ussd, sms asterisk, RX, issue, shell script perl, perl script shell script, issue asterisk, perl sms script, datetime, parse php, variable mysql, shell script mysql, line sms, sms monitor, parse log, asterisk mysql php, mysql shell script, ussd php, asterisk dongle commands, dongle sms mysql, asterisk carrier, mysql log, top balance script

Concernant l'employeur :
( 88 commentaires ) dix hills, United States

N° du projet : #2358739

Décerné à :

gangabass

I can do this for you. See PM for details.

90 $ USD en 1 jour
(201 Commentaires)
6.2

6 freelance ont fait une offre moyenne de 195 $ pour ce travail

k1ng440

Full time freelance web developer with 7 years of commercial experience.

250 $ USD en 3 jours
(93 Commentaires)
6.5
shakoush2001

Hi I am a CISSP,RHCE,CCNA,MCSA,Linux+ and a CEH. I do have 7+ years experience in System Administration . I have experience in a high availability environment with 100+ servers and more than 500 000+ subscribers, I kno Plus

200 $ USD en 10 jours
(86 Commentaires)
6.4
kommandant

i can help

250 $ USD en 1 jour
(24 Commentaires)
4.7
amsak

Placing bid

300 $ USD en 30 jours
(10 Commentaires)
3.8
billyhoward1

As a devops engineer I've lots of experience with developing these sort of tools.

80 $ USD en 2 jours
(1 Commentaire)
0.0