Re: unicode problem with sqlbox Revision: 62

[Kyriacos/Netsmart]

Hi,

Did you upgrade both kannel and the DB server/version at once? If you 
set the new kannel instance to write to the old DB, or the old kannel to 
the new DB what happens?


Kyriacos

On 04/07/2024 12:42 pm, Konstantinos Liadakis wrote:


Here is the insert query which works perfectly fine on old system but 
not on the new one


INSERT INTO send_sms (
    sql_id, momt, sender, receiver, udhdata, msgdata, time, smsc_id, 
service, account, id, sms_type, mclass, mwi, coding, compress, 
validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, 
boxc_id, binfo, meta_data, priority, foreign_id

) VALUES (
    1, 'MT', 'UnicKlad', '306931234567', NULL, 
'%ce%b1%ce%b2%ce%b3%ce%b4%ce%b5%ce%b6%ce%b7%ce%b8%ce%b9%ce%ba%ce%bb%ce%bc%ce%bd%ce%be%ce%bf%cf%80%cf%81%cf%83%cf%84%cf%85%cf%86%cf%87%cf%88%cf%89%0a%40%23!%24%25%5e%26*()+%5b%5d+%7b%7d+%27%3b+%3f+%3c%3e+%2f+%5c+%7c%3d+%2b+-+%e2%82%ac', 
NULL, 'MYSMSC', NULL, 'account', NULL, 2, NULL, NULL, 2, NULL, 4320, 
NULL, 19, 'http://url', NULL, NULL, NULL, 'utf-8', NULL, NULL, NULL, 
NULL, NULL

);

On 4/7/24 12:39, Ruben Melikyan wrote:

Hi Dinos,
Please paste here your sql query which inserts unicode message to 
SendTable.


Please provide full query

Best regards,
Ruben Melikyan

*From:* Konstantinos Liadakis 
*Sent:* Thursday, July 4, 2024 11:44:39 AM
*To:* Ruben Melikyan ; users@kannel.org 
*Subject:* Re: unicode problem with sqlbox Revision: 62

Hellomy replies below to your questions

1. I can send normal sms with no problem, it is just unicode that i 
am not able to send


2. MariaDB [kannel]> show variables like '%char%';
+--++
| Variable_name    | Value  |
+--++
| character_set_client | utf8mb4    |
| character_set_connection | utf8mb4    |
| character_set_database   | utf8mb4    |
| character_set_filesystem | binary |
| character_set_results    | utf8mb4    |
| character_set_server | utf8mb4    |
| character_set_system | utf8mb3    |
| character_sets_dir   | /usr/share/mysql/charsets/ |
+--++
8 rows in set (0.002 sec)

MariaDB [kannel]> show variables like '%collation%';
+--++
| Variable_name    | Value  |
+--++
| collation_connection | utf8mb4_general_ci |
| collation_database   | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
+--++
3 rows in set (0.001 sec)


3. I am sending message by making an insert to mysql

4. Yes

5. The table is created by sqlbox it self

MariaDB [kannel]> select * from sent_sms;
++--+--+--+-+++--+-++--+--++--++--+--+--+--++--+-+--+-+-+---++--++
| sql_id | momt | sender   | receiver | udhdata | msgdata | 
time   | smsc_id  | service | account    | id   | sms_type | 
mclass | mwi  | coding | compress | validity | deferred | dlr_mask | 
dlr_url | pid  | alt_dcs | rpi  | charset | boxc_id | binfo | 
meta_data  | priority | foreign_id |

++--+--+--+-+++--+-++--+--++--++--+--+--+--++--+-+--+-+-+---++--++

I installed kannel from svn, and also sqlbox.

Today i did make clean in sqlbox and recompiled the one from addons 
folder, but i is exactly the same version when doing svn info


I am sure if i install an older version everything will work

Thank you for your efforts

Best regards

Dinos

On 4/7/24 07:24, Ruben Melikyan wrote:

Hi Dinos,
If so, I need more info:

 1. if you send ASCII( not unicode message), what happens? Do you
see record in your table?
 2. What are your DB settings ?
 3. How do you send message? Please 

Re: SMPP message ID greater than 9223372036854775807 breaking DLRs

[Kyriacos/Netsmart]

And your mysql table create statement. It might be that you are using a 
filed type that can not hold such large numbers. Can easily be converted 
to a char based storage if you don't have extreme space limit issues on 
the DB side.


On 06/08/2023 6:16 pm, Mesbahuddin Malik wrote:

Send your Smpp Config.

On Sun, Aug 6, 2023 at 8:26 PM Alex Kinch  wrote:

Hi all,

I've run into an issue with a certain SMS provider (Nexmo/Vonage)
that is using message IDs greater than 9223372036854775807 (e.g.
6142530091694509440651642911224527237), which is in turn breaking
DLR processing in Kannel.

They use hex in submit_sm_resp and decimal in deliver_sm so I have
to have msg-id-type=0x01 set, so it's not like I can remove it and
have Kannel use a C literal instead.

I've just tried the latest daily build and have the same issue.
Using MySQL for DLR storage if that's relevant.

Any help appreciated!

Thanks
Alex



--
Kyriacos Sakkas
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email:kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender atsupp...@netsmart.com.cy  **

Re: MO Routing on the fly

[Kyriacos/Netsmart]

Hi,

I think you are missing the smsbox-route route.

group = smsbox-route
smsbox-id = mySMSBox
smsc-id = smpp [list any other SMSC connections here]


On 24/04/2023 12:31 pm, akamat sarat wrote:

Dear All,

Thank you for your advice. I have tried all of your suggestions but 
cant get it to work like you say it should.
Without an smsbox-route, when ever an MO comes in I still get the 
"WARNING: smsbox_list empty"  warning.

Below my complete setup is below, what am I doing wrong?


group = core
admin-port = 13000
admin-password = ADMINPW
status-password = STATUSPW
smsbox-port = 13032
log-file = "/var/log/kannel/kannel.log"
log-level = 5
box-allow-ip = "*.*.*.*"
access-log = "/var/log/kannel/access.log"
store-type = spool
store-location = /var/spool/kannel/store
smsbox-max-pending = 100
dlr-storage = "internal"
sms-resend-freq = 1200
sms-resend-retry = 1
group = smsbox
bearerbox-host = localhost
bearerbox-port = 13032
sendsms-port = 13033
log-file = "/var/log/kannel/nosmscidsmsbox.log"
log-level = 3
reply-emptymessage = ""
http-request-retry = 2
http-queue-delay = 15
sms-length = 500
mo-recode=yes
group = sms-service
keyword = default
catch-all=true
omit-empty = true
assume-plain-text = yes
concatenation = true
max-messages = 0
get-url = "my_gt_uri"
group = smsc
smsc = smpp
smsc-admin-id = SMSC
smsc-id = SMSC
allowed-smsc-id = SMSC
preferred-smsc-id = SMSC
host = host
port = port
transceiver-mode = 1
smsc-username = USERNAME
smsc-password = PASSWORD
dest-addr-ton = 0
dest-addr-npi = 0
source-addr-ton = 0
source-addr-npi = 0
throughput = 30
enquire-link-interval = 30
log-file = /var/log/kannel/SMSC.log
log-level = 0
system-type = ""

On Mon, Apr 24, 2023 at 10:02 AM rm mobbis.am  
 wrote:


Hi Akamat. Sorry for late response.

The point is that you organize routing outside kannel and inside
your script or your MO sms handler web application side. This
gives you possibility to implement sms-service with any difficulty.

**

*Below are essential configs examples:*

# -- SMSBOX GROUP --

group = smsbox

bearerbox-host = localhost

bearerbox-port = 19005

sendsms-port = 19555

log-file = "/var/log/kanpsms/smsbox.log"

log-level = 3

access-log = "/var/log/kanpsms/smsbox-sms-access.log"

sendsms-chars = "0123456789 +#._"

reply-couldnotfetch = // If set, replaces the SMS message sent
back to user when Kannel could not fetch content //

reply-couldnotrepresent = // If set, replaces the SMS message sent
back when Kannel could not represent the result as a SMS message//

reply-requestfailed = // If set, replaces the SMS message sent
back when Kannel could not contact http service.//

reply-emptymessage = ""

http-request-retry = 2

http-queue-delay = 15

sms-length = 500

mo-recode=yes

# --  SMS SERVICE --

group = sms-service

keyword = default

catch-all=true

omit-empty = true

assume-plain-text = yes

concatenation = true

max-messages = 0

get-url = //Link to your script//

# -- SENDSMS USER GROUPS --

group = sendsms-user

username = SMSC1

password = *

user-deny-ip = "*.*.*.*"

user-allow-ip = "”

concatenation = true

max-messages = 4

forced-smsc = SMSC-ID1

group = sendsms-user

username = SMSC2

password = **

user-deny-ip = "*.*.*.*"

user-allow-ip = "”

concatenation = true

max-messages = 4

forced-smsc = SMSC-ID2

group = sendsms-user

username = SMSC3

password = ***

user-deny-ip = "*.*.*.*"

user-allow-ip =  "”

concatenation = true

max-messages = 4

forced-smsc = SMSC-ID3

*Please note,  that there is no smsbox-route config in my setup.*

*Explanation*

When kannel receives MO message it forwards received message to
your script.

Message handling, processing, saving your message to related DB,
generating answer and also submitting reply/answer message to
related SMSC (using the *KANNEL’S *HTTP interface to send SMS
messages) must be implemented in your script or your MO sms
handler web application side.

**

*Best regards,*

*Ruben Melikyan*



*From:*akamat sarat 
*Sent:* Thursday, April 20, 2023 11:53:17 AM
*To:* rm mobbis.am  
*Cc:* Tolga Ulas ; users@kannel.org

*Subject:* Re: MO Routing on the fly

Do you mean something like the following?
group = sms-service

get-url = "http://get-url.com;
catch-all = yes
This kind of setup does not work without adding smsbox-route. 
smsbox-route is either short code or smsc-id specific.
If you mean something else, can you write an example please?

Than k you

On Wed, Apr 19, 2023 at 9:32 PM rm mobbis.am 
 

sar and UDHI from operator

[Kyriacos/Netsmart]

Hi,

I have a connection to one network which send both sar and UDH for 
concat messages, causing kannel to reject them.


While they acknowledge that this is wrong, they have asked their vendor 
for a fix and that can take it's time.


Is their any way to tell kannel to ignore the sar fields and simply go 
with UDH?


Thanks,
Kyriacos

--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email: kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender at kyria...@netsmart.com.cy **

Re: No translation found for incoming sms

[Kyriacos/Netsmart]

Hello,

Do you know what language/encoding the MO you receive is supposed to be in?
From your Log:
2015-11-23 16:46:37 [21318] [6] DEBUG:   data_coding: 0 = 0x
Data coding = 0 would normally mean that the incoming message is Default 
encoding, usually GSM-ASCII (or Latin1 some times), which would not need 
any special handling.

Normally when receiving Unicode messages you would see the following:
2015-11-30 06:26:00 [13448] [11] DEBUG: *data_coding: 8 = 0x0008*

If the SMSC you connect to is giving data_coding as 0 when sending 
Unicode SMS, then you should raise this with them.


Something to check, in the group = smsbox section you should have:
mo-recode = true
This will trigger the conversion of UCS-2 MO to a UTF-8 output on your 
service URLs.


Regards,
Kyriacos Sakkas

On 30/11/2015 09:53, Yasmine Sayed-AbdElMohsen, Vodafone Egypt wrote:


Dears,

I am using Kannel with gateway v1.4.4.

I have trouble reading the incoming messages.

I get no translation found in the smsbox logs , and gibberish data in 
the bearerbox logs.


*For example:*

For sent  sms from mobile device : “Hi from wet and windy ireland”

I receive this SMS data in the PDU

SMPP[Smsc50496]: Got PDU:

2015-11-23 16:46:37 [21318] [6] DEBUG: SMPP PDU 0x7f518c000a00 dump:

2015-11-23 16:46:37 [21318] [6] DEBUG: type_name: deliver_sm

2015-11-23 16:46:37 [21318] [6] DEBUG: command_id: 5 = 0x0005

2015-11-23 16:46:37 [21318] [6] DEBUG: command_status: 0 = 0x

2015-11-23 16:46:37 [21318] [6] DEBUG: sequence_number: 2 = 0x0002

2015-11-23 16:46:37 [21318] [6] DEBUG: service_type: NULL

2015-11-23 16:46:37 [21318] [6] DEBUG: source_addr_ton: 1 = 0x0001

2015-11-23 16:46:37 [21318] [6] DEBUG: source_addr_npi: 1 = 0x0001

2015-11-23 16:46:37 [21318] [6] DEBUG: source_addr: "353872849213"

2015-11-23 16:46:37 [21318] [6] DEBUG: dest_addr_ton: 6 = 0x0006

2015-11-23 16:46:37 [21318] [6] DEBUG: dest_addr_npi: 9 = 0x0009

2015-11-23 16:46:37 [21318] [6] DEBUG: destination_addr: "50496"

2015-11-23 16:46:37 [21318] [6] DEBUG: esm_class: 0 = 0x

2015-11-23 16:46:37 [21318] [6] DEBUG: protocol_id: 0 = 0x

2015-11-23 16:46:37 [21318] [6] DEBUG: priority_flag: 0 = 0x

2015-11-23 16:46:37 [21318] [6] DEBUG: schedule_delivery_time: NULL

2015-11-23 16:46:37 [21318] [6] DEBUG: validity_period: NULL

2015-11-23 16:46:37 [21318] [6] DEBUG: registered_delivery: 0 = 0x

2015-11-23 16:46:37 [21318] [6] DEBUG: replace_if_present_flag: 0 = 
0x


2015-11-23 16:46:37 [21318] [6] DEBUG: data_coding: 0 = 0x

2015-11-23 16:46:37 [21318] [6] DEBUG: sm_default_msg_id: 0 = 0x

2015-11-23 16:46:37 [21318] [6] DEBUG: sm_length: 27 = 0x001b

2015-11-23 16:46:37 [21318] [6] DEBUG: short_message:

2015-11-23 16:46:37 [21318] [6] DEBUG: Octet string at 0x7f518c005660:

2015-11-23 16:46:37 [21318] [6] DEBUG: len:  27

2015-11-23 16:46:37 [21318] [6] DEBUG: size: 28

2015-11-23 16:46:37 [21318] [6] DEBUG: immutable: 0

2015-11-23 16:46:37 [21318] [6] DEBUG:   data: c8 34 c8 2c 7f b7 41 f7 
32 1d 14 76 93 41 f7 b4 .4.,..A.2..v.A..


2015-11-23 16:46:37 [21318] [6] DEBUG: data: 9b 9c 07 25 e5 65 76 d8 
4d 76 01 ...%.ev.Mv.


2015-11-23 16:46:37 [21318] [6] DEBUG: Octet string dump ends.

2015-11-23 16:46:37 [21318] [6] DEBUG: user_message_reference: 252 = 
0x00fc


2015-11-23 16:46:37 [21318] [6] DEBUG: privacy_indicator: 0 = 0x

2015-11-23 16:46:37 [21318] [6] DEBUG: SMPP PDU dump ends.

I searched a lot , and the proposed solution is to change the coding 
value to be 2 , in order to receive legible SMS(es), and this is 
reflected through changing the alt-charset configuration. But It had 
no effect.



*Here is my Kannel.conf file*



group = core

admin-port = 13001

smsbox-port = 13002

admin-password = bar

log-file = "/home/pnps/pnps/logs/kannellogs/SmscGateway.log"

log-level = 0

box-deny-ip = "*.*.*.*"

box-allow-ip = "127.0.0.1;172.*.*.*;192.*.*.*;10.*.*.*"

admin-allow-ip = "127.0.0.1;172.*.*.*;192.*.*.*;10.*.*.*"

admin-deny-ip = "*.*.*.*"

access-log = "/home/pnps/pnps/logs/kannellogs/access.log"

# SMSBOX SETUP

group = smsbox

bearerbox-host = localhost

sendsms-port = 13013

log-file="/home/pnps/pnps/logs/kannellogs/smsbox.log"

log-level = 0

access-log="/home/pnps/pnps/logs/kannellogs/sms_access.log"

reply-couldnotfetch = "Service is down, please try again later"

reply-couldnotrepresent = "Service is down, please try again later"

reply-requestfailed = "Service is down, please try again later"

reply-emptymessage = ""

mo-recode = true

# SEND-SMS USERS

group = sendsms-user

username=username

password=password

user-allow-ip = "*.*.*.*"

concatenation = true

split-chars = "#!^&*("

max-messages = 10

# SMPP PARAMETERS for SMSC account

group = smsc

smsc = smpp

smsc-id = Smsc12345

smsc-username = smscUser

smsc-password = smscPass

host = 213.233.143.11

port = 1040

system-type = SystemType403

Re: Get URL Not Getting Invoked For MO Msgs

[Kyriacos/Netsmart]

Hi,

The sms-service be default sends back to the phone any output of the 
get-url, or that phrase if there is no output. To avoid this add:

omit-empty  = true
to the sms-service config,

Kyriacos

On 13/11/2015 12:49, Amit Sharma (VAS) wrote:


Thanks Jesus for the suggestion, I have changed to get-url & changed 
the smsbox-id in smsbox configuration and smsbox-routing accordingly. 
Also disabled reroute=true


Now, URL is getting called & php script is getting invoked.

Can you please suggest now I am getting return sms that “Empty reply 
from service provider”, how to change this sms content for successful 
& failure cases?


Logs in bearer access logs is as follows:

2015-11-13 16:04:03 Sent SMS [SMSC:MTS] [SVC:default] [ACT:] [BINF:] 
[FID:B64174D1] [META:?smpp_resp?] [from:YD-MTS] [to:+919136006473] 
[flags:-1:0:-1:-1:-1] [msg:35:] 
[udh:0:]


Best regards*
Amit Sharma

*

*From:*Jesus Irausquin [mailto:jdirausq...@gmail.com]
*Sent:* Friday, November 13, 2015 3:51 PM
*To:* Amit Sharma (VAS)
*Cc:* users@kannel.org
*Subject:* Re: Get URL Not Getting Invoked For MO Msgs

Hi Amit,

You should use 'get-url' or 'post-url' in your sms-service 
configuration instead only 'url' (depending of your php script accepts 
get or post). Also you should put the same smsbox-id in smsbox 
configuration you are using in smsbox-routing.


Regards.

Dan


On Nov 13, 2015, at 2:08 AM, Amit Sharma (VAS) 
> wrote:


Hi,

I have configured kannel on red hat linux(2.6.32-358.el6.x86_64) &
i receive sms at bearerbox(Kannel bearerbox version `1.4.4'&
Libxml version 2.7.6) but URL containing the required action to be
taken using receivesms php script is not called. receivesms script
in php works fine when i call it externally, but kannel does not
invokes the get-url as mentioned in the "SMS service"
confiugration & below access logs is repeating again and again in
the logs & also smsbox logs doesn't have any logs related to this
transaction. Please suggest what can be wrong in the
configuration. Kannel configuration is as follows

group = core

admin-port = 13010

smsbox-port = 13012

log-file = "/u03/kannel/logs/bearerbox.log"

box-allow-ip = "10.130.252.160,127.0.0.1"

access-log = "/u03/kannel/logs/bearerbox_access.log"

dlr-storage = internal

##TX-1##

group = smsc

smsc-id ="MT"

smsc = smpp

host =10.10.22.10

port = 5016

system-type = "INAPPS"

interface-version = 34

receive-port =0

source-addr-ton = 1

source-addr-npi = 1

dest-addr-ton = 1

dest-addr-npi = 1

keepalive = 30

log-level =0

throughput = 50

max-pending-submits=50

reconnect-delay = 60

reroute = true

log-file = "/u03/kannel/logs/smsc_conn.log"

##RX-1

group = smsc

smsc-id ="MTS"

smsc = smpp

host =10.10.22.10

port = 0

system-type = "INAPPS"

receive-port =5016

interface-version = 34

source-addr-ton = 1

source-addr-npi = 1

dest-addr-ton = 1

dest-addr-npi = 1

keepalive = 30

log-level =0

reconnect-delay = 60

reroute = true

log-file = "/u03/kannel/logs/smsc_conn.log"

group = smsbox

bearerbox-host = 127.0.0.1

sendsms-port = 13013

global-sender = YD-MTS

log-file = "/u03/kannel/logs/smsbox.log"

log-level = 0

#SMSBOX ROUTING

group = smsbox-route

smsbox-id = smsbox

smsc-id ="MT"

group = sendsms-user

username = smsg

password = smsg@123

default-smsc="MT"

concatenation= true

max-messages = 6

group = sms-service

keyword = default

url = http://10.130.250.58/receivesms.php?sender=%p=%b


catch-all = true

max-messages = 1

text = "This is a reply"

bearerbox access log is as follows

|2015-11-12 09:04:53 Sent SMS [SMSC:MTS] [SVC:] [ACT:MTSCC_APPS]
[BINF:]   [FID:AFB4EE11] [META:?smpp??smpp_resp?]
[from:+919136006473] [to:+915] [flags:-1:0:-1:0:-1] [msg:2:Hi]
[udh:0:]|

|2015-11-12 09:04:53 Receive SMS [SMSC:MTS] [SVC:] [ACT:MTSCC_APPS]
[BINF:] [FID:] [META:?smpp?] [from:+919136006473] [to:+915]
[flags:-1:0:-1:0:-1] [msg:2:Hi] [udh:0:]|

|2015-11-12 09:04:53 Receive SMS [SMSC:MTS] [SVC:] [ACT:MTSCC_APPS]
[BINF:] [FID:] [META:?smpp?] [from:+919136006473] [to:+915]
[flags:-1:0:-1:0:-1] [msg:2:Hi] [udh:0:]|

|2015-11-12 09:04:53 Sent SMS [SMSC:MTS] [SVC:] [ACT:MTSCC_APPS]
[BINF:] [FID:AFB4EE31] [META:?smpp??smpp_resp?]
[from:+919136006473] [to:+915] [flags:-1:0:-1:0:-1] [msg:2:Hi]
[udh:0:]|

Best regards*
Amit Sharma *




This 

Re: trouble compiling latest svn

[Kyriacos/Netsmart]

On 06/02/2015 17:21, Milan P. Stanic wrote:

On Wed, 2015-02-04 at 14:42, Kyriacos/Netsmart wrote:

/usr/bin/convert doc/wtls/fig8o.png doc/wtls/fig8o.ps
/usr/bin/convert doc/wtls/fig9o.png doc/wtls/fig9o.ps
sed s/#FIGTYPE#/.png/;s/#VERSION#/svn-r5129M/;s/#DATE#/`date
+%Y.%m.%d`/;s/#DRAFTS#/IGNORE/ doc/alligata/alligata.xml 
doc/alligata/alligata.tmp
openjade -V nochunks -t sgml -d
/usr/share/sgml/docbook/stylesheet/dsssl/modular/html/docbook.dsl
doc/alligata/alligata.tmp  doc/alligata/alligata.html
openjade:URLhttp://docbook.org/xml/4.2/docbookx.dtd:112:17:E: X20AC is
not a function name
openjade:/usr/share/xml/entities/xml-iso-entities-8879.1986/ISOamsa.ent:40:19:E:
X21B6 is not a function name
openjade:/usr/share/xml/entities/xml-iso-entities-8879.1986/ISOamsa.ent:41:19:E:
X21B7 is not a function name

openjade:/usr/share/xml/entities/xml-iso-entities-8879.1986/ISOamsr.ent:53:18:E:
X227C is not a function name
openjade:/usr/share/xml/entities/xml-iso-entities-8879.1986/ISOamsr.ent:54:18:E:
X22A3 is not a function name
openjade:I: maximum number of errors (200) reached; change with -E option
make: *** [doc/alligata/alligata.html] Error 1

What is your build platform? How you invoke 'build process'?

Please read the document at:
http://www.catb.org/esr/faqs/smart-questions.html


I'll have a read. Just a note that wit the docs disabled it compiles fine.

Running this on a fresh install of debian 7.8 amd64 on a Vmware VM.

Compile time options set for mysql use and alternative installation path.

Kyriacos

--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email: kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender at kyria...@netsmart.com.cy **

trouble compiling latest svn

[Kyriacos/Netsmart]

/usr/bin/convert doc/wtls/fig8o.png doc/wtls/fig8o.ps
/usr/bin/convert doc/wtls/fig9o.png doc/wtls/fig9o.ps
sed s/#FIGTYPE#/.png/;s/#VERSION#/svn-r5129M/;s/#DATE#/`date 
+%Y.%m.%d`/;s/#DRAFTS#/IGNORE/ doc/alligata/alligata.xml  
doc/alligata/alligata.tmp
openjade -V nochunks -t sgml -d 
/usr/share/sgml/docbook/stylesheet/dsssl/modular/html/docbook.dsl 
doc/alligata/alligata.tmp  doc/alligata/alligata.html
openjade:URLhttp://docbook.org/xml/4.2/docbookx.dtd:112:17:E: X20AC 
is not a function name
openjade:/usr/share/xml/entities/xml-iso-entities-8879.1986/ISOamsa.ent:40:19:E: 
X21B6 is not a function name
openjade:/usr/share/xml/entities/xml-iso-entities-8879.1986/ISOamsa.ent:41:19:E: 
X21B7 is not a function name


openjade:/usr/share/xml/entities/xml-iso-entities-8879.1986/ISOamsr.ent:53:18:E: 
X227C is not a function name
openjade:/usr/share/xml/entities/xml-iso-entities-8879.1986/ISOamsr.ent:54:18:E: 
X22A3 is not a function name

openjade:I: maximum number of errors (200) reached; change with -E option
make: *** [doc/alligata/alligata.html] Error 1

--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email: kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender at kyria...@netsmart.com.cy **

Re: Kannel app suggestion

[Kyriacos/Netsmart]

Well if the stations alarm can feed some trigger signal into a computer, 
kannel could be used to send out messages to volunteer firefighters with 
info on fire etc. Might save some time from having to manually call them 
if that is what is done now.


It might be best if you knew what needs they have, and then seeing if 
kannel can help with any of that.


Kyriacos


On 10/12/2014 17:33, José Patricio Isama Peña wrote:
Any suggestion  about making a sms application with kannel for 
firefigthers ?


--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email: kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender at kyria...@netsmart.com.cy **

Re: Can we pull DLRs instead of PUSH by kannel?

[Kyriacos/Netsmart]

Assuming he wanted to avoid a DB hit altogether really, but yep sqlbox 
should do that (no personal experience).



On 07/10/2014 20:47, Rene Kluwen wrote:


If you use sqlbox, they will be inserted in the log table and you can 
select them any time afterwards.


*From:*users [mailto:users-boun...@kannel.org] *On Behalf Of 
*Kyriacos/Netsmart

*Sent:* maandag 6 oktober 2014 11:58
*To:* Vikas Wasiya
*Cc:* kannel users@kannel.org
*Subject:* Re: Can we pull DLRs instead of PUSH by kannel?

If the DB hit is the big issue and not the URL call, then simply have 
that URL write the DLRs in some serialized file that will allow easy 
processing latter.


Still is probably more efficient overall to just push them to a DB 
table without processing, and then pull them from that for processing 
latter.


Kyriacos

On 06/10/2014 04:25, Willy Mularto wrote:

How big is your daily DLR volume?  My suggestion is to tune up
your DB, either the engine (MyISAM to InnoDB maybe) or configuration.

Also I want to know how will you store the DLR? Parsing Kannel's
log? Save it to plain text? When you do the bunch or batch will it
still update the DB? Then it will double the load, it will eat
your DB and also the IO (if you parse the DLR from plain text)

Please address this kind question to user's list rather than
devel's list. Thanks

Willy Mularto

SMS Gateway, Content Provider, Mobile Solution Specialist

M: +62811923464, +62818923464

PIN BBM: 74924429

On Oct 3, 2014, at 6:55 PM, Vikas Wasiya vi...@hostnsoft.com
mailto:vi...@hostnsoft.com wrote:



Hello,

We have certain queries related to kannel dlr reports.

We do not want Kannel to call our URL and delete delivery reports
from Spool.

Instead, we want to pull the delivery report in bunch and delete.

Reason: reducing our DB load because every URL runs the update
query on our DB.

Thanks and waiting for your reply,

-- 


Thanks  Regards*
**Vikas Wasiya*

*Sr. Software Developer
Walkover Web Solutions | HOSTnSOFT*



--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email:kyria...@netsmart.com.cy  mailto:kyria...@netsmart.com.cy
http://www.netsmart.com.cy
  
Taking Business to a New Level!
  
** Confidentiality Notice: The information contained in this email

message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender atkyria...@netsmart.com.cy  mailto:kyria...@netsmart.com.cy  
**


--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email: kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender at kyria...@netsmart.com.cy **

Re: Can we pull DLRs instead of PUSH by kannel?

[Kyriacos/Netsmart]

If the DB hit is the big issue and not the URL call, then simply have 
that URL write the DLRs in some serialized file that will allow easy 
processing latter.


Still is probably more efficient overall to just push them to a DB table 
without processing, and then pull them from that for processing latter.


Kyriacos


On 06/10/2014 04:25, Willy Mularto wrote:
How big is your daily DLR volume?  My suggestion is to tune up your 
DB, either the engine (MyISAM to InnoDB maybe) or configuration.
Also I want to know how will you store the DLR? Parsing Kannel’s log? 
Save it to plain text? When you do the bunch or batch will it still 
update the DB? Then it will double the load, it will eat your DB and 
also the IO (if you parse the DLR from plain text)
Please address this kind question to user’s list rather than devel’s 
list. Thanks



Willy Mularto
SMS Gateway, Content Provider, Mobile Solution Specialist
M: +62811923464, +62818923464
PIN BBM: 74924429



On Oct 3, 2014, at 6:55 PM, Vikas Wasiya vi...@hostnsoft.com 
mailto:vi...@hostnsoft.com wrote:



Hello,

We have certain queries related to kannel dlr reports.

We do not want Kannel to call our URL and delete delivery reports 
from Spool.


Instead, we want to pull the delivery report in bunch and delete.

Reason: reducing our DB load because every URL runs the update query 
on our DB.




Thanks and waiting for your reply,

--
Thanks  Regards*
Vikas Wasiya
*
*Sr. Software Developer
Walkover Web Solutions | HOSTnSOFT**
*




--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email: kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender at kyria...@netsmart.com.cy **

Re: Same SMS, 2 Different MessageIDs

[Kyriacos/Netsmart]

If %F is not provided by the SMSC then the whole thing would not work 
anyway, as kannel will not be able to find the matching pending DLR 
record in order to get the DLR URL. If it is there, then there can not 
be a timing issue.


The different formating issue, well I don't know if %F is populated 
after the msg-id-type rules are applied, but doing the conversion 
should be easy enough since each SMSC behaves in just one way all the time.


I believe the only way you can have what you are asking for is to use a 
DLR URL like:


http://localhost/dlr.php?BATCHID=1234MSISDN=%pSMSCMSGID=%Fstatus=%d 
http://localhost/dlr.php?id=12312312status=%d


I suggest you try this and let us know if it does not work.

Kyriacos


On 12/03/2014 15:40, spameden wrote:




2014-03-12 14:31 GMT+04:00 mydi...@gmail.com 
mailto:mydi...@gmail.com mydi...@gmail.com mailto:mydi...@gmail.com:


Thanks for your reply Kyriacos.

%F is SMSC provided. It could be delayed, it could be changing
format (depending on each SMSC), it could indicate who my SMSC is,
it could have different format. Like any standard provided, and
normal SMSC, I must provide my own ID and be able to update status
(type) based on that ID. You know what I mean?

I can not request users to give their own messageID (not only
technically is extra work and development for each of them, but no
provider does that).

What is everyone else using Kannel doing? I am just thrilled to
know...


Again, you need to pass your OWN variable with identificator, e.g.:

dlr_url = url_encode('http://localhost/dlr.php?id=12312312status=%d

read this - http://www.kannel.org/pipermail/users/2010-July/011875.html


Thank you,
Ali.


On 12/03/2014 09:15, Kyriacos/Netsmart wrote:

So,

If in your DLR url you request %F ? Wouldn't that just do what
you need?
Provide the same ID back to you for all DLRs relating to one MT?

Regards,
Kyriacos





--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email: kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender at kyria...@netsmart.com.cy **

Re: Same SMS, 2 Different MessageIDs

[Kyriacos/Netsmart]

So,

If in your DLR url you request %F ? Wouldn't that just do what you need? 
Provide the same ID back to you for all DLRs relating to one MT?


Regards,
Kyriacos



On 11/03/2014 14:50, mydi...@gmail.com wrote:

Hi Kyriacos,

Yea sure, here is the screenshot of my db where dlrs are inserted: 
http://www.mydigia.com/images/ImG/2014-03-11_1248.png


There are 2 records for the same number sent to, one sms sending. 
msgidk is the kannel %I (kannel internal messageID), which changes 
on each type, which is my problem...


Thank you,
Ali.

On 11/03/2014 10:42, Kyriacos/Netsmart wrote:

By the way, can you provide samples of these different IDs?

Kyriacos

On 10/03/2014 15:25, spameden wrote:




2014-03-10 17:15 GMT+04:00 mydi...@gmail.com
mailto:mydi...@gmail.com mydi...@gmail.com 
mailto:mydi...@gmail.com:


Thanks for your reply.

As for the speed, you are right, it doesn't affect my kannel
receiving/sending speed, but what happens is sending to 100numbes
in the same URL, instead of sending to 100 number in 100urls
(1number each url), affects the sending script speed. I send
through send-sms cgi using php, and the speed is massively
different between the two methods, which is why i need to use
100numbers in one url.


Try tuning your script / database setup. Preferrably use nginx +
php5-fpm over slow apache2.


As for type=8, and dlr-mask. I completely have read the user
guide, and know exactly how it works. My issue is different from
that. And anyway I need type=8, for the reason you mentioned, I
need to know the submission... Regardless of DLR-mask, shouldn't
kannel provide ONLY 1 message ID for 1 sms send request? Why is it
giving different message IDs for the same number, same request?
Unless I am still missing a point...


As I said earlier kannel's internal message scheme is suitable only
for kannel's internal needs. Basically, each msgid inside the kannel
(%I modifier) means unique identifier either for MT, MO or DLR message
types.

So, after you submit a batch of 100 numbers through send-sms cgi
script with dlr_mask=31, kannel first returns DLR with status = 8 and
its unique msgid and after sms get to the receiver you get a new DLR
from your SMSC with status=1 and thus it has new msgid because it's a
new DLR.

You need to use your own msgid instead of %I and pass it to your 
dlr_url.



I mean, regardless of type=1,..4,8,..., the messages id must be
constant. That is the whole point, so the STATUS of one send
request gets updated and the only way to identify which request,
is using the messages id.


No, the only constant messageid is SMSC message identifier, but you
really shouldnt rely on it too, because if you use multiple SMSC they
might be overlapping and different SMSC are using different types of
message id (someone uses plain integers, someone hex, someone uses
mixed text-integer type).


Thank you,
Ali.




--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email:kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender atkyria...@netsmart.com.cy  **



--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email: kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender at kyria...@netsmart.com.cy **

compile troubles on Debian 6.0.5 from trunk (synced yesterday)

[Kyriacos/Netsmart]

Hi all,

Wondering if the below is indication of something serious, or just 
random error messages:



./configure  - make works,
make check returns:
Check: checks/check_ppg.sh...bb failed with control file test/iptestppg.txt

found some suggestions in emails from 2006

tried : ./configure --bindir=/opt/kannel_20120726 --with-mysql 
--with-malloc=checking

resulted in:
Configuring parameters ...
checking which malloc to use... Unknown malloc wrapper checking. Oops.

tried: ./configure --bindir=/opt/kannel_20120726 --with-mysql 
--with-malloc=slow

configure was ok
make was ok
make check:
utils/run-checks checks/check_counter checks/check_date 
checks/check_ipcheck checks/check_list checks/check_octstr 
checks/check_compiler.sh checks/check_fakesmsc.sh 
checks/check_fakewap.sh checks/check_headers.sh checks/check_http.sh 
checks/check_httpsmsc_kannel.sh checks/check_ppg.sh 
checks/check_sendsms.sh checks/check_smpp.sh

Check: checks/check_counter... OK.
Check: checks/check_date... OK.
Check: checks/check_ipcheck... OK.
Check: checks/check_list... OK.
Check: checks/check_octstr... OK.
Check: checks/check_compiler.sh... OK.
Check: checks/check_fakesmsc.sh... OK.
Check: checks/check_fakewap.sh... FAILURE!
Check: checks/check_headers.sh... OK.
Check: checks/check_http.sh...do not check SSL, SSL not compiled in
 OK.
Check: checks/check_httpsmsc_kannel.sh... OK.
Check: checks/check_ppg.sh...bb failed with control file test/iptestppg.txt
 FAILURE!
Check: checks/check_sendsms.sh... OK.
Check: checks/check_smpp.sh... OK.
At least one check failed, see `check.log'.

check.log
Check: checks/check_fakewap.sh
kill: 32: No such process

Check: checks/check_ppg.sh
kill: 113: No such process


thanks to all,
Kyriacos Sakkas

--
Kyriacos Sakkas
Development Team
Netsmart
Tel: + 357 22 452565
Fax: + 357 22 452566
Email: kyria...@netsmart.com.cy
http://www.netsmart.com.cy

Taking Business to a New Level!

** Confidentiality Notice: The information contained in this email
message may be privileged, confidential and protected from disclosure.
If you are not the intended recipient, any dissemination, distribution,
or copying of this  email message is strictly prohibited.
If you think that you have received this email message in error, please
email the sender at kyria...@netsmart.com.cy **

Re: SMS Text Length

[Kyriacos/Netsmart]

A small note:

Not all carriers have coding 0 == GSM, coding 0 is the Default charset 
of the specific SMSC, in most cases this is 7bit GSM, but that is not 
always true.


Kyriacos

On 05/06/2012 14:23, Tapan Kumar Thapa wrote:

Thanks...

I got it from docs...

It is GSM coding=0 by default for normal text messages.

Regards
Tapan Thapa

On Tue, Jun 5, 2012 at 4:47 PM, spameden spame...@gmail.com 
mailto:spame...@gmail.com wrote:


Read User Guide, I can't be your helping bot, sorry.


2012/6/5 Tapan Kumar Thapa tapan.thapa2...@gmail.com
mailto:tapan.thapa2...@gmail.com

Thanks..

What Is the default values of sendsms URL for coding
parameters if I am not setting any coding value?

Sent from my iPhone

Regards
Tapan Kumar Thapa
Manager-Tech Support
HT Mobile Solutions Limited
Mob-919871701375

On Jun 5, 2012, at 4:27 PM, spameden spame...@gmail.com
mailto:spame...@gmail.com wrote:


It depends on which coding you're sending.

if it's 7bit (coding=0), than messages will be splitted in
this scenario:

1) 160 symbols - 1 sms
2) each part of long concatenated sms is 153 symbols

for 8bit (coding=1)

1) 140 symbols - 1 sms
2) each part of long concatenated sms is 134 symbols

for UCS-2 (coding=2) (mainly used for unicode symbols etc,
russian language for exampl, your own language)

1) 70 symbols - 1 sms
2) each part of long concatenated sms is 67 symbols


read more here -
http://en.wikipedia.org/wiki/Short_Message_Service

you can specify to kannel which coding you'd like to use with
either coding= to smsbox or in sqlbox you coding parameter
in send_sms table.
2012/6/5 Tapan Thapa tapan.thapa2...@gmail.com
mailto:tapan.thapa2...@gmail.com

Hello,

If i am sending multi-part text messages (some times
320,480 or bigger character length message) then how many
messages kannel will submit to upstream smsc.

Regards
Tapan Thapa

Re: kannel's load balancing when using multiple concurrent connections to the same SMSC with the same smsc_id and login

[Kyriacos/Netsmart]

Hi,

I believe the load balance happens only in the sence that if one bind 
is busy sending an SMS and a new request comes, instead of queuing it, 
it goes to the second bind of the same name, rather than doing 
round-robin load balancing which seems to be what most people 
expect/assume. If your send rate is fairly low, then most messages will 
leave via the 1st bind.


Regards,
Kyriacos Sakkas

On 04/04/2012 13:58, spameden wrote:

I'm using latest kannel from SVN with sqlbox in scheme:
Box connections: smsbox:sqlbox, IP 127.0.0.1 (0 queued), (on-line 0d 
0h 13m 12s)


I'm using multiple connections to the same SMSC with the same login 
(my smsc allows up to 4 concurrent connections under the same login).


I have configured 2 connections for sending SMS and 2 connections for 
receiving DLRs.


I noticed from kannel's status kannel isn't load balancing properly 
between them:


  mysmsc[smsc]SMPP:smpp-provider.com:2775/0:login:NULL 
http://smpp-provider.com:2775/0:login:NULL (online 623s, rcvd: sms 0 
(0.00,0.00,0.00) / dlr 2559 (4.29,4.21,4.11), sent: sms 2559 
(4.29,4.21,4.11) / dlr 0

   (0.00,0.00,0.00), failed 0, queued 0 msgs)
   mysmsc[smsc]SMPP:smpp-provider.com:2775/0:login:NULL 
http://smpp-provider.com:2775/0:login:NULL (online 623s, rcvd: sms 0 
(0.00,0.00,0.00) / dlr 234 (0.40,0.38,0.38), sent: sms 234 
(0.40,0.38,0.38) / dlr 0

   (0.00,0.00,0.00), failed 0, queued 0 msgs)

dlr's are here because I'm using dlr_mask=31 to get also state=8.

You can clearly see that number of sent sms are not the same and 
differs in about 10 times or more.


I can't use different smsc_id's because in this case messages won't be 
matched against dlr table.


I can post relevant bits from configuration as well if needed..