HI,
Request you please to provide the below mention details.
1) I am using the Kannel gateway source code for my ESME application.
what my question is the kannel code supports MYSQL database?
2) If it supports MYSQL i required libraries for connecting Esme
APPLICATION TO database.
now we can see the messages in the log files .rather than message insert
into data-base table and pickup a data and send it io smsc.this is my main
work .so wat i can do for this work.
We have to submit to submit my complete esme application with in
two days.
.
i am using below cfg file .in mysystem mysql libraries is there .but i use
dlr-storage=mysql means it wlii show the below error
.butfor thisdlr-storage =internal for this one it will work fine.
> 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.
I am using suse
linux 10.0 version .how i compiled na ./configure and make and make
install . i done like that .after this i will get with extra three
libraries .they are libgw.a libgwlib.a libwap.a libwmlscript.a these four
only i am getting extra with source code..i configure like this also
./configure --with-mysql=/usr/lib/mysql .now also successfully run.but i
run beareerbox i will get error.
> 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
>
kindly suggested if request any modifications
.
>
--
Thanks and Regards,
Kamani.
