Hello Rene.
Thanks for your assistance
In my understanding for Oracle DB (in absence of auto increment fields)
sqlbox uses triggers and sequences to generate ids.
In source code (sqlbox_oracle.c):
/*
* Oracle implementation using a sequence and a trigger for
auto_increment fields.
*/
sql = octstr_format(SQLBOX_ORACLE_CREATE_LOG_SEQUENCE,
sqlbox_logtable);
...
sql = octstr_format(SQLBOX_ORACLE_CREATE_LOG_TRIGGER,
sqlbox_logtable, sqlbox_logtable, sqlbox_logtable);
Also sqlbox log shows trigger creation attempts on each initialization:
2017-01-17 20:51:20 [5746] [0] ERROR: Error - ORA-04081: trigger
'sms_sent_trg' already exists
2017-01-17 20:51:22 [5746] [0] ERROR: Error - ORA-04081: trigger
'sms_send_trg' already exists
Regards
2017-01-19 7:03 GMT-04:00 Rene Kluwen <rene.klu...@chimit.nl>:
> 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] *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
>>
>>
>>
>>
>>
>
