The sent sms is not properly stored in database. In the msdata field of sent_sms table there are strange characters instead of content of sent sms. Below are config files.
KANNEL.CONF #Sample configuration file for Kannel bearerbox on Debian. # See the documentation for explanations of fields. # # HTTP administration is disabled by default. Make sure you set the # password if you enable it. group = core admin-port = 13015 admin-password = hard2guess admin-deny-ip = "*.*.*.*" admin-allow-ip = "127.0.0.1" dlr-storage = internal smsbox-port = 13016 #wdp-interface-name = "*" log-file = "/var/log/kannel/bearerbox.log" access-log = "/var/log/kannel/access.log" box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" log-level = 1 #group = wapbox #bearerbox-host = localhost #log-file = "/var/log/kannel/wapbox.log" group = smsc smsc-id = MediaTek smsc = at modemtype = MediaTek device= /dev/ttyACM0 my-number = +919417212503 connect-allow-ip = 127.0.0.1 log-level = 0 group = modems id = MediaTek name = "MediaTek" detect-string = "MediaTek" #init-string = "ATZ" init-string = "AT Q0 V1 E1 S0=0 &C1 &D2 +FCLASS=0" init-string = "AT+CNMI=2,1,2,2,0" message-storage = sm #speed = 460800 #message-start = 0 group = smsbox smsbox-id = mysmsc bearerbox-host = localhost #bearerbox-port = 13018 sendsms-port = 13018 global-sender = *************** access-log = "/var/log/kannel/smsbox-access.log" log-file = "/var/log/kannel/smsbox.log" log-level = 0 mo-recode = true group = sendsms-user username = *************** password = hard2guess concatenation= true max-messages = 10000 group = sms-service keyword-regex = .* catch-all = yes accepted-smsc = MediaTek max-messages = 3 get-url = "http://localhost/sms.php?phone=%p&text=%a"; SQLBOX.CONF group = sqlbox id = sqlbox-db smsbox-id = mysmsc global-sender = "***************" bearerbox-host = localhost bearerbox-port = 13016 smsbox-port = 13017 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/kannel-sqlbox.log" log-level = 0 #ssl-client-certkey-file = "" #ssl-server-cert-file = "" #ssl-server-key-file = "" #ssl-trusted-ca-file = "" # Database connection examples. Please uncomment as needed # Example MYSQL Connection group = mysql-connection id = sqlbox-db host = localhost username = *************** password = *************** database = kannel # Example ORACLE Connection #group = oracle-connection #id = sqlbox-db #username = myuser #password = mypass #tnsname = //localhost:1521/XE # Example POSTGRESQL Connection #group = pgsql-connection #id = sqlbox-db #id = sqlbox-db #username = myuser #password = mypass #database = kannel #host = localhost # Example SDB Connection with some database URL examples # *** Note: Uncomment only _one_ "url" line *** #group = sdb-connection #id = sqlbox-db #url = mysql:host=localhost:db=kannel:uid=myuser:pwd=mypass #url = sqlite:db=/path/to/kannel.db #url = sqlite3:db=/path/to/kannel3.db # Example SQLITE 2 Connection #group = sqlite-connection #id = sqlbox-db #database = /path/to/kannel.db #max-connections = 1 # Example SQLITE 3 Connection #group = sqlite3-connection #id = sqlbox-db #database = /path/to/kannel.db #max-connections = 1 Kannel version : Kannel bearerbox version `svn-r4871M'. Build `Nov 12 2010 17:56:44', compiler `4.4.3'. System Linux, release 2.6.32-25-generic, version #45-Ubuntu SMP Sat Oct 16 19:52:42 UTC 2010, machine x86_64. Libxml version 2.7.6. Compiled with MySQL 5.1.41, using MySQL 5.1.41. Using native malloc. Sqlbox Version: Kannel sqlbox version `svn-r4871M'. Build `Nov 12 2010 17:56:44', compiler `4.4.3'. System Linux, release 2.6.32-25-generic, version #45-Ubuntu SMP Sat Oct 16 19:52:42 UTC 2010, machine x86_64. Libxml version 2.7.6. Compiled with MySQL 5.1.41, using MySQL 5.1.41. Using native malloc.
