Hi
bearerbox DOES NOT permanently save any to mysql. You need to use
sqlbox for that --or your own app--.
Bearerbos uses mysql only to track dlr. Once it receives a final
status, it removes the entry from db. That is why that table is
-almost- always empty.
Regards
Alvaro
On 2/7/12, Trevor Benedict <mre...@gmail.com> wrote:
> I am having a hell of a hard time trying to get bearerbox to save
> incoming smpp pdu's into the database.
> What am I doing wrong? Ive spent the last 3 days trying to get this working.
>
> Ver: SVN Build `Feb 3 2012 10:44:12'
> Libxml version 2.7.8
> Ubuntu 11.10
>
> DEBUG: SMPP PDU 0x2624740 dump:
> DEBUG: type_name: deliver_sm
> DEBUG: command_id: 5 = 0x00000005
> DEBUG: command_status: 0 = 0x00000000
> DEBUG: sequence_number: 92 = 0x0000005c
> DEBUG: service_type: NULL
> DEBUG: source_addr_ton: 1 = 0x00000001
> DEBUG: source_addr_npi: 1 = 0x00000001
> DEBUG: source_addr: "119784068219"
> DEBUG: dest_addr_ton: 0 = 0x00000000
> DEBUG: dest_addr_npi: 1 = 0x00000001
> DEBUG: destination_addr: "41080197"
> DEBUG: esm_class: 4 = 0x00000004
> DEBUG: protocol_id: 0 = 0x00000000
> DEBUG: priority_flag: 0 = 0x00000000
> DEBUG: schedule_delivery_time: NULL
> DEBUG: validity_period: NULL
> DEBUG: registered_delivery: 2 = 0x00000002
> DEBUG: replace_if_present_flag: 0 = 0x00000000
> DEBUG: data_coding: 0 = 0x00000000
> DEBUG: sm_default_msg_id: 0 = 0x00000000
> DEBUG: sm_length: 119 = 0x00000077
> DEBUG: short_message:
> DEBUG: Octet string at 0x2625680:
> DEBUG: len: 119
> DEBUG: size: 120
> DEBUG: immutable: 0
> DEBUG: data: 69 64 3a 34 37 37 31 44 46 36 39 20 73 75 62 3a
> id:4771DF69 sub:
> DEBUG: data: 30 30 31 20 64 6c 76 72 64 3a 30 30 30 20 73 75
> 001 dlvrd:000 su
> DEBUG: data: 62 6d 69 74 20 64 61 74 65 3a 31 30 30 35 31 30
> bmit date:100510
> DEBUG: data: 31 36 34 39 20 64 6f 6e 65 20 64 61 74 65 3a 31
> 1649 done date:1
> DEBUG: data: 30 30 35 31 30 31 36 34 39 20 73 74 61 74 3a 52
> 005101649 stat:R
> DEBUG: data: 45 4a 45 43 54 44 20 65 72 72 3a 30 30 42 20 74
> EJECTD err:00B t
> DEBUG: data: 65 78 74 3a 2b 58 54 3a 31 30 31 30 2c 31 30 35
> ext:+XT:1010,105
> DEBUG: data: 31 32 2c 32 30 39 2e 12,209.
> DEBUG: Octet string dump ends.
> DEBUG: message_state: 5 = 0x00000005
> DEBUG: receipted_message_id: "4771DF69"
> DEBUG: SMPP PDU dump ends.
> DEBUG: SMPP['kore_smsc'] handle_pdu, got DLR
> DEBUG: DLR[mysql]: Looking for DLR smsc='kore_smsc', ts=1198645097,
> dst=119784068219, type=2
> DEBUG: sql: SELECT `mask`, `service`, `url`, `source`, `destination`,
> `boxc` FROM `dlr` WHERE `smsc`=? AND `ts`=? LIMIT 1
> DEBUG: column=mask buffer_type=3 max_length=0 length=10
> DEBUG: column=service buffer_type=253 max_length=0 length=40
> DEBUG: column=url buffer_type=253 max_length=0 length=255
> DEBUG: column=source buffer_type=253 max_length=0 length=40
> DEBUG: column=destination buffer_type=253 max_length=0 length=40
> DEBUG: column=boxc buffer_type=253 max_length=0 length=40
> WARNING: DLR[mysql]: DLR from SMSC<'kore_smsc'> for DST<119784068219> not
> found.
> ERROR: SMPP['kore_smsc']: got DLR but could not find message or was
> not interested in it id<1198645097> dst<119784068219>, type<2>
>
> group = smsc
> smsc = smpp
> host = xxx.com
> port = 2777
> receive-port = 2777
> smsc-username = xxxuser
> smsc-password = xxxpass
> keepalive = 55
> system-type = 'VMA'
> interface-version = 34
> transceiver-mode = 0
> wait-ack = 60
> smsc-id = 'kore_smsc'
> my-number= '89014104'
> source-addr-ton = 0
> source-addr-npi = 1
> dest-addr-ton = 1
> dest-addr-npi = 1
> bind-addr-ton = 0
> bind-addr-npi = 0
> connection-timeout = 60
> throughput = 1
> msg-id-type = "0x02"
>
> group = core
> admin-port = 13000
> admin-password = bar
> #admin-deny-ip = "*.*.*.*"
> admin-allow-ip = "*.*.*.*"
> wapbox-port = 13002
> wdp-interface-name = "*"
> log-file = "/var/log/kannel/bearerbox.log"
> #box-deny-ip = "*.*.*.*"
> box-allow-ip = "*.*.*.*"
> smsbox-port = 13003
> dlr-storage = mysql
> store-type = file
> store-location = "/tmp/kannel.store"
>
> group = sms-service
> accepted-smsc = "kore_smsc"
> #tried a few things here
> keyword = id:
> catch-all = true
> omit-empty = true
> #doesnt work...
> exec = "echo '%a' >> /tmp/sms_in.txt"
>
> group = smsbox-route
> smsbox-id = "smsb"
> smsc-id = "kore_smsc"
> #shortcode = "8901"
>
> group = smsbox
> bearerbox-host = localhost
> #bearerbox-port = 13005
> smsbox-id = "smsb"
> mo-recode = true
>
> group = mysql-connection
> id = mydlr
> host = 10.0.0.20
> username = xxxmysql
> password = xxxmysql
> database = kannel
> 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
>
>
--
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
SMS y GPRS online
Visitenos en www.perusms.NET www.smsglobal.com.mx y
www.pravcom.com
