On Mon, Feb 9, 2009 at 5:17 PM, narendra reddy <[email protected]> wrote: > 1) i am using smpp protocol in the kannel gateway.
read the manual: http://kannel.org/download/1.4.3/userguide-1.4.3/userguide.html#AEN1624 > > 2)when i run the bearerbox with dlr-storage-mysql added in the core > group i am getting the below error . > > 2009-02-09 21:41:25 [19887] [0] INFO: Debug_lvl = 1, log_file = > <none>, log_lvl = 0 > 2009-02-09 21:41:25 [19887] [0] PANIC: DLR: storage type 'MySQL' is not > supported! > 2009-02-09 21:41:25l [19887] [0] PANIC: ./bearerbox(gw_panic+0x182) > [0x46d9f2] > 2009-02-09 21:41:25 [19887] [0] PANIC: ./bearerbox(dlr_init+0x1e7) > [0x414977] > 2009-02-09 21:41:25 [19887] [0] PANIC: ./bearerbox(main+0xdc) [0x40bbcc] > 2009-02-09 21:41:25 [19887] [0] PANIC: > /lib64/libc.so.6(__libc_start_main+0xf4) [0x2b654e54a154] > 2009-02-09 21:41:25 [19887] [0] PANIC: ./bearerbox [0x40ae39] This is because your kannel is not compiled with mysql dlr support. Download the source and when runnig the configure type: ./compile --with-mysql > 3) dlr-storage=internal it will work fine .but my requirement is to view > the incoming msg and out going msg in the database tables. > using with this internal parameter it is possible to view the dlr reports > in the tables . dlr-storage = internal tells kannel to use internal memory structure to store the delivery reports. It doesn't store the messages ina database. If you want to have the messages in a database you should create your own queue outside kannel and call repeatedly the sendsms script whenever you have new messages, some scheduled script could check the db table with the MT messages, read the data, format the sendsms url and then execute the http request. For the MO messages you have to create sms-service and set the get-url to a http listener that will process the url and save the message in a db table. I'm not sure, I think that the other option is to use sqlbox which is a database queue to store and forward messages, but I've never used it so I can't help. You can check the sqlbox user guide on Alejandro Guerrieri's blog http://www.blogalex.com/wp-content/uploads/2008/11/userguide.html BR, Jovan
