Nexmo No longer Working

Closed Posted 4 years ago Paid on delivery
Closed Paid on delivery

I have a subscription service which sends out receipt via Nexmo.

Seems the system was build with perl.

The subscription service still works but sms no longer goes out.

I do not understand clearly where to check credentials.

This is the most relevant script I found

I need someone who can troubleshoot and fix the issue, issue is most likely due to new logins or api

cat [login to view URL]

#!/usr/bin/perl -I .

#

use strict;

use warnings;

use mlib::db;

use mlib::html;

use mlib::utils;

use mlib::session;

my $sql0="update sms_queue set result='outdated' where atdate<date_sub(now(),interval 1 day) and result is null";

my $sql="select id,phone,sms_text from sms_queue where atdate>date_sub(now(),interval 1 day) and result is null";

my $con=Mconnect();

$con->ping() or $con=Mconnect();

db_query_exec_($sql0,$con);

db_commit_($con);

my $input=db_query_($sql,$con);

for my $row (@{$input}){

my ($id,$phone,$sms_text)=@{$row};

print "$id,$phone,$sms_text\n";

my $res=do_sms2($phone,$sms_text);

print $res."`date`\n";

db_query_exec_("update sms_queue set result=".db_quote($res)." where id=$id",$con);

db_commit_($con);

sleep 2;

}

sleep 2;

$con->disconnect();

[root@pin-call scripts]#

MySQL Linux Perl XML Bash Scripting

Project ID: #23494008

About the project

6 proposals Remote project Active 4 years ago

6 freelancers are bidding on average $168 for this job

Alian123soleil

Hi ! I can be interested in your project. I know well your environment, so let me search if I can find & fix this quickly. If I don't find shortly it's free for you. Ping me for any question. Have a good day.

$150 USD in 2 days
(53 Reviews)
6.6
stepinnsolution

Hi, I have more than 10 years of development experience in multiple technologies. I have gone through your requirements and ready to complete your job. I am committed to provide you high quality services. My goal is t More

$220 USD in 7 days
(25 Reviews)
5.0
umairkaramat24

Hello There. How are you doing?. I have read the description, I have great experience doing similar jobs related to these skills Bash Scripting, Linux, MySQL, Perl, XML. Please start the chat so we can have detailed di More

$155 USD in 7 days
(4 Reviews)
3.9
ramepo6585

I WILL START QUICKLY!!! Hello I am a senior developer. I want to do it for you if you want. we can discuss more about this project. if you can send a reply. I waiting for you best response. let me discuss Many thanks

$140 USD in 7 days
(0 Reviews)
0.0
promax0107

Glad to see U. I will never make you disappointed. If you give me a chance to work with you, I will provide you with high-quality work only for you daily. I am always ready for you to discuss your project. -Time is mo More

$140 USD in 7 days
(0 Reviews)
0.0
pythonworkforay

I am a very experience software developer with extensive working knowledge using django and python to build full stack web application. I have worked on a lot of django based projects in the past and will happily show More

$200 USD in 7 days
(0 Reviews)
0.0