Clickatell - New API


(Emmanuel Chanson) #1

Hello, Come back to playSMS after a long time I am deploying playSMS version 1.4.
I try to configure Clickatell Gateway until I discover the plugin is obsolete because Clickatell changed its API.
I am modifying it but I am faced to a strange behavior.

I succeed to send SMS and the response received is processed to retrieve apiMessageId and set the statut to 1=sent in playsms BUT daemon DLRD modify the statut and keep adding new entries in the DLR table.

Why ?

curl <clickatell_url>

{“messages”:[
{
“apiMessageId”:“f1d62a882833431d8419047c334541d4”,
“accepted”:true,
“to”:“xxxxxxxx”,
“error”:null
}],
“error”:null
}

Can not put log (new user can only post 2 links it is said
Can not attach a file

[root@server gateway]# mysql -u root playsms -e "select * from playsms_tblDLR WHERE smslog_id=26;"
±------------±-----±---------------±----------±---------±----+
| c_timestamp | id | flag_processed | smslog_id | p_status | uid |
±------------±-----±---------------±----------±---------±----+
| 1518486787 | 1726 | 2 | 26 | 3 | 1 |
| 1518486787 | 1727 | 2 | 26 | 3 | 1 |
| 1518486839 | 1728 | 2 | 26 | 3 | 1 |
| 1518486840 | 1729 | 2 | 26 | 3 | 1 |
| 1518486841 | 1730 | 2 | 26 | 3 | 1 |
| 1518486842 | 1731 | 2 | 26 | 3 | 1 |
| 1518486843 | 1732 | 2 | 26 | 3 | 1 |
| 1518486844 | 1733 | 2 | 26 | 3 | 1 |
| 1518486845 | 1734 | 2 | 26 | 3 | 1 |
| 1518486846 | 1735 | 2 | 26 | 3 | 1 |
| 1518486847 | 1736 | 2 | 26 | 3 | 1 |
| 1518486848 | 1737 | 2 | 26 | 3 | 1 |
| 1518486849 | 1738 | 2 | 26 | 3 | 1 |
| 1518486850 | 1739 | 2 | 26 | 3 | 1 |
| 1518486851 | 1740 | 2 | 26 | 3 | 1 |
| 1518486853 | 1741 | 2 | 26 | 3 | 1 |
| 1518486854 | 1742 | 2 | 26 | 3 | 1 |
| 1518486855 | 1743 | 2 | 26 | 3 | 1 |
| 1518486856 | 1744 | 2 | 26 | 3 | 1 |
| 1518486857 | 1745 | 2 | 26 | 3 | 1 |
Note: I have force the status to 3 in order to stop DLRd to process

Any idea how to solve this ?

Emmanuel


(Emmanuel Chanson) #4

115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L2 sendsms # start uid:1 sender_id:[1234] smsc:[]
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L3 sendsms # maxlen:459 footerlen:7 footer:[ @admin] msglen:21 message:[Test 18 - Clickatell]
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L2 sendsms_queue_create # saving queue_code:18225e9e629c912367aa723c0549b36c src:1234 scheduled:2018-02-13 12:53:05
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L2 sendsms_queue_create # saved queue_code:18225e9e629c912367aa723c0549b36c id:26
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L3 sendsms_manipulate_prefix # before prefix manipulation:[+xxxxxxxxx]
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L3 sendsms_manipulate_prefix # after prefix manipulation:[+xxxxxxxxx]
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L3 simplerate_hook_rate_getbyprefix # found rate id:1 prefix:687 rate:1.000 description:Nouvelle-Calédonie to:+xxxxxxxxx
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L3 simplerate_hook_rate_getcharges # uid:1 u:admin len:28 unicode:0 to:+xxxxxxxxx enable_credit_unicode:0 count:1 rate:1.000 charge:1
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L2 sendsms # dst_count:1 sms_count:1 total_charges:1
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L2 sendsms_queue_push # saving queue_code:18225e9e629c912367aa723c0549b36c dst:+xxxxxxxxx
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L2 sendsms_queue_push # saved queue_code:18225e9e629c912367aa723c0549b36c smslog_id:26
115.126.162.204 server.com 2018-02-13 12:53:05 PID5a8245011738b admin L2 sendsms # end queue_code:18225e9e629c912367aa723c0549b36c queue_count:1 sms_count:1 failed_queue:0 failed_sms:0

    • 2018-02-13 12:53:06 PID5a8245025847a - L2 sendsmsd # start processing queue_code:18225e9e629c912367aa723c0549b36c chunk:0 queue_count:1 sms_count:1 scheduled:2018-02-13 12:53:05 uid:1 gpid:0 sender_id:1234
    • 2018-02-13 12:53:06 PID5a8245025847a - L2 sendsmsd # sending queue_code:18225e9e629c912367aa723c0549b36c smslog_id:26 to:+xxxxxxxxx sms_count:1 counter:1
    • 2018-02-13 12:53:06 PID5a8245025847a - L3 sendsms_intercept # msgtemplate modified sms_sender:[1234] sms_footer:[@admin] sms_to:[+xxxxxxxxx] sms_msg:[Test 18 - Clickatell] uid:[1] gpid:[0] sms_type:[text] unicode:[0] queue_code:[18225e9e629c912367aa723c0549b36c] smsc:[]
    • 2018-02-13 12:53:06 PID5a8245025847a - L3 outgoing_hook_sendsms_intercept # no SMSC found uid:1 parent_uid:0 from:1234 to:+xxxxxxxxx
    • 2018-02-13 12:53:06 PID5a8245025847a - L2 recvsms_process # using default SMSC smsc:[clickatelldev]
    • 2018-02-13 12:53:06 PID5a8245025847a - L2 sendsms_process # start
    • 2018-02-13 12:53:06 PID5a8245025847a - L3 simplerate_hook_rate_getbyprefix # found rate id:1 prefix:687 rate:1.000 description:Nouvelle-Calédonie to:+xxxxxxxxx
    • 2018-02-13 12:53:06 PID5a8245025847a - L3 simplerate_hook_rate_getcharges # uid:1 u:admin len:28 unicode:0 to:+xxxxxxxxx enable_credit_unicode:0 count:1 rate:1.000 charge:1
    • 2018-02-13 12:53:06 PID5a8245025847a - L2 simplerate_hook_rate_cansend # allowed user uid:1 sms_to:+xxxxxxxxx adhoc_credit:4 count:1 rate:1.000 charge:1 adhoc_balance:3
    • 2018-02-13 12:53:06 PID5a8245025847a - L2 sendsms # saving smslog_id:26 u:1 parent_uid:0 g:0 gw:clickatell smsc:clickatelldev s:1234 d:+xxxxxxxxx type:text unicode:0 status:0
    • 2018-02-13 12:53:06 PID5a8245025847a - L2 sendsms_process # saved smslog_id:26 id:27
    • 2018-02-13 12:53:06 PID5a8245025847a - L3 sendsms # final smslog_id:26 gw:clickatell smsc:clickatelldev message:Test 18 - Clickatell @admin len:28
    • 2018-02-13 12:53:06 PID5a8245025847a - L3 clickatell_hook_sendsms # enter smsc:clickatelldev smslog_id:26 uid:1 to:+xxxxxxxxx
    • 2018-02-13 12:53:07 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:53:07 PID5a8245025847a - L2 clickatell__outgoing # smslog_id:26 charge: sms_status:1 response: [Id:07b00f2167f648ceba3f1576f35db501|To:xxxxxxxxx|Error:]
    • 2018-02-13 12:53:07 PID5a8245025847a - L3 dlr # isdlrd:1 smslog_id:26 p_status:1 uid:1
    • 2018-02-13 12:53:07 PID5a8245025847a - L2 simplerate_hook_rate_deduct # enter smslog_id:26
    • 2018-02-13 12:53:07 PID5a8245025847a - L3 simplerate_hook_rate_getbyprefix # found rate id:1 prefix:687 rate:1.000 description:Nouvelle-Calédonie to:+xxxxxxxxx
    • 2018-02-13 12:53:07 PID5a8245025847a - L3 simplerate_hook_rate_getcharges # uid:1 u:admin len:28 unicode:0 to:+xxxxxxxxx enable_credit_unicode:0 count:1 rate:1.000 charge:1
    • 2018-02-13 12:53:07 PID5a8245025847a - L2 simplebilling_hook_billing_post # saving smslog_id:26 rate:1.000 count:1 charge:1
    • 2018-02-13 12:53:07 PID5a8245025847a - L2 simplebilling_hook_billing_post # saved smslog_id:26 id:15
    • 2018-02-13 12:53:07 PID5a8245025847a - L3 simplerate_hook_rate_deduct # deduct successful uid:1 parent_uid:0 smslog_id:26
    • 2018-02-13 12:53:07 PID5a8245025847a - L2 sendsms_process # end
    • 2018-02-13 12:53:07 PID5a8245025847a - L2 sendsmsd # result queue_code:18225e9e629c912367aa723c0549b36c to:+xxxxxxxxx flag:1 smslog_id:26
    • 2018-02-13 12:53:07 PID5a8245025847a - L2 sendsmsd # finish processing queue_code:18225e9e629c912367aa723c0549b36c uid:1 sender_id:1234 queue_count:1 sms_count:1
    • 2018-02-13 12:53:08 PID5a821d84b14b7 - L3 dlrd # id:1726 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:53:08 PID5a821d84b14b7 - L3 dlrd # id:1727 smslog_id:26 p_status:1 uid:1
    • 2018-02-13 12:53:08 PID5a821d84b14b7 - L2 simplebilling__finalize # saving smslog_id:26
    • 2018-02-13 12:53:08 PID5a821d84b14b7 - L2 simplebilling__finalize # saved smslog_id:26
    • 2018-02-13 12:53:59 PID5a821d84b40cc - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:00 PID5a821d84b14b7 - L3 dlrd # id:1728 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:00 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:01 PID5a821d84b14b7 - L3 dlrd # id:1729 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:01 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:02 PID5a821d84b14b7 - L3 dlrd # id:1730 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:02 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:03 PID5a821d84b14b7 - L3 dlrd # id:1731 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:03 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:04 PID5a821d84b14b7 - L3 dlrd # id:1732 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:04 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:05 PID5a821d84b14b7 - L3 dlrd # id:1733 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:05 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:06 PID5a821d84b14b7 - L3 dlrd # id:1734 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:06 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:07 PID5a821d84b14b7 - L3 dlrd # id:1735 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:07 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:08 PID5a821d84b14b7 - L3 dlrd # id:1736 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:08 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:09 PID5a821d84b14b7 - L3 dlrd # id:1737 smslog_id:26 p_status:0 uid:1
    • 2018-02-13 12:54:09 PID5a821d84b14b7 - L3 dlr # isdlrd:1 smslog_id:26 p_status:0 uid:1