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 [url removed, login to view];Mensajes 20;

mark trunks_trunk.balance=[url removed, login to view] 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 mark, ussd, sms asterisk, rx, issue, shell script perl, issue asterisk, perl sms script, datetime, variable mysql, shell script mysql, line sms, sms monitor, asterisk mysql php, mysql shell script, ussd php, asterisk dongle commands, dongle sms mysql, asterisk carrier, mysql log, top balance script, file based mysql, dongle sms, perl log, log file

Concernant l'employeur :
( 87 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