On Fri, 2016-02-05 at 13:57, Беляев Владимир Николаевич wrote:
> Добрый день!
Добар дан! :)
> An error occurred while sending sms:
>
> DEBUG: sql: INSERT INTO sent_sms ( sql_id, momt, sender, receiver, udhdata,
> msgdata, time, smsc_id, service, account, sms_type, mclass, mwi, coding,
> compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset,
> boxc_id, binfo, meta_data ) VALUES ( NULL, 'DLR', 'SNGB', '+79682012971',
> NULL, 'id:33303613023 sub:001 dlvrd:001 submit date:1602051127 done
> date:1602051127 stat:DELIVRD err:0 text:
>
> ERROR: MYSQL: You have an error in your SQL syntax; check the manual that
> corresponds to your MariaDB server version for the right syntax to use near
> ''id:33303613023 sub:001 dlvrd:001 submit date:1602051127 done
> date:1602051127 st' at line 1
I didn't worked with MariaDB and don't know if it's syntax differs from
Mysql. Anyway, look s like there is missing ending single quote
character (') around value for meta_data column.
Are you sure you DEBUG text (look above) is properly posted here?
> 2016-02-05 13:32:57 [57147] [4] DEBUG: smsbox_to_bearerbox: sms received
>
> SMPP dump:
> 2016-02-05 13:33:01 [57268] [6] DEBUG: Optional parameter length read as 12
> 2016-02-05 13:33:01 [57268] [6] DEBUG: SMPP[smstraffic_test]: Got PDU:
> 2016-02-05 13:33:01 [57268] [6] DEBUG: SMPP PDU 0x7f259c000a30 dump:
> 2016-02-05 13:33:01 [57268] [6] DEBUG: type_name: deliver_sm
> 2016-02-05 13:33:01 [57268] [6] DEBUG: command_id: 5 = 0x00000005
> 2016-02-05 13:33:01 [57268] [6] DEBUG: command_status: 0 = 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: sequence_number: 404759 = 0x00062d17
> 2016-02-05 13:33:01 [57268] [6] DEBUG: service_type: NULL
> 2016-02-05 13:33:01 [57268] [6] DEBUG: source_addr_ton: 0 = 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: source_addr_npi: 0 = 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: source_addr: "79682012971"
> 2016-02-05 13:33:01 [57268] [6] DEBUG: dest_addr_ton: 0 = 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: dest_addr_npi: 0 = 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: destination_addr: "SNGB"
> 2016-02-05 13:33:01 [57268] [6] DEBUG: esm_class: 4 = 0x00000004
> 2016-02-05 13:33:01 [57268] [6] DEBUG: protocol_id: 0 = 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: priority_flag: 0 = 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: schedule_delivery_time: NULL
> 2016-02-05 13:33:01 [57268] [6] DEBUG: validity_period: NULL
> 2016-02-05 13:33:01 [57268] [6] DEBUG: registered_delivery: 0 = 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: replace_if_present_flag: 0 =
> 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: data_coding: 0 = 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000
> 2016-02-05 13:33:01 [57268] [6] DEBUG: sm_length: 116 = 0x00000074
> 2016-02-05 13:33:01 [57268] [6] DEBUG: short_message:
> 2016-02-05 13:33:01 [57268] [6] DEBUG: Octet string at 0x7f259c000d60:
> 2016-02-05 13:33:01 [57268] [6] DEBUG: len: 116
> 2016-02-05 13:33:01 [57268] [6] DEBUG: size: 117
> 2016-02-05 13:33:01 [57268] [6] DEBUG: immutable: 0
> 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 69 64 3a 33 33 33 30 33 37 37
> 32 35 31 35 20 73 id:33303772515 s
> 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 75 62 3a 30 30 31 20 64 6c 76
> 72 64 3a 30 30 31 ub:001 dlvrd:001
> 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 20 73 75 62 6d 69 74 20 64 61
> 74 65 3a 31 36 30 submit date:160
> 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 32 30 35 31 31 33 32 20 64 6f
> 6e 65 20 64 61 74 2051132 done dat
> 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 65 3a 31 36 30 32 30 35 31 31
> 33 33 20 73 74 61 e:1602051133 sta
> 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 74 3a 44 45 4c 49 56 52 44 20
> 65 72 72 3a 30 20 t:DELIVRD err:0
> 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 74 65 78 74 3a 54 65 73 74 20
> 44 4c 52 20 53 4d text:Test DLR SM
> 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 50 50 20 33 PP 3
> 2016-02-05 13:33:01 [57268] [6] DEBUG: Octet string dump ends.
> 2016-02-05 13:33:01 [57268] [6] DEBUG: message_state: 2 = 0x00000002
> 2016-02-05 13:33:01 [57268] [6] DEBUG: receipted_message_id: "33303772515"
> 2016-02-05 13:33:01 [57268] [6] DEBUG: SMPP PDU dump ends.
>
> Send code:
>
> my $resp = $smpp->submit_sm( source_addr => 'SNGB',
> source_addr_ton => 0x05,
> source_addr_npi => 0x01,
> destination_addr => $phone,
> dest_addr_ton => 0x01,
> dest_addr_npi => 0x01,
> data_coding => 0x08,
> message_payload => $msg_ucs2,
> esm_class => 0x00,
> registered_delivery => 1);
Is this some ready made function or something you developed in house?
