You can log sms message body section through sqlbox (msgdata in sent_sms table) for both MT and MO.
dlr table is for DLR messages, they contain only delivery reports and msgdata in most cases cropped by your upstream SMSC operator. 2013/5/23 Вадим Бажов <[email protected]> > Hi, people. How i can log sms messages body section in sql ? It seems > that original sql table from the documentation just doesn't have such > field. That's my sql table schema: > > CREATE TABLE dlr ( > smsc varchar(40), > ts varchar(40), > destination varchar(40), > source varchar(40), > service varchar(40), > url varchar(255), > mask int(10), > status int(10), > boxc varchar(40) > ) > > > > Like from original kannel documentation. It works fine but i'd like sms > texts of the messages to be stored to. Is it possible? > My configuration includes kannel + opensmppbox installed. No sqlbox > included. Do i need this? What is sqlbox need for? > > >
