sqlbox logs MO, MT and DLR messages. Rene Kluwen Chimit
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pedro B. Sent: vrijdag 19 maart 2004 0:31 To: [EMAIL PROTECTED] Subject: Re: Using MySQL storage Hello, First of all, i apologise if this question (and/or an answer) have already been discussed, but i did not find any on the mailing list's archives. Will the sqlbox also be able to support archiving/logging of incoming sms's, or will the only way to it be (for example), an exec to a php or pl code that would process the MO, log it, process it, create the MT, sent it? Thanks in advance \\pb Rene Kluwen wrote: > SQLBOX is for this. > It is another box (besides smsbox, wapbox, bearerbox) for Kannel. > It will be available as patch on this mailinglist shortly, after I worked > away everything that has been waiting for me in the month that I have been > away from my desk. > > Rene Kluwen > Chimit > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Reto Hersiczky > Sent: vrijdag 5 maart 2004 1:34 > To: [EMAIL PROTECTED] > Subject: Using MySQL storage > > > I want to store each SMS delivery log entry directly into a MySQL > table. I could verify Kannel is able to read from the related database > table since the web-based status panel on > http://localhost:13000/status.html?username=foo&password=bar > always shows the exact number of rows as > > DLR: 1 queued, using mysql storage > > (I just played with that table so the 1 row has been inserted by me > not by the smsbox daemon.) > > Although I can send SMS with > > http://localhost:13002/cgi-bin/sendsms?to=0764611551&username=foo&password=b > ar&text=Hello > > and Kannel confirms the built-in MySQL support is ready ... > > Kannel bearerbox version `1.2.1'. System Linux, release 2.4.20-8, > version #1 Thu Mar 13 17:54:28 EST 2003, machine i686. > Hostname foo.bar.ch, IP 127.0.0.1. Libxml version 20504. > Using MySQL 4.0.15. > Using LibSDB 0.5.2. > Using native malloc. > > ... no records are being inserted. > > The goal is to send SMS through smsbox and the the requests and their > status are beeing logged into a MySQL table. > > > Can anybody share her/his expertise on this? > > > Have configured and compiled Kannel with > > ./configure --disable-ssl --with-mysql=/usr --enable-mysql --with-dlr=mysql > --enable-mysql-dlr --enable-sdb > > > > -- > Best regards, > Reto mailto:[EMAIL PROTECTED] > > > Will publish the complete solution procedure on this as quickly as I > get rid of this problem on > http://www.infocopter.com/know-how/kannel-mysql-print.htm > >
