Hi
Please post your questions to users list so you can receive better support.
You need to compile kannel with support for mysq. ie in configure add
--with-mysql option among the others you might need.
Also you need to have mysq libraries installed (devel/common
depending on your OS)
Regards
Alvaro
|-----------------------------------------------------------------------------------------------------------------|
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 Thu, Jan 22, 2009 at 11:12 AM, narendra reddy
<[email protected]> wrote:
> Hi Alvaro,
>
>
>
>
> group = core
> admin-port = 13000
> admin-password = bar
> log-file = "log/bearer.log"
> log-level = 0
> access-log = "log/beareraccess.log"
> smsbox-port = 13003
> store-file = "log/kannelqueue.log"
> dlr-storage=mysql
>
>
>
> # SMSC SMPP
> group = smsc
> smsc = smpp
> smsc-id =pyro
> host = localhost
> port = 2775
> transceiver-mode=1
> log-file = "log/kannel.log"
> alt-dcs = true
> smsc-username =smppclient
> smsc-password = password
> system-type = "VMS"
> address-range ="555"
> source-addr-ton = 1
> source-addr-npi = 1
> dest-addr-ton = 1
> dest-addr-npi = 1
> msg-id-type = 0x01
> throughput = 50
> max-pending-submits = 10
> enquire-link-interval= 60
>
> # SMSBOX SETUP
> group = smsbox
> bearerbox-host = localhost
> sendsms-port = 13001
> log-file = "log/smsbox.log"
> log-level = 0
> access-log = "log/smsboxaccess.log"
>
> # SEND-SMS USERS
> group = sendsms-user
> username =pyro
> password = pyro
> max-messages = 5
> concatenation = true
>
> #SMS-Service
> group = sms-service
> keyword = default
> text = "Reply from ESME"
>
> group = mysql-connection
> id = mydlr
> host = localhost
> username = foo
> password = bar
> database = dlr
> # max count of connections that will be opened for dbpool
> # default is 1
> max-connections = 1
>
> #
> # Create the required table for the DLR support in the database
> # with something similar like this:
> #
> # CREATE TABLE dlr (
> # smsc varchar(40),
> # ts varchar(40),
> # destination varchar(40),
> # source varchar(40),
> # service varchar(40),
> # url varchar(255),
> # mask int(10),
> # status int(10),
> # boxc varchar(40)
> # )
> #
>
> 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
>
>
>
> i added above config-file and after i run the
> bearerbox it is showing the below error in bearer box . can you tell me
> what is the error in my config -file . right now mysql is not there in
> laptop .may be that is the error? . after i install mysql what i can do .
> i am new to this kannel -gateway.
>
>
>
>
> 2009-01-22 21:41:10 [4278] [0] INFO: Debug_lvl = 1, log_file = <none>,
> log_lvl = 0
> 2009-01-22 21:41:10 [4278] [0] PANIC: DLR: storage type 'mysql' is not
> supported!
> 2009-01-22 21:41:10 [4278] [0] PANIC: ./bearerbox(gw_panic+0x182) [0x46d9f2]
> 2009-01-22 21:41:10 [4278] [0] PANIC: ./bearerbox(dlr_init+0x1e7) [0x414977]
> 2009-01-22 21:41:10 [4278] [0] PANIC: ./bearerbox(main+0xdc) [0x40bbcc]
> 2009-01-22 21:41:10 [4278] [0] PANIC:
> /lib64/libc.so.6(__libc_start_main+0xf4) [0x2b76e083b154]
> 2009-01-22 21:41:10 [4278] [0] PANIC: ./bearerbox [0x40ae39]
>
> Regards,
> Narendra reddy.
>
>
>
>
>
>
>
>
> On Wed, Jan 21, 2009 at 9:10 PM, Alvaro Cornejo <[email protected]>
> wrote:
>>
>> Hi
>>
>> Can it also be related to this error I reported?
>>
>> 2009-01-20 00:27:14 [8890] [6] PANIC: octstr_format format string syntax
>> error.
>> 2009-01-20 00:27:14 [8890] [6] PANIC:
>> /usr/local/sbin/bearerbox(gw_panic+0xc2) [0x80ce3a2]
>> 2009-01-20 00:27:14 [8890] [6] PANIC:
>> /usr/local/sbin/bearerbox(octstr_format_valist_real+0x1a8) [0x80d2518]
>> 2009-01-20 00:27:14 [8890] [6] PANIC:
>> /usr/local/sbin/bearerbox(octstr_format+0x1b) [0x80d2e5b]
>> 2009-01-20 00:27:14 [8890] [6] PANIC: /usr/local/sbin/bearerbox
>> [0x808844c]
>> 2009-01-20 00:27:14 [8890] [6] PANIC: /usr/local/sbin/bearerbox
>> [0x8089420]
>> 2009-01-20 00:27:14 [8890] [6] PANIC: /usr/local/sbin/bearerbox
>> [0x808ad59]
>> 2009-01-20 00:27:14 [8890] [6] PANIC: /usr/local/sbin/bearerbox
>> [0x80c4c31]
>> 2009-01-20 00:27:14 [8890] [6] PANIC: /lib/libpthread.so.0 [0x4c83db]
>> 2009-01-20 00:27:14 [8890] [6] PANIC: /lib/libc.so.6(clone+0x5e)
>> [0x5a726e]
>>
>> Regards
>>
>> Alvaro
>>
>>
>> On Wed, 2009-01-21 at 14:59 +0100, Alexander Malysh wrote:
>> > Hi,
>> >
>> > yep, great... pleas try attached patch on top of 1.4.2
>> >
>> > Thanks,
>> > Alex
>> >
>> > Arne K. Haaje schrieb:
>> > > Onsdag 21 januar 2009 14:26:31 skrev Alexander Malysh:
>> > >> Hi,
>> > >>
>> > >> could you please run:
>> > >>
>> > >> addr2line -e /path/to/64bit/compiled/bearerbox 0x448c31 0x449348
>> > >> 0x44a49b 0x4968b9
>> > >
>> > > This was probably for Hillel, but I ran it as well for our own panics;
>> > >
>> > > 2009-01-21 11:51:05 [25065] [7] DEBUG: SMPP[xxxxx] handle_pdu, got DLR
>> > > 2009-01-21 11:51:05 [25065] [7] PANIC: octstr_format format string
>> > > syntax
>> > > error.
>> > > 2009-01-21 11:51:05 [25065] [7] PANIC: bearerbox(gw_panic+0x10d)
>> > > [0x4796ad]
>> > > 2009-01-21 11:51:05 [25065] [7] PANIC:
>> > > bearerbox(octstr_format_valist_real+0x1b2) [0x47f602]
>> > > 2009-01-21 11:51:05 [25065] [7] PANIC: bearerbox(octstr_format+0x8b)
>> > > [0x47fe8b]
>> > > 2009-01-21 11:51:05 [25065] [7] PANIC: bearerbox [0x43a8f7]
>> > > 2009-01-21 11:51:05 [25065] [7] PANIC: bearerbox [0x43b7b2]
>> > > 2009-01-21 11:51:05 [25065] [7] PANIC: bearerbox [0x43c2b4]
>> > > 2009-01-21 11:51:05 [25065] [7] PANIC: bearerbox [0x4710c5]
>> > > 2009-01-21 11:51:05 [25065] [7] PANIC: /lib64/tls/libpthread.so.0
>> > >
>> > > addr2line -e sbin/bearerbox 0x43a8f7 0x43b7b2 0x43c2b4 0x4710c5
>> > > /usr/include/stdlib.h:378
>> > > gw/smsc/smsc_smpp.c:1424
>> > > gw/smsc/smsc_smpp.c:1815
>> > > gwlib/gwthread-pthread.c:135
>> > >
>> >
>> > plain text document attachment (smpp.patch)
>> > --- gw/smsc/smsc_smpp.c.orig 2009-01-21 14:55:38.000000000 +0100
>> > +++ gw/smsc/smsc_smpp.c 2009-01-21 14:55:51.000000000 +0100
>> > @@ -1278,9 +1278,9 @@
>> > } else {
>> > if ((smpp->smpp_msg_id_type & 0x02) ||
>> > (!octstr_check_range(msgid, 0, octstr_len(msgid),
>> > gw_isdigit))) {
>> > - tmp = octstr_format("%llu",
>> > strtoll(octstr_get_cstr(msgid), NULL, 16));
>> > + tmp = octstr_format("%lu",
>> > strtoll(octstr_get_cstr(msgid), NULL, 16));
>> > } else {
>> > - tmp = octstr_format("%llu",
>> > strtoll(octstr_get_cstr(msgid), NULL, 10));
>> > + tmp = octstr_format("%lu",
>> > strtoll(octstr_get_cstr(msgid), NULL, 10));
>> > }
>> > }
>> >
>>
>>
>
>
