Hi Christopher, all traffic is stored in the sent_sms table, that's the reason why there is an momt field in that table, so you can know which kind of message it is, have you checked your sqlbox log file? Maybe there is some kind of helpful info on it.
Other thing that is not clear to me, is your sms-service URL receiving the MOs? Thanks. Juan L. From: Christopher Burke <[email protected]> Date: Wednesday, June 13, 2012 12:19 PM To: Julien Buratto <[email protected]> Cc: <[email protected]> Subject: Re: [Queued] Receive Messages using Kannel 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 <tel: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
