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
