Looks fine, you'll have to specify dlr sql storage on core group also. The unique key for a primary key field is unneccesary I suppose, but won't hurt anyway (primary keys _are_ unique by definition).
Kannel logs the message as sent when the SMSC accepts it. You'll also have to develop a script to handle DLR's of course. The process is as follows: - When you queue a message by any means (for example, inserting a row on send_sms or calling the sendsms interface), you should set dlr-mask (to tell which message status you want to "capture") and dlr-url (pointing to your dlr script). - You should include some sort of message_id identifier on your dlr-url field in order to be able to match your message against the dlr request. What I do is first insert the message on a table and use the insert-id from that table as message identifier to pass to the dlr-url. - When the message status changes, kannel calls the url script with the parameters properly loaded. The script will be called as many times as the message status changes. - Your script should update the table (or do whatever you want it to do). Since the message-id will be included you shouldn't have any problem matching against it. Hope it helps, Alejandro On 10/15/07, Michael Habashy <[EMAIL PROTECTED]> wrote: > I have been searching for stuff on dlr and sqlbox --unable to find any > thing. > I have used the config below for mysql config. > I have a couple of questions: > 1. Is there anyhting I am missing??? > 2. will kannel log the sms messege after it sends it ? or before? I just > want to know that kannel has sent the messege. I can always write a sql > query to see if the db was updated....if not ..i can try to send it anohter > way. > > > group = mysql-connection > > > id = mydlr > > host = localhost > > username = joey > > password = jtjjj > > database = sms > > max-connections = 1 > > 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 > > > CREATE TABLE `dlr` ( > `smsc` varchar(40) default NULL, > `ts` varchar(40) default NULL, > `destination` varchar(40) default NULL, > `source` varchar(40) default NULL, > `service` varchar(40) default NULL, > `url` varchar(255) default NULL, > `mask` smallint(6) default NULL, > `status` smallint(6) default NULL, > `boxc` varchar(40) default NULL, > `dlr_id` bigint(20) unsigned NOT NULL auto_increment, > `tsread` timestamp NOT NULL default CURRENT_TIMESTAMP, > PRIMARY KEY (`dlr_id`), > UNIQUE KEY `dlr_id` (`dlr_id`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; > > > > > > On 10/12/07, Alejandro Guerrieri <[EMAIL PROTECTED]> wrote: > > Michael, > > > > You can use sqlbox to enqueue MT messages, but it won't provide a > > native way to handle errors. > > > > In order to handle errors and delivery reports, you should use the DLR > > functionality on kannel. It could be used to save message delivery > > status on Kannel side or, if your SMSC supports it, to track the > > delivery of the messages up to the "real" phone terminals. > > > > Check on the user guide and list archives for more info about DLR's > > and sqlbox, I think that with some script "glue" and thos two elements > > you can achieve what you're looking for. > > > > Hope it helps, > > > > Alejandro > > On 10/12/07, Michael Habashy <[EMAIL PROTECTED]> wrote: > > > Can i send sms messeges from mysql ? > > > I would like to get a better way of tracking messeges that get sent out > via > > > kannel. > > > > > > There is no error handlign...that i can see in kannel to help that > along. > > > > > > thanks > > > mjh > > > > > > -- > > Alejandro Guerrieri > > Magicom > > http://www.magicom-bcn.net/ > > LinkedIn: http://www.linkedin.com/in/aguerrieri > > > > > > -- Alejandro Guerrieri Magicom http://www.magicom-bcn.net/ LinkedIn: http://www.linkedin.com/in/aguerrieri
