1) please check attached file.
2) i have this problem with 2 of my 6 providers: one returns ts=10 and the
other ts=4294967295
3) i tried to fix msg-id-type using 0x00, 0x01, 0x02, 0x03 but nothing changed
Thanks for your understanding !
Christian N'GOLE
General Manager WEB PLURIEL
Abidjan - CocodyAdresse : 27 BP 1222 Abj 27Email : [email protected] : +225
22 42 89 62Cel : +225 07 74 97 97Site Web : www.smseco.com
--- En date de : Jeu 15.7.10, brett skinner <[email protected]> a
écrit :
De: brett skinner <[email protected]>
Objet: Re: Mysql Timestamp issue
À: [email protected]
Cc: "N'Gole Christian" <[email protected]>
Date: Jeudi 15 juillet 2010, 15h29
Hi
Sorry my experience is very limited so someone better than me is going to have
to respond.
>From what I can see it looks like the SMSC keeps sending you delivery receipts
>and Kannel is acknowledging them so no problem there. The problem it seems is
>Kannel cannot find a particular DLR in the temporary table for the given
>arguments. In particular it seems to be looking for DLR from the SMSC with an
>id given to it by the SMSC of 4294967295 (or the ts values). I am not sure if
>this is the case and why Kannel keeps retrying that one or how to reset it.
@Nikos: Sorry I tried to help but I think your wisdom is needed. Mine is not
enough and I might be totally off the target. :)
Regards,
2010/7/15 Nikos Balkanas <[email protected]>
Hi,
1) You have not posted *any* submit_sm pdus (the ones you are trying to send)
as requested.
2) Your SMSc is right. It is you fault. Where did you find ts = 10?
3) Fix your msg-id-type. Read User's guide about it.
BR,
Nikos
----- Original Message ----- From: N'Gole Christian
To: brett skinner
Cc: Nikos Balkanas ; [email protected]
Sent: Thursday, July 15, 2010 2:57 PM
Subject: Re: Mysql Timestamp issue
sorry i send txt format.
Christian N'GOLE
General Manager WEB PLURIEL
Abidjan - Cocody
Adresse : 27 BP 1222 Abj 27
Email : [email protected]
Tel : +225 22 42 89 62
Cel : +225 07 74 97 97
Site Web : www.smseco.com
--- En date de : Jeu 15.7.10, brett skinner <[email protected]> a
Γ©crit :
De: brett skinner <[email protected]>
Objet: Re: Mysql Timestamp issue
Γ€: "N'GolΓ© Christian" <[email protected]>
Cc: "Nikos Balkanas" <[email protected]>, [email protected]
Date: Jeudi 15 juillet 2010, 13h38
Hi
The zip file appears to be corrupted.
On Thu, Jul 15, 2010 at 11:58 AM, N'GolΓ© Christian
<[email protected]> wrote:
Ok i send parts of smsc log.
THANKS YOU FOR YOUR TIME !
Christian N'GOLE
General Manager WEB PLURIEL
Abidjan - Cocody
Adresse : 27 BP 1222 Abj 27
Email : [email protected]
Tel : +225 22 42 89 62
Cel : +225 07 74 97 97
Site Web : www.smseco.com
--- En date de : Jeu 15.7.10, Nikos Balkanas <[email protected]> a Γ©crit :
De: Nikos Balkanas <[email protected]>
Objet: Re: Mysql Timestamp issue
Γ€: "N'Gole Christian" <[email protected]>, "brett skinner"
<[email protected]>
Cc: [email protected]
Date: Jeudi 15 juillet 2010, 11h34
Hi,
No, ts is the single most important value for dlr matching. Can't do it without
it.
Could be an issue with message-id-type, but your description doesn't make any
sense.
Listen, if you ask for help you need to post detailed smsc logs as i asked in a
previous mail.
BR,
Nikos
----- Original Message ----- From: N'Gole Christian
To: brett skinner
Cc: [email protected]
Sent: Thursday, July 15, 2010 12:18 PM
Subject: Re: Mysql Timestamp issue
yes i know that ! so if i understand this value is not important for dlrs
managing ?
Christian N'GOLE
General Manager WEB PLURIEL
Abidjan - Cocody
Adresse : 27 BP 1222 Abj 27
Email : [email protected]
Tel : +225 22 42 89 62
Cel : +225 07 74 97 97
Site Web : www.smseco.com
--- En date de : Jeu 15.7.10, brett skinner <[email protected]> a
ΞΉcrit :
De: brett skinner <[email protected]>
Objet: Re: Mysql Timestamp issue
Ξ : "N'GolΞΉ Christian" <[email protected]>
Cc: [email protected]
Date: Jeudi 15 juillet 2010, 11h15
Firstly that table is for use by Kannel as a storage so that you do not lose
any DLR if the box goes down.
If you want more information for DLRs when sending sms you need to append the
dlr-url parameter to the end of the URL that you are using. Also make sure that
you are using the dlr-mask parameter. In that URL you can specify what
information you would like posted back.
Please see the user guide for details.
Regards,
On Thu, Jul 15, 2010 at 11:11 AM, N'GolΞΉ Christian
<[email protected]> wrote:
yes i use kannel as smpp client. So please what must i do to solve this issue ?
Christian N'GOLE
General Manager WEB PLURIEL
Abidjan - Cocody
Adresse : 27 BP 1222 Abj 27
Email : [email protected]
Tel : +225 22 42 89 62
Cel : +225 07 74 97 97
Site Web : www.smseco.com
--- En date de : Jeu 15.7.10, brett skinner <[email protected]> a
ΞΉcrit :
De: brett skinner <[email protected]>
Objet: Re: Mysql Timestamp issue
Ξ : "N'GolΞΉ Christian" <[email protected]>
Cc: [email protected]
Date: Jeudi 15 juillet 2010, 11h02
Hi
Are you using SMPP? If so then the ts field although it would seem is a
timestamp but it acutally maps to the unique ID provided by the SMSC for that
message. I asked this question a little while ago and that was the answer I got
and it seems to be correct from my testing. The group can correct me if I am
wrong.
Regards,
On Thu, Jul 15, 2010 at 10:43 AM, N'GolΞΉ Christian
<[email protected]> wrote:
Heemmo Group,
I still have problem with mysql ts value. when kannel gets dlrs from my smsc
the field ts has the same value.
2010-07-14 06:32:42 [31512] [10] DEBUG: DLR[mysql]: Looking for DLR
smsc=vodoosms, ts=10, dst=22507484497, type=1
2010-07-14 06:32:42 [31512] [10] DEBUG: sql: SELECT mask, service, url, source,
destination, boxc FROM kannel_dlrs WHERE smsc='vodoosms' AND ts='10';
I contacted my smsc but he told me that this is kannel issue.
Please i need help.
2010-07-12 07:20:27 [16187] [15] DEBUG: SMPP[mobiweb]: Sending PDU:
2010-07-12 07:20:27 [16187] [15] DEBUG: SMPP PDU 0x9dfa728 dump:
2010-07-12 07:20:27 [16187] [15] DEBUG: type_name: submit_sm
2010-07-12 07:20:27 [16187] [15] DEBUG: command_id: 4 = 0x00000004
2010-07-12 07:20:27 [16187] [15] DEBUG: command_status: 0 = 0x00000000
2010-07-12 07:20:27 [16187] [15] DEBUG: sequence_number: 12 = 0x0000000c
2010-07-12 07:20:27 [16187] [15] DEBUG: service_type: NULL
2010-07-12 07:20:27 [16187] [15] DEBUG: source_addr_ton: 5 = 0x00000005
2010-07-12 07:20:27 [16187] [15] DEBUG: source_addr_npi: 0 = 0x00000000
2010-07-12 07:20:27 [16187] [15] DEBUG: source_addr: "SMSECO.COM"
2010-07-12 07:20:27 [16187] [15] DEBUG: dest_addr_ton: 1 = 0x00000001
2010-07-12 07:20:27 [16187] [15] DEBUG: dest_addr_npi: 1 = 0x00000001
2010-07-12 07:20:27 [16187] [15] DEBUG: destination_addr: "22507749798"
2010-07-12 07:20:27 [16187] [15] DEBUG: esm_class: 3 = 0x00000003
2010-07-12 07:20:27 [16187] [15] DEBUG: protocol_id: 0 = 0x00000000
2010-07-12 07:20:27 [16187] [15] DEBUG: priority_flag: 0 = 0x00000000
2010-07-12 07:20:27 [16187] [15] DEBUG: schedule_delivery_time: NULL
2010-07-12 07:20:27 [16187] [15] DEBUG: validity_period: NULL
2010-07-12 07:20:27 [16187] [15] DEBUG: registered_delivery: 1 = 0x00000001
2010-07-12 07:20:27 [16187] [15] DEBUG: replace_if_present_flag: 0 =
0x00000000
2010-07-12 07:20:27 [16187] [15] DEBUG: data_coding: 0 = 0x00000000
2010-07-12 07:20:27 [16187] [15] DEBUG: sm_default_msg_id: 0 = 0x00000000
2010-07-12 07:20:27 [16187] [15] DEBUG: sm_length: 4 = 0x00000004
2010-07-12 07:20:27 [16187] [15] DEBUG: short_message: "test"
2010-07-12 07:20:27 [16187] [15] DEBUG: SMPP PDU dump ends.
2010-07-12 07:20:27 [16187] [15] DEBUG: SMPP[mobiweb]: Got PDU:
2010-07-12 07:20:27 [16187] [15] DEBUG: SMPP PDU 0x9dfa728 dump:
2010-07-12 07:20:27 [16187] [15] DEBUG: type_name: submit_sm_resp
2010-07-12 07:20:27 [16187] [15] DEBUG: command_id: 2147483652 = 0x80000004
2010-07-12 07:20:27 [16187] [15] DEBUG: command_status: 0 = 0x00000000
2010-07-12 07:20:27 [16187] [15] DEBUG: sequence_number: 12 = 0x0000000c
2010-07-12 07:20:27 [16187] [15] DEBUG: message_id:
2010-07-12 07:20:27 [16187] [15] DEBUG: Octet string at 0x9e03d90:
2010-07-12 07:20:27 [16187] [15] DEBUG: len: 32
2010-07-12 07:20:27 [16187] [15] DEBUG: size: 33
2010-07-12 07:20:27 [16187] [15] DEBUG: immutable: 0
2010-07-12 07:20:27 [16187] [15] DEBUG: data: 36 61 65 63 33 62 63 35 32
39 61 31 34 64 64 32 6aec3bc529a14dd2
2010-07-12 07:20:27 [16187] [15] DEBUG: data: 61 66 36 37 66 61 39 64 34
33 63 36 63 30 32 33 af67fa9d43c6c023
2010-07-12 07:20:27 [16187] [15] DEBUG: Octet string dump ends.
2010-07-12 07:20:27 [16187] [15] DEBUG: SMPP PDU dump ends.
2010-07-12 07:20:27 [16187] [15] DEBUG: DLR[mysql]: Adding DLR smsc=mobiweb,
ts=4294967295, src=SMSECO.COM, dst=22507749798, mask=19, boxc=
2010-07-12 07:20:27 [16187] [15] DEBUG: sql: INSERT INTO kannel_dlrs (smsc, ts,
source, destination, service, url, mask, boxc, status) VALUES ('mobiweb',
'4294967295', 'SMSECO.COM', '22507749798', 'smsecosender',
'http://www.smseco.com/includes/smpp/smseco_smpp/dlr.php?smsc=%i&status=%d&numero=%P&id_sender=%p&dtSent=%t&msgid=MSG_59f0239089cc34fcc06bb5a1b5f517d0_22507749798_1_9-9_1&fuseau=Europe/Paris',
'19', '', '0');
2010-07-12 07:20:32 [16187] [12] DEBUG: clear_old_concat_parts called
