Re: mysql DLR update

On Fri, Feb 14, 2014 at 11:32 AM, John alero wrote: > Hii, > > > Kindly use below parameters in SMSC.conf file. > > msg-id-type= 0x01 > > My bad, it worked. thanks. > > > On Fri, Feb 14, 2014 at 11:44 AM, [Digital^Dude] (R) < > millennium@gmail.com> wrote: > >> Hello, >> >> Here is the rele

Re: mysql DLR update

Hii, Kindly use below parameters in SMSC.conf file. msg-id-type= 0x01 On Fri, Feb 14, 2014 at 11:44 AM, [Digital^Dude] (R) wrote: > Hello, > > Here is the relevant log dump: > > DEBUG: SMPP[abcdef] handle_pdu, got DLR > DEBUG: SMPP[abcdef]: *Couldnot parse DLR string sscanf way,fallback to

Re: mysql DLR update

Hello, Here is the relevant log dump: DEBUG: SMPP[abcdef] handle_pdu, got DLR DEBUG: SMPP[abcdef]: *Couldnot parse DLR string sscanf way,fallback to old way. Please report!* DEBUG: DLR[mysql]: Looking for DLR smsc=abcdef, ts=0120338847, dst=msisdn, type=1 DEBUG: sql: SELECT `mask`, `service`, `ur

Re: mysql DLR update

Try to set all log-level=0 and watch it. I think it cant find the row. Sent from my Sony Xperia(tm) smartphone On 13 Feb 2014 21:01, "[Digital^Dude] (R)" wrote: > As for me, its not touching the rows inserted in the dlr table, no > deletes, no updates, for success or failure. > I agree dlr-url i

Re: mysql DLR update

As for me, its not touching the rows inserted in the dlr table, no deletes, no updates, for success or failure. I agree dlr-url is a better way, but its strange how/why a built-in feature is not working in kannel. I'm suspicious of any configuration error, and/or known bug in the r5053 version..

Re: mysql DLR update

AFAIK it deletes success DLR from the row. It is better for you to have a simple http script to handle DLR. Sent from my Sony Xperia(tm) smartphone On 13 Feb 2014 20:49, "[Digital^Dude] (R)" wrote: > Hi all, > > I just need to be clear here, when dlr-storage=mysql, and I specify a > valid dlr-ma

Re: mysql-dlr storage problem

Try this (quoting Alejandro Guerrieri): –>Yes, SqlBox can handle MO Traffic as well. To do that, you need to put SqlBox between –>smsbox and bearerbox, so all traffic intented for smsbox would pass thru SqlBox before. –>To achieve that, you need to configure smsbox to use the SqlBox port instead

Re: mysql-dlr storage problem

Hi, I found another thing. I am unable to receive parameters when i insert into mysql. But when i use the sendsms url i.e. http://localhost:13013/cgi-bin/sendsms?username=tester&password=foobar&to=919067184864&from=TESTSMS&text=message&dlr-mask=31&dlr-url=http://192.168.111.151:8085/Kannel_Test/

Re: mysql-dlr storage problem

Here are my configurations again. Kannel.conf === group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar dlr-storage = mysql box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" group = smsc smsc = fake smsc-id = FAKE port = 2 connect-allow-ip = 127.0.0.1 group =

Re: mysql-dlr storage problem

Ya i compiled it from latest source only but still facing this problem. On 13 June 2013 14:21, spameden wrote: > I was wrong, you need to urlencode each parameter passed, i.e: > > 'http://192.168.111.151:8085/Kannel_Test/Receive_dlr?

Re: mysql-dlr storage problem

I was wrong, you need to urlencode each parameter passed, i.e: 'http://192.168.111.151:8085/Kannel_Test/Receive_dlr? message=%25a×tamp=%25

Re: mysql-dlr storage problem

Try building kannel from latest SVN and sqlbox. 2013/6/13 testn4n1 > Kannel 1.5.0 > sqlbo 0.7.2 > > > On 13 June 2013 12:39, spameden wrote: > >> What kannel version you're using btw? >> >> >> 2013/6/13 spameden >> >>> try urlencoding whole parameter string, i.e.: >>> >>> insert this value as

Re: mysql-dlr storage problem

No, this is also not working. Same result as before. On 13 June 2013 12:37, spameden wrote: > try urlencoding whole parameter string, i.e.: > > insert this value as dlr_url: > > 'http://192.168.111.151:8085/Kannel_Test/Receive_dlr?

Re: mysql-dlr storage problem

Kannel 1.5.0 sqlbo 0.7.2 On 13 June 2013 12:39, spameden wrote: > What kannel version you're using btw? > > > 2013/6/13 spameden > >> try urlencoding whole parameter string, i.e.: >> >> insert this value as dlr_url: >> >> 'http://192.168.111.151:8085/Kannel_Test/Receive_dlr?

Re: mysql-dlr storage problem

What kannel version you're using btw? 2013/6/13 spameden > try urlencoding whole parameter string, i.e.: > > insert this value as dlr_url: > > 'http://192.168.111.151:8085/Kannel_Test/Receive_dlr?

Re: mysql-dlr storage problem

try urlencoding whole parameter string, i.e.: insert this value as dlr_url: 'http://192.168.111.151:8085/Kannel_Test/Receive_dlr? message

Re: mysql-dlr storage problem

Hi, Did you find any solution to my problem? Regards, James On 12 June 2013 09:45, testn4n1 wrote: > Yes, that problem is solved. But now i am having another problem. > > > When i insert into the database using the following query, the dlr_url is > called instantly and it is called as-it-is. i

Re: mysql-dlr storage problem

Yes, that problem is solved. But now i am having another problem. When i insert into the database using the following query, the dlr_url is called instantly and it is called as-it-is. i.e. the %i, %p etc. values are not replced with actual values. After the actual delivery report arrives, the same

Re: mysql-dlr storage problem

Quoting Rene on this one: On Wed, Aug 1, 2012 at 3:05 PM, Rene Kluwen http://www.kannel.org/mailman/listinfo/users>> wrote: The error is self-explanatory. You should just dlrencode your parameters in the dlr-url. Not the url itself. So insert:http://10.0.0.1/sms/dlrNEW.php?dlr=%25d%26to%3D%25

Re: mysql-dlr storage problem

Hi, I am facing some problems. When i insert into the database using the following query, the dlr_url is called instantly and it is called as-it-is. i.e. the %i, %p etc. values are not replced with actual values. After the actual delivery report arrives, the same url is called again without actual

Re: mysql-dlr storage problem

I am getting this error: 2013-06-11 12:27:07 [4669] [7] WARNING: DLR[mysql]: DLR from SMSC for DST<919067184864> not found. 2013-06-11 12:27:07 [4669] [7] ERROR: SMPP[smpp]: got DLR but could not find message or was not interested in it id<40007077826> dst<919067184864>, type<1> I read on a b

Re: mysql-dlr storage problem

Hi James It is only the query parameter values part that should be encoded: http://192.168.111.151:8085/Kannel_Test/Recieve_dlr?message=%25a×tamp=%25tetc Jacob Eiler Apide ApS e: jacob.ei...@apide.com t: +45 2374 0486 w: apide.com Den 11/06/2013 kl. 08.26 skrev testn4n1 : Hi, Hi tried the fo

Re: mysql-dlr storage problem

Hi, Hi tried the following insert query with the encoded url: INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url, boxc_id) VALUES ('MT', '1234', '919067184864', 'Abbe russsh', 2, 31, 'http%3A%2F%2F192.168.111.151%3A8085%2FKannel_Test%2FReceive_dlr%3Fmessage%3D%

Re: mysql-dlr storage problem

check page 91 of the guide (Table 6-9. Parameters (Escape Codes)) 2013/6/10 testn4n1 > Hi, > > I read the user-guide. It says about url encoding in the MO Messages > section. but it does not specify what are the key and values for the > parameters. i.e. which are the common parameters we need t

Re: mysql-dlr storage problem

Hi, I read the user-guide. It says about url encoding in the MO Messages section. but it does not specify what are the key and values for the parameters. i.e. which are the common parameters we need to pass in the dlr-url. Only an example is given like this: http://localhost/myscript?...&meta-dat

Re: mysql-dlr storage problem

Thanks, but this is not my question. You forgot to copy users, so doing it. Also thanks for the trigger tip, I completely forgot about it. See below testn4n1. 2013/6/10 Ali Kashif > default SQLBox stores the DLR in sent_sms, > you have these options > > 1) Modify sqlbox source [proper but d

Re: mysql-dlr storage problem

Yes, you need to: 1) URLENCODE URL before inserting into database 2) pass parameters into URL, i.e. example: http%3A%2F%2F192.168.111.151%3A8085%2FKannel_Test%2FReceive_dlr%3Fsmsc-id%3D%25i%22%22 Once again, read user-guide. 2013/6/10 testn4n1 > ok...the url i provided gets called the second

Re: mysql-dlr storage problem

ok...the url i provided gets called the second i insert data into the send_sms table but no parameters are passed. i printed all the request parameters but got nothing. On 10 June 2013 17:58, spameden wrote: > To achieve this you need to put smsbox in between of the sqlbox and > bearerbox or enf

Re: mysql-dlr storage problem

To achieve this you need to put smsbox in between of the sqlbox and bearerbox or enforce smsbox id into boxc_id field, i.e.: INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url, boxc_id) VALUES ('MT', '1234', '919067184864', 'Abbe russsh', 2, 31, 'http://192.168.

Re: mysql-dlr storage problem

i am trying to send sms by inserting data into send_sms table and want to process dlrs with script using dlr_url. So, i have changed the configuration to the following but i cannot receive anything in my application: group = sendsms-user username = tester password = foobar forced-smsc = smpp-nexmo

Re: mysql-dlr storage problem

2013/6/10 testn4n1 > ok...but then why are there entries in my sent_sms table like the > following: > > 12 | DLR | 1234 | 919067184864 | NULL| > id%3A288230376265477711+sub%3A001+dlvrd%3A001+submit+date%3A1306061034+done+date%3A1306060504+stat%3ADELIVRD+err%3A000+text%3Anone+++

Re: mysql-dlr storage problem

i want dlrs but not in the sent_sms table On 10 June 2013 17:04, spameden wrote: > If you don't want to receive DLR's you can use different dlr_mask. > > Read User-Guide about it. > > > 2013/6/10 testn4n1 > >> also, i have two dlr entries for every sms sent. the following are these: >> >> |

Re: mysql-dlr storage problem

If you don't want to receive DLR's you can use different dlr_mask. Read User-Guide about it. 2013/6/10 testn4n1 > also, i have two dlr entries for every sms sent. the following are these: > > | 11 | DLR | 1234 | 919067184864 | NULL| ACK%2F | 1370495085 | > smpp-nexmo | NULL| NUL

Re: mysql-dlr storage problem

also, i have two dlr entries for every sms sent. the following are these: | 11 | DLR | 1234 | 919067184864 | NULL| ACK%2F | 1370495085 | smpp-nexmo | NULL| NULL | NULL |3 | NULL | NULL | NULL | NULL | NULL | NULL |8 | NULL| NULL |NULL | NU

Re: mysql-dlr storage problem

ok...but then why are there entries in my sent_sms table like the following: 12 | DLR | 1234 | 919067184864 | NULL| id%3A288230376265477711+sub%3A001+dlvrd%3A001+submit+date%3A1306061034+done+date%3A1306060504+stat%3ADELIVRD+err%3A000+text%3Anone | 1370495099 | smpp-nexmo |

Re: mysql-dlr storage problem

dlr table only used to track which messages are awaiting reports you need to modify sqlbox source if you need to store DLR entries separately 2013/6/10 testn4n1 > Hi, > > I am able to send sms using sqlbox and able to receive dlr reports also. > But, these reports do not go in the table that i

Re: Mysql DLR an opensmppbox

Ignore that question ;) of course i need it. Slavoj. Dňa 1. 2. 2011 10:55, XEN-Housing s.r.o. wrote / napísal(a): Hello there, i have solo config for kannel and opensmppbox (two separate files). when i want to use myslq dlr storage, need i to put config part about dlr-db part to both of them

Re: MySQL DLR not working

Bryan Gintz schrieb: Hello, I recompiled Kannel with --with-mysql and have the following in my conf file: group = core . dlr-storage = mysql and group = mysql-connection id = mydlr host = localhost username = devec_kannel password = dvkannel database = devec_kannel m

Re: MySQL DLR not working

There was a post here some days ago by Tharaga. Check http://www.nabble.com/Small-DLR-notification-tutorial---mysql-%2B-php-%2B-kannel---Version-2-td17820493.html Best regards James Bryan Gintz wrote: Hello, I recompiled Kannel with --with-mysql and have the following in my conf file: group

Re: Mysql DLR help needed...

"MYSQL: Access denied for user '[EMAIL PROTECTED]' (using password: YES)" That's a mysql error saying that the user you've configured it's not allowed to login. Check if you can login to mysql from localhost: mysql -ufoo -pmy_pass my_database If you get the same error, check the GRANT privileg

Re: Mysql DLR help needed...

Did you define mysql-connection correctly on kannel.conf? What's your kannel.conf? On 2/1/07, Tushar <[EMAIL PROTECTED]> wrote: Hi All, I m using kannel since last 1 month. I try to connect to mysql thru kannel for storing the DLRs but I got the following error…:- 2007-02-01

Re: mysql dlr storage

you might try uncommenting your username and password in the mysql group cheers ian On Fri, 27 Oct 2006, Eric Magutu wrote: Hi, I am running kannel on Ubuntu. I am trying to store DLR information into a MySQL database. I get the following error when checking the status: While trying to retri

RE: MYSQL dlr

Hi, I already setup kannel with mysql successfully...but I noticed that I can't reply any messages...and my data in my dlr is empty...what seems to be the problem? 2004-03-10 11:14:38 [0] INFO: Added logfile `/var/log/newng/globe.log' with level `0'. 2004-03-10 11:14:38 [0] INFO: Started ac

RE: mysql dlr

s [mailto:[EMAIL PROTECTED] >Sent: Wednesday, March 03, 2004 4:31 AM >To: Navjot Singh >Subject: Re: mysql dlr > > >I browsed over dlr_mysql.c and I found out that it is already included... > >Tnx >- Original Message - >From: "Navjot Singh" <[EMAIL PROTECTE

Re: mysql dlr

>Hi, > > How can I resolve this? I already enable mysql when I compiled kannel I had a similar problem. You just have to set up the config file properly: group = mysql-connection id = mydlr host = x.x.x.x mysql-username = somename mysql-password = somepass database = dlr max-connections = 1 gro

RE: mysql dlr

EASY. That's surely because you are using a kannel version that doesnot support field-url. Peep into gw/dlr_mysql.c to see what all fields are supported in your version. HTH Navjot Singh >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Tuesday, March 02, 2004

Re: Mysql DLR support !!!

You also need to set dlrmask to get the type of report you want. Then you will be notified of the dlr that you wish to receive. I think it is in Chapter 9 of the user guide. Ponnambalam balamurugan wrote: Hi all, I have compiled kannel with mysql support for dlr storage.But i have not get stored

Re: Mysql DLR error

, March 22, 2003 2:48 PM Subject: Re: Mysql DLR error Hi Ariee, Please compile kannel by adding the following parameters also to your command and try: --with-mysql=/usr --with-dlr=mysql Regards. Shanavaz.

Re: Mysql DLR error

D] Sent: Saturday, March 22, 2003 2:48 PM Subject: Re: Mysql DLR error Hi Ariee, Please compile kannel by adding the following parameters also to your command and try: --with-mysql=/usr --with-dlr=mysql   Regards. Shanavaz.  

Re: Mysql DLR error

Hi Ariee, Please compile kannel by adding the following parameters also to your command and try: --with-mysql=/usr --with-dlr=mysql   Regards. Shanavaz.   - Original Message - From: Ariee To: [EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 7:51 AM Subject: Mysql