Hi,

Please read UG about dlr-url.

BR,
Nikos

On Sun, Jun 12, 2011 at 5:53 PM, Rene Kluwen <[email protected]> wrote:

> 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
> >
> >
> >
> >
>
>
>
>
>
>

Reply via email to