, sent 0
DLR: inbound (0.51,0.51,0.54) msg/sec, outbound (0.00,0.00,0.00) msg/sec
DLR: 2339007 queued, using mysql storage
your assistance would be of greatvalue
Chris
--
Tervitades/Best Wishes,
Gert Tamm
Süsteemiadministraator/System administrator
E-mail: g...@messenger.ee
Direct Messenger OÜ
Hello support,
Am wondering how to delete/flush queued dlrs as its showing in my status
and seems to be slowing down things
DLR: received 1109, sent 0
DLR: inbound (0.51,0.51,0.54) msg/sec, outbound (0.00,0.00,0.00) msg/sec
DLR: 2339007 queued, using mysql storage
your assistance would
t;
Cc: "users" <users@kannel.org>
Subject: Re: HUGE DRL QUEUE MYSQL STORAGE
thanks for your response.I would like to know what effects this might have when
the DB is that big? and does it mean that its failing to match dlrs from
operator. is their a validity period i can put in ka
. You can clear that
queue by deleting the entry from that table.
-Original Message-
From: "christopher kamutumwa" <chriskamutu...@gmail.com>
Sent: 08-07-2017 06:38
To: "users" <users@kannel.org>
Subject: HUGE DRL QUEUE MYSQL STORAGE
Hello Team
I hav
: 753643 queued, using mysql storage
Regards,
Chris
Thanks for your reply. But I haven't complied from source, I used yum to
install kannel.
what to do in this case?
Kind Regards,
*Ali Ansari*
Better to compile from source. Its pretty much straight forward and fairly easy
Sent from Samsung Mobile.
Original message
From: Ali Ansari
Date:26/02/2014 1:18 PM (GMT+05:00)
To: John alero
Cc: users@kannel.org
Subject: Re: MySQL Storage Fails
Thanks for your reply. But I
Hello,
When I try to run kannel with dlr-storage = mysql, it simply doesn't
start, and log files don't say anything, I have love level at 0, but the
deamon simply doesn't even start, thus no logging, and I don't know what
is wrong.
I have below for my mysql configuration in kannel.conf:
Dear Ali,
When you compile the source code use below command.
#./configure --with-mysql --with-mysql-dlr=/usr/include/mysql/mysql.h
And then check for the same.
On Wed, Feb 26, 2014 at 6:04 AM, Ali Ansari mydi...@gmail.com wrote:
Hello,
When I try to run kannel with dlr-storage =
dear list
pl help
i am getting a message when i open status page of kannel.
*DLR: 2578 queued, using mysql storage*
why it is being, how can i clear queued message, i am using sqlbox for
sending message.
regards
abhi
It might be you set dlr-mask and your telco does't enable the DLR and Kannel
keeps waiting for the final DLR from telco.
On Dec 5, 2012, at 3:21 PM, alok srivastava wrote:
dear list
pl help
i am getting a message when i open status page of kannel.
DLR: 2578 queued, using mysql storage
Hello,
I wish to know what is the suitable mysql engine(MYISAM or INNODB) for dlr
and sqlbox (send_sms and sent_sms table) from kannel. I currently have high
load of traffic and RAM is not a problem.
Please suggest.
--
Regards,
Ashish
We are using InnoDB. It works just fine with dlr and send_sms, sent_sms
tables. InnoDB comparing to MyISAM is more fault proof, so I'd recommend
using it, every insert is a transaction, so theoritacally you won't lose
more than 1 transaction if something bad happens.
Don't forget to add relevant
Hello,
Thanks for your response. What are the fields that should be indexed?
On Fri, Mar 23, 2012 at 12:54 AM, spameden spame...@gmail.com wrote:
We are using InnoDB. It works just fine with dlr and send_sms, sent_sms
tables. InnoDB comparing to MyISAM is more fault proof, so I'd recommend
mysql show indexes from kannel.dlr;
+---++-+--+-+---+-+--++--++-+---+
| Table | Non_unique | Key_name| Seq_in_index | Column_name |
Collation |
And how much concurrent connection i.e. max-connection is recommended for
high traffic when using innodb.
On Fri, Mar 23, 2012 at 12:59 AM, spameden spame...@gmail.com wrote:
mysql show indexes from kannel.dlr;
not quite sure about this, we are using 10.
the speed mostly depends on your smsc provider(s) actually
2012/3/22 Ashish Agarwal ashisha...@gmail.com
And how much concurrent connection i.e. max-connection is recommended for
high traffic when using innodb.
On Fri, Mar 23, 2012 at 12:59 AM,
If you need speed (store more than 100 records per second, give a
look to 'INSERT DELAYED' (only MyISAM)
later I will suggest to first normalize the DB, and based on your
queries made by your frontend/application crete your indexes.
either MyISAM/INODB *sql, you will need to implement a queue
Hi everyone.
im trying to work with Kannel since some month now and ive successfull
let it work as the company where i work want.. now.. my next step is
save SMS into a DB so ive recompiled Kannel with latest SVN (yesterday
06/12/11) with mysql option enabled (and ofc mysql-devel installed).
Hi everyone.
im trying to work with Kannel since some month now and ive successfull
let it work as the company where i work want.. now.. my next step is
save SMS into a DB so ive recompiled Kannel with latest SVN (yesterday
06/12/11) with mysql option enabled (and ofc mysql-devel installed).
Hello,
Mysql db in Kannel is used to handle dlr report not to store all sms.
Have a look to playsms you may find some usefull features.
All sms will be stored in mysql db.
Playsms.org
Playsms-mc.mediacom.nc
Br
Emmanuel
Le 7 déc. 2011 20:51, Supporto Tecnico - Crazy Network
Ok, thanks a lot :)
Il 07/12/2011 11:08, Emmanuel CHANSON ha scritto:
Hello,
Mysql db in Kannel is used to handle dlr report not to store all sms.
Have a look to playsms you may find some usefull features.
All sms will be stored in mysql db.
Playsms.org
Playsms-mc.mediacom.nc
Hi,
you can install sqlbox, and you get a table called sent_sms with all
sms sent and DLR.
Cheers.
El mié, 07-12-2011 a las 10:49 +0100, Supporto Tecnico - Crazy Network
escribió:
Hi everyone.
im trying to work with Kannel since some month now and ive successfull
let it work as the
Ive managed to solve every problem using playsms with kannel.
Everything now is working great, have just to correctly configure
playsms for the forwarders :)
Regards
Il 07/12/2011 14:42, Carlos Massoglia Lillo ha scritto:
Hi,
you can install sqlbox, and you get a table called sent_sms
Just for stay on same topic.
Anyone of you have also experience with playsms or you suggest to
write on their own ml?
Thanks
Il 07/12/2011 14:42, Carlos Massoglia Lillo ha scritto:
Hi,
you can install sqlbox, and you get a table called
Hi,
I know of one Emmanuel Chanson. He could really be helpful in matters
pertaining PlaySMS. One question to the Kannelers, is it ok to discuss here
about Kannel integration scripts like PlaySMS?
Kind Regards,
Joseph Koech
On Wed, Dec 7, 2011 at 7:27 PM, Supporto Tecnico - Crazy Network
*To:* users users@kannel.org
*Sent:* Friday, December 04, 2009 11:54 AM
*Subject:* Re: Kannel CVS and DLRs MySQL storage / can not decode PDU to
a message
Thanks Nikos for your reply,
But I am a little bit surprised about
*As the rest goes, the advice is simple: Use another modem
or 2.
But it seems to me a waste of time.
BR,
Nikos
- Original Message -
*From:* Emmanuel CHANSON emmanuelchan...@gmail.com
*To:* users users@kannel.org
*Sent:* Friday, December 04, 2009 5:39 AM
*Subject:* Re: Kannel CVS and DLRs MySQL storage / can not decode PDU to
a message
you tried changing it?
Anyway, CMEE might be able to tell you more.
BR,
Nikos
- Original Message -
From: Emmanuel CHANSON
To: users
Sent: Friday, December 04, 2009 11:54 AM
Subject: Re: Kannel CVS and DLRs MySQL storage / can not decode PDU to a
message
Thanks Nikos
:* Friday, December 04, 2009 11:54 AM
*Subject:* Re: Kannel CVS and DLRs MySQL storage / can not decode PDU to
a message
Thanks Nikos for your reply,
But I am a little bit surprised about
*As the rest goes, the advice is simple: Use another modem.*
Siemens M20 is listed as a modem that works
Hi everybody,
Below an issue I am faced trying to configure DLR management and kannel.
Environnement:
Kannel CVS 20091124 installed using RPM patch from Alejandro
MySQL DLR storage configured
Issue: can not decode PDU to a message
I have configure DLR to use mysql (config file below)
I send a
Adding some informations,
I notice when using a Nokia 6230 on another kannel server that it works well
and I have the following:
== /var/log/kannel/access.log ==
2009-12-04 14:08:20 Receive DLR [SMSC:nokia6230] [SVC:alt] [ACT:] [BINF:]
[FID:48] [from:687971204] [to:+687773502]
Subject: Re: Kannel CVS and DLRs MySQL storage / can not decode PDU to a
message
Adding some informations,
I notice when using a Nokia 6230 on another kannel server that it works well
and I have the following:
== /var/log/kannel/access.log ==
2009-12-04 14:08:20 Receive DLR
Hi guys,
I have been searching in the list a lot regarding mysql storage issue. I
noticed that users complains are very similar (including mine that i`m not
able to configure mysql, in different machines as well), all of them using
the magic keyword DLR: storage type 'mysql' is not supported
with ./configure --with-mysql
Regards
Falko
Am 10.03.2009 um 10:42 schrieb Elton Hoxha:
Hi guys,
I have been searching in the list a lot regarding mysql storage issue. I
noticed that users complains are very similar (including mine that i`m not
able to configure mysql, in different
Ziemann fal...@gmail.com wrote:
Hi,
you have to install the mysql-dev package first and then compile (!) kannel
with ./configure --with-mysql
Regards
Falko
Am 10.03.2009 um 10:42 schrieb Elton Hoxha:
Hi guys,
I have been searching in the list a lot regarding mysql storage issue. I
Regards
Falko
Am 10.03.2009 um 10:42 schrieb Elton Hoxha:
Hi guys,
I have been searching in the list a lot regarding mysql storage
issue. I noticed that users complains are very similar (including
mine that i`m not able to configure mysql, in different machines as
well), all of them using
(!)
kannel with ./configure --with-mysql
Regards
Falko
Am 10.03.2009 um 10:42 schrieb Elton Hoxha:
Hi guys,
I have been searching in the list a lot regarding mysql storage issue. I
noticed that users complains are very similar (including mine that i`m not
able to configure mysql, in different
Try to install package like libmysql-devel
configure --with-mysql --with-mysql-dir=/path/to/libs
Regards,
Cezary
- Original Message -
From: Elton Hoxha
To: Falko Ziemann
Cc: kannel users
Sent: Tuesday, March 10, 2009 10:11 AM
Subject: Re: mysql storage frequent complains
:
Hi guys,
I have been searching in the list a lot regarding
mysql storage issue. I noticed that users complains
are very similar (including mine that i`m not able
to configure mysql
Regards
Falko
Am 10.03.2009 um 10:42 schrieb Elton Hoxha:
Hi guys,
I have been searching in the list a lot regarding
mysql storage issue. I noticed that users
Hi,
Kannel tries to connect to mysql server and fails. Try pgrep -fl mysqld and
if it's not running, start it.
BR,
Nikos
- Original Message -
From: Elton Hoxha
To: sangprabv
Cc: kannel users
Sent: Tuesday, March 10, 2009 12:58 PM
Subject: Re: mysql storage frequent
mysqld
and if it's not running, start it.
BR,
Nikos
- Original Message -
From: Elton Hoxha
To: sangprabv
Cc: kannel users
Sent: Tuesday, March 10, 2009 12:58 PM
Subject: Re: mysql storage frequent complains
Thanks my friends,
I managed to install it and run it. I dont know how
: Tuesday, March 10, 2009 12:58 PM
Subject: Re: mysql storage frequent complains
Thanks my friends,
I managed to install it and run it. I dont know how was gonna do it
without your help.
Anyway I`m receiving this bearerbox logs when I switch off the phone to
store the delivery report.
2009
hi !!
i'm using kannel and all works well(connection to the
simulator(smpp), sms sending and receiving), but
though i put the mysql storage i find the sms
in the table for only submit_sm. and if we can send the messages
through http we can set the dlr-mask value.but how we can set a
dlr_mask
www.perusms.NET www.smsglobal.com.mx y
www.pravcom.com
On Mon, Feb 16, 2009 at 11:00 AM, pandu reddy pandu.reddy...@gmail.com wrote:
hi !!
i'm using kannel and all works well(connection to the
simulator(smpp), sms sending and receiving), but
though i put the mysql storage i find the sms
in the table
field-boxc-id = boxc
Regards,
Remon
-Original Message-
From: Jovan Kostovski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2008 6:18 PM
To: Iain Dooley
Cc: users@kannel.org
Subject: Re: mysql storage
On Tue, Sep 9, 2008 at 4:09 PM, Iain Dooley [EMAIL PROTECTED] wrote
hi all, i've finalled gotten round to trying mysql storage. i compiled
mysql support in, and included the following in smskannel.conf:
group = mysql-connection
id = mydlr
host = localhost
username = kannel
password = kannel
database = kannel
max-connections = 1
group = dlr-db
id = mydlr
table
storage
hi all, i've finalled gotten round to trying mysql storage. i compiled
mysql support in, and included the following in smskannel.conf:
group = mysql-connection
id = mydlr
host = localhost
username = kannel
password = kannel
database = kannel
max-connections = 1
group = dlr-db
id = mydlr
On Tue, Sep 9, 2008 at 4:09 PM, Iain Dooley [EMAIL PROTECTED] wrote:
and then created a database kannel, with username kannel and password
kannel.
I'm using a table with all the fields as varchars. Works without any problems.
CHEERS, Jovan
:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2008 6:18 PM
To: Iain Dooley
Cc: users@kannel.org
Subject: Re: mysql storage
On Tue, Sep 9, 2008 at 4:09 PM, Iain Dooley [EMAIL PROTECTED] wrote:
and then created a database kannel, with username kannel and password
kannel.
I'm using a table
:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2008 6:18 PM
To: Iain Dooley
Cc: users@kannel.org
Subject: Re: mysql storage
On Tue, Sep 9, 2008 at 4:09 PM, Iain Dooley
[EMAIL PROTECTED] wrote:
and then created a database kannel, with username kannel and password
kannel.
I'm using a table
Hello,
Do you have a config example for MySQL storage ?
- config for kannel.conf
- SQL schema
Thanks ! ;)
Mickael.
= source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
-Original Message-
From: users@kannel.org [EMAIL PROTECTED]
Sent: 14 ? 2008 ?.
To: seik
Subject:MySQL Storage Example
Hello,
Do you have a config example for MySQL storage
Example
Hello,
Do you have a config example for MySQL storage ?
- config for kannel.conf
- SQL schema
Thanks !
Mickael.
Well, as I see, noone would like to reply to my e-mail (Sent on 25st
February, ~16:20; Subject: DLR handling).
So, anyway, I'd like to try once more, but now with another
question.
Is there any way to make Kannel work with MySQL 4.1.x? For now it
does not compile, because of
Do you have older mysql (3.23.x) installed, which must be tru should
you have chosen full OS installtion?
Compile kannel with the client library from 3.23 installation.
Once, the kannel is compiled, you can use it with mysql 4.1.x.
HTH
Navjot Singh
On Mon, 28 Feb 2005 11:47:50 +0200, Kaspars
prepend list-delete with 'gw'. This fix should be in cvs.
Aarno
On 28.2.2005, at 10:47, Kaspars Foigts wrote:
Well, as I see, noone would like to reply to my e-mail (Sent on 25st
February, ~16:20; Subject: DLR handling).
So, anyway, I'd like to try once more, but now with another
question.
: Using MySQL storage
sqlbox logs MO, MT and DLR messages.
Rene Kluwen
Chimit
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Pedro B.
Sent: vrijdag 19 maart 2004 0:31
To: [EMAIL PROTECTED]
Subject: Re: Using MySQL storage
Hello,
First of all, i apologise
Nowhere yet.
They are 'under construction'.
Rene Kluwen
Chimit
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Roman Alonso
Sent: dinsdag 23 maart 2004 14:05
To: 'Rene Kluwen'; 'Pedro B.'; [EMAIL PROTECTED]
Subject: RE: Using MySQL storage
Hello,
Where
sqlbox logs MO, MT and DLR messages.
Rene Kluwen
Chimit
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Pedro B.
Sent: vrijdag 19 maart 2004 0:31
To: [EMAIL PROTECTED]
Subject: Re: Using MySQL storage
Hello,
First of all, i apologise if this question
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Reto Hersiczky
Sent: vrijdag 5 maart 2004 1:34
To: [EMAIL PROTECTED]
Subject: Using MySQL storage
I want to store each SMS delivery log entry directly into a MySQL
table. I could verify Kannel is able to read from the related database
everything that has been waiting for me in the month that I have been
away from my desk.
Rene Kluwen
Chimit
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Reto Hersiczky
Sent: vrijdag 5 maart 2004 1:34
To: [EMAIL PROTECTED]
Subject: Using MySQL storage
I want
, using mysql storage
(I just played with that table so the 1 row has been inserted by me
not by the smsbox daemon.)
Although I can send SMS with
http://localhost:13002/cgi-bin/sendsms?to=0764611551username=foopassword=bartext=Hello
and Kannel confirms the built-in MySQL support is ready ...
Kannel
Hi Jarl,
I'm not sure but probably you mix up what Kannel do and what Kannel doesn't do
(which we must do or create ourselves).
1) If you need to store the outgoing SMS (and its DLR status), you need to
stop pursue using Kannel built-in dlr features (I might miss something, but
the group =
Last question before I accept I'm stupid and should not be bothering anyone
with more questions
there could have been my fault or version mismatch but as of 1.3.1, there
are 2 variables *dlrurl* and *dlrmask*.
I take it as I'm using kannel-cvs (a week or two old) the above still
applies,
Jarl,
I take it as I'm using kannel-cvs (a week or two old) the above still
applies, however I get the message
saying use dlr-mask in my smsbox... any ideas why?
There has been a move away from dlrmask to dlr-mask. In future releases
you will need to use the later.
Cheers,
Alan
0.9.6k
30 Sep 2003. Using MySQL 4.0.14. Using native malloc.
Status: running, uptime 0d 0h 22m 7s
WDP: received 0 (0 queued), sent 0 (0 queued)
SMS: received 0 (0 queued), sent 3 (0 queued), store size 0
SMS: inbound 0.00 msg/sec, outbound 0.00 msg/sec
DLR: 0 queued, using mysql
This is rather embarrassing, however after having read all the great replies
and thinking nothing can go wrong now, things still seem a bit odd.
However this is most likely due to some misunderstanding on my side, which
is why I'm going to try to clear this out once and for all.
You might
Jarlco,
You seems to be in hurry. Please calm down.
Read this link
http://www.kannel.org/download/1.3.1/userguide-1.3.1/userguide.html#AEN3199
Read the details of dlrurl an dlrmask here.
http://www.kannel.org/download/1.3.1/userguide-1.3.1/userguide.html#AEN3530
and think thoroughly.
2.
4.0.14. Using native malloc.
Status: running, uptime 0d 0h 22m 7s
WDP: received 0 (0 queued), sent 0 (0 queued)
SMS: received 0 (0 queued), sent 3 (0 queued), store size 0
SMS: inbound 0.00 msg/sec, outbound 0.00 msg/sec
DLR: 0 queued, using mysql storage
Box connections:
smsbox
, 2003 5:40 AM
To: [EMAIL PROTECTED]
Subject: Re: 0 queued, using mysql storage (PLEASE Check this thread
again)
I've found an old post by Navjot Singh, in the thead at:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg00909.html
Now this is very interesting, however I've got some questions
: 0 queued, using mysql storage
Box connections:
smsbox:(none), IP 127.0.0.1 (0 queued), (on-line 0d 0h 14m 6s)
SMSC connections:
wavecom_1AT2[wavecom_1] (online 1327s, rcvd 0, sent 3, failed 0,
queued 0 msgs)
and my config file looks like
queued), sent 0 (0 queued)
SMS: received 0 (0 queued), sent 3 (0 queued), store size 0
SMS: inbound 0.00 msg/sec, outbound 0.00 msg/sec
DLR: 0 queued, using mysql storage
Box connections:
smsbox:(none), IP 127.0.0.1 (0 queued), (on-line 0d 0h 14m 6s)
SMSC connections:
wavecom_1AT2[wavecom_1
hi i am using kannel-1.2.0 with CMG smsc and my problem remain the same as it is going
to the default service anyhow even i defined so many and another problem is it is not
storing DLR into mysql my kannel.conf is look like that and it is running fine without
file-syntax error ..
#
75 matches
Mail list logo
