Re: DLR with sqlbox
Jorge, If you insert directly into send_sms table, I think you must set an unique id in dlr_url. This because the same info you insert into send_sms is inserted into sent_sms, and to track DLR for messages, yu must compare dlr_url in rows with momt field set to DLR and the dlr_url. By example mysqlselect momt,receiver,dlr_mask,dlr_url from sent_sms where dlr_url='141b2de2'; +--+--+--+--+ | momt | receiver | dlr_mask | dlr_url | +--+--+--+--+ | MT | +569775 | 19 | 141b2de2 | | DLR | +569775 |1 | 141b2de2 | +--+--+--+--+ 2 rows in set (0.00 sec) As you see, setting dlr_url to a unique id for each message I can track the DLR for each one. Best regards, El jue, 22-12-2011 a las 15:20 +, Jorge Raimundo escribió: Hi all! I've installed smsbox and successfully sent an SMS using it, but I'm not being able to receive the DLR info. Right now the SMSC is rejecting my SMSes because I have no credits there and I am using this situation to test the DLR. I should have DLR information on the database that tells me that the SMSC is rejecting my messages. On the database I'm doing this: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url ) VALUES ( 'MT', 'MV', '+3519**67', 'Hello world', 2, 31, 'http%3A%2F% 2F**%2Fteste.php%3Fdestination%3D7%26type%3D%25d' ) On the smsc log I get the following: [2447] [6] DEBUG: SMPP PDU 0x7dde00 dump: [2447] [6] DEBUG: type_name: submit_sm_resp [2447] [6] DEBUG: command_id: 2147483652 = 0x8004 [2447] [6] DEBUG: command_status: 69 = 0x0045 [2447] [6] DEBUG: sequence_number: 252 = 0x00fc [2447] [6] DEBUG: message_id: NULL [2447] [6] DEBUG: SMPP PDU dump ends. [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x0045 (Submit failed) in response to submit_sm. [2447] [6] DEBUG: SMSC[ROUTO]: creating DLR message [2447] [6] DEBUG: SMSC[ROUTO]: DLR = http%3A%2F% 2Feasymessage.multivision.pt%2Fservices%2Fteste.php%3Fdestination%3D7% 26type%3D%25d [2447] [6] WARNING: smsbox_list empty! I'm getting command_status: 69 (SMSC returned error code 0x0045), this is the code used by my SMSC to tell me that the SMS was rejected, so this should translate to a status of 16 on dlr, but nothing was passed to my side. The sent_sms has no dlr data and the link I passed on dlr-url was not called... What's wrong in here? Best regards, Jorge -- Multivision Jorge Raimundo RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt -- Carlos Massoglia Lillo Gerencia de Innovación y Desarrollo MindFree Ingeniería Limitada www.mindfree.cl
Re: Help store DLR REPORTS
You can use SQLBOX. It has two tables sent_sms and send_sms. In sent_sms table are saved the DLR automatically. best regards, El mié, 21-12-2011 a las 13:43 +0100, mohamed keita escribió: Hello I read the documentation(user documentation) on dlr. I uninstalled and recompiled kannel with - with-mysql. Then I update my core group by adding dlr-storage = mysql. I added the following lines to my configuration lines. # Configuration connection mysql group = mysql-connection id = mydlr host = localhost username = root password = fyle database = kannel max-connections =2 # Groupe dlr-db(stocker les informations sur les sms envoyés) 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 but i have no datas in my database. I have no data in my database. I field-boxc-id = boxc -- Carlos Massoglia Lillo Gerencia de Innovación y Desarrollo MindFree Ingeniería Limitada www.mindfree.cl
Re: MySQL Storage
Hi, you can install sqlbox, and you get a table called sent_sms with all sms sent and DLR. Cheers. El mié, 07-12-2011 a las 10:49 +0100, Supporto Tecnico - Crazy Network escribió: Hi everyone. im trying to work with Kannel since some month now and ive successfull let it work as the company where i work want.. now.. my next step is save SMS into a DB so ive recompiled Kannel with latest SVN (yesterday 06/12/11) with mysql option enabled (and ofc mysql-devel installed). Installation went just fine, configuration doent give any error but im unable to see sms stored in database. Ive made some search on google and i should have wrong understand what i read (my native language is not english, so, sorry for any error), ive read that mysql is used just as temp database where kannel put the sms and remove that line once he have reply to the database, is this correct? If yes, how should i do for let sms stored to the database? Also, what about if i dont want that kannel reply directly to the sms? (Now he reply with a get-url in sms-service and with a status 0 delivery accepted from source code (that i had edited for test). Here my needs so: 1 - Kannel receive the SMS and store it in a MySQL DB 2 - A custom PHP script (that will be programmed from some programmers here in office) will check every minute (with crontab) if there are new sms 3 - The PHP script will call smsbox for send multiple sms (like sms accepted, forward of the sms to tech support or/and whatever) 4 - Kannel store the sent sms into another table using sqlbox i suppose (still didnt study this yet) Anyone can help me out with this request? Here my config: cat kannel.conf include = /usr/local/kannel/core.conf include = /usr/local/kannel/smsc.conf include = /usr/local/kannel/smsbox.conf include = /usr/local/kannel/sms-user.conf include = /usr/local/kannel/sms-service.conf include = /usr/local/kannel/modems.conf include = /usr/local/kannel/mysql.conf cat core.conf group = core admin-port = 13000 smsbox-port = 13001 admin-password = foo #status-password = foo #admin-deny-ip = admin-allow-ip = log-file = /var/log/kannel/bearerbox.log log-level = 0 #box-deny-ip = *.*.*.* box-allow-ip = *.*.*.* dlr-storage = mysql #unified-prefix = +39,0039;+,00 access-log = /var/log/kannel/bearerbox-access.log #store-location = /usr/local/kannel/store.kannel #ssl-server-cert-file = cert.pem #ssl-server-key-file = key.pem #ssl-certkey-file = mycertandprivkeyfile.pem cat smsc.conf group = smsc smsc = at modemtype = auto device=/dev/ttyUSB1 my-number = 3806320353 connect-allow-ip = *.*.*.* log-level = 0 cat smsbox.conf group = smsbox bearerbox-host = 10.10.15.123 sendsms-port = 13013 global-sender = 3806320353 #sendsms-chars = 0123456789 +- log-file = /var/log/kannel/smsbox.log log-level = 0 access-log = /var/log/kannel/bearerbox-access.log cat sms-user.conf group = sendsms-user username = andrea password = password concatenation = true max-messages = 1000 #user-deny-ip = user-allow-ip = *.*.*.* cat sms-service.conf group = sms-service keyword = catch-all = yes get-url = http://10.10.15.123:13013/cgi-bin/sendsms?username=andreapassword=passwordfrom=RTHto=3388552885+%qtext=GAI+USER+%q+your+request+is+accepted+form+the+system+at+%t+and+will+be+sent+to+our+team.+Text:+%a; group = sms-service keyword = default text = No service specified cat mysql.conf group = mysql-connection id = dlr-db host = 10.10.11.7 username = sms password = vR174 database = sms max-connections = 10 group = dlr-db id = dlr-db table = dlr field-smsc = smsc field-timestamp = ts field-source = source field-destination = destination field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc I didnt pasted modem.conf cause i dont think is needed, modem is an Huawei E220 USB that is working great if anyone would like to use it. Can anyone point me to the right edits? Thanks in advance. Best regards -- Carlos Massoglia Lillo Gerencia de Innovacion y Desarrollo MindFree Ingenieria www.mindfree.cl
How to force dcs
Hi everybody I am having problems with sms encoding. My actual problematic smsc config is: group = smsc smsc = smpp smsc-id = gw1 host = X port = smsc-username = smsc-password = x system-type = www log-file = /var/log/kannel/gw1.log log-level = 0 address-range = connection-timeout = 60 transceiver-mode = 1 enquire-link-interval = 45 alt-charset = gsm preferred-smsc-id=gw1 denied-smsc-id = gw2 The problem is my sms gateway provider told me that only 140 chars can be used. I need tu use 160 chars, so I need to use GSM encoding and dcs = 1. I read about alt-charset and alt-dcs but when I use alt-charset = gsm the dcs always is 0 and my provider need to be set in 1. There are some way to force dcs to 1 for one smsc in particular? Thank you in advance -- Carlos Patricio Massoglia Lillo Gerente de Innovación y Desarrollo MindFree Ingeniería Limitada (56) 32 2713596 www.mindfree.cl
Re: How to force dcs
El mar, 30-11-2010 a las 01:43 +0200, Nikos Balkanas escribió: Hi, Try in your sendsms-url to specify also coding=0mclass=1 to see if it helps. Which is your gateway? Doesn't it support concatenation? BR, Nikos Hi Nikos, I did some test using coding=0mclass=1 but it seems not help. When I used that params I get in my logs data_coding: 4 = 0x0004 and for my provider that is a wrong value in that param. How can I change data_coding using opensmpp?. As I said in my previuos mail, I used alt-charset and alt-dcs without success because I always get data_coding: 0 = 0x There are some way to force data_coding to use with opensmppbox? Thank you -- Carlos Patricio Massoglia Lillo Gerente de Innovación y Desarrollo MindFree Ingeniería Limitada (56) 32 2713596 www.mindfree.cl