A possible solution would be using sqlbox in between your smsbox and bearerbox. Read the documentation about it.
== Rene -----Original Message----- From: Michael van der Poel [mailto:[email protected]] Sent: Sunday, 12 June, 2011 16:23 To: Rene Kluwen; [email protected] Subject: Re: MySQL issue Hi Rene, Thanks for your feedback. I was using 'dlr-mask=17' but now have tried with 'dlr-mask > 0': the message sends okay but no trace in the logs of anything being inserted into the 'log' table. Still, from your and Nikos' comment, I now understand that if working properly, Kannel will not leave anything in the table. That isn't what I was assuming. One would like to have a record of the details. How could that be achieved within Kannel? Any pointers would be much appreciated! Michael On 12/6/11 11:21, "Rene Kluwen" <[email protected]> wrote: > Did you try to send messages with dlr-mask > 0? > If not, Kannel won't insert anything in the dlr table. > And even so -like Nikos said- the entries will be deleted when the message > reaches a final state. > > == Rene > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Michael vd Poel > Sent: Sunday, 12 June, 2011 06:43 > To: [email protected] > Subject: MySQL issue > > Hi all, > > I have Kannel running on CentOS and it is sending messages. I have > configured > with '--with-mysql' and when Kannel is starting, it shows "2011-06-12 > 01:10:05 > [7937] [0] INFO: MYSQL: Connected to server at localhost." > > In the configuration file, I have: > > dlr-storage=mysql > > group = mysql-connection > id = mydlr > host = localhost > username = gebruiker > password = password > database = sms > max-connections = 10 > > group = dlr-db > id = mydlr > table=log > field-smsc=smsc > field-timestamp=timestamp > field-destination=destination > field-source=source > field-service=service > field-url=url > field-mask=mask > > The MySQL user 'gebruiker' has INSERT privilege. > > I have a table with corresponding fields in the database. But the table > isn't > populating. > > Does anyone see what I am overlooking? > > Thanks for any help! > > > Michael > > > >
