Kannel MUST HAVE mysql libraries in order compile mysql support. You
can NOT use mysql connections if kannel was compiled without them
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
SMS y GPRS online
Visitenos en www.perusms.NET www.smsglobal.com.mx y
www.pravcom.com
On Wed, Jan 28, 2009 at 11:32 AM, narendra reddy
<[email protected]> wrote:
> Hi Alvaro,
> Thanks for giving feedback to my mail.
>
>
> It means to install mysql library. actuvally
> now in my laptop no mysql library.we have explicitly create any tables and
> write code and so on........? can do any manual opereations for data-base
> part as from user side.can you give me a sugetion me.
> please don't hesitate me because i am new to this kannelgateway. right
> now i am working with only text sms (sms gateway).
>
> Best Regards
> Narendra reddy.
>
> On Wed, Jan 28, 2009 at 9:41 PM, Alvaro Cornejo <[email protected]>
> wrote:
>>
>> Have you compiled kannel with mysql support?
>>
>> use --with-mysql when runing ./configure
>>
>>
>>
>> On Wed, 2009-01-28 at 19:52 +0530, narendra reddy wrote:
>> >
>> > Hi,
>> >
>> >
>> > I gothrogh the documents wat they are provided in the
>> > kannel.org .based on that i added dlr-storage=mysql in the
>> > coregroup . and added the remaing things after send-sms users group.
>> > they are.
>> >
>> > group = mysql-connection
>> > id = mydlr
>> > host = localhost
>> > username = narendra
>> > password = password
>> > database = dl
>> >
>> > group = dlr-db
>> > id = mydlr
>> > table = dlr
>> > field-smsc = smsc
>> > field-timestamp = ts
>> > field-destination = destination
>> > field-source = source
>> > field-service = service
>> > field-url = url
>> > field-mask = mask
>> > field-status = status
>> > field-boxc-id = boxc
>> >
>> >
>> >
>> > when i run the bearerbox its not running.it showing error message like
>> > 2009-01-28 19:26:10 [23776] [0] INFO: Debug_lvl = 1, log_file =
>> > <none>, log_lvl = 0
>> > 2009-01-28 19:26:10 [23776] [0] PANIC: DLR: storage type 'MySQL' is
>> > not supported!
>> > 2009-01-28 19:26:10 [23776] [0] PANIC: ./bearerbox(gw_panic+0x182)
>> > [0x46d9f2]
>> > 2009-01-28 19:26:10 [23776] [0] PANIC: ./bearerbox(dlr_init+0x1e7)
>> > [0x414977]
>> > 2009-01-28 19:26:10 [23776] [0] PANIC: ./bearerbox(main+0xdc)
>> > [0x40bbcc]
>> > 2009-01-28 19:26:10 [23776] [0]
>> > PANIC: /lib64/libc.so.6(__libc_start_main+0xf4) [0x2b0c29318154]
>> > 2009-01-28 19:26:10 [23776] [0] PANIC: ./bearerbox [0x40ae39]
>> >
>> > is there not nedd to specify to write explicitly any application
>> > for data-base .but in mysystem mysql libraries is there.wat is the
>> > error .how to overcome this error in mysystem sql libraries is not
>> > there how to add the data-base part to config-file.please give me some
>> > suggetion regarding data-base topic.
>> >
>> > Best Regards,
>> > Narendra reddy.
>> >
>> >
>> >
>> > On Wed, Jan 28, 2009 at 5:33 PM, Nikos Balkanas <[email protected]>
>> > wrote:
>> > Sounds fair. I will check into it.
>> >
>> > BR,
>> > Nikos
>> > ----- Original Message -----
>> > From: Alexander Malysh
>> > To: Nikos Balkanas
>> > Cc: [email protected]
>> >
>> > Sent: Wednesday, January 28, 2009 1:15 PM
>> > Subject: Re: Patch removed from CVS
>> >
>> >
>> > the issue is that we always paniced when %llu was used
>> > because octstr_format doesn't implement %llu format.
>> >
>> >
>> > Thanks,
>> > Alex
>> >
>> >
>> > P.S. You are free to implement %llu for octstr_format
>> > then I will reapply my smpp patch ;)
>> >
>> > Am 28.01.2009 um 12:09 schrieb Nikos Balkanas:
>> >
>> > > Interesting. This is just correct C for printing
>> > > strtoll. Seems that in this case 2 wrongs make it
>> > > right. Any chance that SMPP dlr handling can be
>> > > corrected? I imagine that all 32bit machines with
>> > > smpp connections would have this problem.
>> > >
>> > > BR,
>> > > Nikos
>> > > ----- Original Message -----
>> > > From: Alexander Malysh
>> > > To: Nikos Balkanas
>> > > Cc: [email protected]
>> > > Sent: Wednesday, January 28, 2009 10:13 AM
>> > > Subject: Re: Patch removed from CVS
>> > >
>> > >
>> > > Hi,
>> > >
>> > >
>> > > this is OK, I have dropped this patch
>> > > because it break SMPP dlr handling.
>> > >
>> > > Am 28.01.2009 um 01:10 schrieb Nikos
>> > > Balkanas:
>> > >
>> > > > Hi,
>> > > >
>> > > > I just tried to update from CVS. A lot of
>> > > > work has been introduced for meta-data
>> > > > recently. Unfortunately, in the case of
>> > > > gw/smsc/smsc_smpp.c it seems old sources
>> > > > were used, with the result that the llu
>> > > > patch commited by Alex for bug #460 has
>> > > > disappeared. Alex, can you recommit
>> > > > please?
>> > > >
>> > > > From: "Alexander Malysh"
>> > > > <[email protected]>
>> > > > To: <[email protected]>
>> > > > Sent: Friday, January 09, 2009 5:05 PM
>> > > > Subject: [PATCH] Bug 460
>> > > >
>> > > >
>> > > > > Hi All,
>> > > > >
>> > > > > here is proposed patch to fix #460.
>> > > > >
>> > > > > any objections to commit it?
>> > > > >
>> > > > > Thanks,
>> > > > > Alex
>> > > > >
>> > > >
>> > > >
>> > > >
>> > --------------------------------------------------------------------------------
>> > > >
>> > > >
>> > > > > diff --git a/gw/smsc/smsc_smpp.c
>> > > > b/gw/smsc/smsc_smpp.c
>> > > > > index d81132c..b6f8cb0 100644
>> > > > > --- a/gw/smsc/smsc_smpp.c
>> > > > > +++ b/gw/smsc/smsc_smpp.c
>> > > > > @@ -1278,9 +1278,9 @@ static Msg
>> > > > *handle_dlr(SMPP *smpp, Octstr
>> > > > > *destination_addr, Octstr *short_messa
>> > > > > } else {
>> > > > > if ((smpp->smpp_msg_id_type
>> > > > & 0x02) ||
>> > > > > (!
>> > > > octstr_check_range(msgid, 0,
>> > > > octstr_len(msgid),
>> > > > > gw_isdigit))) {
>> > > > > - tmp = octstr_format("%
>> > > > lu",
>> > > > > strtoll(octstr_get_cstr(msgid), NULL,
>> > > > 16));
>> > > > > + tmp = octstr_format("%
>> > > > llu",
>> > > > > strtoll(octstr_get_cstr(msgid), NULL,
>> > > > 16));
>> > > > > } else {
>> > > > > - tmp = octstr_format("%
>> > > > lu",
>> > > > > strtoll(octstr_get_cstr(msgid), NULL,
>> > > > 10));
>> > > > > + tmp = octstr_format("%
>> > > > llu",
>> > > > > strtoll(octstr_get_cstr(msgid), NULL,
>> > > > 10));
>> > > > > }
>> > > > > }
>> > > > >
>> > > > >
>> > > >
>> > >
>> > >
>> > >
>> >
>> >
>> >
>> >
>> >
>> > --
>> > Narendra Reddy
>> >
>>
>
>
>
> --
> Narendra Reddy
>
>
