On Tue, 2012-02-07 at 20:08, Aleksandar Smolovic wrote: > you have it in "addons" dir... > Prior that you need to install openssl-devel package and libxml2 package
That depends on distribution and OS version. OP wrote that he uses Ubuntu (which is Debian derivative) so he have to install libssl-dev and libxml-dev and some other development packages. But becasue he runs SVN version he probably knows that already ;-) > -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 > > > -- Kind regards, Milan -------------------------------------------------- Arvanta, IT Security http://www.arvanta.net Please do not send me e-mail containing HTML code or documents in proprietary format (word, excel, pps and so on)
