Hi Julien,

Strangely, I sometimes see received messages in my sent_sms table, do you
know why this might occur?

Kind Regards,

Christopher

On 13 June 2012 18:15, Julien Buratto <[email protected]> wrote:

> The "sent_sms" table stores the sms that have been sent. Not the SMS that
> get received :-)
> It may happen that you see them appearing there when you send them from
> your sending instance of kannel ?
>
> So basically when you send a message (ie INSERT a row in the send_sms
> table), the sms get routed to your SMSC and then removed from the send_sms
> table and copied into the sent_sms table.
>
> When you receive messages, you should take care of saving them in your
> script:
> http://sub.url.tld/sms.php?p=%p&msg=message
>
>
>
> 2012/6/13 Christopher Burke <[email protected]>
>
>> Hi,
>>
>> I currently have two SMSCs running on two separate Kannel instances. I am
>> using version -r4979 Kannel from the SVN on a Linux machine, and I have set
>> up the Kannel instances as follows: three separate configuration files for
>> the bearerbox, smsbox and sqlbox respectively shown below.
>>
>> send_kannel.conf
>> ############################################################
>> # KANNEL CONFIGURATION   #
>> ############################################################
>>
>> group = core
>> admin-port = 14000
>> smsbox-port = 14001
>> admin-password = ******
>> log-file = "/var/log/kannel/send/log_core.log"
>> access-log = "/var/log/kannel/send/acc_core.log"
>> log-level = 0
>> box-deny-ip = "*.*.*.*"
>> box-allow-ip = "*.*.*.*"
>>
>> ############################################################
>> # SMSC Connections    #
>> ############################################################
>>
>> group = smsc
>> smsc = smpp
>> smsc-id = ******
>> host = ******
>> port = ****
>> transceiver-mode = true
>> smsc-username = ******
>> smsc-password = ******
>> system-type = "SMPP"
>> address-range = ******
>> source-addr-ton = 1
>> source-addr-npi = 1
>> dest-addr-ton = 1
>> dest-addr-npi = 1
>> bind-addr-ton = 1
>> bind-addr-npi = 1
>>
>> group = smsbox
>>
>> send_smsbox.conf
>> ############################################################
>> # KANNEL CONFIGURATION   #
>> ############################################################
>>
>> group = core
>> smsbox-port = 14005
>>
>> group                           = smsbox
>> smsbox-id                       = send_smsbox
>> bearerbox-host                  = localhost
>> bearerbox-port = 14005
>> sendsms-port                    = 14013
>> global-sender                   = 447797882105
>> sendsms-chars                   = "0123456789+" # -+
>> log-file                        = "/var/log/kannel/send/log_smsbox.log"
>> log-level                       = 0
>> access-log                      = "/var/log/kannel/send/acc_smsbox.log"
>>
>> ############################################################
>> # SENDSMS USER CONFIGURATIONS   #
>> ############################################################
>>
>> group = sendsms-user
>> username = "wim"
>> password = "wim"
>>
>> send_sqlbox.conf
>> ############################################################
>> # KANNEL CONFIGURATION   #
>> ############################################################
>>
>> group = sqlbox
>> id = send_sqlbox
>> smsbox-id = send_sqlbox
>> #global-sender = ""
>> bearerbox-host = localhost
>> bearerbox-port = 14001
>> smsbox-port = 14005
>> smsbox-port-ssl = false
>> sql-log-table = sent_sms
>> sql-insert-table = send_sms
>> log-file = "/var/log/kannel/send/log_sqlbox.log"
>> log-level = 0
>> #ssl-client-certkey-file = ""
>> #ssl-server-cert-file = ""
>> #ssl-server-key-file = ""
>> #ssl-trusted-ca-file = ""
>>
>> group = mysql-connection
>> id = send_sqlbox
>> host = localhost
>> username = ******
>> password = ******
>> database = kannel
>>
>> I then launch Kannel with the following Shell script:
>>
>> #!/bin/bash
>> # BEARERBOXES
>> nohup /usr/local/sbin/bearerbox -v 1 /etc/kannel/recv/recv_kannel.conf &
>> nohup /usr/local/sbin/bearerbox -v 1 /etc/kannel/send/send_kannel.conf &
>> sleep 5
>> # SQLBOXES
>> nohup /usr/local/sbin/sqlbox -v 1 /etc/kannel/recv/recv_sqlbox.conf &
>> nohup /usr/local/sbin/sqlbox -v 1 /etc/kannel/send/send_sqlbox.conf &
>> sleep 5
>> # SMSBOXES
>> nohup /usr/local/sbin/smsbox -v 1 /etc/kannel/recv/recv_smsbox.conf &
>> nohup /usr/local/sbin/smsbox -v 1 /etc/kannel/send/send_smsbox.conf &
>>
>> So I have two SMSCs, one which sends messages and another
>> which receives messages. Both of the SMSCs have their own Kannel
>> (Bearerbox, SMSBox, SQLBox) and one of the SMSCs is set to send messages,
>> the other is set to receive them.
>>
>> The receive box has the following recv_smsbox.conf (sms-service etc);
>>
>> ############################################################
>> # SENDSMS USER CONFIGURATIONS   #
>> ############################################################
>>
>> group = sendsms-user
>> username = "wim"
>> password = "wim"
>>
>> ############################################################
>> # SMS-SERVICE                                              #
>> ############################################################
>>
>> group                           = sms-service
>> keyword-regex = .*
>> catch-all = yes
>> get-url                         = "
>> http://sub.url.tld/sms.php?p=%p&msg=message";
>> accept-x-kannel-headers = true
>> concatenation = true
>> max-messages = 0
>>
>> With this, I see the incoming messages in my acc_core.log however they're
>> not in my sent_sms table. What I'd like, is to have any and all messages
>> sent to the recv Kannel to appear in the sent_sms table (I sometimes get
>> them to appear if I send a message to the phone, and respond).
>>
>> Any pointers or help is much appreciated!
>>
>> Kind Regards,
>>
>> Christopher
>>
>>
>
>
> --
> Julien Buratto
> Linkas SRL
> Tel. 0230321419
>

Reply via email to