Ya, I cant get it to compile on ubuntu 11.10 Using sqlbox 1.4.3 Build May 19 2011 22:12:07
I can see that sql box makes a connection to BB. INFO: MYSQL: server version 5.5.9, client version 5.1.58. DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 2548. INFO: Connected to bearerbox at localhost port 13001. DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 2548. But I do not see BB routing the messages to sqlbox. I assume "group = smsbox-route" but its not working. is 'smsbox-id' the id that I gave the sqlbox ? or is that ment just for the smsbox exec? - Trevor On Tue, Feb 7, 2012 at 11:26 AM, Milan P. Stanic <[email protected]> wrote: > 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 <[email protected]> >> 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 >> <[email protected]> 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 <[email protected]> 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) >
