Re: Re: Kannel Queued SMS location

2016-08-15 Thread Biswajit, BPL 

Hello,

Could anyone give some update on this? Thanks in advance.



/Thanks & Regards,/
Biswajit Kumar
Sr. System Engineer, P&D
Bangla Phone Ltd. <http://www.banglaphone.net.bd>
Phone: +880 359 345 1125 
Cell: +880 18 33 10 39 09 

On 2016-08-10 02:04, Biswajit, BPL wrote:


Dear Concern,

Please have the configuration in the attachment. We use separate 
config file for core, bearerbox, sqlbox and smsbox; here config is 
combined.


/Thanks & Regards,/
Biswajit Kumar
Sr. System Engineer, P&D
Bangla Phone Ltd. <http://www.banglaphone.net.bd>
Phone: +880 359 345 1125 
Cell: +880 18 33 10 39 09 

On 2016-08-09 17:00, Web Services wrote:

Hello,


kindly post your kannel config file so we can help you


Thanks

On Tue, Aug 9, 2016 at 4:02 PM, Biswajit, BPL 
mailto:biswa...@banglaphone.net.bd>> wrote:


Dear Milan,

Thanks for your feedback. As we use sqlbox we assumed we wouldn't
have to use store configurations, hence we have not used the
store-type, store-location or store-dump-freq. Could you please
suggest best suitable config for them? Thanks in advance.



/Thanks & Regards,/
Biswajit Kumar
Sr. System Engineer, P&D
Bangla Phone Ltd. <http://www.banglaphone.net.bd>
Phone: +880 359 345 1125 
Cell: +880 18 33 10 39 09 

On 2016-08-08 16:18, Milan P. Stanic wrote:

On Mon, 2016-08-08 at 15:22, Biswajit, BPL wrote:

We are using Kannel 1.4.4 to connect with Mobile operators using SMPP SMSC.
We use SQLBox for handling SMS transaction.
What we want to find out is: where is the location of storing messages which
is showed as 'Queued' in Kannel status page (attached). If and when we need
to restart Kannel after configuration change, we have to wait for the queue
to clear. If we knew which messages were being queued, we could resend those
messages manually after restart.
Appreciate your suggestion.

You don't need to resend messages when you restart kannel if you use
persistent storage for queued messages. Read the userguide and look
configuration directives store-type, store-location and store-dump-freq.
If that does not solve your problem then you should ask further
questions here.

Re: Kannel Queued SMS location

2016-08-09 Thread Biswajit, BPL 

Dear Concern,

Please have the configuration in the attachment. We use separate config 
file for core, bearerbox, sqlbox and smsbox; here config is combined.


/Thanks & Regards,/
Biswajit Kumar
Sr. System Engineer, P&D
Bangla Phone Ltd. <http://www.banglaphone.net.bd>
Phone: +880 359 345 1125 
Cell: +880 18 33 10 39 09 

On 2016-08-09 17:00, Web Services wrote:

Hello,


kindly post your kannel config file so we can help you


Thanks

On Tue, Aug 9, 2016 at 4:02 PM, Biswajit, BPL 
mailto:biswa...@banglaphone.net.bd>> wrote:


Dear Milan,

Thanks for your feedback. As we use sqlbox we assumed we wouldn't
have to use store configurations, hence we have not used the
store-type, store-location or store-dump-freq. Could you please
suggest best suitable config for them? Thanks in advance.



/Thanks & Regards,/
Biswajit Kumar
Sr. System Engineer, P&D
Bangla Phone Ltd. <http://www.banglaphone.net.bd>
Phone: +880 359 345 1125 
Cell: +880 18 33 10 39 09 

On 2016-08-08 16:18, Milan P. Stanic wrote:

    On Mon, 2016-08-08 at 15:22, Biswajit, BPL wrote:

We are using Kannel 1.4.4 to connect with Mobile operators using SMPP SMSC.
We use SQLBox for handling SMS transaction.
What we want to find out is: where is the location of storing messages which
is showed as 'Queued' in Kannel status page (attached). If and when we need
to restart Kannel after configuration change, we have to wait for the queue
to clear. If we knew which messages were being queued, we could resend those
messages manually after restart.
Appreciate your suggestion.

You don't need to resend messages when you restart kannel if you use
persistent storage for queued messages. Read the userguide and look
configuration directives store-type, store-location and store-dump-freq.
If that does not solve your problem then you should ask further
questions here.







##--core file--##
#-- core group connection 
---
group = core
admin-port = 13000
smsbox-port = 13001
admin-password = 
admin-allow-ip = "*.*.*.*"
dlr-storage = mysql
sms-combine-concatenated-mo = true
log-level = 0
access-log= "/var/log/kannel/cdr.log"
access-log-clean= true
#"date gmt-time direction type smsc FID sender receiver char-count dlr-type"
access-log-format= "%t,%l,%i,%F,%p,%P,%L,%d"
sms-resend-retry = 50
sms-resend-freq = 60
sms-incoming-queue-limit = 5000
#sqlbox mysql connection 

group = mysql-connection
id = sqlbox-db
host = localhost
username = 
password = x
database = kannelDb
max-connections = 10
#dlr mysql connection 
group = mysql-connection
id = mydlr
host = localhost
username = 
password = x
database = kannelDb
max-connections = 10
#- DLR table structure 
group = dlr-db
id = mydlr
table = kannel_dlr
field-smsc = smsc
field-timestamp = timestamp
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc_id
##--bearerbox file--##
##---list of SMPP SMSC operators --
##-
##---Airtel
##-
##-Dhaka 1 
group = smsc
smsc = smpp
smsc-id = airtelsmsc
denied-smsc-id = blsmsc;gpsmsc;robismsc
host = x.x.x.x
port = xxx
transceiver-mode = true
connect-allow-ip="*.*.*.*"
smsc-username = xxx
smsc-password = xx
system-type = 
source-addr-ton=1
source-addr-npi=1
dest-addr-ton=1
dest-addr-npi=1
interface-version = 34
enquire-link-interval = 120
address-range = 
msg-id-type = 1
alt-charset = utf-8
throughput = 10
max-pending-submits = 10
log-file = "/var/log/kannel/airtelsmsc1b1.log"
***
***
.
.
.
.
.
***
.
.
.
##smsbox-route--#
##---
group = smsbox-route
smsbox-id = airtelsmsbox
smsc-id = airtelsmsc
.
.
.
.
##--sqlbox file--##
##-SQLBOX configuration-
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
bearerbox-host = localhost
bearerbox-port = 13001
smsbox-port = 13002
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/var/log/kannel/kannel-sqlbox.log"
log-level = 0
##--smsbox file--##
#-smsbox
group = smsbox
bearerbox-host = localhost
smsbox-id = airtelsmsbox

Re: Re: Kannel Queued SMS location

2016-08-09 Thread Biswajit, BPL 

Dear Milan,

Thanks for your feedback. As we use sqlbox we assumed we wouldn't have 
to use store configurations, hence we have not used the store-type, 
store-location or store-dump-freq. Could you please suggest best 
suitable config for them? Thanks in advance.




/Thanks & Regards,/
Biswajit Kumar
Sr. System Engineer, P&D
Bangla Phone Ltd. <http://www.banglaphone.net.bd>
Phone: +880 359 345 1125 
Cell: +880 18 33 10 39 09 

On 2016-08-08 16:18, Milan P. Stanic wrote:

On Mon, 2016-08-08 at 15:22, Biswajit, BPL wrote:

We are using Kannel 1.4.4 to connect with Mobile operators using SMPP SMSC.
We use SQLBox for handling SMS transaction.
What we want to find out is: where is the location of storing messages which
is showed as 'Queued' in Kannel status page (attached). If and when we need
to restart Kannel after configuration change, we have to wait for the queue
to clear. If we knew which messages were being queued, we could resend those
messages manually after restart.
Appreciate your suggestion.

You don't need to resend messages when you restart kannel if you use
persistent storage for queued messages. Read the userguide and look
configuration directives store-type, store-location and store-dump-freq.
If that does not solve your problem then you should ask further
questions here.

Kannel Queued SMS location

2016-08-08 Thread Biswajit, BPL 

Dear All,

We are using Kannel 1.4.4 to connect with Mobile operators using SMPP 
SMSC. We use SQLBox for handling SMS transaction.
What we want to find out is: where is the location of storing messages 
which is showed as 'Queued' in Kannel status page (attached). If and 
when we need to restart Kannel after configuration change, we have to 
wait for the queue to clear. If we knew which messages were being 
queued, we could resend those messages manually after restart.

Appreciate your suggestion.

/Thanks & Regards,/
Biswajit Kumar
Sr. System Engineer, P&D
Bangla Phone Ltd. 
Phone: +880 359 345 1125 
Cell: +880 18 33 10 39 09 

Title: Kannel


Kannel bearerbox version `1.4.4'.
Build `Mar  5 2015 15:38:42', compiler `4.8.2'.
System Linux, release 3.16.0-31-generic, version #43~14.04.1-Ubuntu SMP Tue Mar 10 20:13:38 UTC 2015, machine x86_64.
Hostname bpl-PowerEdge-2950, IP 127.0.1.1.
Libxml version 2.9.1.
Compiled with MySQL 5.5.41, using MySQL 5.5.41.
Using native malloc.


 Status: running, uptime 0d 7h 36m 40s

 WDP: received 0 (0 queued), sent 0 (0 queued)

 SMS: received 957 (0 queued), sent 78698 (1 queued), store size -1
 SMS: inbound (0.05,0.03,0.03) msg/sec, outbound (3.83,3.67,2.87) msg/sec

 DLR: received 87891, sent 0
 DLR: inbound (3.57,3.74,3.21) msg/sec, outbound (0.00,0.00,0.00) msg/sec
 DLR: 246478 queued, using mysql storage

Box connections:
smsbox:sqlbox, IP 127.0.0.1 (0 queued), (on-line 0d 7h 36m 36s)  
smsbox:airtelsmsbox, IP 127.0.0.1 (0 queued), (on-line 0d 7h 36m 26s)  
smsbox:blsmsbox, IP 127.0.0.1 (0 queued), (on-line 0d 7h 36m 19s)  
smsbox:gpsmsbox, IP 127.0.0.1 (0 queued), (on-line 0d 7h 36m 12s)  
smsbox:robismsbox, IP 127.0.0.1 (0 queued), (on-line 0d 7h 35m 42s)  


SMSC connections:
airtelsmsc[airtelsmsc]SMPP:x.x.x.x:x/x:xx:
 (online 27400s, rcvd: sms 271 (0.00,0.00,0.01) / dlr 4763 
(0.23,0.22,0.17), sent: sms 4229 (0.11,0.13,0.15) / dlr 0 
(0.00,0.00,0.00), failed 0, queued 0 msgs)
airtelsmsc[airtelsmsc]SMPP:x.x.x.x:x/x:xx:
 (online 27400s, rcvd: sms 0 (0.00,0.00,0.00) / dlr 3831 
(0.08,0.11,0.14), sent: sms 3601 (0.08,0.08,0.13) / dlr 0 
(0.00,0.00,0.00), failed 0, queued 0 msgs)
blsmsc[blsmsc]SMPP:x.x.x.x:x/x:xx:
 (online 16053s, rcvd: sms 99 (0.01,0.01,0.00) / dlr 18774 
(0.67,0.57,0.69), sent: sms 20090 (0.48,0.55,0.73) / dlr 0 
(0.00,0.00,0.00), failed 0, queued 72 msgs)
gpsmsc[gpsmsc]SMPP:x.x.x.x:x/x:xx:
 (online 27400s, rcvd: sms 498 (0.03,0.02,0.02) / dlr 37267 
(1.33,1.51,1.36), sent: sms 27870 (1.32,1.26,1.02) / dlr 0 
(0.00,0.00,0.00), failed 0, queued 82833 msgs)
robismsc[robismsc]SMPP:x.x.x.x:x/x:xx:
 (online 15343s, rcvd: sms 89 (0.00,0.00,0.00) / dlr 23256 
(1.30,1.38,0.85), sent: sms 22908 (1.53,1.64,0.84) / dlr 0 
(0.00,0.00,0.00), failed 9, queued 867 msgs)