RE: SQL Box

2013-02-23 Thread Rene Kluwen
Subject: Re: SQL Box Hello guys Was a port-mismatch just like Rene suggested. Thank you! =) By the way, where can I buy the SMPPBox commercial module? Regards Arturo 2013/2/21 Rene Kluwen rene.klu...@chimit.nl Probably you have a port-mismatch. Post your config and we'll help you out

Re: SQL Box

2013-02-21 Thread spameden
2013/2/21 Arturo SAnchez artusa...@gmail.com: Willy, Yes, but I can't catch all the sms sent from my opensmppbox is what I need. To catch all the sms sent from a smpp login for example. You can do that via simple query: SELECT count(*) from sent_sms WHERE boxc_id='XXX' and momt='MT' where

RE: SQL Box

2013-02-21 Thread Rene Kluwen
Probably you have a port-mismatch. Post your config and we'll help you out. From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Arturo SAnchez Sent: donderdag 21 februari 2013 4:19 To: Willy Mularto Cc: users@kannel.org Subject: Re: SQL Box Willy, Yes, but I

Re: SQL Box

2013-02-21 Thread Arturo SAnchez
:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On Behalf Of *Arturo SAnchez *Sent:* donderdag 21 februari 2013 4:19 *To:* Willy Mularto *Cc:* users@kannel.org *Subject:* Re: SQL Box ** ** Willy, Yes, but I can't catch all the sms sent from my opensmppbox is what I

Re: SQL Box

2013-02-20 Thread Willy Mularto
That's how SQLBox works :) send_sms is the queue, when it has been proceed SQLBox move it to sent_sms. Set your all log-level=0 and tail them. Go insert 1 record to send_sms and watch the log. Willy Mularto sangpr...@gmail.com On Feb 21, 2013, at 9:18 AM, Arturo SAnchez artusa...@gmail.com

Re: SQL Box

2013-02-20 Thread Willy Mularto
Why not count them from the table (sent_sms)? I think it contains enough information Willy Mularto sangpr...@gmail.com On Feb 21, 2013, at 9:51 AM, Arturo SAnchez artusa...@gmail.com wrote: Hi willy I see. But I meant is there a way to track how many SMS had sent a user using

Re: SQL Box

2013-02-20 Thread Arturo SAnchez
Willy, Yes, but I can't catch all the sms sent from my opensmppbox is what I need. To catch all the sms sent from a smpp login for example. Regards Arturo 2013/2/20 Willy Mularto sangpr...@gmail.com Why not count them from the table (sent_sms)? I think it contains enough information

RE: SQL Box Question

2010-09-11 Thread Rene Kluwen
Why, if you can use the dlr-url field for this? Dlr-url has the same value for MT and for DLR. == Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of T.K.Thapa Sent: Saturday, 11 September, 2010 07:12 To: KangMas Willy Cc: Kannel list Subject: Re: SQL Box

RE: SQL Box Question

2010-09-11 Thread T.K.Thapa
this parameter then kannel invokes some third party api/url to provide delivery information. Am i right? Please explain. Regards Tapan Thapa --- On Sat, 11/9/10, Rene Kluwen rene.klu...@chimit.nl wrote: From: Rene Kluwen rene.klu...@chimit.nl Subject: RE: SQL Box Question To: 'T.K.Thapa

Re: SQL Box Question

2010-09-11 Thread T.K.Thapa
Thanks for the explation Rene. That is why I asked the patch developed by sangprabv (sangpr...@gmail.com http://www.petitiononline.com/froyo/). Sangprabv: can you please share the code with us. I think this patch will help other too. Regards Tapan Thapa

Re: SQL Box Question

2010-09-10 Thread KangMas Willy
For my case I did some patches on smsbox, mysql dlr and sqlbox to store internal message-id and use it to map between MO, MT, and DLR if no foreign-id. And I developed a simple consolidator script and store the result it consolidated table sangprabv sangpr...@gmail.com

Re: SQL Box Question

2010-09-10 Thread T.K.Thapa
Can you share newly developed smsbox/sqlbox binary with source code? I will try to compile for my o.s. from your provided source code. Regards Tapan Thapa --- On Sat, 11/9/10, KangMas Willy sangpr...@gmail.com wrote: From: KangMas Willy sangpr...@gmail.com Subject: Re: SQL Box Question

RE: SQL Box Question

2010-09-09 Thread Rene Kluwen
If you use the proper dlr mask, then you can map the sent messages by means of dlr_url. This may be a http url but alternatively, it can be any id if you don’t mean smsbox. == Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of T.K.Thapa Sent: Thursday,

Re: SQL Box Question

2010-09-09 Thread carla godinho
19:27:06 Subject: RE: SQL Box Question If you use the proper dlr mask, then you can map the sent messages by means of dlr_url. This may be a http url but alternatively, it can be any id if you don’t mean smsbox.   == Rene   From:users-boun...@kannel.org [mailto:users-boun...@kannel.org

RE: SQL Box Question

2010-09-09 Thread T.K.Thapa
...@chimit.nl wrote: From: Rene Kluwen rene.klu...@chimit.nl Subject: RE: SQL Box Question To: 'T.K.Thapa' tapan_thapa2...@yahoo.com, 'Kannel list' users@kannel.org Date: Thursday, 9 September, 2010, 11:57 PM If you use the proper dlr mask, then you can map the sent messages by means

Re: SQL Box Question

2010-09-09 Thread Nikos Balkanas
: RE: SQL Box Question Hello, I don't understand completely. While submitting sms to smsbox i am using dlr-mask=7 and i am not using dlr-url. Do you mean that i should change dlr-mask=7 to dlr-mask=31 and put any id in dlr-url? Please explain. Regards Tapan Thapa --- On Thu, 9/9/10, Rene

RE: SQL Box and DLR Best Practice

2009-07-04 Thread Bharat Vasant
Dear Group: I am wondering whether group members didn't understood my query or are occupied..?! J In the mean time, I have decided to try ID field of send_sms and sent_sms table since I am injecting message by INSERT, and have tried removing commented code in SqlBox_mysql.c to move ID

Re: SQL BOX

2009-04-29 Thread Nikos Balkanas
SQL BOXCheck bearerbox-access.log. By configuring dlr-mask, you can get confirmation from the SMSc is the SMS was accepted succefully or delivered succesfully to the client. Read the manual. BR, Nikos - Original Message - From: waza...@inbox.lv To: users@kannel.org Sent:

Re: SQL BOX

2009-04-29 Thread waza123
Title: Re: SQL BOX Ok, found the solution, its very easy.. just put inside query dlr_mask value 31 example: INSERT INTO `send_sms` (`momt`, `sender`, `receiver`, `msgdata`, `sms_type`, `dlr_mask`) VALUES ('MT', '1234', '987654321', 'test sms dlr mask', 2, 31); 31 is = 1+2+4+8+16 About

RE: SQL BOX: sqlbox.c Connection closed by the box (null)

2007-09-20 Thread Cezary Siwek
hello, if you use smsbox-port = 13011 in [core] group then you shoud use the same port as bearerbox-port = 13011 in sqlbox.conf Also smsbox-port in sqlbox.conf should be the same as bearerbox-port in [smsbox] group smsbox---sqlbox:13012---bearerbox:13011 Regards, C.

Re: SQL Box udhdata problem

2007-03-06 Thread Jay
Re: SQL Box udhdata problemAlejandro Guerrieri Mon, 05 Mar 2007 13:14:09 -0800 You need to send the binary data urlencoded. In other words, put a % before each pair of characters on the UDH i.e: %05%00%03%18 and so on... Hope it helps, Alejandro. On 3/5

Re: SQL Box udhdata problem

2007-03-06 Thread Jay
Jay -- Re: SQL Box udhdata problemJay Tue, 06 Mar 2007 22:13:47 -0800 Hi Alejandro, Thanks for your reply, I tried your suggestion but using UDH %05%00%03%19%02%01

Re: SQL Box udhdata problem

2007-03-05 Thread Alejandro Guerrieri
You need to send the binary data urlencoded. In other words, put a % before each pair of characters on the UDH i.e: %05%00%03%18 and so on... Hope it helps, Alejandro. On 3/5/07, Jay [EMAIL PROTECTED] wrote: Hi Guys, SQL Box is working fine until I tried sending SMS with udhdata for

Re: SQL BOX PATCH INSTALL ON KANNEL INSTALLED BY RPM ON FEDORA

2006-04-27 Thread Alejandro Guerrieri
that do updatedb to be sure the locate command will find the binaries Luis Valencia -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alejandro Guerrieri Sent: Miércoles, 26 de Abril de 2006 01:10 p.m. To: users@kannel.org Subject: Re: SQL BOX PATCH

Re: SQL BOX PATCH INSTALL ON KANNEL INSTALLED BY RPM ON FEDORA

2006-04-26 Thread Alejandro Guerrieri
try running locate bearerbox or locate sqlbox to find the binaries. If it's in the path you can also do which bearerbox Those commands will give you the location for thos files, if that's what you want to know. Hope it helps, -- Alejandro Guerrieri Magicom http://www.magicom-bcn.net/ LinkedIn:

Re: SQL BOX PATCH INSTALL ON KANNEL INSTALLED BY RPM ON FEDORA

2006-04-20 Thread issam
hello Ihave the same problem whenI installed kannel from rpm package on linux fedora core3. I never find the installed files on the server. how can I do to normally install kannel and find his files on the server. thank you and have a nice day. kechaou issam - Original Message -

Re: SQL BOX PATCH INSTALL ON KANNEL INSTALLED BY RPM ON FEDORA

2006-04-20 Thread Theo Vassiliadis
What about installing kannel from source? It 's a very easy process, which is documented pretty well in the user guide and you will be able to control everything. Just a hint on fedora users: if you wish mysql support, be sure you have installed all mysql related packages needed (mysql,

RE: SQL BOX PATCH INSTALL ON KANNEL INSTALLED BY RPM ON FEDORA

2006-04-20 Thread Luis Valencia
--your-options; make Hopes this help you, for me works fine. Luis Valencia From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of issam Sent: Jueves, 20 de Abril de 2006 05:26 a.m. To: Konstantinos Liadakis; users@kannel.org Subject: Re: SQL BOX PATCH INSTALL ON KANNEL

Re: SQL BOX

2006-02-27 Thread Alejandro Ramírez
Nikos, I dont beleive that is the case... im using SQLbox with a throughput much much higher than that successfully! Good luck Alejandro Ramirez Chronis Nikos wrote: Hello, I just understand that the SQLbox can only delivery 1 message per second! I am correct? Regards, Nikos

Re: SQL BOX

2006-02-27 Thread Chronis Nikos
] To: Chronis Nikos [EMAIL PROTECTED] Cc: users@kannel.org Sent: Monday, February 27, 2006 7:04 PM Subject: Re: SQL BOX Nikos, I dont beleive that is the case... im using SQLbox with a throughput much much higher than that successfully! Good luck Alejandro Ramirez Chronis Nikos wrote: Hello, I just

RE: SQL BOX

2006-02-27 Thread Rene Kluwen
correct me if I am wrong. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chronis Nikos Sent: maandag 27 februari 2006 20:35 To: Alejandro Ramírez Cc: users@kannel.org Subject: Re: SQL BOX Dear Alejandro, Log file of my mysql.log

Re: SQL BOX

2006-02-27 Thread Alejandro Guerrieri
wrong. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chronis Nikos Sent: maandag 27 februari 2006 20:35 To: Alejandro Ramírez Cc: users@kannel.org Subject: Re: SQL BOX Dear Alejandro, Log file of my mysql.log 060227 20:40

Re: SQL Box Table docs

2005-02-07 Thread Alejandro Guerrieri
Davy, That covers about everything I may need. I'll give it a try, looks like that's what the parameters are meant for. Many thanks for your prompt and thoroughful response. Best regards, On Mon, 7 Feb 2005 13:23:15 +0800, Davy Chan [EMAIL PROTECTED] wrote: **Date: Mon, 7 Feb 2005 04:12:12

Re: SQL Box Table docs

2005-02-06 Thread Davy Chan
**Date: Mon, 7 Feb 2005 04:12:12 +0100 **From: Alejandro Guerrieri [EMAIL PROTECTED] **To: users@kannel.org users@kannel.org **Subject: SQL Box Table docs **Reply-To: Alejandro Guerrieri [EMAIL PROTECTED] ** **Hi all, ** **I'm starting to try out SQLBOX on Kannel. I've already applied the **latest