you have it in "addons" dir... Prior that you need to install openssl-devel package and libxml2 package
-original message- Subject: Re: MySQL Save from smpp From: Trevor Benedict <mre...@gmail.com> Date: 07/02/2012 8:04 pm 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
