atefsaeed2010 / datacard

Automatically exported from code.google.com/p/datacard
Other
0 stars 1 forks source link

problem with recieving large sms #59

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
I use external application to read/send sms (sending through gateway).
=======part of extensions.conf======
[gsm-in]
....
exten => 
sms,1,Macro(sql-query-sms-insert,${DATACARD},${CALLERID(num)},${SMS_BASE64})
exten => sms,n,Hangup()

[macro-sql-query-sms-insert]
exten => s,1,MYSQL(Connect connid localhost user pass db)
exten => s,n,MYSQL(Query r ${connid} INSERT INTO short_messages SET 
datacard='${ARG1}',callerid='${ARG2}',body='${SQL_ESC(${BASE64_DECODE(${ARG3})})
}',created_at=UTC_TIMESTAMP())
exten => s,n,MYSQL(Disconnect ${connid})
====================================

Problem appears when i want to recieve large sms.
They come as few pieces and each part wrote into DB separately.
How identify them and concatenate in one message?
Maybe you add some variable as SMSID? (And after use GROUP BY request in DB)

Thanks.

Original issue reported on code.google.com by Alexande...@gmail.com on 10 Feb 2011 at 10:50

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
User header of SMS (where part# of long SMS defined) at present time just 
ignored.
No passed up.

Original comment by bg_...@mail.ru on 11 Feb 2011 at 11:49

GoogleCodeExporter commented 9 years ago
And when we can expect the appearance this feature?

Original comment by Alexande...@gmail.com on 24 Feb 2011 at 9:09

GoogleCodeExporter commented 9 years ago
i will add feature 'pass up raw PDU' ASAP.

Original comment by bg_...@mail.ru on 27 Feb 2011 at 12:20

GoogleCodeExporter commented 9 years ago
in r191 added DatacardNewCMGR  and ${CMGR} (may be TODO ${CMGR_BASE64} die to 
multiline )

please test and feedback

Original comment by bg_...@mail.ru on 27 Feb 2011 at 1:52

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
${CMGR} contain full SMS as reported by modem in response, not SMS ID
asterisk cut content of variable to first newline 

Original comment by bg_...@mail.ru on 28 Feb 2011 at 5:05