DLR problems with Hex vs Decimal message ID
Hi Team, One of our SMSCs is returning message IDs in the submit_sm_resp in hex - eg 84493328 - but the DLRs are coming back in decimal - eg 2219389736. This is causing problems with Kannel with the MySQL queries on the DLR database, as it can't find the related message. *ERROR: SMPP[ABC]: got DLR but could not find message or was not interested in it id2224181776 dst91X, type1* We are using bearerbox configuration parameters in given below. group = smsc smsc = smpp smsc-id = ABC host= 10.0.0.1 smsc-username= abc smsc-password= abc123 port = 1234 #receive-port= 1234 connect-allow-ip = 127.0.0.1 system-type= address-range= #alt-charset=ASCII source-addr-ton=5 source-addr-npi=9 dest-addr-ton=1 dest-addr-npi=1 *msg-id-type=0x00* allowed-smsc-id= ABC transceiver-mode=1 Any quick fixes I can make?
Route Managing:
Dear Team, We have two account i.e one account for *ab* and second account for *dc*, If one account i.e (*ab*) going on re-connecting so how we will transfer all the queue from other SMPP Account i.e (*dc*). Kindly let me know for the same.
Dlr reports match.
Dear Team, I have one query regarding the delivery reports, please let me know how Kannel manage the delivery reports for each and every message. Does Kannel has any value or key values which match with the desired input given while specifying the dlr url while submitting the SMS.
Re: dlr-url call on sqlbox
Dear Spameden,
Thanks for your response.
On Fri, Oct 26, 2012 at 3:42 PM, spameden spame...@gmail.com wrote:
I've attached zip archive with complete code
You'd need to change few parameters in kannel_status.php to get it
working.
2012/10/26 Ravindra Gupta // Viva ravin...@vivainfomedia.com
Dear Spameden,
We have created one page in sqlbox server and I have found there is
missing two files i.e (class_mysql.php, curl.class.php).Kindly provide
me both the php code for the same.
---
?php
require_once('class_mysql.php');
include_once('curl.class.php');
$DB=NEW DB_MYSQL('kannel_db', 'kannel', 'password', 'sqladmin');
$DB-query(show tables like 'send_sms%');
$tables = $DB-collect(Tables_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()));
$DB-free_result();
$result[$i]['count'] = $DB-next_record('cnt');
$result[$i]['name'] = $table;
}
$DB-close();
$get = new cURL();
?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
html
titleKannel Status/title
body
Current Pending Queue:br
var_dump($result);
? foreach($result as $tmp) { ?
? =$tmp['name']?: ?=(is_null($tmp['count']) ? 0:'b'.$tmp[
'count'].'/b')?br
? }
?
pre
?=$get-get('http://180.149.242.80:13000/status')?
/pre
/body
/html
we have got the below error.
PHP Warning: require_once(class_mysql.php): failed to open stream: No
such file or directory in /var/www/html/monitor.php on line 2
PHP Fatal error: require_once(): Failed opening required
'class_mysql.php' (include_path='.:/usr/share/pear:/usr/share/php') in
/var/www/html/monitor.php on line 2
On Sat, Oct 13, 2012 at 8:11 AM, spameden spame...@gmail.com wrote:
There is no WEB panel for monitoring SQLBox, but you can code one,
it's very easy I think.
Right now I'm using this code just to monitor what happens with kannelvia
the WEB.
It gets current pending queue on multiple sqlbox'es and displays
kannel's status page. You can extend it to allow kannel's different
commands.
Here is what I'm using so you'll get an idea:
?
require_once('class_mysql.php');
include_once('curl.class.php');
$DB=NEW DB_MYSQL('kannel_db', 'kannel_user', 'password', 'localhost');
$DB-query(show tables like 'send_sms%');
$tables = $DB-collect(Tables_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()));
$DB-free_result();
$result[$i]['count'] = $DB-next_record('cnt');
$result[$i]['name'] = $table;
}
$DB-close();
$get = new cURL();
?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
html
titleKannel Status/title
body
Current Pending Queue:br
? foreach($result as $tmp) { ?
?=$tmp['name']?: ?=(is_null($tmp['count']) ? 0:'b'.$tmp[
'count'].'/b')?br
? }
?
pre
?=$get-get('http://127.0.0.1:13000/status')?
/pre
/body
/html
2012/8/29 Ravindra Gupta // Viva ravin...@vivainfomedia.com
Dear Rene
We have successfully configured SQLBOX on our Linux server, I have some
query as given below.
1) Any web panel in SQLBOX where we will be Monitored SMS bulk queue
like kannel.
On Wed, Aug 8, 2012 at 9:13 PM, Rene Kluwen rene.klu...@chimit.nlwrote:
Sorry… Now I see what is happening.
You should comment out 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
*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, smsbox_to_bearerbox: sms received);*
* msg_escaped = msg_duplicate(msg);*
*gw_sql_save_msg(msg_escaped, octstr_imm(MT)); *
* msg_destroy(msg_escaped);*
*} */*
** **
*/* if (msg_type(msg) == sms) {x, 0, smsbox_to_bearerbox: sms
received);*
*msg_escaped = msg_duplicate(msg);*
*gw_sql_save_msg(msg_escaped, octstr_imm(MT)); *
* msg_destroy(msg_escaped);*
*}*
**/*
** **
*mysql** select count(*) from sent_sms;*
*+--+*
*| count(*) |*
*+--+*
*| 10 | *
*+--+*
*1 row in set (0.00 sec)*
* *
** **
** **
On Wed, Aug 8, 2012 at 6:14 PM, Rene Kluwen rene.klu...@chimit.nl
wrote:
Hello Ravindra,
1. The sent_sms table is a log table. It records all smsmessages
that have been sent, either through a connected
smsbox or via an insert in send_sms. Entries are never deleted. If
you don’t need a log of your sms messages, you can comment out
Re: dlr-url call on sqlbox
Dear Spameden,
As I have already mentioned in my above mail that I want to store both the
MT and MO PDU in Mysql database. Currently we get the MT PDU in sent_sms
table in the database however there is no entry in the MO PDU.
Kindly let me know where I will get the MO response (delivery_sm) status
like delivered, undelivered, expired.
Thanks
On Mon, Oct 22, 2012 at 2:45 PM, spameden spame...@gmail.com wrote:
sqlbox by default stores DLR, MT, MO in sent_sms messages after message
is being sent or received.
for monitoring you might want to consider kannel monitor included in the
latest svn package or writing it yourself
2012/10/22 Ravindra Gupta // Viva ravin...@vivainfomedia.com
Dear Spameden,
We have configured sqlbox in one of our Linux servers, We require to
store MT and MO pdu in mysql database.
How we can do for the same.
Ravindra Gupta B: +91.22.6785 6785 Server AdministratorD: +91.22.6785
6754 ravin...@vivaconnect.in M: +91.98199 92242 www.vivaconnect.in
Blog http://blog.vivaconnect.in/
LinkedInhttp://www.linkedin.com/company/viva-infomedia-pvt-ltd
Twitter https://twitter.com/vivaconnect1
Facebookhttps://www.facebook.com/pages/VivaConnect/181323090987
YouTubehttps://www.youtube.com/watch?v=MoLPYhTvNlgfeature=player_embedded
*Viva Infomedia Pvt. Ltd,* 242, Oshiwara Industrial Centre, New Link
Road, Goregaon (West), Mumbai- 400104.
DISCLAIMER: This e-mail and any files transmitted with it are for the
sole use of the intended recipient(s) and may contain confidential and
privileged information. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies and the original
message. Any unauthorized review, use, disclosure,dissemination,
forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful. The
recipient acknowledges that Viva Infomedia Pvt.Ltd. or its subsidiaries
and associated companies are unable to exercise control or ensure or
guarantee the integrity of/over the contents of the information contained
in e-mail transmissions and further acknowledges that any views expressed
in this message are those of the individual sender and no binding nature of
the message shall be implied or assumed unless the sender does so expressly
with due authority of Viva Infomedia Pvt.Ltd. Before opening any
attachments please check them for viruses and defects.
On Sat, Oct 13, 2012 at 8:11 AM, spameden spame...@gmail.com wrote:
There is no WEB panel for monitoring SQLBox, but you can code one,
it's very easy I think.
Right now I'm using this code just to monitor what happens with kannelvia
the WEB.
It gets current pending queue on multiple sqlbox'es and displays
kannel's status page. You can extend it to allow kannel's different
commands.
Here is what I'm using so you'll get an idea:
?
require_once('class_mysql.php');
include_once('curl.class.php');
$DB=NEW DB_MYSQL('kannel_db', 'kannel_user', 'password', 'localhost');
$DB-query(show tables like 'send_sms%');
$tables = $DB-collect(Tables_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()));
$DB-free_result();
$result[$i]['count'] = $DB-next_record('cnt');
$result[$i]['name'] = $table;
}
$DB-close();
$get = new cURL();
?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
html
titleKannel Status/title
body
Current Pending Queue:br
? foreach($result as $tmp) { ?
?=$tmp['name']?: ?=(is_null($tmp['count']) ? 0:'b'.$tmp[
'count'].'/b')?br
? }
?
pre
?=$get-get('http://127.0.0.1:13000/status')?
/pre
/body
/html
2012/8/29 Ravindra Gupta // Viva ravin...@vivainfomedia.com
Dear Rene
We have successfully configured SQLBOX on our Linux server, I have some
query as given below.
1) Any web panel in SQLBOX where we will be Monitored SMS bulk queue
like kannel.
On Wed, Aug 8, 2012 at 9:13 PM, Rene Kluwen rene.klu...@chimit.nlwrote:
Sorry… Now I see what is happening.
You should comment out 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
*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, smsbox_to_bearerbox: sms received);*
* msg_escaped = msg_duplicate(msg);*
*gw_sql_save_msg(msg_escaped, octstr_imm(MT)); *
* msg_destroy(msg_escaped);*
*} */*
** **
*/* if (msg_type(msg) == sms) {x, 0, smsbox_to_bearerbox: sms
received);*
*msg_escaped = msg_duplicate(msg
Re: dlr-url call on sqlbox
Dear Spameden,
We have configured sqlbox in one of our Linux servers, We require to store
MT and MO pdu in mysql database.
How we can do for the same.
Ravindra Gupta B: +91.22.6785 6785 Server AdministratorD: +91.22.6785
6754 ravin...@vivaconnect.in M: +91.98199 92242 www.vivaconnect.in
Bloghttp://blog.vivaconnect.in/
LinkedIn http://www.linkedin.com/company/viva-infomedia-pvt-ltd
Twitterhttps://twitter.com/vivaconnect1
Facebook https://www.facebook.com/pages/VivaConnect/181323090987
YouTubehttps://www.youtube.com/watch?v=MoLPYhTvNlgfeature=player_embedded
*Viva Infomedia Pvt. Ltd,* 242, Oshiwara Industrial Centre, New Link Road,
Goregaon (West), Mumbai- 400104.
DISCLAIMER: This e-mail and any files transmitted with it are for the sole
use of the intended recipient(s) and may contain confidential and
privileged information. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies and the original
message. Any unauthorized review, use, disclosure,dissemination,
forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful. The
recipient acknowledges that Viva Infomedia Pvt.Ltd. or its subsidiaries and
associated companies are unable to exercise control or ensure or guarantee
the integrity of/over the contents of the information contained in e-mail
transmissions and further acknowledges that any views expressed in this
message are those of the individual sender and no binding nature of the
message shall be implied or assumed unless the sender does so expressly
with due authority of Viva Infomedia Pvt.Ltd. Before opening any
attachments please check them for viruses and defects.
On Sat, Oct 13, 2012 at 8:11 AM, spameden spame...@gmail.com wrote:
There is no WEB panel for monitoring SQLBox, but you can code one, it's
very easy I think.
Right now I'm using this code just to monitor what happens with kannel via
the WEB.
It gets current pending queue on multiple sqlbox'es and displays kannel's
status page. You can extend it to allow kannel's different commands.
Here is what I'm using so you'll get an idea:
?
require_once('class_mysql.php');
include_once('curl.class.php');
$DB=NEW DB_MYSQL('kannel_db', 'kannel_user', 'password', 'localhost');
$DB-query(show tables like 'send_sms%');
$tables = $DB-collect(Tables_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()));
$DB-free_result();
$result[$i]['count'] = $DB-next_record('cnt');
$result[$i]['name'] = $table;
}
$DB-close();
$get = new cURL();
?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
html
titleKannel Status/title
body
Current Pending Queue:br
? foreach($result as $tmp) { ?
?=$tmp['name']?: ?=(is_null($tmp['count']) ?
0:'b'.$tmp['count'].'/b')?br
? }
?
pre
?=$get-get('http://127.0.0.1:13000/status')?
/pre
/body
/html
2012/8/29 Ravindra Gupta // Viva ravin...@vivainfomedia.com
Dear Rene
We have successfully configured SQLBOX on our Linux server, I have some
query as given below.
1) Any web panel in SQLBOX where we will be Monitored SMS bulk queue like
kannel.
On Wed, Aug 8, 2012 at 9:13 PM, Rene Kluwen rene.klu...@chimit.nlwrote:
Sorry… Now I see what is happening.
You should comment out 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
*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, smsbox_to_bearerbox: sms received);***
**
* msg_escaped = msg_duplicate(msg);*
*gw_sql_save_msg(msg_escaped, octstr_imm(MT)); *
* msg_destroy(msg_escaped);*
*} */*
** **
*/* if (msg_type(msg) == sms) {x, 0, smsbox_to_bearerbox: sms
received);*
*msg_escaped = msg_duplicate(msg);*
*gw_sql_save_msg(msg_escaped, octstr_imm(MT)); *
* msg_destroy(msg_escaped);*
*}*
**/*
** **
*mysql** select count(*) from sent_sms;*
*+--+*
*| count(*) |*
*+--+*
*| 10 | *
*+--+*
*1 row in set (0.00 sec)*
* *
** **
** **
On Wed, Aug 8, 2012 at 6:14 PM, Rene Kluwen rene.klu...@chimit.nl
wrote:
Hello Ravindra,
1. The sent_sms table is a log table. It records all sms messages
that have been sent, either through a connected smsbox or via an insert
in send_sms. Entries are never deleted. If you don’t need a log of your
sms messages, you can comment out the line “gw_sql_save_msg(msg
Store Access log in database
Hi Team, We have configured Kannel server 1.5.0 on Linux server, We need store online mode kannel_access.log data in the mysql database. Kindly share some suggestions for the same. Thanks
Re: Store Access log in database
Dear Tapan, We have successfully configured Sqlbox one of our local servers but we need to store kannel_access.log in mysql database. Any script or any config parameters so that we will capture the logs in DB. Thanks On Thu, Oct 18, 2012 at 5:58 PM, Tapan Kumar Thapa tapan.thapa2...@gmail.com wrote: Kindly check sqlbox.. On Thu, Oct 18, 2012 at 5:43 PM, Ravindra Gupta // Viva ravin...@vivainfomedia.com wrote: Hi Team, We have configured Kannel server 1.5.0 on Linux server, We need store online mode kannel_access.log data in the mysql database. Kindly share some suggestions for the same. Thanks
Re: users Digest, Vol 74, Issue 51
Dear satya,
We need below value in database.
012-10-17 14:30:16 Sent SMS [SMSC:Pipe] [SVC:abc][FID:1sdd]
[from:456123] [to:919X] [msg:26:Test !%^*()_+[]{} Message]
[udh:0:
On 10/19/12, users-requ...@kannel.org users-requ...@kannel.org wrote:
Send users mailing list submissions to
users@kannel.org
To subscribe or unsubscribe via the World Wide Web, visit
http://www.kannel.org/mailman/listinfo/users
or, via email, send a message with subject or body 'help' to
users-requ...@kannel.org
You can reach the person managing the list at
users-ow...@kannel.org
When replying, please edit your Subject line so it is more specific
than Re: Contents of users digest...
Today's Topics:
1. Store Access log in database (Ravindra Gupta // Viva)
2. Re: Store Access log in database (Tapan Kumar Thapa)
3. Re: Store Access log in database (Ravindra Gupta // Viva)
4. Re: Store Access log in database (Tapan Kumar Thapa)
5. Re: Store Access log in database (Satyadeep Kumar)
6. kannel wavecom fastrack (mohamed keita)
--
Message: 1
Date: Thu, 18 Oct 2012 17:43:40 +0530
From: Ravindra Gupta // Viva ravin...@vivainfomedia.com
To: users-ow...@kannel.org, users-requ...@kannel.org, users@kannel.org
Subject: Store Access log in database
Message-ID:
CAHxf3E6Y1R_5_=6ehm+hufupbb9fhk7crb872hskzmdevl-...@mail.gmail.com
Content-Type: text/plain; charset=iso-8859-1
Hi Team,
We have configured Kannel server 1.5.0 on Linux server, We need store
online mode kannel_access.log data in the mysql database.
Kindly share some suggestions for the same.
Thanks
-- next part --
An HTML attachment was scrubbed...
URL:
http://www.kannel.org/pipermail/users/attachments/20121018/633b73ee/attachment-0001.html
--
Message: 2
Date: Thu, 18 Oct 2012 17:58:22 +0530
From: Tapan Kumar Thapa tapan.thapa2...@gmail.com
To: Ravindra Gupta // Viva ravin...@vivainfomedia.com
Cc: users@kannel.org, users-ow...@kannel.org, users-requ...@kannel.org
Subject: Re: Store Access log in database
Message-ID:
CAJaLo3C1h7Qx49uTzGz-P6Y75AC9=x90n8wh8zsudf6fmjd...@mail.gmail.com
Content-Type: text/plain; charset=iso-8859-1
Kindly check sqlbox..
On Thu, Oct 18, 2012 at 5:43 PM, Ravindra Gupta // Viva
ravin...@vivainfomedia.com wrote:
Hi Team,
We have configured Kannel server 1.5.0 on Linux server, We need store
online mode kannel_access.log data in the mysql database.
Kindly share some suggestions for the same.
Thanks
-- next part --
An HTML attachment was scrubbed...
URL:
http://www.kannel.org/pipermail/users/attachments/20121018/c1775af6/attachment-0001.html
--
Message: 3
Date: Thu, 18 Oct 2012 18:22:26 +0530
From: Ravindra Gupta // Viva ravin...@vivainfomedia.com
To: Tapan Kumar Thapa tapan.thapa2...@gmail.com
Cc: users@kannel.org, users-ow...@kannel.org, users-requ...@kannel.org
Subject: Re: Store Access log in database
Message-ID:
CAHxf3E507PTE+73GZWUg1aOcdaa_Y29=4TY=136v=dk5w_y...@mail.gmail.com
Content-Type: text/plain; charset=iso-8859-1
Dear Tapan,
We have successfully configured Sqlbox one of our local servers but we need
to store kannel_access.log in mysql database.
Any script or any config parameters so that we will capture the logs in DB.
Thanks
On Thu, Oct 18, 2012 at 5:58 PM, Tapan Kumar Thapa
tapan.thapa2...@gmail.com wrote:
Kindly check sqlbox..
On Thu, Oct 18, 2012 at 5:43 PM, Ravindra Gupta // Viva
ravin...@vivainfomedia.com wrote:
Hi Team,
We have configured Kannel server 1.5.0 on Linux server, We need store
online mode kannel_access.log data in the mysql database.
Kindly share some suggestions for the same.
Thanks
-- next part --
An HTML attachment was scrubbed...
URL:
http://www.kannel.org/pipermail/users/attachments/20121018/8604acbb/attachment-0001.html
--
Message: 4
Date: Thu, 18 Oct 2012 18:26:43 +0530
From: Tapan Kumar Thapa tapan.thapa2...@gmail.com
To: Ravindra Gupta // Viva ravin...@vivainfomedia.com
Cc: users@kannel.org, users-ow...@kannel.org, users-requ...@kannel.org
Subject: Re: Store Access log in database
Message-ID:
cajalo3ccretpzugojhtkw4ocn_nobuc9qmgk0q9-h9lo8md...@mail.gmail.com
Content-Type: text/plain; charset=iso-8859-1
Unfortunately there is no script available which can parse access.log and
can store in MySQL or any other DB as far as i know.
May be any other user of kannel can help.
You can easily make it if you know coding.
Regards
Tapan Thapa
On Thu, Oct 18, 2012 at 6:22 PM, Ravindra Gupta // Viva
ravin...@vivainfomedia.com wrote:
Dear Tapan,
We have successfully configured Sqlbox one of our local servers but we
need to store kannel_access.log in mysql database.
Any script or any config
Store SMS Que delivery status for same Database:
Dear Team, I have configured Kannel 1.5.0 on our production server and all the thing going working fine. I need to store all the message on the MYSQL server whether received delivery on not. Please let me know for the same.
Sqlbox Monitoring Panel:
Dear Rene, We have successfully configured SQLBOX on our Linux server, I have some query as given below. 1) Any web panel in SQLBOX where we will be Monitored SMS bulk queue like kannel. Thanks Ravindra
Re: dlr-url call on sqlbox
Dear Rene
We have successfully configured SQLBOX on our Linux server, I have some
query as given below.
1) Any web panel in SQLBOX where we will be Monitored SMS bulk queue like
kannel.
On Wed, Aug 8, 2012 at 9:13 PM, Rene Kluwen rene.klu...@chimit.nl wrote:
Sorry… Now I see what is happening.
You should comment out 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
*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, smsbox_to_bearerbox: sms received);*
* msg_escaped = msg_duplicate(msg);*
*gw_sql_save_msg(msg_escaped, octstr_imm(MT)); *
* msg_destroy(msg_escaped);*
*} */*
** **
*/* if (msg_type(msg) == sms) {x, 0, smsbox_to_bearerbox: sms
received);*
*msg_escaped = msg_duplicate(msg);*
*gw_sql_save_msg(msg_escaped, octstr_imm(MT)); *
* msg_destroy(msg_escaped);*
*}*
**/*
** **
*mysql** select count(*) from sent_sms;*
*+--+*
*| count(*) |*
*+--+*
*| 10 | *
*+--+*
*1 row in set (0.00 sec)*
* *
** **
** **
On Wed, Aug 8, 2012 at 6:14 PM, Rene Kluwen rene.klu...@chimit.nl wrote:
Hello Ravindra,
1. The sent_sms table is a log table. It records all sms messages
that have been sent, either through a connected smsbox or via an insert
in send_sms. Entries are never deleted. If you don’t need a log of your
sms messages, you can comment out the line “gw_sql_save_msg(msg,
octstr_imm(MT));” in the gw/sqlbox.c file.
2. If you don’t need them, you can just delete everything from the
sent_sms table, for instance in a cron table. Or otherwise, see 1.
3. sqlbox doesn’t manage an internal queue. If you need information
about the sqlbox queue size, just apply a “select count(*) from send_sms”
and it will give you the number of messages still in the queue.
4. There’s several options. If you don’t need a log of the messages
that are sent, comment out the line that saves sent messages (see 1.).
Also, if you want to increase speed of inserting messages in send_sms, you
can look at the mysql syntax “INSERT… DELAYED”. This is what your client
program should do. Another thing is to adjust the SQLBOX_MYSQL_SELECT_QUERY
query in gw/sql_mysql.h. You can increase LIMIT 0,1 to a bigger value. I
never bothered to test this out on high 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]
*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 and sends it to
sent_sms which further submits it to the Operator and it deletes the entry
from send_sms. However when we receive the deliver_sm from operator, it
doesn't
deletes the entry from sent_sms table.
2. If the above scenario continues it would increase the size of
sent_sms table and will affect the mysql performance.
3. How we will manage queue in sqlbox, is there any patch available
which will give us the queue related information.
4. How to increase insertion speed to send_sms tables or sent_sms
table.
** **
On Wed, Aug 1, 2012 at 6:24 PM, Rene Kluwen rene.klu...@chimit.nl wrote:
I don’t understand quite what you mean with your questions.
But to answer:
1. Yes, you can send bulk sms through smsbox. It should work better
than sending them via smsbox.
2. Performance issues are dependant of a number of things. Check
the complete chain (smsbox - 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,
Thanks for your response.
We have successfully configured SQLBOX in our server.
We need some query as given below.
1. Can we send bulk load using SQLBOX i.e ( 5 to 10 Lac sms).
2. SQLBOX totally
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 and sends it to sent_sms which further submits it to the Operator and it deletes the entry from send_sms. However when we receive the deliver_sm from operator, it doesn't deletes the entry from sent_sms table. 2. If the above scenario continues it would increase the size of sent_sms table and will affect the mysql performance. 3. How we will manage queue in sqlbox, is there any patch available which will give us the queue related information. 4. How to increase insertion speed to send_sms tables or sent_sms table. On Wed, Aug 1, 2012 at 6:24 PM, Rene Kluwen rene.klu...@chimit.nl wrote: I don’t understand quite what you mean with your questions. But to answer: ** ** **1. **Yes, you can send bulk sms through smsbox. It should work better than sending them via smsbox. **2. **Performance issues are dependant of a number of things. Check the complete chain (smsbox - 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, ** ** Thanks for your response. ** ** We have successfully configured SQLBOX in our server. ** ** We need some query as given below. ** ** 1. Can we send bulk load using SQLBOX i.e ( 5 to 10 Lac sms). 2. SQLBOX totally on database so any performance issue occurred when we have inserted 1 Lac to 10 Lac sms. 3. We have used mysql 5.5 version. Kindly share your expert sugesstion for the same. ** ** On Wed, Aug 1, 2012 at 3:05 PM, Rene Kluwen rene.klu...@chimit.nl wrote: The error is self-explanatory. You should just dlrencode your parameters in the dlr-url. Not the url itself. So insert: http://10.0.0.1/sms/dlrNEW.php?dlr=%25d%26to%3D%25p%26smsID%3D%25A%26BatchID%3Dravi123-5d12d21asdq1asravi == Rene ** **
Re: dlr-url call on sqlbox
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...@vm1.kannel.org
Subject: Re: dlr-url call on sqlbox
Dear Rene,
Can send some sample example.
On Mon, Jul 30, 2012 at 8:08 PM, Rene Kluwen rene.klu...@chimit.nl
wrote:
This is a FAQ.
Sqlbox doesn’t call dlr-url’s, since it’s sql based and not http based.
The workaround is as follows:
Insert as your “boxc_id” the smsbox id of your connected smsbox.
== Rene
From: users-boun...@vm1.kannel.org [mailto:users-boun...@vm1.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, 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%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26
BatchID%3D123-5d1Xahttp://10.0.0.1/sms/dlrNEW.php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26
BatchID%3D123-5d1Xa' );
Email2SMS
Hi Team, We are using Kannel 1.5.0. Is it possible to use Kannel as Email2SMS or SMS2Email gateway ? Kindly provide some suggestion for the same.
Re: Email2SMS
Dear Komil, you have any installation doc for the same. Ravindra Gupta B: +91.22.6785 6785 Server AdministratorD: +91.22.6785 6754 ravin...@vivaconnect.in M: +91.98199 92242 www.vivaconnect.in Bloghttp://blog.vivaconnect.in/ LinkedIn http://www.linkedin.com/company/viva-infomedia-pvt-ltd Twitterhttps://twitter.com/vivaconnect1 Facebook https://www.facebook.com/pages/VivaConnect/181323090987 YouTubehttps://www.youtube.com/watch?v=MoLPYhTvNlgfeature=player_embedded *Viva Infomedia Pvt. Ltd,* 242, Oshiwara Industrial Centre, New Link Road, Goregaon (West), Mumbai- 400104. DISCLAIMER: This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies and the original message. Any unauthorized review, use, disclosure,dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. The recipient acknowledges that Viva Infomedia Pvt.Ltd. or its subsidiaries and associated companies are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Viva Infomedia Pvt.Ltd. Before opening any attachments please check them for viruses and defects. On Fri, Jul 27, 2012 at 12:15 PM, Komil ko...@payvand.tj wrote: Hi Ravindra. You can use PlaySMS, this project is free and support Email2SMS. PlaySMS also supporting Kannel. 7/27/2012 11:42 AM, Ravindra Gupta // Viva пишет: Hi Team, We are using Kannel 1.5.0. Is it possible to use Kannel as Email2SMS or SMS2Email gateway ? Kindly provide some suggestion for the same.
Color SMS using Kannel 1.5.0 Gateway.
Hi Team, We are using Kannel 1.5.0. Is it possible to sent color SMS using Kannel gateway ? Kindly provide some suggestion for the same.
Special characters @$_
Dear Users, I am using kannel-1.5.0 for bulk sms. I am not getting Special Characters like @$_ on handset. Is there any parameter needs to be include so I can get it ?? Kannel Conf file. group = core admin-port = smsbox-port = admin-password =xxx status-password = #admin-deny-ip = *.*.*.* #admin-allow-ip = 127.0.0.1 log-file = /var/log/kannel/kannel.log log-level = 0 box-deny-ip = *.*.*.* box-allow-ip = 127.0.0.1 #unified-prefix = +358, access-log = /var/log/kannel/kannel_access.log #store-type = kannel.store #store-location = /home/kannel/kannel.store #ssl-server-cert-file = #ssl-server-key-file = key.pem #ssl-certkey-file = mycertandprivkeyfile.pem sms-combine-concatenated-mo = true smsbox-max-pending=1024 dlr-storage=mysql #- # SMSC CONNECTIONS group = smsc smsc = smpp smsc-id = demo host=x.x.x.x smsc-username=demo smsc-password= port = receive-port= 0 connect-allow-ip = 127.0.0.1 system-type= address-range= #alt-dcs= 0 source-addr-ton=1 source-addr-npi=1 source-addr-autodetect= dest-addr-ton=1 dest-addr-npi=1 #msg-id-type=0x00 allowed-smsc-id=demo transceiver-mode=1 throughput=10 #- # SMSBOX SETUP # Smsbox(es) do higher-level SMS handling after they have been received from # SMS centers by bearerbox, or before they are given to bearerbox for delivery group = smsbox smsbox-id=asmsbox bearerbox-host = 127.0.0.1 sendsms-port = global-sender = SMS sendsms-chars = 0123456789 skype:0123456789 +- #log-file = /tmp/smsbox.log #log-level = 0 #access-log = /home/kannel/smsbox01.log http-request-retry=5 http-queue-delay=50 #- # SEND-SMS USERS # These users are used when Kannel smsbox sendsms interface is used to # send PUSH sms messages, i.e. calling URL like # http://kannel.machine:13013/cgi-bin/sendsms?username=testerpassword=foobar... group = sendsms-user username = password = x #user-deny-ip = #user-allow-ip = #default-smsc=xy #default-smsc= max-messages = 5 concatenation=true #dlr-url=http://localhost/sms/dlr.php?; #- # SERVICES # These are 'responses' to sms PULL messages, i.e. messages arriving from # handsets. The response is based on message content. Only one sms-service is # applied, using the first one to match. group = sms-service keyword = nop #text = You asked nothing and I did it! concatenation=true max-messages=5 text=480 Characters with spaces # There should be always a 'default' service. This service is used when no # other 'sms-service' is applied. group = sms-service keyword = default #text = No service specified text=480 Characters with spaces concatenation=true max-messages=5 Appreciate for Quick reply. Thanks in advance.
SMSC returned error code 0x00000014 (Message Queue Full) in response to submit_sm
Dear Team, We are facing issue when we are submitting the SMS to operator: *SMSC returned error code 0x0014 (Message Queue Full) in response to submit_sm.* 2012-06-22 02:05:14 [9456] [9] DEBUG: type_name: submit_sm 2012-06-22 02:05:14 [9456] [9] DEBUG: command_id: 4 = 0x0004 2012-06-22 02:05:14 [9456] [9] DEBUG: command_status: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: sequence_number: 2409 = 0x0969 2012-06-22 02:05:14 [9456] [9] DEBUG: service_type: NULL 2012-06-22 02:05:14 [9456] [9] DEBUG: source_addr_ton: 5 = 0x0005 2012-06-22 02:05:14 [9456] [9] DEBUG: source_addr_npi: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: source_addr: TESTMT 2012-06-22 02:05:14 [9456] [9] DEBUG: dest_addr_ton: 1 = 0x0001 2012-06-22 02:05:14 [9456] [9] DEBUG: dest_addr_npi: 1 = 0x0001 2012-06-22 02:05:14 [9456] [9] DEBUG: destination_addr: 919x 2012-06-22 02:05:14 [9456] [9] DEBUG: esm_class: 67 = 0x0043 2012-06-22 02:05:14 [9456] [9] DEBUG: protocol_id: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: priority_flag: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: schedule_delivery_time: NULL 2012-06-22 02:05:14 [9456] [9] DEBUG: validity_period: NULL 2012-06-22 02:05:14 [9456] [9] DEBUG: registered_delivery: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: replace_if_present_flag: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: data_coding: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: sm_default_msg_id: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: sm_length: 56 = 0x0038 2012-06-22 02:05:14 [9456] [9] DEBUG: short_message: 2012-06-22 02:05:14 [9456] [9] DEBUG:Octet string at 0x1790c6c0: 2012-06-22 02:05:14 [9456] [9] DEBUG: len: 56 2012-06-22 02:05:14 [9456] [9] DEBUG: size: 1024 2012-06-22 02:05:14 [9456] [9] DEBUG: immutable: 0 2012-06-22 02:05:14 [9456] [9] DEBUG: data: 05 00 03 48 02 02 6c 65 61 73 65 20 63 6f 6d 70 ...H..lease comp 2012-06-22 02:05:14 [9456] [9] DEBUG: data: 6c 65 74 65 20 79 6f 75 72 20 41 70 70 6c 69 63 lete your Applic 2012-06-22 02:05:14 [9456] [9] DEBUG: data: 61 74 69 6f 6e 20 46 6f 72 6d 2e 20 52 65 67 61 ation Form. Rega 2012-06-22 02:05:14 [9456] [9] DEBUG: data: 72 64 73 2c 20 44 54 45 rds, DTE 2012-06-22 02:05:14 [9456] [9] DEBUG:Octet string dump ends. 2012-06-22 02:05:14 [9456] [9] DEBUG: SMPP PDU dump ends. 2012-06-22 02:05:14 [9456] [11] WARNING: SMPP: PDU NULL terminated string (message_id) has no NULL. 2012-06-22 02:05:14 [9456] [11] DEBUG: SMPP[Critical_Pipe]: Got PDU: 2012-06-22 02:05:14 [9456] [11] DEBUG: SMPP PDU 0x2aaab0008b10 dump: 2012-06-22 02:05:14 [9456] [11] DEBUG: type_name: submit_sm_resp 2012-06-22 02:05:14 [9456] [11] DEBUG: command_id: 2147483652 = 0x8004 2012-06-22 02:05:14 [9456] [11] DEBUG: command_status: 20 = 0x0014 2012-06-22 02:05:14 [9456] [11] DEBUG: sequence_number: 2330 = 0x091a 2012-06-22 02:05:14 [9456] [11] DEBUG: message_id: NULL 2012-06-22 02:05:14 [9456] [11] DEBUG: SMPP PDU dump ends. 2012-06-22 02:05:14 [9456] [11] ERROR: SMPP[Critical_Pipe]: *SMSC returned error code 0x0014 (Message Queue Full) in response to submit_sm.* *2012-06-22 02:05:14 [9456] [11] WARNING: Maximum retries for message exceeded, discarding it!* *2012-06-22 02:05:14 [9456] [11] DEBUG: Set split msg status to 6* *2012-06-22 02:05:14 [9456] [11] PANIC: gwlib/octstr.c:2504: seems_valid_real: Assertion `ostr-data != NULL' failed. (Called from gwlib/octstr.c:325:octstr_destroy.)* Kindly find the kannel.conf file as given below. #coregroup group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar status-password = foo log-file = /var/log/kannel/kannel.log log-level = 0 access-log = /var/log/kannel/kannel_access.log store-location = /home/kannel/kannel.store box-deny-ip = *.*.*.* box-allow-ip = 127.0.0.1 dlr-storage=mysql sms-resend-freq= 9000 sms-resend-retry= 1 #bearerbox group group = smsc smsc = smpp smsc-id = Critical_Pipe host= 127.0.0.1 smsc-username= abc1 smsc-password= abc1 port = 1234 #receive-port=0 connect-allow-ip = 127.0.0.1 system-type=VIVAINFO address-range= alt-charset=1 alt-charset=ASCII source-addr-ton=5 source-addr-npi=9 dest-addr-ton=1 dest-addr-npi=1 #msg-id-type=0x01 allowed-smsc-id= Critical_Pipe #transceiver-mode=1 wait-ack= 6000 wait-ack-expire= 0x02 enquire-link-interval= 60 max-pending-submits = 10 throughput= 12 group = smsc smsc = smpp smsc-id = Critical_Pipe host= 127.0.0.1 smsc-username= abc1 smsc-password= abc1 port = 1234 #receive-port=0 connect-allow-ip = 127.0.0.1 system-type=VIVAINFO address-range= alt-charset=1 alt-charset=ASCII source-addr-ton=5 source-addr-npi=9 dest-addr-ton=1 dest-addr-npi=1 #msg-id-type=0x01 allowed-smsc-id= Critical_Pipe #transceiver-mode=1 wait-ack= 6000 wait-ack-expire= 0x02 enquire-link-interval= 60
[no subject]
Dear Team, We are facing issue when we are submitting the SMS to operator: *SMSC returned error code 0x0014 (Message Queue Full) in response to submit_sm.* 2012-06-22 02:05:14 [9456] [9] DEBUG: type_name: submit_sm 2012-06-22 02:05:14 [9456] [9] DEBUG: command_id: 4 = 0x0004 2012-06-22 02:05:14 [9456] [9] DEBUG: command_status: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: sequence_number: 2409 = 0x0969 2012-06-22 02:05:14 [9456] [9] DEBUG: service_type: NULL 2012-06-22 02:05:14 [9456] [9] DEBUG: source_addr_ton: 5 = 0x0005 2012-06-22 02:05:14 [9456] [9] DEBUG: source_addr_npi: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: source_addr: TESTMT 2012-06-22 02:05:14 [9456] [9] DEBUG: dest_addr_ton: 1 = 0x0001 2012-06-22 02:05:14 [9456] [9] DEBUG: dest_addr_npi: 1 = 0x0001 2012-06-22 02:05:14 [9456] [9] DEBUG: destination_addr: 919x 2012-06-22 02:05:14 [9456] [9] DEBUG: esm_class: 67 = 0x0043 2012-06-22 02:05:14 [9456] [9] DEBUG: protocol_id: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: priority_flag: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: schedule_delivery_time: NULL 2012-06-22 02:05:14 [9456] [9] DEBUG: validity_period: NULL 2012-06-22 02:05:14 [9456] [9] DEBUG: registered_delivery: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: replace_if_present_flag: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: data_coding: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: sm_default_msg_id: 0 = 0x 2012-06-22 02:05:14 [9456] [9] DEBUG: sm_length: 56 = 0x0038 2012-06-22 02:05:14 [9456] [9] DEBUG: short_message: 2012-06-22 02:05:14 [9456] [9] DEBUG:Octet string at 0x1790c6c0: 2012-06-22 02:05:14 [9456] [9] DEBUG: len: 56 2012-06-22 02:05:14 [9456] [9] DEBUG: size: 1024 2012-06-22 02:05:14 [9456] [9] DEBUG: immutable: 0 2012-06-22 02:05:14 [9456] [9] DEBUG: data: 05 00 03 48 02 02 6c 65 61 73 65 20 63 6f 6d 70 ...H..lease comp 2012-06-22 02:05:14 [9456] [9] DEBUG: data: 6c 65 74 65 20 79 6f 75 72 20 41 70 70 6c 69 63 lete your Applic 2012-06-22 02:05:14 [9456] [9] DEBUG: data: 61 74 69 6f 6e 20 46 6f 72 6d 2e 20 52 65 67 61 ation Form. Rega 2012-06-22 02:05:14 [9456] [9] DEBUG: data: 72 64 73 2c 20 44 54 45 rds, DTE 2012-06-22 02:05:14 [9456] [9] DEBUG:Octet string dump ends. 2012-06-22 02:05:14 [9456] [9] DEBUG: SMPP PDU dump ends. 2012-06-22 02:05:14 [9456] [11] WARNING: SMPP: PDU NULL terminated string (message_id) has no NULL. 2012-06-22 02:05:14 [9456] [11] DEBUG: SMPP[Critical_Pipe]: Got PDU: 2012-06-22 02:05:14 [9456] [11] DEBUG: SMPP PDU 0x2aaab0008b10 dump: 2012-06-22 02:05:14 [9456] [11] DEBUG: type_name: submit_sm_resp 2012-06-22 02:05:14 [9456] [11] DEBUG: command_id: 2147483652 = 0x8004 2012-06-22 02:05:14 [9456] [11] DEBUG: command_status: 20 = 0x0014 2012-06-22 02:05:14 [9456] [11] DEBUG: sequence_number: 2330 = 0x091a 2012-06-22 02:05:14 [9456] [11] DEBUG: message_id: NULL 2012-06-22 02:05:14 [9456] [11] DEBUG: SMPP PDU dump ends. 2012-06-22 02:05:14 [9456] [11] ERROR: SMPP[Critical_Pipe]: *SMSC returned error code 0x0014 (Message Queue Full) in response to submit_sm.* *2012-06-22 02:05:14 [9456] [11] WARNING: Maximum retries for message exceeded, discarding it!* *2012-06-22 02:05:14 [9456] [11] DEBUG: Set split msg status to 6* *2012-06-22 02:05:14 [9456] [11] PANIC: gwlib/octstr.c:2504: seems_valid_real: Assertion `ostr-data != NULL' failed. (Called from gwlib/octstr.c:325:octstr_destroy.)* Kindly find the kannel.conf file as given below. #coregroup group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar status-password = foo log-file = /var/log/kannel/kannel.log log-level = 0 access-log = /var/log/kannel/kannel_access.log store-location = /home/kannel/kannel.store box-deny-ip = *.*.*.* box-allow-ip = 127.0.0.1 dlr-storage=mysql sms-resend-freq= 9000 sms-resend-retry= 1 #bearerbox group group = smsc smsc = smpp smsc-id = Critical_Pipe host= 127.0.0.1 smsc-username= abc1 smsc-password= abc1 port = 1234 #receive-port=0 connect-allow-ip = 127.0.0.1 system-type=VIVAINFO address-range= alt-charset=1 alt-charset=ASCII source-addr-ton=5 source-addr-npi=9 dest-addr-ton=1 dest-addr-npi=1 #msg-id-type=0x01 allowed-smsc-id= Critical_Pipe #transceiver-mode=1 wait-ack= 6000 wait-ack-expire= 0x02 enquire-link-interval= 60 max-pending-submits = 10 throughput= 12 group = smsc smsc = smpp smsc-id = Critical_Pipe host= 127.0.0.1 smsc-username= abc1 smsc-password= abc1 port = 1234 #receive-port=0 connect-allow-ip = 127.0.0.1 system-type=VIVAINFO address-range= alt-charset=1 alt-charset=ASCII source-addr-ton=5 source-addr-npi=9 dest-addr-ton=1 dest-addr-npi=1 #msg-id-type=0x01 allowed-smsc-id= Critical_Pipe #transceiver-mode=1 wait-ack= 6000 wait-ack-expire= 0x02 enquire-link-interval= 60
opensmppbox issue
Hii, I have configured opensmppbox in kannel 1.5.0. I have faced issue in *Waiting for SMPP connections on port 2346. * opensmppbox logs as given below. [root@SqlBOX opensmppbox]# opensmppbox -v 0 opensmppbox.conf 2012-04-05 01:10:48 [4069] [0] ERROR: Error while gw_gethostbyname occurs. 2012-04-05 01:10:48 [4069] [0] ERROR: System error 1: Operation not permitted 2012-04-05 01:10:48 [4069] [0] ERROR: Can't find out official hostname for this host, using `SqlBOX' instead. 2012-04-05 01:10:48 [4069] [0] INFO: Debug_lvl = 0, log_file = none, log_lvl = 0 2012-04-05 01:10:48 [4069] [0] DEBUG: Kannel opensmppbox version svn-r gwlib version `1.5.0'. Build `Mar 6 2012 21:43:19', compiler `4.1.2 20080704 (Red Hat 4.1.2-51)'. System Linux, release 2.6.18-274.el5, version #1 SMP Fri Jul 22 04:43:29 EDT 2011, machine x86_64. Hostname SqlBOX, IP 127.0.0.1. Libxml version 2.6.26. Using OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008. Compiled with MySQL 5.0.95, using MySQL 5.0.95. Using native malloc. 2012-04-05 01:10:48 [4069] [0] INFO: MYSQL: Connected to server at localhost. 2012-04-05 01:10:48 [4069] [0] INFO: MYSQL: server version 5.0.95, client version 5.0.95. 2012-04-05 01:10:48 [4069] [0] INFO: DLR using storage type: mysql 2012-04-05 01:10:48 [4069] [0] INFO: Starting to log to file /var/log/kannel/opensmppbox.log level 0 2012-04-05 01:10:48 [4069] [0] INFO: Added logfile `/var/log/kannel/opensmppbox.log' with level `0'. 2012-04-05 01:10:48 [4069] [0] INFO:* Waiting for SMPP connections on port 2346.* opensmppbox.conf group = core #dlr-storage = internal dlr-storage = mysql # this group defines your opensmppbox group = opensmppbox # our boxc type opensmppbox-id = smppbox1 # the port to listen on for smpp connections opensmppbox-port = 2346 #opensmppbox-port = 13001 # we connect to the following host as a box bearerbox-host = 127.0.0.1 bearerbox-port = 13001 log-level = 0 log-file = /var/log/kannel/opensmppbox.log our-system-id = viva #route-to-smsc = my-default-smsc route-to-smsc = SMPP-Testing1 # see sample smpplogins.txt smpp-logins = /root/gateway-1.5.0/addons/opensmppbox/smpplogins.txt # the following is just standard dlr configuration group = mysql-connection id = mydlr host = localhost username = root password = sqladmin database = smart_kannel # you can increase this upon a higher load #max-connections = 1 group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxcid
opensmppbox issue:
Hello everyone, I have installed opensmppbox on a centOS server and have configured it with a client, but the client is not able to connect. When the client tries to connect it gives SMSC rejected login to transmit, code 0x000d (Bind Failed). Couldn't connect to SMS center (retrying in 10 seconds). On the server side, it gives this error, Invalid SMPP PDU received. Server Bearerbox log 2011-01-15 13:07:37 [26155] [5] INFO: Client connected from 127.0.0.1 2011-01-15 13:07:37 [26155] [5] DEBUG: Started thread 45 (gw/bb_boxc.c:function) 2011-01-15 13:07:37 [26155] [45] DEBUG: Thread 45 (gw/bb_boxc.c:function) maps to pid 26155. 2011-01-15 13:07:37 [26155] [45] DEBUG: Started thread 46 (gw/bb_boxc.c:boxc_sender) 2011-01-15 13:07:37 [26155] [46] DEBUG: Thread 46 (gw/bb_boxc.c:boxc_sender) maps to pid 26155. 2011-01-15 13:07:40 [26155] [45] INFO: Connection closed by the box 127.0.0.1 2011-01-15 13:07:40 [26155] [46] DEBUG: send_msg: sending msg to box: 127.0.0.1 2011-01-15 13:07:40 [26155] [46] DEBUG: Thread 46 (gw/bb_boxc.c:boxc_sender) terminates. 2011-01-15 13:07:40 [26155] [45] DEBUG: Thread 45 (gw/bb_boxc.c:function) terminates. 2011-01-15 13:07:48 [26155] [5] INFO: Client connected from 127.0.0.1 2011-01-15 13:07:48 [26155] [5] DEBUG: Started thread 47 (gw/bb_boxc.c:function) 2011-01-15 13:07:48 [26155] [47] DEBUG: Thread 47 (gw/bb_boxc.c:function) maps to pid 26155. 2011-01-15 13:07:48 [26155] [47] DEBUG: Started thread 48 (gw/bb_boxc.c:boxc_sender) 2011-01-15 13:07:48 [26155] [48] DEBUG: Thread 48 (gw/bb_boxc.c:boxc_sender) maps to pid 26155. 2011-01-15 13:07:51 [26155] [47] INFO: Connection closed by the box 127.0.0.1 2011-01-15 13:07:51 [26155] [48] DEBUG: send_msg: sending msg to box: 127.0.0.1 2011-01-15 13:07:51 [26155] [48] DEBUG: Thread 48 (gw/bb_boxc.c:boxc_sender) terminates. 2011-01-15 13:07:51 [26155] [47] DEBUG: Thread 47 (gw/bb_boxc.c:function) terminates. 2011-01-15 13:07:59 [26155] [5] INFO: Client connected from 127.0.0.1 2011-01-15 13:07:59 [26155] [5] DEBUG: Started thread 49 (gw/bb_boxc.c:function) 2011-01-15 13:07:59 [26155] [49] DEBUG: Thread 49 (gw/bb_boxc.c:function) maps to pid 26155. 2011-01-15 13:07:59 [26155] [49] DEBUG: Started thread 50 (gw/bb_boxc.c:boxc_sender) 2011-01-15 13:07:59 [26155] [50] DEBUG: Thread 50 (gw/bb_boxc.c:boxc_sender) maps to pid 26155. 2011-01-15 13:08:02 [26155] [49] INFO: Connection closed by the box 127.0.0.1 2011-01-15 13:08:02 [26155] [50] DEBUG: send_msg: sending msg to box: 127.0.0.1 2011-01-15 13:08:02 [26155] [50] DEBUG: Thread 50 (gw/bb_boxc.c:boxc_sender) terminates. 2011-01-15 13:08:02 [26155] [49] DEBUG: Thread 49 (gw/bb_boxc.c:function) terminates. Server Opensmppbox log 2011-01-15 13:06:40 [28249] [25] INFO: Client connected from 40.100.0.000 2011-01-15 13:06:40 [28249] [25] DEBUG: Connecting to 127.0.0.1 2011-01-15 13:06:40 [28249] [25] INFO: Connected to bearerbox at localhost port 13001. 2011-01-15 13:06:40 [28249] [25] DEBUG: Started thread 26 (opensmppbox.c:smpp_to_bearerbox) 2011-01-15 13:06:40 [28249] [26] DEBUG: Thread 26 (opensmppbox.c:smpp_to_bearerbox) maps to pid 28249. 2011-01-15 13:06:41 [28249] [26] DEBUG: SMPP[opensmppbox]: Got PDU: 2011-01-15 13:06:41 [28249] [26] DEBUG: SMPP PDU 0x4ea0170 dump: 2011-01-15 13:06:41 [28249] [26] DEBUG: type_name: bind_transceiver 2011-01-15 13:06:41 [28249] [26] DEBUG: command_id: 9 = 0x0009 2011-01-15 13:06:41 [28249] [26] DEBUG: command_status: 0 = 0x 2011-01-15 13:06:41 [28249] [26] DEBUG: sequence_number: 13 = 0x000d 2011-01-15 13:06:41 [28249] [26] DEBUG: system_id: 12345 2011-01-15 13:06:41 [28249] [26] DEBUG: password: 12345 2011-01-15 13:06:41 [28249] [26] DEBUG: system_type: vma 2011-01-15 13:06:41 [28249] [26] DEBUG: interface_version: 52 = 0x0034 2011-01-15 13:06:41 [28249] [26] DEBUG: addr_ton: 0 = 0x 2011-01-15 13:06:41 [28249] [26] DEBUG: addr_npi: 1 = 0x0001 2011-01-15 13:06:41 [28249] [26] DEBUG: address_range: NULL 2011-01-15 13:06:41 [28249] [26] DEBUG: SMPP PDU dump ends. 2011-01-15 13:06:41 [28249] [26] DEBUG: SMPP[opensmppbox]: Sending PDU: 2011-01-15 13:06:41 [28249] [26] DEBUG: SMPP PDU 0x4ea38a0 dump: 2011-01-15 13:06:41 [28249] [26] DEBUG: type_name: bind_transceiver_resp 2011-01-15 13:06:41 [28249] [26] DEBUG: command_id: 2147483657 skype:2147483657 = 0x8009 2011-01-15 13:06:41 [28249] [26] DEBUG: command_status: 13 = 0x000d 2011-01-15 13:06:41 [28249] [26] DEBUG: sequence_number: 13 = 0x000d 2011-01-15 13:06:41 [28249] [26] DEBUG: system_id: NULL 2011-01-15 13:06:41 [28249] [26] DEBUG: SMPP PDU dump ends. 2011-01-15 13:06:42 [28249] [26] ERROR: Invalid SMPP PDU received. 2011-01-15 13:06:42 [28249] [26] DEBUG: Thread 26 (opensmppbox.c:smpp_to_bearerbox) terminates. 2011-01-15 13:06:43 [28249] [25] DEBUG: Thread 25 (opensmppbox.c:function) terminates. Client bearerbox log 2011-01-14 14:19:13 [20507] [6] DEBUG: SMPP[ukserver]: Sending PDU: 2011-01-14 14:19:13 [20507]
sqlbox issue
Hii, I have configured sqlbox to sending the SMS and I am facing bearerbox connectivity issue. Kindly find the below smskannel.conf file parameters. *sqlbox --- bearerbox smsbox* # # THIS IS A SAMPLE CONFIGURATION FOR SMS KANNEL #- # CORE # # There is only one core group and it sets all basic settings # of the bearerbox (and system). You should take extra notes on # configuration variables like 'store-file' (or 'store-dir'), # 'admin-allow-ip' and 'access.log' group = core admin-port = 13000 smsbox-port = 13001 #smsbox-port = 13003 admin-password = demokannel status-password =demokannel #status-password = foo #admin-deny-ip = #admin-allow-ip = log-file = /var/log/kannel/bearerbox.log log-level = 0 box-deny-ip = *.*.*.* box-allow-ip = 127.0.0.1 #unified-prefix = +358,00358,0;+,00 access-log = /var/log/kannel/kannel_access.log store-file = /home/kannel.store #ssl-server-cert-file = cert.pem #ssl-server-key-file = key.pem #ssl-certkey-file = mycertandprivkeyfile.pem #dlr-storage= sqlbox sms-resend-freq=60 sms-resend-retry=5 #- # SMSC CONNECTIONS # # SMSC connections are created in bearerbox and they handle SMSC specific # protocol and message relying. You need these to actually receive and send # messages to handset, but can use GSM modems as virtual SMSCs group= smsc smsc = smpp smsc-id = demo host= 127.0.0.1 smsc-username= demo smsc-password= demo port = 1234 #receive-port= 1234 connect-allow-ip = 127.0.0.1 system-type= #address-range= #alt-charset=1 #alt-charset=ASCII source-addr-ton=1 source-addr-npi=1 dest-addr-ton=1 dest-addr-npi=1 #msg-id-type=0x01 allowed-smsc-id= demo #transceiver-mode=1 throughput= 10 group= smsc smsc = smpp smsc-id = demo host= 127.0.0.1 smsc-username= demo smsc-password= demo #port = 1234 receive-port= 1234 connect-allow-ip = 127.0.0.1 system-type= #address-range= #alt-charset=1 #alt-charset=ASCII source-addr-ton=1 source-addr-npi=1 dest-addr-ton=1 dest-addr-npi=1 #msg-id-type=0x01 allowed-smsc-id= demo #transceiver-mode=1 throughput= 10 # This is a fake smsc connection, _only_ used to test the system and services. # It really cannot relay messages to actual handsets! #--- # SMSBOX SETUP # # Smsbox(es) do higher-level SMS handling after they have been received from # SMS centers by bearerbox, or before they are given to bearerbox for delivery group = smsbox smsbox-id=dlrbox bearerbox-host = 127.0.0.1 sendsms-port = 13013 #sendsms-port = 13003 global-sender = demo #sendsms-chars = 0123456789 +- log-file = /var/log/kannel/smsbox.log log-level = 0 #access-log = /tmp/access.log http-request-retry=5 http-queue-delay=50 #- # SEND-SMS USERS # # These users are used when Kannel smsbox sendsms interface is used to # send PUSH sms messages, i.e. calling URL like # http://kannel.machine:13013/cgi-bin/sendsms?username=testerpassword=foobar. .. group = sendsms-user username = tester password = foobar #user-deny-ip = #user-allow-ip = concatenation = true default-smsc = demo #- # SERVICES # # These are 'responses' to sms PULL messages, i.e. messages arriving from # handsets. The response is based on message content. Only one sms-service is # applied, using the first one to match. group = sms-service keyword = nop accepted-smsc= demo text = You asked nothing and I did it! # -- SMS BOX ROUTE --- # group = smsbox-route smsbox-id = dlrbox smsc-id = demo # There should be always a 'default' service. This service is used when no # other 'sms-service' is applied. group = sms-service keyword = default text = 480 Characters with spaces concatenation = true max-messages = 5 group = mysql-connection id = mydlr host = localhost username = root password = root database = dlr group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-source = source field-destination = destination field-service = service field-url = url field-mask = mask field-status = status field-boxc-id= boxc ##sqlbox .conf# group = sqlbox id = sqlbox-db smsbox-id = sqlbox #global-sender = bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = /var/log/kannel/kannel-sqlbox.log log-level = 0 #ssl-client-certkey-file = #ssl-server-cert-file = #ssl-server-key-file = #ssl-trusted-ca-file = # Database connection examples. Please uncomment as needed # Example MYSQL Connection group = mysql-connection id = sqlbox-db host = localhost username = root password = sqladmin database = smart_kannel so kindly let me if any wrong parameters I have mention.
Re: kannel-sqlbox.log issue:
Hii Rene,
I have resolved this listing 13001 issue.
When I am sending one messages using below mysql command i have checked
dlr_url parameters did not call i also got the testing message in my cell.
INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, smsc_id,
dlr_mask, *dlr_url*)
VALUES ('MT', 'XX', '919XX', 'SQLBOX TESTING SERVER', 2,
'', 23,
*'
http://127.0.0.1/dlrNEW.php?%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26BatchID%3DTEST-12345
'*);
Kindly let me know why dlr_url not call.
On Fri, Mar 16, 2012 at 12:44 AM, Rene Kluwen rene.klu...@chimit.nl wrote:
It means that bearerbox is not listening on port 13001 of the current host.
What is your config?
** **
== Rene
** **
*From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On
Behalf Of *Ravindra Gupta // Viva
*Sent:* Thursday, 15 March, 2012 13:18
*To:* users-requ...@kannel.org; users@kannel.org; users-ow...@kannel.org
*Subject:* kannel-sqlbox.log issue:
** **
hii,
** **
When we sent the messages using sqlbox we got given below error
in kannel-sqlbox.log file.
** **
** **
2012-03-16 10:30:03 [25024] [0] INFO: Added logfile
`/var/log/kannel/kannel-sqlbox.log' with level `0'.
2012-03-16 10:30:03 [25024] [0] INFO: MYSQL: Connected to server at
localhost.
2012-03-16 10:30:03 [25024] [0] INFO: MYSQL: server version 5.0.95, client
version 5.0.95.
2012-03-16 10:30:03 [25024] [0] DEBUG: Started thread 1
(sqlbox.c:sql_to_bearerbox)
2012-03-16 10:30:03 [25024] [1] DEBUG: Thread 1
(sqlbox.c:sql_to_bearerbox) maps to pid 25024.
2012-03-16 10:30:03 [25024] [1] DEBUG: Connecting to 127.0.0.1
2012-03-16 10:30:03 [25024] [1] ERROR: connect to 127.0.0.1 failed
2012-03-16 10:30:03 [25024] [1] ERROR: System error 111: Connection refused
2012-03-16 10:30:03 [25024] [1] ERROR: error connecting to server
`localhost' at port `13001'
2012-03-16 10:30:03 [25024] [1] DEBUG: Thread 1
(sqlbox.c:sql_to_bearerbox) terminates.
2012-03-16 10:31:54 [25024] [0] ERROR: SIGINT received, aborting program...
2012-03-16 10:31:54 [25024] [0] DEBUG: Immutable octet strings: 58.
** **
Re: kannel-sqlbox.log issue:
Hi Rene,
Thanks for your quick response.
*Please let me know how we can call the the dlr_url using sqlbox.*
On Fri, Mar 16, 2012 at 4:06 PM, Rene Kluwen rene.klu...@chimit.nl wrote:
Sqlox doesn’t call dlr url’s. Smsbox does that, but sqlbox doesn’t.
** **
== Rene
** **
*From:* Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com]
*Sent:* Friday, 16 March, 2012 05:14
*To:* Rene Kluwen
*Cc:* users-requ...@kannel.org; users@kannel.org; users-ow...@kannel.org
*Subject:* Re: kannel-sqlbox.log issue:
** **
** **
Hii Rene,
** **
I have resolved this listing 13001 issue.
** **
When I am sending one messages using below mysql command i have checked
dlr_url parameters did not call i also got the testing message in my cell.
** **
** **
INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, smsc_id,
dlr_mask, *dlr_url*)
VALUES ('MT', 'XX', '919XX', 'SQLBOX TESTING SERVER', 2,
'', 23,
*'
http://127.0.0.1/dlrNEW.php?%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26BatchID%3DTEST-12345
'*);
** **
Kindly let me know why dlr_url not call.
** **
On Fri, Mar 16, 2012 at 12:44 AM, Rene Kluwen rene.klu...@chimit.nl
wrote:
It means that bearerbox is not listening on port 13001 of the current host.
What is your config?
== Rene
*From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On
Behalf Of *Ravindra Gupta // Viva
*Sent:* Thursday, 15 March, 2012 13:18
*To:* users-requ...@kannel.org; users@kannel.org; users-ow...@kannel.org
*Subject:* kannel-sqlbox.log issue:
hii,
When we sent the messages using sqlbox we got given below error
in kannel-sqlbox.log file.
2012-03-16 10:30:03 [25024] [0] INFO: Added logfile
`/var/log/kannel/kannel-sqlbox.log' with level `0'.
2012-03-16 10:30:03 [25024] [0] INFO: MYSQL: Connected to server at
localhost.
2012-03-16 10:30:03 [25024] [0] INFO: MYSQL: server version 5.0.95, client
version 5.0.95.
2012-03-16 10:30:03 [25024] [0] DEBUG: Started thread 1
(sqlbox.c:sql_to_bearerbox)
2012-03-16 10:30:03 [25024] [1] DEBUG: Thread 1
(sqlbox.c:sql_to_bearerbox) maps to pid 25024.
2012-03-16 10:30:03 [25024] [1] DEBUG: Connecting to 127.0.0.1
2012-03-16 10:30:03 [25024] [1] ERROR: connect to 127.0.0.1 failed
2012-03-16 10:30:03 [25024] [1] ERROR: System error 111: Connection refused
2012-03-16 10:30:03 [25024] [1] ERROR: error connecting to server
`localhost' at port `13001'
2012-03-16 10:30:03 [25024] [1] DEBUG: Thread 1
(sqlbox.c:sql_to_bearerbox) terminates.
2012-03-16 10:31:54 [25024] [0] ERROR: SIGINT received, aborting program...
2012-03-16 10:31:54 [25024] [0] DEBUG: Immutable octet strings: 58.
** **
kannel-sqlbox.log issue:
hii, When we sent the messages using sqlbox we got given below error in kannel-sqlbox.log file. 2012-03-16 10:30:03 [25024] [0] INFO: Added logfile `/var/log/kannel/kannel-sqlbox.log' with level `0'. 2012-03-16 10:30:03 [25024] [0] INFO: MYSQL: Connected to server at localhost. 2012-03-16 10:30:03 [25024] [0] INFO: MYSQL: server version 5.0.95, client version 5.0.95. 2012-03-16 10:30:03 [25024] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2012-03-16 10:30:03 [25024] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 25024. 2012-03-16 10:30:03 [25024] [1] DEBUG: Connecting to 127.0.0.1 2012-03-16 10:30:03 [25024] [1] ERROR: connect to 127.0.0.1 failed 2012-03-16 10:30:03 [25024] [1] ERROR: System error 111: Connection refused 2012-03-16 10:30:03 [25024] [1] ERROR: error connecting to server `localhost' at port `13001' 2012-03-16 10:30:03 [25024] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) terminates. 2012-03-16 10:31:54 [25024] [0] ERROR: SIGINT received, aborting program... 2012-03-16 10:31:54 [25024] [0] DEBUG: Immutable octet strings: 58.
Message rejected by bearerbox, no router!
Hello, I am using sqlbox and bearerbox, when I am sending the messages I have got error as given below in bearerbox.log. Kindly help me 2012-03-10 04:07:00 [9875] [9] WARNING: Cannot find SMSCConn for message to 919X, rejected. 2012-03-10 04:07:00 [9875] [9] WARNING: Message rejected by bearerbox, no router! 2012-03-10 04:07:00 [9875] [9] DEBUG: send_msg: sending msg to boxc: sqlbox 2012-03-10 04:07:00 [9875] [9] DEBUG: boxc_receiver: sms received 2012-03-10 04:07:00 [9875] [9] WARNING: Cannot find SMSCConn for message to 919X, rejected. 2012-03-10 04:07:00 [9875] [9] WARNING: Message rejected by bearerbox, no router! 2012-03-10 04:07:00 [9875] [9] DEBUG: send_msg: sending msg to boxc: sqlbox 2012-03-10 04:07:00 [9875] [9] DEBUG: boxc_receiver: sms received 2012-03-10 04:07:00 [9875] [9] WARNING: Cannot find SMSCConn for message to 919XX, rejected. 2012-03-10 04:07:00 [9875] [9] WARNING: Message rejected by bearerbox, no router! 2012-03-10 04:07:00 [9875] [9] DEBUG: send_msg: sending msg to boxc: sqlbox
SQLBOX CONFIGURATION
Hii, How to configure SQLBOX in kannel 1.5.0 gateway.
Kannel Daemon Issue:
Hii,
I have created script file for kannel daemon.when I have run .sh file I
have got given below error.
*Starting bearer service (gateway kannel 1.5.0): Usage: named
{start|stop|status|restart}
Starting smsbox service (gateway kannel 1.5.0): Usage: named
{start|stop|status|restart}
*
---
*Kannel Startup Script as given below:
*
#!/bin/sh
#
# gateway This shell script takes care of starting and stopping
# the Kannel WAP gateway (bearer/wapbox)
#
# chkconfig: 2345 97 03
# description: Start and stop the Kannel WAP gateway used to fetch \
# some WML content from a Web server compile it \
# into WMLC mobile phone bytecode.
# probe: true
# Use start-stop-daemon
ver=1.40
BBOX=/usr/local/sbin/bearerbox
SBOX=/usr/local/sbin/smsbox
START=/root/kannel/gateway-1.5.0/utils/start-stop-daemon --start
--background --quiet --exec
STOP=/root/kannel/gateway-1.5.0/utils/start-stop-daemon --stop --quiet
--oknodo --exec
CONF=/etc/smskannel.conf
[ $# -eq 2 ] ver=$2
# Source function library.
. /etc/rc.d/init.d/functions
# Source networking configuration.
. /etc/sysconfig/network
# Check that networking is up.
[ ${NETWORKING} = no ] exit 0
[ -x $BBOX ] || exit 0
[ -x $SBOX ] || exit 0
[ -f $CONF ] || exit 0
RETVAL=0
# See how we were called.
case $1 in
start)
# Start daemons.
echo -n Starting bearer service (gateway kannel $ver):
$START $BBOX -- $CONF
RETVAL1=$?
sleep 1 # Sleep for a while before we try to start smsbox
echo
echo -n Starting smsbox service (gateway kannel $ver):
$START $SBOX -- $CONF
RETVAL2=$?
echo
echo
[ $RETVAL1 -eq 0 -a $RETVAL2 -eq 0 ] touch
/var/lock/subsys/gateway ||\
RETVAL=1
;;
stop)
# Stop daemons.
echo -n Shutting down smsbox (kannel $ver):
$STOP $SBOX
RETVAL2=$?
echo
echo -n Shutting down bearerbox (kannel $ver):
$STOP $BBOX
RETVAL1=$?
echo
[ $RETVAL1 -eq 0 -a $RETVAL2 -eq 0 ] rm -f
/var/lock/subsys/gateway
echo
;;
status)
status bearerbox
status smsbox
exit $?
;;
restart)
$0 stop
sleep 1
$0 start
;;
*)
echo Usage: named {start|stop|status|restart}
exit 1
esac
exit $RETVAL
Re: Kannel Daemon Issue:
HI, Can u provide some sample scripts to start or stop kannel script in startup.
Daemon Conversion
hii, How to make process smsbox and bearerbox as daemon.. Kindly help for this.
kannel Url using Command Mode
Hi Team, I have sent messages using kannel sms url i.e http://10.0.0.12:13013/cgi-bin/sendsms?username=kannel2password=kannel123from=91Xtestto=91XXsmsc=TESTtext=Hello%20testingdlr-mask=23http://180.179.105.229:13013/cgi-bin/sendsms?username=vivakannel2password=vi10@87*(9)from=testto=919821466406+919819992242smsc=viva_IGWAtext=Hello%20testingdlr-mask=23 this is http web request. I dont want to use http request so kindly let me know if there any other procedure to send messages for eg. i.e command mode .
Create XML page on daily basis
hii, How to create status.xml page on daily basis in kannel 1.4.3 gateway. Kindly help.
Send WAP PUSH SMS
hii, How to send WAP push sms using kannel server 1.4.3. http://127.0.0.1:13013/cgi-bin/sendsms?username=kannelpassword=from=TESTto=919Xsmsc=testdemodlr-mask=23udh=%06%05%04%C3%4F%00%00text=%http:/ /google.com
Transmitter and Receiver as two different server
hi, I am using kannel 1.4.3 ,how to send messages in two different server means we have configure two server one server as a transmitter and other server as a receiver. kindly provide the help for the same.
Re: Transmitter and Receiver as two different server
Dear Alejandro, Thanks for your response. I already use kannel server for last 3 years, i have bind transmitter and receiver in same server (smskannel.conf) file. I want to change transmitter and receiver in different server means messages going on one server and (submit_sm) and receive response (submit_sm_respo) from other server. Kindly help me for the same.
increase store file size on kannel server
Hiii, I am using kannel 1.4.3, how to increase kannel.store file size on kannel server. give me some advice for the same. Thanks Ravindra Gupta
Enquiry regarding kannel version
which is the latest kannel version running currently in the market. Which all Kannel versions supports ussd_service-op parameter
smsbox automatic shutdown
hii, if we start the smsbox service so that we got below error, # smsbox -v 0 smskannel.conf 2011-01-18 22:53:50 [22982] [0] ERROR: connect failed 2011-01-18 22:53:50 [22982] [0] ERROR: System error 111: Connection refused 2011-01-18 22:53:50 [22982] [0] ERROR: error connecting to server `127.0.0.1' at port `13001' 2011-01-18 22:53:50 [22982] [0] PANIC: Couldn't connect to the bearerbox. 2011-01-18 22:53:50 [22982] [0] PANIC: smsbox(gw_panic+0xc2) [0x80872c2] 2011-01-18 22:53:50 [22982] [0] PANIC: smsbox(main+0xf31) [0x8053e71] 2011-01-18 22:53:50 [22982] [0] PANIC: /lib/libc.so.6(__libc_start_main+0xdc) [0x983e9c] 2011-01-18 22:53:50 [22982] [0] PANIC: smsbox [0x8052791] Please check the issue and give suggestion.
bearerbox error
-hii, we have found this error. 2011-01-06 11:41:22 [7239] [0] ERROR: connect failed 2011-01-06 11:41:22 [7239] [0] ERROR: System error 111: Connection refused 2011-01-06 11:41:22 [7239] [0] ERROR: error connecting to server `127.0.0.1' at port `13001' 2011-01-06 11:41:22 [7239] [0] PANIC: Couldn't connect to the bearerbox. 2011-01-06 11:41:22 [7239] [0] PANIC: ./smsbox(gw_panic+0xc2) [0x80872c2] 2011-01-06 11:41:22 [7239] [0] PANIC: ./smsbox(main+0xf31) [0x8053e71] 2011-01-06 11:41:22 [7239] [0] PANIC: /lib/i686/nosegneg/libc.so.6(__libc_start_main+0xdc) [0x5f0e9c] 2011-01-06 11:41:22 [7239] [0] PANIC: ./smsbox [0x8052791] give me some advice.
USSD REQUEST
Hii, How to configure Kannel to send/receive USSD request?
[no subject]
hiii, I am using kannel 1.4.3, i need some below suggestion. 1) Some times my smsbox automatic shutdown.i dont know where we will check the logs. 2) Can you inform me why smsbox was goes down any reason for the same. i am waiting for your response.
smsbox automatic shutdown
hiii, I am using kannel 1.4.3, i need some below suggestion. 1) Some times my smsbox automatic shutdown.i dont know where we will check the logs. 2) Can you inform me why smsbox was goes down any reason for the same. i am waiting for your response.
Re: smsbox automatic shutdown
Dear Mohammed, Thanks for your response. But i dont know how to set log level to zero can you provide some parameters so that we will work on the same. set the smsbox log level to zero in the smsbox config, for more info check the UG, then post the crash log here. I had a similar problem which caused by an assertion failure, tried to solve it but didn't achieve any solution, it happens rarely so I ran the smsbox from a bash script into an infinite loop so each time it crashes it restarts automatically #!/bin/sh while : do smsbox -v 5 done Hope this helps Best Regards, Mohammed M I Sleem http://www.abusleem.net - Personal blog http://www.freakle.com - The Search Freak
Re: smsbox automatic shutdown
Dear Mohammed, This is a path of our kannel server,in this path we find smskannel.conf file but i am not found smsbox.config file. cd /home/kannel/kannel1.4.3/gateway-1.4.3/gw kindly provide me some parameters On Sun, Jan 2, 2011 at 4:35 PM, Mohammed Saleem mohammedsl...@gmail.comwrote: check the UG, see the smsbox group configurations Best Regards, Mohammed M I Sleem http://www.abusleem.net - Personal blog http://www.freakle.com - The Search Freak http://www.colorle.com On Sun, Jan 2, 2011 at 1:02 PM, Ravindra Gupta // Viva ravin...@vivainfomedia.com wrote: Dear Mohammed, Thanks for your response. But i dont know how to set log level to zero can you provide some parameters so that we will work on the same. set the smsbox log level to zero in the smsbox config, for more info check the UG, then post the crash log here. I had a similar problem which caused by an assertion failure, tried to solve it but didn't achieve any solution, it happens rarely so I ran the smsbox from a bash script into an infinite loop so each time it crashes it restarts automatically #!/bin/sh while : do smsbox -v 5 done Hope this helps Best Regards, Mohammed M I Sleem http://www.abusleem.net - Personal blog http://www.freakle.com - The Search Freak
Re: smsbox automatic shutdown
Dear Mohammed, I already mention smsboc.config file as below parameters. loglevel = 0; please check the above parameters. On Sun, Jan 2, 2011 at 4:43 PM, Ravindra Gupta // Viva ravin...@vivainfomedia.com wrote: Dear Mohammed, This is a path of our kannel server,in this path we find smskannel.conf file but i am not found smsbox.config file. cd /home/kannel/kannel1.4.3/gateway-1.4.3/gw kindly provide me some parameters On Sun, Jan 2, 2011 at 4:35 PM, Mohammed Saleem mohammedsl...@gmail.comwrote: check the UG, see the smsbox group configurations Best Regards, Mohammed M I Sleem http://www.abusleem.net - Personal blog http://www.freakle.com - The Search Freak http://www.colorle.com On Sun, Jan 2, 2011 at 1:02 PM, Ravindra Gupta // Viva ravin...@vivainfomedia.com wrote: Dear Mohammed, Thanks for your response. But i dont know how to set log level to zero can you provide some parameters so that we will work on the same. set the smsbox log level to zero in the smsbox config, for more info check the UG, then post the crash log here. I had a similar problem which caused by an assertion failure, tried to solve it but didn't achieve any solution, it happens rarely so I ran the smsbox from a bash script into an infinite loop so each time it crashes it restarts automatically #!/bin/sh while : do smsbox -v 5 done Hope this helps Best Regards, Mohammed M I Sleem http://www.abusleem.net - Personal blog http://www.freakle.com - The Search Freak
[no subject]
hiii, I am using kannel server,how to store bulk sms traffic in store.conf file. some time kannel is goes down on the same case my que is not store in this file. give me guidence for the same.
sms traffic in store.conf file
hiii, I am using kannel server,how to store bulk sms traffic in store.conf file. some time kannel is goes down on the same case my que is not store in this file. give me guidence for the same.
[no subject]
hi i am using kannel 1.4.3.i asking few question as given below: 1) how to manage the que using kannel.if any parametrs required ?? 2) how many sms traffix will be supported by kannel. 3) how to improve performance of kannel.
how to SMS que management
hi i am using kannel 1.4.3.i asking few question as given below: 1) how to manage the que using kannel.if any parametrs required ?? 2) how many sms traffix will be supported by kannel. 3) how to improve performance of kannel.
Re: users Digest, Vol 51, Issue 63
Dear Team, I am using kannel 1.4.3 .i will be send port(5000) wise message give me some suggestion. On Fri, Nov 19, 2010 at 3:00 PM, users-requ...@kannel.org wrote: Send users mailing list submissions tot users@kannel.org To subscribe or unsubscribe via the World Wide Web, visit http://www.kannel.org/mailman/listinfo/users or, via email, send a message with subject or body 'help' to users-requ...@kannel.org You can reach the person managing the list at users-ow...@kannel.org When replying, please edit your Subject line so it is more specific than Re: Contents of users digest... Today's Topics: 1. Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug (Willy Mularto) -- Message: 1 Date: Fri, 19 Nov 2010 16:30:08 +0700 From: Willy Mularto sangpr...@gmail.com To: Peter p...@locosms.gr Cc: Kannel Users us...@vm1.kannel.org Subject: Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug Message-ID: 43565e68-0e59-4b61-990f-aa474585e...@gmail.com Content-Type: text/plain; charset=utf-8 http://www.mail-archive.com/de...@kannel.org/ http://www.mail-archive.com/users@kannel.org/ sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Nov 19, 2010, at 4:26 PM, Peter wrote: Hi, excuse my ignorance but i do not know where the devel archives are in the svn (is it something like .../sqlbox/devel?), where do i find the patch and how to apply it. Is it possible to guide me on that? why this patch was not commited into trunk yet? Best regards 19-11-2010, ? ???, ??? ??? 07:34 +0700, ?/? Willy Mularto ??: Rene has the patch for the issue. Please check the devel archives. sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Nov 19, 2010, at 1:19 AM, Alejandro Guerrieri wrote: Hrm, no, that DLR doesn't even include single quotes, that's an artifact from the log. On Thu, Nov 18, 2010 at 6:51 PM, Peter p...@locosms.gr wrote: Alejandro, I send you the requested dump plus typical log files ... 18-11-2010, ? ???, ??? ??? 18:31 +0100, ?/? Alejandro Guerrieri ??: It's probably an issue with single quotes on dlr text. Can you provide a full pdu dump for the DLR? Regards, Alex On Thu, Nov 18, 2010 at 6:21 PM, Peter p...@locosms.gr wrote: Dear friends, I found that in the last patch still reproduces 2010-11-18 18:29:01 [10182] [3] DEBUG: smsbox_to_bearerbox: sms received 2010-11-18 18:29:01 [10182] [4] ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id:1219071490 sub:001 dlvrd:001 submit date:1011181629 done date:1011181629 sta' at line 1 2010-11-18 18:29:09 [10182] [4] ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id:1219071490 sub:001 dlvrd:001 submit date:1011181729 done date:1011181629 sta' at line 1 Can you verify that this is a problem of null (or something else?). In this case dlrs are received by our application using smssend == smsbox ==sqlbox==bearer box but records are not inserted in mysql sent-sms table. Please check. Best regards Peter Kontopoulos 14-11-2010, ? ???, ??? ??? 19:45 +0700, ?/? Willy Mularto ??: I have used the latest SVN to work with Kannel early 2009 CVS version (1 version before 1.4.3 was released). I found it still reproduce my previous error. I think I need to use the same Kannel SVN as well. So I re apply patch from Rene :) sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Nov 12, 2010, at 9:46 PM, Alejandro Guerrieri wrote: Sure, let me give you a couple of hints: * url-encode msgdata and udhdata, for example: udh = %06%05%04%0B%84%23%F0 msgdata = %1B%06%01%AE%02%05%6A... * You'll probably need to set alt_dcs = 1 Hope it helps, Alex On Fri, Nov 12, 2010 at 3:13 PM, Willy Mularto sangpr...@gmail.com wrote: Will play with it tonight and hope those errors disapear and hopefully no need to use sendsms to send wap push anymore. Many thanks to Alex, Rene and all Kannel project+addons developers. sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Nov 12, 2010, at 9:03 PM, Alejandro Guerrieri wrote: Yes, it url-encodes msgdata and udhdata when saving, and url-decodes when reading. It also allows wap pushes to work btw. Regards, Alex On Fri, Nov 12, 2010 at 2:59 PM, Rene Kluwen rene.klu...@chimit.nl wrote: Does it also encode normal text messages? Because those are the case, here. == Rene From: Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com] Sent: Friday, 12
port wise messages
I am using kannel 1.4.3 version.now we will send the message on particular mobile port 5000 .Give me any parameters or any hints where we are send the OTA message on particular 5000 mobile port.
Increase windows size in Kannel
Dear Team, I am using kannel 1.4.3 Please conform us.How to increase windows size on kannel. -- Incase of any further queries, Please feel free to mail me or contact me on the numbers provided below. Thanks Regards, Ravindra Gupta Technical Support Viva Infomedia Pvt. Ltd. 242, Oshiwara Industrial Centre, New Link Road, Opp. Oshiwara Bus Depot, Goregaon West, Mumbai 400104. Direct: +91.22.40310353 Board: +91.22.40310310 Email : ravin...@vivainfomedia.com Viva Infomedia: Awarded as Best SME (E-Commerce) at CNBC Emerging India Awards 2009
