Thanks for the quick reply Thanasis...
*Do the "original_ref_no" and "gateway_id" of the IN table match the
"ref_no" and "gateway_id" of the OUT table? *
Yes it matches.
I only have one modem setup for this testing (modem1).
*Is the IN."type" == "S" for the status report message? *
Yes it is "S"
Just to let you know I have the same "ref no" repeated in OUT table. for
some ref nos. can this be an issue?
On Wednesday, September 5, 2012 1:51:09 AM UTC+5:30, Thanasis wrote:
>
> Hi,
>
> Weird...
> Do the "original_ref_no" and "gateway_id" of the IN table match the
> "ref_no" and "gateway_id" of the OUT table?
> Is the IN."type" == "S" for the status report message?
>
> On 4 September 2012 12:23, SMSLib Discussion Group on behalf of Ruchi <
> smslib+noreply-apn2wqevdeldjfzw4y8rwhuq3yi0n-gcp6knmr4qekq7l3...@googlegroups.com<javascript:>
> > wrote:
>
>> Hi
>>
>> I'm using the latest version of SMSLib and SMSServer (ver. 3.5.2).
>>
>> I have successfully configured it and the SMS server is sending &
>> receiving sms messages using an iTegno GMS modem W3800E with a Mysql
>> database interface (the table structures created using the provided script)
>> and I don't use SMSLib api as I don't have such requirement at the the time
>> being.
>>
>> I have a requirement of capturing delivery status report of chosen
>> outbound messages (Just to mention the service provider of the SIM card
>> supports delivery status reports).
>>
>> My database interface configuration is as follows.
>>
>> # Here is an example of a MySQL database interface.
>> interface.0=db1, Database
>> db1.type=mysql
>> db1.url=jdbc:mysql://localhost:3306/smslib?autoReconnect=true
>> db1.driver=com.mysql.jdbc.Driver
>> db1.username=root
>> db1.password=root123
>> db1.tables.sms_in=smsserver_in
>> db1.tables.sms_out=smsserver_out
>> db1.tables.calls=smsserver_calls
>> db1.batch_size=100
>> db1.retries=2
>> db1.update_outbound_on_statusreport=*yes*
>>
>> I use "*status_report" *column in the outbound message table
>> (smsserver_out) as *"1" *and the message is being successfully sent but
>> the *"status" *column is only being updated as *"S"*
>> *
>> *
>> When I query the inbound table (smsserver_in) I can see the
>> respective delivery status message record ("text" column with the value "00
>> - Succesful Delivery").
>>
>> But the problem is the *"status" *column of the respective record in the
>> outbound table is not get updated as *"D"* even after
>> the delivery status report is received as mentioned in the doc.
>>
>> Can someone help me to get this work or guide me to fix this if I have
>> done any mis-configuration.
>>
>> Thanks!!
>>
>> On Tuesday, December 9, 2008 3:06:31 PM UTC+5:30, benficamania wrote:
>>>
>>> I'm gonna try with another modem... Maybe it's from the terminal, like
>>> Thanasis said...
>>> Thanks
>>>
>>> 2008/12/9 benficamania <[email protected]>
>>>
>>>> I want to know if a message have been delivered or not... In the
>>>> outbound message I set the status field to "true", so I think the status
>>>> in
>>>> the message should be set to "D" when delivered, but this doesn't happen...
>>>>
>>>> 2008/12/9 Aryo Sanjaya <[email protected]>
>>>>
>>>> Just wanna make it clear:
>>>>>
>>>>> - If you want to get status for sent SMS: check for "S" status
>>>>> - If you want to get status for delivered SMS: check for "D" status
>>>>>
>>>>> Maybe like that.
>>>>>
>>>>>
>>>>> Best Regards,
>>>>>
>>>>> Aryo Sanjaya
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Dec 9, 2008 at 16:21, benficamania <[email protected]>wrote:
>>>>>
>>>>>> So, there's nothing i can do to get status message?
>>>>>>
>>>>>> 2008/12/7 Thanasis <[email protected]>
>>>>>>
>>>>>>
>>>>>>> The "S" stands for "sent". Once the message gets sent sucessfully,
>>>>>>> the
>>>>>>> flag is set to "S".
>>>>>>> If sms delivery reports worked, you would get a "D" for
>>>>>>> "delivered" (see
>>>>>>> http://smslib.org/doc/**smsserver/interfaces/db/<http://smslib.org/doc/smsserver/interfaces/db/>
>>>>>>> ).
>>>>>>>
>>>>>>> On Dec 7, 4:23 pm, benficamania <[email protected]> wrote:
>>>>>>> > Yes, he reaches it... But it's strange that even with the
>>>>>>> destination
>>>>>>> > cellphone off, the status in the outbound messages table is set to
>>>>>>> "S"
>>>>>>> >
>>>>>>> > 2008/12/5, Thanasis <[email protected]>:
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> > > Hi,
>>>>>>> >
>>>>>>> > > The compatibility list is just an indication.
>>>>>>> > > I really cannot say if this is a problem of the M20 terminal.
>>>>>>> The only
>>>>>>> > > way to be sure is to find some other model and test that as well.
>>>>>>> >
>>>>>>> > > Does the message reach the recipient?
>>>>>>> >
>>>>>>> > > On Dec 5, 10:51 am, benficamania <[email protected]> wrote:
>>>>>>> > > > I see this (see File)... Maybe the problem is with the M20
>>>>>>> terminal... I
>>>>>>> > > can
>>>>>>> > > > send and receive SMS with it, but he's not in the
>>>>>>> compatibility list...
>>>>>>> >
>>>>>>> > > > Thanks
>>>>>>> >
>>>>>>> > > > 2008/12/3 Thanasis <[email protected]>
>>>>>>> >
>>>>>>> > > > > Hi,
>>>>>>> >
>>>>>>> > > > > Lets start the easy way, shall we? :)
>>>>>>> >
>>>>>>> > > > > Modify the SendMessage example and ask it to provide a
>>>>>>> status report.
>>>>>>> > > > > Run it to send the message and leave it running (it will say
>>>>>>> > > > > "sleeping..." blah blah). At some time after a few minutes
>>>>>>> you should
>>>>>>> > > > > see the alert that a new message has been received. Do you
>>>>>>> see this
>>>>>>> > > > > behaviour?
>>>>>>> >
>>>>>>> > > > > On Dec 3, 4:08 pm, benficamania <[email protected]>
>>>>>>> wrote:
>>>>>>> > > > > > I'm from Portugal... If I receive a report when using the
>>>>>>> sim-card in
>>>>>>> > > a
>>>>>>> > > > > > normal cellphone, I think I should receive a report using
>>>>>>> the
>>>>>>> > > sim-card in
>>>>>>> > > > > a
>>>>>>> > > > > > modem... But I'm not sure... I'm gonna try with a sim-card
>>>>>>> from
>>>>>>> > > another
>>>>>>> > > > > > operator...
>>>>>>> >
>>>>>>> > > > > > 2008/12/3 Jeff <[email protected]>
>>>>>>> >
>>>>>>> > > > > > > StatusReports are telco-specific I think. Here in the
>>>>>>> Philippines
>>>>>>> > > I
>>>>>>> > > > > > > never got a status report at all. But I think Thanasis
>>>>>>> is able to
>>>>>>> > > get
>>>>>>> > > > > > > them in Greece.
>>>>>>> >
>>>>>>> > > > > > > On Dec 3, 6:51 pm, "[email protected]" <
>>>>>>> > > [email protected]>
>>>>>>> > > > > > > wrote:
>>>>>>> > > > > > > > I've been trying for the last 10 days to use the
>>>>>>> Status Reports
>>>>>>> > > > > > > > functionality, but it doesn't work... I put the
>>>>>>> message in the
>>>>>>> > > > > > > > database with the status report field = 1, the
>>>>>>> SMSServer.conf
>>>>>>> > > have
>>>>>>> > > > > the
>>>>>>> > > > > > > > fields for status reports set to yes, but the Status
>>>>>>> Report
>>>>>>> > > doesn´t
>>>>>>> > > > > > > > work... Even when i turn my cellphone off and try to
>>>>>>> send a SMS
>>>>>>> > > to
>>>>>>> > > > > the
>>>>>>> > > > > > > > cellphone, using a modem, the status of the output
>>>>>>> message in the
>>>>>>> > > > > > > > database is set to "S"... I'm using a M20 terminal...
>>>>>>> Has anybody
>>>>>>> > > > > > > > implemented a system with status reports really
>>>>>>> working? How?
>>>>>>> >
>>>>>>> > > > > > > > Thanks...- Hide quoted text -
>>>>>>> >
>>>>>>> > > > > > - Show quoted text -
>>>>>>> >
>>>>>>> > > > [SMSLib.txt13K ]Output with msg.setStatusReport(true);
>>>>>>> >
>>>>>>> > > > Modem Information:
>>>>>>> > > > Manufacturer: SIEMENS
>>>>>>> > > > Model: M20
>>>>>>> > > > Serial No: 520008411028388
>>>>>>> > > > SIM IMSI: ** MASKED **
>>>>>>> > > > Signal Level: 87%
>>>>>>> > > > Battery Level: 100%
>>>>>>> >
>>>>>>> > > ==============================**==============================**
>>>>>>> ===================
>>>>>>> > > > << OutboundMessage >>
>>>>>>> >
>>>>>>> > > ------------------------------**------------------------------**
>>>>>>> -------------------
>>>>>>> > > > Gateway Id: modem.com1
>>>>>>> > > > Encoding: 7-bit
>>>>>>> > > > Date: Wed Dec 03 21:36:57 GMT 2008
>>>>>>> > > > SMSC Ref No: 233
>>>>>>> > > > Recipient: +351969343198
>>>>>>> > > > Dispatch Date: Wed Dec 03 21:37:01 GMT 2008
>>>>>>> > > > Message Status: SENT
>>>>>>> > > > Validity Period (Hours): -1
>>>>>>> > > > Status Report: true
>>>>>>> > > > Source / Destination Ports: -1 / -1
>>>>>>> > > > Flash SMS: false
>>>>>>> > > > Text: Hello from SMSLib!
>>>>>>> > > > PDU data: C8329BFD0699E5EF3668DA9C32D3E2**10
>>>>>>> >
>>>>>>> > > ==============================**==============================**
>>>>>>> ===================
>>>>>>> >
>>>>>>> > > > Now Sleeping - Hit <enter> to terminate.
>>>>>>> >
>>>>>>> > > > Output with msg.setStatusReport(false)
>>>>>>> >
>>>>>>> > > > Modem Information:
>>>>>>> > > > Manufacturer: SIEMENS
>>>>>>> > > > Model: M20
>>>>>>> > > > Serial No: 520008411028388
>>>>>>> > > > SIM IMSI: ** MASKED **
>>>>>>> > > > Signal Level: 83%
>>>>>>> > > > Battery Level: 100%
>>>>>>> >
>>>>>>> > > ==============================**==============================**
>>>>>>> ===================
>>>>>>> > > > << OutboundMessage >>
>>>>>>> >
>>>>>>> > > ------------------------------**------------------------------**
>>>>>>> -------------------
>>>>>>> > > > Gateway Id: modem.com1
>>>>>>> > > > Encoding: 7-bit
>>>>>>> > > > Date: Wed Dec 03 21:41:49 GMT 2008
>>>>>>> > > > SMSC Ref No: 234
>>>>>>> > > > Recipient: +351969343198
>>>>>>> > > > Dispatch Date: Wed Dec 03 21:41:54 GMT 2008
>>>>>>> > > > Message Status: SENT
>>>>>>> > > > Validity Period (Hours): -1
>>>>>>> > > > Status Report: false
>>>>>>> > > > Source / Destination Ports: -1 / -1
>>>>>>> > > > Flash SMS: false
>>>>>>> > > > Text: Hello from SMSLib!
>>>>>>> > > > PDU data: C8329BFD0699E5EF3668DA9C32D3E2**10
>>>>>>> >
>>>>>>> > > ==============================**==============================**
>>>>>>> ===================
>>>>>>> >
>>>>>>> > > > Now Sleeping - Hit <enter> to terminate.
>>>>>>> >
>>>>>>> > > > DEBUG:
>>>>>>> >
>>>>>>> > > > 0 [Thread-1] INFO org.smslib - GTW: modem.com1: Starting
>>>>>>> gateway, using
>>>>>>> > > Generic AT Handler.
>>>>>>> > > > 21 [Thread-1] INFO org.smslib - GTW: modem.com1: Opening:
>>>>>>> COM1 @9600
>>>>>>> > > > 51 [SMSLib-WatchDog] DEBUG org.smslib - WatchDog started.
>>>>>>> > > > 51 [SMSLib-WatchDog] INFO org.smslib - WatchDog running...
>>>>>>> > > > 591 [Thread-1] DEBUG org.smslib - GTW: modem.com1:
>>>>>>> ModemDriver:
>>>>>>> > > KeepAlive thread started.
>>>>>>> > > > 621 [Thread-1] DEBUG org.smslib - GTW: modem.com1:
>>>>>>> ModemReader thread
>>>>>>> > > started.
>>>>>>> > > > 631 [Thread-1] DEBUG org.smslib - GTW: modem.com1:
>>>>>>> AsyncNotifier thread
>>>>>>> > > started.
>>>>>>> > > > 631 [Thread-1] DEBUG org.smslib - GTW: modem.com1:
>>>>>>> AsyncMessageProcessor
>>>>>>> > > thread started.
>>>>>>> > > > 641 [Thread-1] DEBUG org.smslib - GTW: modem.com1:
>>>>>>> clearBuffer() called.
>>>>>>> > > > 1643 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND :(27)
>>>>>>> > > > 1863 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND :+++
>>>>>>> > > > 2063 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND :ATZ
>>>>>>> > > > 2264 [Thread-1] DEBUG org.smslib - GTW: modem.com1:
>>>>>>> clearBuffer()
>>>>>>> > > called.
>>>>>>> > > > 3265 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :ATZ(cr)
>>>>>>> > > > 3495 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :ATE0(cr)
>>>>>>> > > > 3726 [Thread-1] DEBUG org.smslib - GTW: modem.com1:
>>>>>>> clearBuffer()
>>>>>>> > > called.
>>>>>>> > > > 4727 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+CPIN?(cr)
>>>>>>> > > > 4877 [Thread-1] DEBUG org.smslib - GTW: modem.com1: BUFFER:
>>>>>>> +CPIN: READY
>>>>>>> >
>>>>>>> > > > 4918 [Thread-1] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :+CPIN:
>>>>>>> > > READY(cr)
>>>>>>> > > > 4918 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :ATE0(cr)
>>>>>>> > > > 5118 [Thread-1] DEBUG org.smslib - GTW: modem.com1:
>>>>>>> clearBuffer()
>>>>>>> > > called.
>>>>>>> > > > 6119 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+CLIP=1(cr)
>>>>>>> > > > 6630 [Thread-1] DEBUG org.smslib - GTW: modem.com1: BUFFER: OK
>>>>>>> >
>>>>>>> > > > 6630 [Thread-1] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :OK(cr)
>>>>>>> > > > 6630 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+COPS=0(cr)
>>>>>>> > > > 7061 [Thread-1] DEBUG org.smslib - GTW: modem.com1: BUFFER: OK
>>>>>>> >
>>>>>>> > > > 7061 [Thread-1] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :OK(cr)
>>>>>>> > > > 7061 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :ATE0(cr)
>>>>>>> > > > 7261 [Thread-1] DEBUG org.smslib - GTW: modem.com1:
>>>>>>> clearBuffer()
>>>>>>> > > called.
>>>>>>> > > > 8262 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+CREG?(cr)
>>>>>>> > > > 8613 [Thread-1] DEBUG org.smslib - GTW: modem.com1: BUFFER:
>>>>>>> +CREG: 0,1
>>>>>>> > > > OK
>>>>>>> >
>>>>>>> > > > 8613 [Thread-1] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :+CREG:
>>>>>>> > > 0,1(cr)OK(cr)
>>>>>>> > > > 8613 [Thread-1] INFO org.smslib - GTW: modem.com1: GSM:
>>>>>>> Registered to
>>>>>>> > > home network.
>>>>>>> > > > 8613 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+CMEE=1(cr)
>>>>>>> > > > 8693 [Thread-1] DEBUG org.smslib - GTW: modem.com1: BUFFER: OK
>>>>>>> >
>>>>>>> > > > 8693 [Thread-1] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :OK(cr)
>>>>>>> > > > 8693 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+CPMS?(cr)
>>>>>>> > > > 8833 [Thread-1] DEBUG org.smslib - GTW: modem.com1: BUFFER:
>>>>>>> +CPMS:
>>>>>>> > > "SM",0,30,"SM",0,30,"SM",0,30
>>>>>>> > > > OK
>>>>>>> >
>>>>>>> > > > 8833 [Thread-1] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :+CPMS:
>>>>>>> > > "SM",0,30,"SM",0,30,"SM",0,30(**cr)OK(cr)
>>>>>>> > > > 8833 [Thread-1] INFO org.smslib - GTW: modem.com1: MEM:
>>>>>>> Storage
>>>>>>> > > Locations Found: SM
>>>>>>> > > > 8843 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+CNMI=?(cr)
>>>>>>> > > > 8933 [Thread-1] DEBUG org.smslib - GTW: modem.com1: BUFFER:
>>>>>>> +CNMI:
>>>>>>> > > (0-3),(0-3),(0-2),0,(0-1)
>>>>>>> > > > OK
>>>>>>> >
>>>>>>> > > > 8933 [Thread-1] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :+CNMI:
>>>>>>> > > (0-3),(0-3),(0-2),0,(0-1)(cr)**OK(cr)
>>>>>>> > > > 8933 [Thread-1] DEBUG org.smslib - CNMI: Found best match: 3
>>>>>>> > > > 8933 [Thread-1] DEBUG org.smslib - CNMI: Found best match: 1
>>>>>>> > > > 8933 [Thread-1] DEBUG org.smslib - CNMI: Found best match: 0
>>>>>>> > > > 8933 [Thread-1] INFO org.smslib - CNMI: No best match,
>>>>>>> returning: 0
>>>>>>> > > > 8933 [Thread-1] DEBUG org.smslib - CNMI: Found best match: 0
>>>>>>> > > > 8933 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> > > :AT+CNMI=3,1,0,0,0(cr)
>>>>>>> > > > 9003 [Thread-1] DEBUG org.smslib - GTW: modem.com1: BUFFER: OK
>>>>>>> >
>>>>>>> > > > 9003 [Thread-1] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :OK(cr)
>>>>>>> > > > 9003 [Thread-1] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+CMGF=0(cr)
>>>>>>> > > > 9053 [Thread-1] DEBUG org.smslib - GTW: modem.com1: BUFFER: OK
>>>>>>> >
>>>>>>> > > > 9053 [Thread-1] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :OK(cr)
>>>>>>> > > > 9064 [Thread-1] DEBUG org.smslib - GTW: modem.com1:
>>>>>>> SyncMessageProcessor
>>>>>>> > > thread started.
>>>>>>> > > > 9074 [Thread-1] INFO org.smslib - GTW: modem.com1: Gateway
>>>>>>> started.
>>>>>>> > > > 9104 [SMSLib-QueueManager] INFO org.smslib - GTW: modem.com1:
>>>>>>> Starting
>>>>>>> > > Queue Manager.
>>>>>>> >
>>>>>>> > > > Modem Information:
>>>>>>> > > > 10065 [main] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+CGMI(cr)
>>>>>>> > > > 10345 [main] DEBUG org.smslib - GTW: modem.com1: BUFFER:
>>>>>>> SIEMENS
>>>>>>> > > > OK
>>>>>>> >
>>>>>>> > > > 10345 [main] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :SIEMENS(cr)OK(cr)
>>>>>>> > > > Manufacturer: SIEMENS
>>>>>>> > > > 10345 [main] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+CGMM(cr)
>>>>>>> > > > 10435 [main] DEBUG org.smslib - GTW: modem.com1: BUFFER: M20
>>>>>>> > > > OK
>>>>>>> >
>>>>>>> > > > 10435 [main] DEBUG org.smslib - GTW: modem.com1: RECV
>>>>>>> :M20(cr)OK(cr)
>>>>>>> > > > Model: M20
>>>>>>> > > > 10435 [main] DEBUG org.smslib - GTW: modem.com1: SEND
>>>>>>> :AT+CGSN(cr)
>>>>>>> > > > 10556 [main] DEBUG org.smslib - GTW: modem.com1: BUFFER:
>>>>>>> >
>>>>>>> > ...
>>>>>>> >
>>>>>>> > read more »- Hide quoted text -
>>>>>>> >
>>>>>>> > - Show quoted text -
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "SMSLib Discussion Group" group.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> To unsubscribe from this group, send email to
>> [email protected] <javascript:>.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msg/smslib/-/cR3Y6kFhz4sJ.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
--
You received this message because you are subscribed to the Google Groups
"SMSLib Discussion Group" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msg/smslib/-/qi7-Sdw_svUJ.
For more options, visit https://groups.google.com/groups/opt_out.
