Re: SQL BOX

[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: Wednesday, April 29, 2009 2:43 PM
  Subject: SQL BOX


  i'm using




  Kannel + SQLBox addon




  When i Send SMS:




  INSERT INTO send_sms 

  (momt, sender, receiver, msgdata, sms_type)

  VALUES ('MT', '1234', '987654321', 'Hello world', 2);







  How can i know: Is SMS delivered to client or it's not ?




  i would like to create system, if SMS not delivered/failed to deliver, Retry 
after 1min, then after 5min, then after 30min etc.




  Or this system is implemented inside Kannel ?

Re: SQL BOX

[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 numbers:

1: delivery success
2: delivery failure
4: message buffered
8: smsc submit
16: smsc reject


I tested it, when i sent sms, after some seconds i got new row in database table,

msgdata: id:271746061 stat:DELIVRD

dlr_mask: 1 (this mean success delivered)

Then another test i made:

removed SIM card from phone, and again sent sms.. So.. no delivery report was made.. then after 5min i put back SIM inside mobile, and i got my SMS, and after some secs a new row in database table, status: delivered.


Thanks for Kannel and sqlbox !


Wednesday, April 29, 2009, 2:59:33 PM, you wrote:






Check 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: Wednesday, April 29, 2009 2:43 PM
Subject: SQL BOX

i'm using

Kannel + SQLBox addon

When i Send SMS:

INSERT INTO send_sms 
(momt, sender, receiver, msgdata, sms_type)
VALUES ('MT', '1234', '987654321', 'Hello world', 2);


How can i know: Is SMS delivered to client or it's not ?

i would like to create system, if SMS not delivered/failed to deliver, Retry after 1min, then after 5min, then after 30min etc.

Or this system is implemented inside Kannel ?








-- 
Best regards,
 Waza123                            mailto:waza...@inbox.lv

Re: SQL Box

[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
> 
> I have just installed the kannel 1.5 with bearerbox, smsbox and opensmppbox
> 
> I would like to setup correctly the sqlbox in order to have the details of 
> all the SMS sent from an smpp account.
> 
> I set the port correctly with the bearerbox but I cannot the inserts in the 
> sent_sms table, when I insert on send_sms it is sent and added to sent_sms
> 
> Could you please help me on setting up the sqlbox ? I want to know which user 
> has sent how many messages by smpp account using opensmppbox.
> 
> Thanks
> Arturo

Re: SQL Box

[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 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
> >
> > I have just installed the kannel 1.5 with bearerbox, smsbox and
> opensmppbox
> >
> > I would like to setup correctly the sqlbox in order to have the details
> of all the SMS sent from an smpp account.
> >
> > I set the port correctly with the bearerbox but I cannot the inserts in
> the sent_sms table, when I insert on send_sms it is sent and added to
> sent_sms
> >
> > Could you please help me on setting up the sqlbox ? I want to know which
> user has sent how many messages by smpp account using opensmppbox.
> >
> > Thanks
> > Arturo
>
>

Re: SQL Box

[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 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 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
> >
> > I have just installed the kannel 1.5 with bearerbox, smsbox and opensmppbox
> >
> > I would like to setup correctly the sqlbox in order to have the details of 
> > all the SMS sent from an smpp account.
> >
> > I set the port correctly with the bearerbox but I cannot the inserts in the 
> > sent_sms table, when I insert on send_sms it is sent and added to sent_sms
> >
> > Could you please help me on setting up the sqlbox ? I want to know which 
> > user has sent how many messages by smpp account using opensmppbox.
> >
> > Thanks
> > Arturo
> 
> 

Re: SQL Box

[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
> 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 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 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
>> >
>> > I have just installed the kannel 1.5 with bearerbox, smsbox and
>> opensmppbox
>> >
>> > I would like to setup correctly the sqlbox in order to have the details
>> of all the SMS sent from an smpp account.
>> >
>> > I set the port correctly with the bearerbox but I cannot the inserts in
>> the sent_sms table, when I insert on send_sms it is sent and added to
>> sent_sms
>> >
>> > Could you please help me on setting up the sqlbox ? I want to know
>> which user has sent how many messages by smpp account using opensmppbox.
>> >
>> > Thanks
>> > Arturo
>>
>>
>
>

Re: SQL Box

[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 third argument in smpplogins.txt file, i.e.:
#login #password #boxc_id #IP
login password XXX 127.0.0.1

if you omit IP address connections will be allowed from anywhere


>
> Regards
> Arturo
>
>
> 2013/2/20 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 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 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
>>> >
>>> > I have just installed the kannel 1.5 with bearerbox, smsbox and
>>> > opensmppbox
>>> >
>>> > I would like to setup correctly the sqlbox in order to have the details
>>> > of all the SMS sent from an smpp account.
>>> >
>>> > I set the port correctly with the bearerbox but I cannot the inserts in
>>> > the sent_sms table, when I insert on send_sms it is sent and added to
>>> > sent_sms
>>> >
>>> > Could you please help me on setting up the sqlbox ? I want to know
>>> > which user has sent how many messages by smpp account using opensmppbox.
>>> >
>>> > Thanks
>>> > Arturo
>>>
>>
>>
>

RE: SQL Box

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

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 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 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
>
> I have just installed the kannel 1.5 with bearerbox, smsbox and
opensmppbox
>
> I would like to setup correctly the sqlbox in order to have the details of
all the SMS sent from an smpp account.
>
> I set the port correctly with the bearerbox but I cannot the inserts in
the sent_sms table, when I insert on send_sms it is sent and added to
sent_sms
>
> Could you please help me on setting up the sqlbox ? I want to know which
user has sent how many messages by smpp account using opensmppbox.
>
> Thanks
> Arturo

 

 

 

Re: SQL Box

[Arturo SAnchez]

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-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 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
>
> 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 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 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
> >
> > I have just installed the kannel 1.5 with bearerbox, smsbox and
> opensmppbox
> >
> > I would like to setup correctly the sqlbox in order to have the details
> of all the SMS sent from an smpp account.
> >
> > I set the port correctly with the bearerbox but I cannot the inserts in
> the sent_sms table, when I insert on send_sms it is sent and added to
> sent_sms
> >
> > Could you please help me on setting up the sqlbox ? I want to know which
> user has sent how many messages by smpp account using opensmppbox.
> >
> > Thanks
> > Arturo
>
> ** **
>
> ** **
>
> ** **
>

RE: SQL Box

[Rene Kluwen]

Contact Stipe Tolj: s...@tolj.org for the commercial smppbox module.

Note that is completely different software from the opensmppbox addon.

 

== Rene

 

From: Arturo SAnchez [mailto:artusa...@gmail.com] 
Sent: donderdag 21 februari 2013 20:19
To: Rene Kluwen
Cc: Willy Mularto; users@kannel.org
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-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 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

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 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 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
>
> I have just installed the kannel 1.5 with bearerbox, smsbox and
opensmppbox
>
> I would like to setup correctly the sqlbox in order to have the details of
all the SMS sent from an smpp account.
>
> I set the port correctly with the bearerbox but I cannot the inserts in
the sent_sms table, when I insert on send_sms it is sent and added to
sent_sms
>
> Could you please help me on setting up the sqlbox ? I want to know which
user has sent how many messages by smpp account using opensmppbox.
>
> Thanks
> Arturo

 

 

 

 

Re: SQL BOX

[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

[Chronis Nikos]

Dear Alejandro,

Log file of my mysql.log
060227 20:40:16   67966 Query   SELECT sql_id, momt, sender, receiver, 
udhdata, msgdata, time, smsc_id, service, account, id, sms_type, mclass, 
mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, 
rpi, charset, boxc_id, binfo FROM queue LIMIT 0,1
060227 20:40:17   67966 Query   SELECT sql_id, momt, sender, receiver, 
udhdata, msgdata, time, smsc_id, service, account, id, sms_type, mclass, 
mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, 
rpi, charset, boxc_id, binfo FROM queue LIMIT 0,1


You can see, every second a check is done "BUT" with a Limit of 1 (one)!
That's for why I told is this only 1 SMS/sec

This is not I do not trust you, but I trust better my log =)
Any other feedback ?

Regards,
Nikos

- Original Message - 
From: "Alejandro Ramírez" <[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 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

[Rene Kluwen]

Maybe I can shed some light on this.
SQLBox checks every second on items in the queue table.
If there are no items, it sleeps for another second.
If there ARE items, no sleeping is done and SQLBox continues with the next
message.

It's been a long time since 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 Ramírez
Cc: users@kannel.org
Subject: Re: SQL BOX


Dear Alejandro,

Log file of my mysql.log
060227 20:40:16   67966 Query   SELECT sql_id, momt, sender, receiver,
udhdata, msgdata, time, smsc_id, service, account, id, sms_type, mclass,
mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs,
rpi, charset, boxc_id, binfo FROM queue LIMIT 0,1
060227 20:40:17   67966 Query   SELECT sql_id, momt, sender, receiver,
udhdata, msgdata, time, smsc_id, service, account, id, sms_type, mclass,
mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs,
rpi, charset, boxc_id, binfo FROM queue LIMIT 0,1

You can see, every second a check is done "BUT" with a Limit of 1 (one)!
That's for why I told is this only 1 SMS/sec

This is not I do not trust you, but I trust better my log =)
Any other feedback ?

Regards,
Nikos

- Original Message -
From: "Alejandro Ramírez" <[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 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

[Alejandro Guerrieri]

I'm pushing tenths of messages per second with SQLBOX, and I think
that's because I've throttled the smpp connections...

Surely SQLBOX can do far more than a message per second. That's for sure.

Hope it helps,

Alejandro

On 2/27/06, Rene Kluwen <[EMAIL PROTECTED]> wrote:
> Maybe I can shed some light on this.
> SQLBox checks every second on items in the queue table.
> If there are no items, it sleeps for another second.
> If there ARE items, no sleeping is done and SQLBox continues with the next
> message.
>
> It's been a long time since 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 Ramírez
> Cc: users@kannel.org
> Subject: Re: SQL BOX
>
>
> Dear Alejandro,
>
> Log file of my mysql.log
> 060227 20:40:16   67966 Query   SELECT sql_id, momt, sender, receiver,
> udhdata, msgdata, time, smsc_id, service, account, id, sms_type, mclass,
> mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs,
> rpi, charset, boxc_id, binfo FROM queue LIMIT 0,1
> 060227 20:40:17   67966 Query   SELECT sql_id, momt, sender, receiver,
> udhdata, msgdata, time, smsc_id, service, account, id, sms_type, mclass,
> mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs,
> rpi, charset, boxc_id, binfo FROM queue LIMIT 0,1
>
> You can see, every second a check is done "BUT" with a Limit of 1 (one)!
> That's for why I told is this only 1 SMS/sec
>
> This is not I do not trust you, but I trust better my log =)
> Any other feedback ?
>
> Regards,
> Nikos
>
> ----- Original Message -
> From: "Alejandro Ramírez" <[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 Ramirez
> >
> > Chronis Nikos wrote:
> >
> >> Hello,
> >>  I just understand that the SQLbox can only delivery 1 message per
> >> second!
> >> I am correct?
> >>  Regards,
> >> Nikos
> >
> >
> >
> >
> >
>
>
>
>
>
>


--
Alejandro Guerrieri
Magicom
http://www.magicom-bcn.net/

RE: SQL Box Question

[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 September, 2010 19:34
To: Kannel list
Subject: SQL Box Question

 


Hello,

I was just checking sqlbox with bearerbox and smsbox to log all sent messages. 
I have seen that in sent_sms table there is no relation (Like message id 
mapping) between MT and DLR. Is it normal behaviour? If yes then can you please 
suggest how will i map sent messages to DLR?

Regards
Tapan Thapa

 

Re: SQL Box Question

[carla godinho]

Dear all,
I know this is not the right address to unsubscribe me from Kannel group, but 
I've been trying to unsubcribe me severeal times using the right procedure 
without succes.
Can some one help me tu unscribe from this group?

Thank you in advance
Carla



- Forwarded Message 
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, 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 September, 2010 19:34
To: Kannel list
Subject: SQL Box Question
 
Hello,

I was just checking sqlbox with bearerbox and smsbox to log all sent messages. 
I 
have seen that in sent_sms table there is no relation (Like message id mapping) 
between MT and DLR. Is it normal behaviour? If yes then can you please suggest 
how will i map sent messages to DLR?

Regards
Tapan Thapa 


  

RE: SQL Box Question

[T.K.Thapa]

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

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 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 September, 2010 19:34

To: Kannel list

Subject: SQL Box Question 



   


 
  
  Hello,

  

  I was just checking sqlbox with bearerbox and smsbox to log all sent
  messages. I have seen that in sent_sms table there is no relation (Like
  message id mapping) between MT and DLR. Is it normal behaviour? If yes then
  can you please suggest how will i map sent messages to DLR?

  

  Regards

  Tapan Thapa 
  
 


   



 

Re: SQL Box Question

[Nikos Balkanas]

That's not what Rene had in mind. You can use any dlr-mask you like. But to 
match DLRs with MTs you need to do it with dlr-url. When you push the SMS 
you type:


/cgi-bin/sendsms?from=...&to=&text=&dlr-mask=...&dlr-url=http://mydlr.php?...&msgid=1&;

Of course dlr-url has to be urlencoded. msgid you increment each time you 
push an MT. Then you know which msgid goes with what SMS you send and you 
can match the DLR received with msgid and SMS.


BR,
Nikos
- Original Message - 
From: T.K.Thapa

To: Rene Kluwen
Cc: Kannel list
Sent: Friday, 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.

Regards
Tapan Thapa

--- On Thu, 9/9/10, Rene Kluwen  wrote:


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 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 September, 2010 19:34
To: Kannel list
Subject: SQL Box Question

Hello,

I was just checking sqlbox with bearerbox and smsbox to log all sent 
messages. I have seen that in sent_sms table there is no relation (Like 
message id mapping) between MT and DLR. Is it normal behaviour? If yes then 
can you please suggest how will i map sent messages to DLR?


Regards
Tapan Thapa 

Re: SQL Box Question

[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.petitiononline.com/froyo/


On Sep 10, 2010, at 12:34 AM, T.K.Thapa wrote:

> Hello,
> 
> I was just checking sqlbox with bearerbox and smsbox to log all sent 
> messages. I have seen that in sent_sms table there is no relation (Like 
> message id mapping) between MT and DLR. Is it normal behaviour? If yes then 
> can you please suggest how will i map sent messages to DLR?
> 
> Regards
> Tapan Thapa
> 

Re: SQL Box Question

[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: "Kannel list" 
Date: Saturday, 11 September, 2010, 6:56 AM

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.comhttp://www.petitiononline.com/froyo/




On Sep 10, 2010, at 12:34 AM, T.K.Thapa wrote:
Hello,

I was just checking sqlbox with bearerbox and smsbox to log all sent messages. 
I have seen that in sent_sms table there is no relation (Like message id 
mapping) between MT and DLR. Is it normal behaviour? If yes then can you please 
suggest how will i map sent messages to DLR?

Regards
Tapan Thapa

RE: SQL Box Question

[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 Question

 


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: "Kannel list" 
Date: Saturday, 11 September, 2010, 6:56 AM

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.petitiononline.com/froyo/

 

On Sep 10, 2010, at 12:34 AM, T.K.Thapa wrote:






Hello,

I was just checking sqlbox with bearerbox and smsbox to log all sent
messages. I have seen that in sent_sms table there is no relation (Like
message id mapping) between MT and DLR. Is it normal behaviour? If yes then
can you please suggest how will i map sent messages to DLR?

Regards
Tapan Thapa

 

 

RE: SQL Box Question

[T.K.Thapa]

Ok, Let me summaries the things which i understood from your suggestions.

When i am sending sms to smsbox which is connected to sqlbox i need to set 
dlr-url= and it will be same for MT as well 
as DLR. Am i right?

My understanding for dlr-url is if we specify 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  wrote:

From: Rene Kluwen 
Subject: RE: SQL Box Question
To: "'T.K.Thapa'" , "'KangMas Willy'" 

Cc: "'Kannel list'" 
Date: Saturday, 11 September, 2010, 12:36 PM




 
 






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 Question 



   


 
  
  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: "Kannel list" 

  Date: Saturday, 11 September, 2010, 6:56 AM 
  
  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.petitiononline.com/froyo/ 
  
  
     
  
  
  On Sep 10, 2010, at 12:34 AM, T.K.Thapa wrote: 
  
  

  

   
  
   

Hello,



I was just checking sqlbox with bearerbox and smsbox to log all sent
messages. I have seen that in sent_sms table there is no relation (Like
message id mapping) between MT and DLR. Is it normal behaviour? If yes then
can you please suggest how will i map sent messages to DLR?



Regards

Tapan Thapa 

   
  
     
  
  
  
  
 


   



 

Re: SQL Box Question

[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 udhdata problem

[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 multipart
messages,

udhdata seems not to be working...

Inserting this value in udhdata "050003180201" results in
"303530303033313930323031",

thanks in advance for ur help.

Regards,
Roland Jay
PH


 
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.





--
Alejandro Guerrieri
Magicom
http://www.magicom-bcn.net/
LinkedIn: http://www.linkedin.com/in/aguerrieri

Re: SQL Box udhdata problem

[Jay]

Hi Alejandro,

Thanks for your reply, I tried your suggestion but using UDH 
"%05%00%03%19%02%01" in SQL Box resulted to 
"253035253030253033253139253032253031"

Still looking for answers...

Thanks.

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 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 multipart
messages,

udhdata seems not to be working...

Inserting this value in udhdata "050003180201" results in
"303530303033313930323031",

thanks in advance for ur help.

Regards,
Roland Jay
PH


 
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.





--
Alejandro Guerrieri
Magicom
http://www.magicom-bcn.net/
LinkedIn: http://www.linkedin.com/in/aguerrieri



 
-
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.

Re: SQL Box udhdata problem

[Jay]

Hi Guys,

I might have fixed the problem with this,

Notes:
a. To set number of messages, use   
mwi=[0-3]&coding=0&udh=%04%01%02%%,   where YY are the number of 
messages, in HEX, and XX are mwi   plus 0xC0 if text field is not empty.

Clumsy me.

Thanks.

Regards,
Roland 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" in SQL Box resulted to 
"253035253030253033253139253032253031"

Still looking for answers...

Thanks.

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 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 multipart
messages,

udhdata seems not to be working...

Inserting this value in udhdata "050003180201" results in
"303530303033313930323031",

thanks in advance for ur help.

Regards,
Roland Jay
PH


 
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.





--
Alejandro Guerrieri
Magicom
http://www.magicom-bcn.net/
LinkedIn: http://www.linkedin.com/in/aguerrieri



 

 
-
Don't be flakey. Get Yahoo! Mail for Mobile and 
always stay connected to friends.

Re: SQL Box Table docs

[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 patch to 1.4.0 and compiled flawlessly. After a few fixes here
**>and there on my start scripts, I've managed to make it work and even
**>sent messages inserting on the send_sms table.
**>
**>My question is: Since there is so little documentation around (apart
**>from a FAQ being attached on many mails on mail-archive I didn't found
**>anything), where could I get some documentation about the tables
**>structure.
**>
**>What I've already did was something like this:
**>
**>$query = "INSERT INTO send_sms ( ".
**> "momt, sender, receiver, udhdata, msgdata, ".
**> "time, smsc_id, service, account, id, ".
**> "sms_type, mclass, mwi, coding, compress, ".
**> "validity, deferred, dlr_mask, dlr_url, ".
**> "pid, alt_dcs, rpi, charset, boxc_id, binfo ".
**> ") VALUES ( ".
**> "'mt', '1234', '12345678', '', 'this+is+a+test', ".
**> "NOW(), 'mysmsc', 'myservice', NULL, NULL, ".
**> "NULL, NULL, NULL, NULL, NULL, ".
**> "NULL, NULL, NULL, NULL, ".
**> "NULL, NULL, NULL, NULL, NULL, NULL ".
**> ")";
**>
**>So there are a lot of "NULLS" (sort of "I don't know what to put there" ;) ).
**>
**>I would _love_ to know what all those fields means, which ones could I
**>ignore, which ones are mandatory and maybe a few examples of simple
**>inserts!
**>
**>Thank you in advance,

I haven't used sqlbox yet nor looked at the source code.  But, I can guess
what each column might be in the table.

It looks similar to the Msg structure that is passed between the
bearerbox and the smsbox.  As such:

momt:
  Description:
Indicates whether the SMS is a Mobile Originated (from mobile user
to an sms-service) or Mobile Terminated (from your application to
the mobile user).
  Supported Values:
'mt', 'mo'
  Kannel SMS Msg structure equivalent:
Not Applicable (specific to the sqlbox)

sender:
  Description:
The origination address.
  Supported Values:
Any alphanumeric value.
  Kannel SMS Msg structure equivalent:
sms.sender

receiver:
  Description:
The destination address.
  Supported Values:
Any alphanumeric value.
  Kannel SMS Msg structure equivalent:
sms.receiver

udhdata:
  Description:
The User Data Header that will be prefixed to the SMS message content.
  Supported Values:
Hexadecimal values
  Kannel SMS Msg structure equivalent:
sms.udhdata

msgdata:
  Description:
The SMS message payload
  Supported Values:
140 8-bit values. If a UDH is also specified for the SMS, then the
maximum length of the msgdata is 140-length(udhdata).
  Kannel SMS Msg structure equivalent:
sms.msgdata

time:
  Description:
The GMT time when the SMS was placed into the sqlbox.  This value
represents the number of seconds since the UNIX EPOCH (Jan 1, 1970).
  Supported Values:
Any decimal value.
  Kannel SMS Msg structure equivalent:
sms.time

smsc_id:
  Description:
The SMSC ID that should or did handle the SMS.
  Supported Values:
Any alphanumeric value.
  Kannel SMS Msg structure equivalent:
sms.smsc_id

service:
  Description:
The sms-service name that was executed on behave of the SMS.
  Supported Values:
Any alphanumeric value.
  Kannel SMS Msg structure equivalent:
sms.service

account:
  Description:
The auxiliary account name or number associated with the SMS
(mustly seen in HTTP relays).
  Supported Values:
Any alphanumeric value.
  Kannel SMS Msg structure equivalent:
sms.account

id:
  Description:
The unique ID assigned to each SMS handled by the Kannel system.
  Supported Values:
Format is: ----
 -> time_low
 -> time_mid
 -> time_hi_and_version
 -> clock_sequence
 -> node_id (usually interface ethernet address that this
  SMS was received from)
  Kannel SMS Msg structure equivalent:
sms.id

sms_type:
  Description:
The Kannel type of the SMS (MO or DLR)
  Supported Values:
0 = MO (coming from the operator on behave of a mobile user)
1 = MT_REPLY (coming from an sms-service)
2 = MT_PUSH (coming from an application external from Kannel)
3 = REPORT_MO (DLR from the operator)
4 = REPORT_MT (DLR from Kannel to the operator)
  Kannel SMS Msg structure equivalent:
sms.sms_type

mclass:
  Description:
The Message Class of the SMS as defined in the Data Coding Scheme
(DCS) Field.
  Supported Values:
0 = sends the message directly to display.
1 = sends to mobile
2 = sends to SIM
3 = sends to SIM Toolkit.
  Kannel SMS Msg structure equivalent:
sms.mclass

mwi:
  Description:
The Messag

Re: SQL Box Table docs

[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 +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 patch to 1.4.0 and compiled flawlessly. After a few fixes here
> **>and there on my start scripts, I've managed to make it work and even
> **>sent messages inserting on the send_sms table.
> **>
> **>My question is: Since there is so little documentation around (apart
> **>from a FAQ being attached on many mails on mail-archive I didn't found
> **>anything), where could I get some documentation about the tables
> **>structure.
> **>
<...> 
> I haven't used sqlbox yet nor looked at the source code.  But, I can guess
> what each column might be in the table.
> 
> It looks similar to the Msg structure that is passed between the
> bearerbox and the smsbox.  As such:
> 
<...> 
> If the author of the sqlbox is following the standard interface
> definitions of the bearerbox then the above information is valid.
> (You can find almost all this information in the manual.  Look for
> the SMS Push CGI Values Table).
> 
> See ya...
> 
> d.c.
> 
> 


-- 
Alejandro Guerrieri
Magicom
http://www.magicom-bcn.net/

RE: SQL Box and DLR Best Practice

[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 send_sms to snet_sms but
the field is not being copied from send_sms to sent_sms.

 

I have also read in some post of DEC 2008 by Mr. Alejandro Guerrieri that
sqlbox code would be patched for this.

 

Does somebody has any clue about the discussed issue or any development on
this front.??

 

Regards,

Bharat

From: Bharat Vasant [mailto:bha...@charteredinfo.com] 
Sent: Thursday, July 02, 2009 4:02 PM
To: 'users@kannel.org'
Subject: SQL Box and DLR Best Practice
Importance: High

 

1.   I am able to test Kannel + SQL Box and DLR.

 

2.   Also I understand that I have to provide my own generated
MsgID(uuid) in DLRUrl and on receiving DLR, my script will query for SMS
record with MsgID(uuid) and update the DLR status.

 

3.   To send the SMS, I have script which inserts SMS in SQLBox table
send_sms which finally gets moved to sent_sms.

 

4.   My question is do I need my separate tables to store MsgID(uuid) as
noted in step 2 above ?  If yes;  this will Involve Injecting SMS in 2
tables.  One - MyOwnSMS table and Two - SQLBox send_sms table; which seems
the be bit of overhead for server at high throughput.

 

5.   In other words, I am wondering, can I use existing tables of SQLBox
(say table sent_sms) to store MsgID(uuid) and update the same using DLRurl
on receipt of delivery report.  i.e. Is there any field in tables send_sms
and sent_sms which may be used for storing MsgID(uuid) generated by our
submit script, and the field gets carried from send_sms to sent_sms
automatically ?  or is it recommended to edit the SQL box code to achieve
this rather than having separate table as discussed in above point ? or
having separate table will not be much of overhead ?!

 

6.   I hope many users here are using Kannel at very high load
conditions and would be able to share their experience with me.

Bharat 

 

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

[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.
 
 
 
 
 
 
 
 

  _  

From: Jins [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 20, 2007 12:50 PM
To: users@kannel.org; [EMAIL PROTECTED]
Cc: Kenney Jacob; Sanil S
Subject: SQL BOX: sqlbox.c Connection closed by the box <(null)>


 
Some one please help me.
 
when i update the send_sms table,the entered field will be transferred to
sent_sms table but my sqlbox is getting terminated giving a log as below... 

2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at
localhost. 
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at
localhost. 
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at
localhost.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22 .
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at
localhost.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22 .
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at
localhost. 
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22.
2007-09-18 03:52:48 [23846] [0] DEBUG: Started thread 1 (
sqlbox.c:sql_to_bearerbox)
2007-09-18 03:52:48 [23846] [1] DEBUG: Thread 1 ( sqlbox.c:sql_to_bearerbox)
maps to pid 23846.
2007-09-18 03:52:48 [23846] [1] INFO: Connected to bearerbox at localhost
port 13010.
2007-09-18 03:52:48 [23846] [1] DEBUG: Started thread 2 (
sqlbox.c:bearerbox_to_sql ) 
2007-09-18 03:52:48 [23846] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql)
maps to pid 23846.
2007-09-18 03:53:48 [23846] [2] INFO: Connection closed by the box <(null)>
2007-09-18 03:53:48 [23846] [2] DEBUG: bearerbox_to_sql: connection to
bearerbox died. 
2007-09-18 03:53:48 [23846] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql)
terminates.
2007-09-18 03:53:48 [23846] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox)
terminates.
2007-09-18 03:53:58 [23846] [0] DEBUG: Immutable octet strings: 65. 

 
 
Here is my conf files 

SQLBOX CONF

group = sqlbox
id = sqlbox-db
smsbox-id = smsbox 
bearerbox-host = "xxx.xxx.xxx"
bearerbox-port = 13010
smsbox-port = 13012
smsbox-port-ssl = false 
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/var/log/kannel/kannel- sqlbox.log"
log-level = 1

group = mysql-connection
id = sqlbox-db
host = localhost
username = x 
password = x
database = x
max-connections = 10

KANNEL.CONF


group = core
admin-port = 13010
admin-password = "xx"
status-password = "xx" 
admin-deny-ip = "*.*.*.*"
admin-allow-ip = " 127.0.0.1  "
smsbox-port = 13011
#wapbox-port = 13002 
smsbox-port-ssl = no
box-deny-ip = "*.*.*.*"
box-allow-ip = "xx.xxx.xx"
#wdp-interface-name = "*"
dlr-storage = mysql 
log-file = "/var/log/kannel/kannel-core.log" 
log-level = 1

group = smsbox
bearerbox-host = "xxx.xx.xxx.xxx"
smsbox-id = smsbox
#bearerbox-port = 13010
sendsms-port = 14001
#global-sender = 1234456
#sendsms-chars = "," 
access-log = "/var/log/kannel/kannel.smsbox.access-log"
log-file = "/var/log/kannel/kannel.smsbox.log"
log-level = 0

group = smsc 
smsc = smpp
host = " xxx.xxx.xxx.xxx"
port = 7677
receive-port = 7677
#service-type = smpp
smsc-id = test
transceiver-mode = true
smsc-username = "zx"
smsc-password = xx 
system-type = ""

group = sendsms-user 
username = 
password = x
concatenation = true
max-messages = 100

group = mysql-connection
id = mydlr
host =localhost
username = x 
password =x
database = xx
max-connections = 1 

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

[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 - 
  From: 
  Konstantinos Liadakis 
  To: users@kannel.org 
  Sent: Thursday, April 20, 2006 10:53 
  AM
  Subject: SQL BOX PATCH INSTALL ON KANNEL 
  INSTALLED BY RPM ON FEDORA
  
  
  Hello,
   
  I have installed the latest rpm of 
  kannel on my brand new fedora core 5 linux.
   
  I am very new to linux and I will 
  need your help in order to install sqlbox.
   
  My problem is that I cannot find 
  where are the installed by rpm kannel files, and hence I cannot follow sql box 
  installation instructions.
   
  Anybody can help me on this with a 
  step by step guide, or pointing to some direction where I canget 
  info
   
  Thank you very much in advance for 
  your time and cooperation
   
  Kind regards
   
  Konstantinos 
  Liadakis

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

[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).
Devel packages are not installed by default on Fed core 1 (unsure
about 2 or newer).

On 4/20/06, issam <[EMAIL PROTECTED]> wrote:
>
> 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 -
> From: Konstantinos Liadakis
> To: users@kannel.org
> Sent: Thursday, April 20, 2006 10:53 AM
> Subject: SQL BOX PATCH INSTALL ON KANNEL INSTALLED BY RPM ON FEDORA
>
>
>
>
> Hello,
>
>
>
> I have installed the latest rpm of kannel on my brand new fedora core 5
> linux.
>
>
>
> I am very new to linux and I will need your help in order to install sqlbox.
>
>
>
> My problem is that I cannot find where are the installed by rpm kannel
> files, and hence I cannot follow sql box installation instructions.
>
>
>
> Anybody can help me on this with a step by step guide, or pointing to some
> direction where I canget info
>
>
>
> Thank you very much in advance for your time and cooperation
>
>
>
> Kind regards
>
>
>
> Konstantinos Liadakis


--
Labor and Joy

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

[Luis Valencia]

As far as I know this sqlbox patch it
should be apply on the sources, because when you compile it, it will be done
with sqlbox support.

 

Download the kannel sources and then untar the sqlbox patch within the kannel dir and type: patch -p0 < sqlbox.patchThen: make distclean; ./configure --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 INSTALLED BY RPM ON FEDORA



 



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 - 





From: Konstantinos
Liadakis 





To: users@kannel.org 





Sent: Thursday,
April 20, 2006 10:53 AM





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





 



Hello,

 

I have installed the latest rpm of kannel on my brand new fedora
core 5 linux.

 

I am very new to linux and I will need your help in order to
install sqlbox.

 

My problem is that I cannot find where are the installed by
rpm kannel files, and hence I cannot follow sql box installation instructions.

 

Anybody can help me on this with a step by step guide, or
pointing to some direction where I canget info

 

Thank you very much in advance for your time and cooperation

 

Kind regards

 

Konstantinos Liadakis

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

[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: http://www.linkedin.com/in/aguerrieri

On 4/20/06, Konstantinos Liadakis <[EMAIL PROTECTED]> wrote:
>
>
>
> Hello,
>
>
>
> I have installed the latest rpm of kannel on my brand new fedora core 5
> linux.
>
>
>
> I am very new to linux and I will need your help in order to install sqlbox.
>
>
>
> My problem is that I cannot find where are the installed by rpm kannel
> files, and hence I cannot follow sql box installation instructions.
>
>
>
> Anybody can help me on this with a step by step guide, or pointing to some
> direction where I canget info
>
>
>
> Thank you very much in advance for your time and cooperation
>
>
>
> Kind regards
>
>
>
> Konstantinos Liadakis

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

[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: 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"

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: http://www.linkedin.com/in/aguerrieri

On 4/20/06, Konstantinos Liadakis <[EMAIL PROTECTED]> wrote:
>
>
>
> Hello,
>
>
>
> I have installed the latest rpm of kannel on my brand new fedora core 5
> linux.
>
>
>
> I am very new to linux and I will need your help in order to install
sqlbox.
>
>
>
> My problem is that I cannot find where are the installed by rpm kannel
> files, and hence I cannot follow sql box installation instructions.
>
>
>
> Anybody can help me on this with a step by step guide, or pointing to some
> direction where I canget info
>
>
>
> Thank you very much in advance for your time and cooperation
>
>
>
> Kind regards
>
>
>
> Konstantinos Liadakis

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

[Alejandro Guerrieri]

If you are on a 24/7 server the locatedb _should_ be updated
automaticaly on a daily basis on the daily cronjob (usually being run
at late night), but if you can't seem to find the files, do as Luis
said to update the db manually.


On 4/26/06, Luis Valencia <[EMAIL PROTECTED]> wrote:
> 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: 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"
>
> 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: http://www.linkedin.com/in/aguerrieri
>
> On 4/20/06, Konstantinos Liadakis <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > Hello,
> >
> >
> >
> > I have installed the latest rpm of kannel on my brand new fedora core 5
> > linux.
> >
> >
> >
> > I am very new to linux and I will need your help in order to install
> sqlbox.
> >
> >
> >
> > My problem is that I cannot find where are the installed by rpm kannel
> > files, and hence I cannot follow sql box installation instructions.
> >
> >
> >
> > Anybody can help me on this with a step by step guide, or pointing to some
> > direction where I canget info
> >
> >
> >
> > Thank you very much in advance for your time and cooperation
> >
> >
> >
> > Kind regards
> >
> >
> >
> > Konstantinos Liadakis
>
>
>


--
Alejandro Guerrieri
Magicom
http://www.magicom-bcn.net/
LinkedIn: http://www.linkedin.com/in/aguerrieri