sqlbox doesn't create triggers out of the box.
You may want to look into that direction.
== Rene
------ Origineel bericht ------
Van: "Seystec Soler" <seys...@gmail.com>
Aan: "info.ubichip" <info.ubic...@free.fr>
Cc: users@kannel.org
Verzonden: 19-1-2017 8:58:32
Onderwerp: RE: MO messages from SMPP stored in database multiple times
Hello.
Messages have same timestamp but different id since ids are created by
triggers with a sequence.
Tables have only two triggers created by sqlbox without changes.
Regards
El 17/1/2017 12:07, "info.ubichip" <info.ubic...@free.fr> escribió:
Hello,
Do you have the same sms Id/timestamp in all the MO message ?
any trigger setup in your database ?
Regards
De : Seystec Soler [mailto:seys...@gmail.com]
Envoyé : mardi 17 janvier 2017 15:23
À : info.ubichip
Cc :users@kannel.org
Objet : Re: MO messages from SMPP stored in database multiple times
Hello
Thanks for your response,
I have only one service in my config file, default service:
group = sms-service
keyword = default
text = ""
max-messages = 0
Any other suggestion?
Regards
2017-01-17 6:54 GMT-04:00 info.ubichip <info.ubic...@free.fr>:
Hello,
Do you have any sms services acting as a loop and reinjecting the MO ?
Regards
De : users [mailto:users-boun...@kannel.org
<mailto:users-boun...@kannel.org>] De la part de Seystec Soler
Envoyé : vendredi 13 janvier 2017 07:22
À :users@kannel.org
Objet : Re: MO messages from SMPP stored in database multiple times
Hello.
Anyone can help me with this?
Thanks
2017-01-10 22:06 GMT-04:00 Seystec Soler <seys...@gmail.com>:
Hello fellows.
I have a strange case, I'm trying to store in database (Oracle)
messages received from an SMPP connection. Connection it's fine and I
can receive it but MO messages are being stored in table 50 times
each. In Kannel logs and web interface shows one message is received
but sqlbox (presumibly) is multiplying each MO message. My setup is:
SMPP --> bearerbox --> sqlbox.
I'm running only bearerbox and sqlbox.
I have been testing with versions 1.4.4 and SVN on Debian Wheezy and
CentOS 7. Can you help me to see what I am missing on my config to
avoid this behavior?
Thanks for you time.
Below is my minimal config:
####### Begin Config file ########
group = core
admin-port = 13000
admin-password = mySecretPass
box-allow-ip = "*.*.*.*"
admin-allow-ip = "127.0.0.1"
smsbox-port = 13001
log-file = "/var/log/kannel/kannel.log"
access-log = "/var/log/kannel/access.log"
group = smsbox
smsbox-id = smsbox
bearerbox-host = 127.0.0.1
sendsms-port = 13013
global-sender = 13013
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
bearerbox-host = localhost
bearerbox-port = 13001
smsbox-port = 13005
sql-log-table = sms_sent
sql-insert-table = sms_send
log-file = "/var/log/kannel/sqlbox.log"
group = oracle-connection
id = sqlbox-db
username = scott
password = tiger
tnsname = //127.0.0.1:1521/kanneldb
max-connections = 1
group = smsc
smsc = smpp
smsc-id = SMPP-RX
host = x.x.x.x
receive-port = 8324
#port = 8324
#transceiver-mode = true
smsc-username = smppUser
smsc-password = smppPasswd
system-type = default
interface-version = 34
enquire-link-interval = 30
dest-addr-ton = 1
dest-addr-npi = 1
source-addr-ton = 1
source-addr-npi = 1
connection-timeout = 100
alt-charset = 0
#Routing messages
group = smsbox-route
smsbox-id = sqlbox
smsc-id = SMPP-RX
####### End Config file ########
Best regards
