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] *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 > > > > >