You have to insert the messages directly on the send_sms table, the sql box will generate the message and pass it to the sent_sms.
So, you insert on the send_sms and sqlbox will process it and pass it to the sent_sms. At the end you'll have an empty send_sms and the sent_sms will have your message. Checkhttp://www.blogalex.com/wp-content/uploads/2008/11/userguide.html#AEN478 Best regrads, Jorge On Sun, Jan 1, 2012 at 7:12 PM, Suranga Ranjith <sura.btac...@gmail.com>wrote: > Hi All, > > I setup kannel gw with sqlbox. somhow it creates 2 tables (send_sms & > sent_sms), but no sms within that tables at anytime. > > How can I resolve this? > > #sqlbox.conf > > group = sqlbox > > > id = sqlbox-db > > > smsbox-id = sqlbox > > > bearerbox-host = localhost > > > bearerbox-port = 13001 > > > smsbox-port = 13005 > > > 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 > > > group = mysql-connection > > > id = sqlbox-db > > > host = localhost > > > username = root > > > password = root > > database = kannel > > Thank you! > -- [image: Multivision] *Jorge Raimundo * RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt
