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.
