Dear Team,
How to call dlr-url on sqlbox.
Kindly find the mysql query as given below.
INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, smsc_id,
dlr_mask, dlr_url) VALUES ('MT', 'DEMO', '919X', 'SQLBOX TESTING
SERVER', 2, 'test', 31, 'http%3A//
10.0.0.1/sms/dlrNEW.php%3Fd
.kannel.org] On
Behalf Of Ravindra Gupta // Viva
Sent: Monday, 30 July, 2012 16:31
To: users-requ...@vm1.kannel.org; us...@vm1.kannel.org
Subject: dlr-url call on sqlbox
Dear Team,
How to call dlr-url on sqlbox.
Kindly find the mysql query as given below.
INSERT INTO send_sms (momt,
y, 2012 16:31
> *To:* users-requ...@vm1.kannel.org; us...@vm1.kannel.org
> *Subject:* dlr-url call on sqlbox
>
> ** **
>
> Dear Team,
>
> ** **
>
> How to call dlr-url on sqlbox.
>
> ** **
>
> Kindly find the mysql query as given below.
&g
msID%3D%25A%26
BatchID%3D123-5d1Xa', 'smsbox-id' );
Where 'smsbox-id' is a random instance of any smsbox that you have
connected.
From: Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
Sent: Monday, 30 July, 2012 16:43
To: Rene Kluwen
Cc: users-requ..
d' );
>
> Where 'smsbox-id' is a random instance of any smsbox that you have
> connected.
>
>
> From: Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
> Sent: Monday, 30 July, 2012 16:43
> To: Rene Kluwen
> Cc: users-requ...@vm1.kannel.org; us...
: Monday, 30 July, 2012 18:25
To: Rene Kluwen
Cc: users-requ...@vm1.kannel.org; us...@vm1.kannel.org
Subject: Re: dlr-url call on sqlbox
Dear Rene,
We have got below error.
INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, smsc_id,
dlr_mask, dlr_url, boxc_id) VALUES (
...@vivainfomedia.com]
Sent: Wednesday, 01 August, 2012 10:17
To: Rene Kluwen
Cc: users-requ...@vm1.kannel.org; us...@vm1.kannel.org
Subject: Re: dlr-url call on sqlbox
Dear Rene,
Dear Rene, We have inserted asmsbox value in boxc_id, after then we have
submitted the sms and found the error on
; sqlbox -> mysql -> bearerbox -> smsc). Usually
sqlbox is not the cause.
== Rene
From: Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
Sent: Wednesday, 01 August, 2012 12:29
To: Rene Kluwen
Cc: us...@vm1.kannel.org
Subject: Re: dlr-url call on sqlbox
Dear Rene,
** **
>
> == Rene
>
> ** **
>
> *From:* Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
> *Sent:* Wednesday, 01 August, 2012 12:29
> *To:* Rene Kluwen
> *Cc:* us...@vm1.kannel.org
>
> *Subject:* Re: dlr-url call on sqlbox
>
> ** **
>
>
Gupta // Viva [mailto:ravin...@vivainfomedia.com]
Sent: Wednesday, 08 August, 2012 09:34
To: Rene Kluwen
Cc: us...@vm1.kannel.org
Subject: Re: dlr-url call on sqlbox
Dear Rene,
While working on sqlbox, I have come across some queries :-
1. When we insert on send_sms table, it invokes
>
> ** **
>
> ** **
>
> Hope this helps,
>
> ** **
>
> Rene
>
> ** **
>
> *From:* Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
> *Sent:* Wednesday, 08 August, 2012 09:34
>
> *To:* Rene Kluwen
> *Cc:* us...@vm1.kannel.org
>
com]
Sent: Wednesday, 08 August, 2012 15:51
To: Rene Kluwen
Cc: us...@vm1.kannel.org
Subject: Re: dlr-url call on sqlbox
Dear Rene,
We have commented the code in sqlbox.c file and found the row in sent_sms
table.
/* if (msg_type(msg) == sms) {
debug("sqlbox", 0,
volumes. So please feel free to test and
share your experiences in the list.
Also there's a number of things you can do to increase mysql speed, which is
beyond the scope of this mailinglist.
Hope this helps,
Rene
From: Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
Sen
d share your experiences in the list.
> Also there’s a number of things you can do to increase mysql speed, which
> is beyond the scope of this mailinglist.
>
>
>
>
>
> Hope this helps,
>
>
>
> Rene
>
>
>
> *From:* Ra
ut line 597 of the original gw/sqlbox.c as well.****
>>
>> ** **
>>
>> == Rene
>>
>> ** **
>>
>> *From:* Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
>> *Sent:* Wednesday, 08 August, 2012 15:51
>> *To:* Rene Kluwen
&g
rom:* Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
>>> *Sent:* Wednesday, 08 August, 2012 09:34
>>>
>>>
>>> *To:* Rene Kluwen
>>> *Cc:* us...@vm1.kannel.org
>>> *Subject:* Re: dlr-url call on sqlbox
>&g
://127.0.0.1:13000/status')?>
>>
>>
>>
>>
>>
>>
>> 2012/8/29 Ravindra Gupta // Viva
>>
>>> Dear Rene
>>>
>>> We have successfully configured SQLBOX on our Linux server, I have some
>>> query as given below.
&g
>>> : '.$tmp[
>>> 'count'].'')?>
>>> >>
>>> ?>
>>>
>>> get('http://127.0.0.1:13000/status')?>
>>>
>>>
>>>
>>>
>>>
>>>
>>> 201
;] = $table;
>>>> }
>>>> $DB->close();
>>>> $get = new cURL();
>>>> ?>
>>>>
>>>>
>>>> Kannel Status
>>>>
>>>> Current Pending Queue:
>>
quot;SELECT count(*) AS cnt FROM `".$table."` WHERE
>>>>> time<=UNIX_TIMESTAMP(NOW())");
>>>>> $DB->free_result();
>>>>> $result[$i]['count'] = $DB->next_record('cnt');
>>>>>
$DB->free_result();
>>> $result[$i]['count'] = $DB->next_record('cnt');
>>> $result[$i]['name'] = $table;
>>> }
>>> $DB->close();
>>> $get = new cURL();
>>> ?>
>>&
es_in_kannel (send_sms%)");
>>>> $DB->free_result();
>>>>
>>>> foreach($tables as $i => $table) {
>>>> $DB->query("SELECT count(*) AS cnt FROM `".$table."` WHERE
>>>> time<=UNIX_TIMESTAMP(NOW())");
22 matches
Mail list logo