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] <javascript:>>
>
>> 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] <javascript:>>
>>
>> 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]<javascript:>
>>> > wrote:
>>>
>>>> So, there's nothing i can do to get status message?
>>>>
>>>> 2008/12/7 Thanasis <[email protected] <javascript:>>
>>>>
>>>>
>>>>> 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/).
>>>>>
>>>>> 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: C8329BFD0699E5EF3668DA9C32D3E210
>>>>> >
>>>>> > >
>>>>> ===============================================================================
>>>>> >
>>>>> > > > 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: C8329BFD0699E5EF3668DA9C32D3E210
>>>>> >
>>>>> > >
>>>>> ===============================================================================
>>>>> >
>>>>> > > > 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.
