Re: information mail regarding mysql -database
narendra reddy <[email protected]>
| Newsgroups | gmane.comp.mobile.kannel.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi , what is the DCS and ESM values for Ringtones and operator-logo and Flash-messages. Thanks in advance Best Regards, Narendra reddy. On Thu, Jan 29, 2009 at 1:55 AM, Alvaro Cornejo <[email protected]>wrote: > 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 > > > > > -- Narendra Reddy