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 > >
