Use sqlbox. Route all traffic via it. It will have very decent logs of both MO and MT.
Another alternate is the kannel.access file parser. It's a script which reads the log file, separates out the fields and loads into a MySQL database. On Wed, Mar 18, 2015 at 2:22 AM, Milan P. Stanic <m...@arvanta.net> wrote: > On Mon, 2015-03-16 at 20:46, Drazen Kozic wrote: > > Yes, it is possible to log messages at application level. I did it > several > > times in the past in situations when I am SMS Service provider and using > > kannel just to connect to mobile operator's SMSC. But, now I have demand > to > > establish messaging gateway at MVNO's site. The purpose of the gateway > is to > > route Premium SMS trafic from SMSC to service providers applications and > to > > record billing data (for charging individual subscribers and interbilling > > between MVNO and MNO). Plain log files are not suitable for billing > > purposes. > > How do you 'route [...] trafic from SMSC to service providers > applications'? > Maybe there you can log everything to DB. > > > I will appreciate any further suggestions. > > On 16.03.2015 19:56, Milan P. Stanic wrote: > > >On Mon, 2015-03-16 at 17:14, Drazen Kozic wrote: > > >>Is the kannel capable to record every MO, MT and DLR message into > database? > > >>I was reading sqlbox doc and it seems that sms box only records MT > messages? > > >>But, we need to record MO and DLR messages, too. > > >Sqlbox could be configured to log messages but better solution is to log > > >messages (and other events) at the application level. > > -- > Kind regards, Milan > -------------------------------------------------- > Arvanta, http://www.arvanta.net > Please do not send me e-mail containing HTML code or documents in > proprietary format (word, excel, pps and so on) > >
