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
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
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
:* 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
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
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
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
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
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
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
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
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
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,
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
...@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
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
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
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:
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
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 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
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
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
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
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:
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 -
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,
--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
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
]
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
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
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
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
**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
34 matches
Mail list logo