Hello,
is it possible to have your "mysql trigger" on the DLR table ?
thanks in advance
-Message d'origine-
De : users-boun...@kannel.org [mailto:users-boun...@kannel.org] De la part de
Niel
Envoyé : mardi 20 mars 2012 07:54
À : users@kannel.org
Objet : Re: OpenSMPP+Kannel: DLR: (dst &
Hi All,
I have installed the Kannel services on my Windows 7
machine.
I have used below command for installation:
$ cygrunsrv -I kannel_bearerbox -d "Kannel Bearer box" -p bearerbox.exe
-a smskannel.conf
$ cygrunsrv -I kannel_smsbox -d "Kannel SMS box" -p smsbox.exe -a
smska
Yes, that is where the trigger should be. My kannel config has been set to
use the table kannel.dlr, and columns dest and src.
The MySQL command would look something like this:
delimiter $
CREATE TRIGGER `kannel`.`dlr_src_dest_swap_trigger`
BEFORE INSERT ON `kannel`.`dlr`
FOR EACH ROW
BEGI
Thanks a lot, I will try it very soon.
one more question : does it change the way the dlr are coming back to the
originator of the request through SMPP ?
-Message d'origine-
De : users-boun...@kannel.org [mailto:users-boun...@kannel.org] De la part de
Niel
Envoyé : vendredi 15 juin 2012
Related to my last question, when a DLR is coming, the mysql request is like :
SELECT `mask`, `service`, `url`, `source`, `
destination`, `boxc` FROM `dlr` WHERE `smsc`=? AND `ts`=? AND `destination`
LIKE CONCAT(
'%', ?) LIMIT 1
so if the destination and source are swapped, it will never match
Hi,
This is intended for swapping the src and dest for delivery report for
clients connected using opensmppbox.
If you are using the same bearerbox for other purposes, such as http smsc
and/or proxy, the delivery reports src and dest will also be swapped around.
You might need to swap the field
Thanks for your answer again.
which opensmppbox are you using ? I just checked the svn repository, it looks
some dlr source code is now inside the opensmppbox, perhaps there is a good way
to make correction inside direclty ?
I'm not sure to understand "kannel will be past memory", do you quit t
Hello all,
does someone got some information on the last svn version of smppbox, I checked
the source code but I'm not sure of the exact additionnal feature such the DLR
source code is now in the same folder, and there is a new directive MULTI-GROUP
which is not well explained in the example.
I'm using SVN dated about 4 months ago (not an option to update due to the
risk of breaking something else - the devil you know...)
I've started a project, guess you might call it a "smpp proxy server" of
sorts, replacing kannel completely.
Regards,
info.ubichip wrote:
>
> Thanks for your a