NACK/

[Robin C]

Hi,

There are some messages showing FAILED Send SMS and its report coming as NACK/
. What will be the reason for this error. Any Idea?

-- 

   *Thanks & Regards,*



  Robin C

 Linux System Administrator



*ZIN-CRON | Bulk Sms, Voice Calls, Long Codes, Short Codes, Software
Development, Web & Graphic Designing.*


*www.zincron.co.in  | www. easyhops.co.in
 | www.equipe.co.in   *

*Corporate Office : S**urabhi ,TC 24/614, Door No.64, First floor *

*Elankam Nagar , Thycaud, *

*Thiruvananthapuram - 695014, , Kerala, India*


*Mobile: +919544861010 *| Phone:  0471 650 0414  | Raise Your Ticket:
zincron-ticketing.com


Connect with us @ Facebook

 | LinkedIn


Disclaimer:  This message contains confidential information and is intended
only for the individual named.  If you are not the named addressee you
should not disseminate, distribute or copy this e-mail.  Please notify the
sender immediately by e-mail if you have received this e-mail by mistake
and delete this e-mail from your system.  E-mail transmission cannot be
guaranteed to be secure or error-free as information could be intercepted,
corrupted, lost, destroyed, arrive late or incomplete, or contain
viruses.  The sender therefore does not accept liability for any errors or
omissions in the contents of this message, which arise as a result of
e-mail transmission.  If verification is required please request a
hard-copy version.

*7* Switch off as you go |*q *Recycle always | P Print only if absolutely
necessary

Re: Re[2]: MO messages from SMPP stored in database multiple times

[Seystec Soler]

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 :

> sqlbox doesn't create triggers out of the box.
> You may want to look into that direction.
>
> == Rene
>
> -- Origineel bericht --
> Van: "Seystec Soler" 
> Aan: "info.ubichip" 
> 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"  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 :
>>
>> 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 :
>>
>> 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
>>
>>
>>
>>
>>
>

http sendsms + smsc

[Eugeniy Khvastunov]

Hello!
I am setup Kannel/1.4.4 under freebsd and trying to select SMSC by smsc
variable for cgi-bin sendsms, but kannel randomly select SMSC.
In my config I have two SMSC.
Plese help, what I miss?

Some conf:

group = smsc
smsc = smpp
smsc-id = SMSC1
system-type = ""
host = 1.1.1.1
port = 29900
source-addr-autodetect = yes
transceiver-mode = true
#receive-port = 29900
interface-version = 34
smsc-username = yyy
smsc-password = yyy
enquire-link-interval = 270
source-addr-ton = 1
source-addr-npi = 1
dest-addr-ton = 0
dest-addr-npi = 1
msg-id-type = 0x03
log-file = "/var/log/kannel/yyy.log"
log-level = 0

group = smsc
smsc = smpp
smsc-id = SMSC2
system-type = ""
host = 2.2.2.2
port = 20510
source-addr-autodetect = yes
transceiver-mode = true
#receive-port = 29900
interface-version = 34
smsc-username = xxx
smsc-password = xxx
enquire-link-interval = 60
source-addr-ton = 5
source-addr-npi = 0
dest-addr-ton = 1
dest-addr-npi = 1
msg-id-type = 0x03
log-file = "/var/log/kannel/xxx.log"
log-level = 0


-- 
wbr. Eugeniy Khvastunov,
   System administrator.
   [FMGH-UANIC]
 http://blog.unlimite.net

Re[2]: MO messages from SMPP stored in database multiple times

[Rene Kluwen]

sqlbox doesn't create triggers out of the box.
You may want to look into that direction.

== Rene

-- Origineel bericht --
Van: "Seystec Soler" 
Aan: "info.ubichip" 
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"  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 :

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 :

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

Re: Reseller panel for Kannel.

[Alaa Al Omari]

Hello Javaid,
You can try white label with http://software.unifonic.com 
 
it allows you to have your own domain as reseller with ALL FEATURES you might 
think about as a reseller.
for more details, please contact Mr. Baker (CCed in this email)
Regards,

 
 

   



 

 
 
Alaa Alomari
Technical Director

T: +962 655 40 555, Ext: 6259
Skype: alaa_alomari
www.unifonic.com 





> On Jan 19, 2017, at 12:22 PM, Javaid  wrote:
> 
> 
> Hi guys,
> I want to know if there is any good web based open source reseller panel for 
> kannel. I checked playsms but it doesn't seem to have reseller option.
> Any help would be highly appreciated.
> 
> Thanks.
> 

Re: Reseller panel for Kannel.

[vinayak mv]

Hi,

You can buy the panel at http://evoxtel.com for bulk sms, smpp reseller
panel with complete managing from front end

On Thu, Jan 19, 2017 at 4:04 PM, Web Services  wrote:

> Hi Javaid,
>
> if you looking for proper professional solution you need to develop or buy
> form any developer any pre made solution will not fulfil your all
> requirements
>
> thanks
>
> On Thu, Jan 19, 2017 at 3:52 PM, Javaid 
> wrote:
>
>>
>> Hi guys,
>> I want to know if there is any good web based open source reseller panel
>> for kannel. I checked playsms but it doesn't seem to have reseller option.
>> Any help would be highly appreciated.
>>
>> Thanks.
>>
>>
>


-- 
Thanks & Regards,
Vinayak

==

*Confucius* once said,
"*Life is really simple, but we insist on making it complicated.*"

*Leonardo da Vinci* once said,
"*Simplicity is the ultimate sophistication.*"

*Albert Einstein* once said,
"*Everything should be made as simple as possible, but not simpler.*"

Re: Reseller panel for Kannel.

[Web Services]

Hi Javaid,

if you looking for proper professional solution you need to develop or buy
form any developer any pre made solution will not fulfil your all
requirements

thanks

On Thu, Jan 19, 2017 at 3:52 PM, Javaid  wrote:

>
> Hi guys,
> I want to know if there is any good web based open source reseller panel
> for kannel. I checked playsms but it doesn't seem to have reseller option.
> Any help would be highly appreciated.
>
> Thanks.
>
>

Fwd: Reseller panel for Kannel.

[Javaid]

Hi guys,
I want to know if there is any good web based open source reseller panel
for kannel. I checked playsms but it doesn't seem to have reseller option.
Any help would be highly appreciated.

Thanks.

RE: MO messages from SMPP stored in database multiple times

[Seystec Soler]

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"  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 :
>
> 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 :
>
> 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
>
>
>
>
>