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
> 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].
> 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/-/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].
For more options, visit https://groups.google.com/groups/opt_out.
