Yes, it is in snv but another trunk. I don't remember where exactly
but search the mailing list for download sqlbox.
On 2/7/12, Trevor Benedict <mre...@gmail.com> wrote:
> Is that not in the svn?
> Where is that located?
>
> Thanks,
> - Trevor
>
> On Tue, Feb 7, 2012 at 10:54 AM, Alvaro Cornejo
> <cornejo.alv...@gmail.com> wrote:
>> 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
>
--
|-----------------------------------------------------------------------------------------------------------------|
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
