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 Probably you have a port-mismatch. Post your config and we'll help you out. From: users

Re: SQL Box

2013-02-21 Thread Arturo SAnchez
t; *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 can&

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,

Re: SQL Box

2013-02-21 Thread spameden
2013/2/21 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. You can do that via simple query: SELECT count(*) from sent_sms WHERE boxc_id='XXX' and momt='MT' where 'XXX' is the th

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 > Why not count them from the table (sent_sms)? I think it contains enough > information > > > Willy Mularto > sa

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 wrote: > Hi willy > > I see. But I meant is there a way to track how many SMS had sent a user using > opensmppbox ? > > I want

Re: SQL Box

2013-02-20 Thread Arturo SAnchez
Hi willy I see. But I meant is there a way to track how many SMS had sent a user using opensmppbox ? I want to track of the SMS sent by my smpplogins.txt using opensmppbox. Regards Arturo 2013/2/20 Willy Mularto > That's how SQLBox works :) > send_sms is the queue, when it has been proceed S

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 wrote: > Hello > >

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-11 Thread T.K.Thapa
some third party api/url to provide delivery information. Am i right? Please explain. Regards Tapan Thapa --- On Sat, 11/9/10, Rene Kluwen wrote: From: Rene Kluwen Subject: RE: SQL Box Question To: "'T.K.Thapa'" , "'KangMas Willy'" Cc: "'Kan

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-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 wrote: From: KangMas Willy Subject: Re: SQL Box Question To: "T.K.Thapa" Cc: "Kan

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 http://www.petitiononl

Re: SQL Box Question

2010-09-09 Thread Nikos Balkanas
y, September 10, 2010 6:21 AM Subject: 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. Regar

RE: SQL Box Question

2010-09-09 Thread T.K.Thapa
From: Rene Kluwen Subject: RE: SQL Box Question To: "'T.K.Thapa'" , "'Kannel list'" Date: Thursday, 9 September, 2010, 11:57 PM 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

Re: SQL Box Question

2010-09-09 Thread carla godinho
From: carla godinho To: listname-requ...@kannel.org Sent: Thu, 19 August, 2010 10:38:37 Subject: unsubscribe From: Rene Kluwen To: T.K.Thapa ; Kannel list Sent: Thu, 9 September, 2010 19:27:06 Subject: RE: SQL Box Question If you use the proper dlr mask, the

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, 09

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 from

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&#

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: Wedne

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
land 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

Re: SQL Box udhdata problem

2007-03-06 Thread Jay
Regards, Roland 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 help

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 multip

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

2006-04-27 Thread Alejandro Guerrieri
01:10 p.m. > To: users@kannel.org > Subject: Re: SQL BOX PATCH INSTALL ON KANNEL INSTALLED BY RPM ON FEDORA > > try running "locate bearerbox" or "locate sqlbox" to find the > binaries. If it's in the path you can also do "which bearerbox" > >

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

2006-04-26 Thread Luis Valencia
Before all 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: R

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/ Linke

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

2006-04-20 Thread Luis Valencia
ure --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 KAN

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, mysql-devel

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

2006-04-20 Thread issam
hello I have the same problem when I 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

2006-02-27 Thread Alejandro Guerrieri
ince I've even looked at the code though. So 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 R

RE: SQL BOX

2006-02-27 Thread Rene Kluwen
though. So 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

Re: SQL BOX

2006-02-27 Thread Chronis Nikos
; <[EMAIL PROTECTED]> To: "Chronis Nikos" <[EMAIL PROTECTED]> Cc: 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

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 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:1

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" **>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