Hi,
Please do not repost the same message more than once without offering
anything new. It is consider spam.
I can't quite understand what is your problem:
Problem is I only seem to get these messages when I restart
kannel, then all the delivery reports come through at that point.
What messages? I didn't ask you to grep 1 liners from submit in the logs,
just post at least 1 full entry (submit_sm, submit_sm_resp, deliver_sm,
deliver_sm_resp) for an SMS in maximum detail from your logs.
Also dlr
table is not removing entries, should it be? Its not updating them
either.
Are you referring to dlr table in kannel or sqlbox? Please be as specific as
you can when asking for help.
BR,
Nikos
----- Original Message -----
From: "Barry Murphy" <[email protected]>
To: "Barry Murphy" <[email protected]>
Cc: "Nikos Balkanas" <[email protected]>; "Users" <[email protected]>
Sent: Monday, May 24, 2010 5:16 AM
Subject: Re: MySQL not storing
Hi,
Having messages queuing up in the dlr and never leaving, this is a problem
I assume as per below problem
Thanks
Barry
On Mon, 24 May 2010 13:18:03 +1200, Barry Murphy <[email protected]> wrote:
Ok so I found the problem, I was not adding dlr_mask 31 which I'm now
doing and getting results inserted into dlr table and also into sent_sms
for sqlbox. Problem is I only seem to get these messages when I restart
kannel, then all the delivery reports come through at that point. Also
dlr
table is not removing entries, should it be? Its not updating them
either.
thanks
Barry
On Mon, 24 May 2010 12:26:27 +1200, Barry Murphy <[email protected]>
wrote:
I have tried setting msg-id-type=0x03 , 0x02 & 0x01 & 0x00, none of
which
place a dlr into mysql table.
thanks
Barry
----- Original Message -----
From: "Barry Murphy" <[email protected]>
To: "Nikos Balkanas" <[email protected]>
Sent: Monday, May 24, 2010 12:16 AM
Subject: Re: MySQL not storing
Hi,
With regards to submit in my logs, all I have is the following on
full
debug 0 .
smsc:~# grep submit /tmp/kannel.log
2010-05-23 23:55:45 [4413] [6] DEBUG: type_name: submit_sm
2010-05-23 23:55:45 [4413] [6] DEBUG: type_name: submit_sm_resp
2010-05-23 23:56:03 [4413] [6] DEBUG: data: 73 75 62 6d 69 74 20
64
61 74 65 3a 31 30 30 35 submit date:1005
2010-05-24 00:02:15 [4413] [6] DEBUG: type_name: submit_sm
2010-05-24 00:02:15 [4413] [6] DEBUG: type_name: submit_sm_resp
2010-05-24 00:02:31 [4413] [6] DEBUG: data: 73 75 62 6d 69 74 20
64
61 74 65 3a 31 30 30 35 submit date:1005
2010-05-24 00:05:40 [4413] [6] DEBUG: type_name: submit_sm
2010-05-24 00:05:40 [4413] [6] DEBUG: type_name: submit_sm_resp
2010-05-24 00:05:47 [4413] [6] DEBUG: data: 73 75 62 6d 69 74 20
64
61 74 65 3a 31 30 30 35 submit date:1005
2010-05-24 00:08:42 [4413] [6] DEBUG: type_name: submit_sm
2010-05-24 00:08:42 [4413] [6] DEBUG: type_name: submit_sm_resp
2010-05-24 00:08:47 [4413] [6] DEBUG: data: 73 75 62 6d 69 74 20
64
61 74 65 3a 31 30 30 35 submit date:1005
2010-05-24 00:29:09 [5952] [6] DEBUG: type_name: submit_sm
2010-05-24 00:29:10 [5952] [6] DEBUG: type_name: submit_sm_resp
2010-05-24 00:45:51 [5952] [6] DEBUG: type_name: submit_sm
2010-05-24 00:45:52 [5952] [6] DEBUG: type_name: submit_sm_resp
2010-05-24 01:49:05 [5952] [6] DEBUG: type_name: submit_sm
2010-05-24 01:49:05 [5952] [6] DEBUG: type_name: submit_sm_resp
2010-05-24 09:14:08 [5952] [6] DEBUG: type_name: submit_sm
2010-05-24 09:14:09 [5952] [6] DEBUG: type_name: submit_sm_resp
smsc:~#
Thanks
Barry
On Sun, 23 May 2010 21:15:50 +0300, "Nikos Balkanas"
<[email protected]>
wrote:
Sorry, that should read "msg-id-type" not "message-type".
BR,
Nikos
----- Original Message -----
From: "Nikos Balkanas" <[email protected]>
To: "Barry Murphy" <[email protected]>; <[email protected]>
Sent: Sunday, May 23, 2010 9:11 PM
Subject: Re: MySQL not storing
Hi,
Mysql looks fine. Your problem doesn't seem to be that "mysql
doesn't
store", but rather that mysql doesn't match. Please read User's
guide
why
in message-type. If that doesn't solve your problem. please repost,
this
time including also submit & submit_resp PDUs in your logs.
BR,
Nikos
----- Original Message -----
From: "Barry Murphy" <[email protected]>
To: <[email protected]>
Sent: Sunday, May 23, 2010 9:33 AM
Subject: MySQL not storing
Hi,
I've setup Kannel to use mysql for storage, see setup below. When
I
check
the status page it shows no errors and that mysql is being used
for
DLR,
select queries seem fine, but when sending a message from smsbox
it
doesnt
appear to add an entry to DLR, see debug info below:
#### CONFIG ####
group = core
dlr-storage = mysql
group = mysql-connection
id = mydlr
host = 10.10.1.1
username = user
password = pass
database = smsc
max-connections = 1
group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
#### DEBUG ####
2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP PDU 0x819dc78 dump:
2010-05-23 06:25:17 [4017] [6] DEBUG: type_name: deliver_sm
2010-05-23 06:25:17 [4017] [6] DEBUG: command_id: 5 = 0x00000005
2010-05-23 06:25:17 [4017] [6] DEBUG: command_status: 0 =
0x00000000
2010-05-23 06:25:17 [4017] [6] DEBUG: sequence_number: 124 =
0x0000007c
2010-05-23 06:25:17 [4017] [6] DEBUG: service_type: NULL
2010-05-23 06:25:17 [4017] [6] DEBUG: source_addr_ton: 1 =
0x00000001
2010-05-23 06:25:17 [4017] [6] DEBUG: source_addr_npi: 1 =
0x00000001
2010-05-23 06:25:17 [4017] [6] DEBUG: source_addr: "64274909123"
2010-05-23 06:25:17 [4017] [6] DEBUG: dest_addr_ton: 1 =
0x00000001
2010-05-23 06:25:17 [4017] [6] DEBUG: dest_addr_npi: 1 =
0x00000001
2010-05-23 06:25:17 [4017] [6] DEBUG: destination_addr:
"621234567"
2010-05-23 06:25:17 [4017] [6] DEBUG: esm_class: 4 = 0x00000004
2010-05-23 06:25:17 [4017] [6] DEBUG: protocol_id: 0 =
0x00000000
2010-05-23 06:25:17 [4017] [6] DEBUG: priority_flag: 0 =
0x00000000
2010-05-23 06:25:17 [4017] [6] DEBUG: schedule_delivery_time:
NULL
2010-05-23 06:25:17 [4017] [6] DEBUG: validity_period: NULL
2010-05-23 06:25:17 [4017] [6] DEBUG: registered_delivery: 1 =
0x00000001
2010-05-23 06:25:17 [4017] [6] DEBUG: replace_if_present_flag: 0
=
0x00000000
2010-05-23 06:25:17 [4017] [6] DEBUG: data_coding: 0 =
0x00000000
2010-05-23 06:25:17 [4017] [6] DEBUG: sm_default_msg_id: 0 =
0x00000000
2010-05-23 06:25:17 [4017] [6] DEBUG: sm_length: 109 =
0x0000006d
2010-05-23 06:25:17 [4017] [6] DEBUG: short_message:
2010-05-23 06:25:17 [4017] [6] DEBUG: Octet string at
0x819e8b0:
2010-05-23 06:25:17 [4017] [6] DEBUG: len: 109
2010-05-23 06:25:17 [4017] [6] DEBUG: size: 110
2010-05-23 06:25:17 [4017] [6] DEBUG: immutable: 0
2010-05-23 06:25:17 [4017] [6] DEBUG: data: 20 69 64 3a 32 31
35
33
32 30 32 32 20 20 73 75 id:21532022 su
2010-05-23 06:25:17 [4017] [6] DEBUG: data: 62 3a 30 30 31 20
64
6c
76 72 64 3a 30 30 31 20 b:001 dlvrd:001
2010-05-23 06:25:17 [4017] [6] DEBUG: data: 73 75 62 6d 69 74
20
64
61 74 65 3a 31 30 30 35 submit date:1005
2010-05-23 06:25:17 [4017] [6] DEBUG: data: 32 33 30 38 32 35
20
64
6f 6e 65 20 64 61 74 65 230825 done date
2010-05-23 06:25:17 [4017] [6] DEBUG: data: 3a 31 30 30 35 32
33
30
38 32 35 20 73 74 61 74 :1005230825 stat
2010-05-23 06:25:17 [4017] [6] DEBUG: data: 3a 44 45 4c 49 56
52
44
20 65 72 72 3a 30 30 30 :DELIVRD err:000
2010-05-23 06:25:17 [4017] [6] DEBUG: data: 20 74 65 78 74 3a
20
33
35 46 30 32 30 text: 35F020
2010-05-23 06:25:17 [4017] [6] DEBUG: Octet string dump ends.
2010-05-23 06:25:17 [4017] [6] DEBUG: receipted_message_id:
"21532022"
2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP PDU dump ends.
2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP[internal] handle_pdu,
got
DLR
2010-05-23 06:25:17 [4017] [6] WARNING: SMPP[internal]: Got DLR
with
unknown 'message_state' (-1).
2010-05-23 06:25:17 [4017] [6] DEBUG: DLR[mysql]: Looking for DLR
smsc=internal, ts=21532022, dst=64274909123, type=2
2010-05-23 06:25:17 [4017] [6] DEBUG: sql: SELECT mask, service,
url,
source, destination, boxc FROM dlr WHERE smsc='internal' AND
ts='21532022';
2010-05-23 06:25:17 [4017] [6] DEBUG: no rows found
2010-05-23 06:25:17 [4017] [6] WARNING: DLR[mysql]: DLR from
SMSC<internal> for DST<64274909123> not found.
2010-05-23 06:25:17 [4017] [6] ERROR: SMPP[internal]: got DLR but
could
not find message or was not interested in it id<21532022>
dst<64274909123>,
type<2>
2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP[internal]: Sending PDU:
2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP PDU 0x819b848 dump:
2010-05-23 06:25:17 [4017] [6] DEBUG: type_name: deliver_sm_resp
2010-05-23 06:25:17 [4017] [6] DEBUG: command_id: 2147483653 =
0x80000005
2010-05-23 06:25:17 [4017] [6] DEBUG: command_status: 0 =
0x00000000
2010-05-23 06:25:17 [4017] [6] DEBUG: sequence_number: 124 =
0x0000007c
2010-05-23 06:25:17 [4017] [6] DEBUG: message_id: NULL
2010-05-23 06:25:17 [4017] [6] DEBUG: SMPP PDU dump ends.
2010-05-23 06:25:34 [4017] [0] WARNING: Killing signal or HTTP
admin
command received, shutting down...
2010-05-23 06:25:34 [4017] [0] DEBUG: Shutting down Kannel...
2010-05-23 06:25:34 [4017] [0] DEBUG: shutting down smsc
2010-05-23 06:25:34 [4017] [0] DEBUG: Shutting down SMSCConn
SMPP:1.2.3.4:7901/7901:userid:VMA (slow)
2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP[internal]: Sending
unbind:
2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP PDU 0x819dc78 dump:
2010-05-23 06:25:34 [4017] [6] DEBUG: type_name: unbind
2010-05-23 06:25:34 [4017] [6] DEBUG: command_id: 6 = 0x00000006
2010-05-23 06:25:34 [4017] [6] DEBUG: command_status: 0 =
0x00000000
2010-05-23 06:25:34 [4017] [6] DEBUG: sequence_number: 4 =
0x00000004
2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP PDU dump ends.
2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP[internal]: Got PDU:
2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP PDU 0x819dc78 dump:
2010-05-23 06:25:34 [4017] [6] DEBUG: type_name: unbind_resp
2010-05-23 06:25:34 [4017] [6] DEBUG: command_id: 2147483654 =
0x80000006
2010-05-23 06:25:34 [4017] [6] DEBUG: command_status: 0 =
0x00000000
2010-05-23 06:25:34 [4017] [6] DEBUG: sequence_number: 4 =
0x00000004
2010-05-23 06:25:34 [4017] [6] DEBUG: SMPP PDU dump ends.
2010-05-23 06:25:35 [4017] [6] DEBUG: SMPP[internal]: io_thread:
break
and
shutting down
Many thanks in advance
Barry
