That is currently my plan. Waiting for a response from them hopefully today. I would be very surprised if it was only me that complained about this.
Kyriacos On 21/02/2011 09:10, Nikos Balkanas wrote: > I still think that your best bet would be to contact your provider. I > have no experience dealing with them, but it seems to me that if he is > a big SMPP one, then all of his clients will have the same problem. > That means if the ticket is still active, the more reason for him to > change. If not, he might know what his other clients have done about it. > > BR, > Nikos > ----- Original Message ----- From: "Alan McNatty" <[email protected]> > To: "Kyriacos Sakkas" <[email protected]> > Cc: "users" <[email protected]> > Sent: Monday, February 21, 2011 1:16 AM > Subject: Re: Odd DLR msg ID from operator > > >> Hi Kyriacos, >> >> Taking this a step further as I was wondering if this was actually >> possible. Caveat: I'm thinking out loud in pgsql (more user than >> admin/guru) and not mysql .. >> >> An insert/update/delete trigger to strip out the prefix (eg 01//) >> wouldn't be a problem assuming you could identify the smsc id, etc (so >> can avoid impacting those that are behaving). The issue as I see is with >> the select when you finally get your DLR .. If the 04/ was consistent >> you would just add it as part of the insert trigger which would work >> fine. But I'm guessing the '04/' is just an example and is varying so >> you need would need a view (pref materialized) do strip it out so your >> select matches. But .. you can't insert / update, etc on a view (in >> postgres .. as far as I know) so as it stands with the existing kannel >> config I can't see a way of doing this if this is what you are seeing. >> >> However, it might be do-able with a combination of views, triggers, >> schemas (so you can have a table and a view of the same name but in >> different schema) and/or different read/write user (associated with >> different schema). But some code change to support schemas / users would >> be required in kannel. You would need to check out what mysql can do >> here .. might not be impossible .. for example, from what I can see >> online (no personal experience) Oracle seems to support an "Instead Of" >> trigger so you could use / handle inserts/etc on a view. >> >> Maybe someone with a bit more experience with DB wrangling might be able >> to help you further with mysql. >> >> As Alex notes I suspect a simpler solution might be to support a regexp >> on DLR details in kannel ;) >> >> Cheers, >> Alan >> >> >> On 18/02/11 22:35, Kyriacos Sakkas wrote: >>> So yep if someone things that this can be done with pure MYSQL triggers >>> or something like that, which does not need heavy kannel changes, >>> please >>> let me know. >> -- Kyriacos Sakkas Development Team Netsmart Tel: + 357 22 452565 Fax: + 357 22 452566 Email: [email protected] http://www.netsmart.com.cy Taking Business to a New Level! ** Confidentiality Notice: The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution, or copying of this email message is strictly prohibited. If you think that you have received this email message in error, please email the sender at [email protected] **
