in case your config processes MO traffic only, your sql should do the regexp you will have insert events only
-----Original Message----- From: Aaron Simmons [EMAIL PROTECTED] Sent: 05 Ноември 2007 г. To: [EMAIL PROTECTED] Subject:sqlbox and keywords/regex > Does anyone have an example of using sqlbox to do keyword processing? I'm > using sqlbox-- it has created the send_sms > and sent_sms tables. I'm not clear where the keywords/regexs go-- there > doesn't appear to be a table for it. Perhaps I'm misunderstanding how this > works? > On Oct 22, 2007 10:36 AM, seik <[EMAIL PROTECTED]> wrote: > you could set sqlbox to get all the traffic - MO, DLR, MT in one table, via > simple default service description. > so you may skip the http request step and the regexps will be performed on > sql level. > even, in case you use postgresql , you could set rules on insert in a view to > automate the processing according the incoming text content, > but but this is not a kannel related issue i believe. > -----Original Message----- > From: Aaron Simmons [EMAIL PROTECTED] > Sent: 22 Октомври 2007 г. > To: seikath > Subject:keyword-regex and matching spaces >> What I've gathered of sqlbox is that it contains a queue table for >> smses to send and a table of logs and DLRs. Does sqlbox handle >> keyword matching, or is that still up to the sms-service conf file and/or >> external app? >> On 10/21/07, seik <[EMAIL PROTECTED]> wrote: >> well, >> you always could read the source from here >> http://www.kannel.org/~mconte/sqlbox/ >> and kannel users mailing list like this one: >> http://www.kannel.org/pipermail/users/2006-October/000859.html >> cheers >> -----Original Message----- >> From: Aaron Simmons [EMAIL PROTECTED] >> Sent: 21 Октомври 2007 г. >> To: [EMAIL PROTECTED] >> Subject:keyword-regex and matching spaces >>> Where is sqlbox documented? Is it a new feature? >>> On Aug 31, 2007, at 9:05 PM, seik wrote: >>>> exactly >>>> >>>> sqlbox to handle all the traffic >>>> ONE default service and the services routing rules are applied upon >>>> db insert >>>> >>>> much easier to implement any new service without touching kannel >>>> instance at all >>>> >>>> >>>> >>>> >>>> -----Original Message----- >>>> From: Rodrigo Cremaschi [EMAIL PROTECTED] ] >>>> Sent: 31 ?????? 2007 ?. >>>> To: seik >>>> Subject:keyword-regex and matching spaces >>>> >>>>> Hello Aaron, >>>> >>>>> This seems to be kind of a philosofical discussion, but at some >>>>> point in time, you will find much easier to modify a script than to >>>>> modify the config file and restart kannel just for a minor change. >>>> >>>>> Best regards, >>>> >>>>> Rodrigo >>>> >>>>> On 8/31/07, Aaron Simmons < [EMAIL PROTECTED]> wrote: >>>>>> I've run into a problem with keyword-regexp and matching spaces. >>>>>> Kannel won't match spaces. Though it doesn't appear to be >>>>>> documented >>>>>> (clearly?) in the Kannel User's Guide, its mentioned a couple >>>>>> times on >>>>>> this mailing list. >>>>>> >>>>>> My question is: why? Does Kannel throw out everything past the >>>>>> first >>>>>> space and only feed the first word to the regexp engine? I >>>>>> understand >>>>>> that the sms-service feature is designed to facilitate single- >>>>>> keyword >>>>>> matching, but still...this seems like an arbitrary limitation. >>>>>> >>>>>> For any kind of semi-complex patterns, the user has to send the sms >>>>>> off to a program that can handle regex's with spaces. Its >>>>>> doable, but >>>>>> its a pain. I'd rather have all of my logic in the conf file and >>>>>> not >>>>>> split between the conf file and some other scripts. >>>>>> >>>>>> >>>>>> >>>>>> Thanks, >>>>>> aaron >>>>>> >>>>>> >>>> >>>> >>>>
