Well, dlr's should be deleted from the db when you receive the final
notification. Perhaps you should adjust the dlr-mask to not wait for dlr's
you're not getting from the carrier.
Regards,
Alejandro
On Thu, May 14, 2009 at 10:50 AM, jyotiranjan panda tell2jy...@gmail.comwrote:
Hi,
I am
Hi Alejandro,
Let me explain my problem clearly.
When I am sending bulk MTs to smsc, kannel starts stores them in db after
getting the response of MTs and when dlr comes for respective MTs it search
in the db and delete it from db.
And when there is data of 20k/30k in db I noticed bearerbox
do you have proper indexes on columns?
Regards,
- Original Message -
From: jyotiranjan panda tell2jy...@gmail.com
To: Alejandro Guerrieri alejandro.guerri...@gmail.com
Cc: users@kannel.org
Sent: 14 May 2009 10:49
Subject: Re: dlr-storage = mysql makes kannel slow ?
Hi Alejandro
If you are using InnoDB tables, make sure you have pre-allocated enough
InnoDB space to make sure that it doesn't need to allocate while you are
sending a batch.
If you are using MyISAM tables make sure that you don't have too many
indexes as this will cause some speed issues too.
Thanks,
Donald
Patrick,
The dlr storage is temporary. In other words, kannel stores the DLR's into
the database only while they're being processed. Once a final (delivered
or failed) state is reached, the row is deleted.
If you want to keep the data, you should do so on the script that is called
on the dlr-url.
Or you can apply SQLBox to do this.
Willy
Hi,
in 1.4.3 where is the sqlbox .and how can i use the sqlbox .and how can i
set the configarations for sqlbox.
On Fri, Mar 6, 2009 at 3:10 PM, sangprabv sangpr...@gmail.com wrote:
Or you can apply SQLBox to do this.
Willy
--
Best Regards,
SQLBox is an independent subsystem for Kannel. You may get it from here
http://www.kannel.org/~aguerrieri/SqlBox/
Willy
take a look in the dlr-url and dlr-mask parameter when you send a sms.
basically, you have to put you dlr-mask to 31 to have all the dlr (your
operator have to support as well), and all the dlr will be forward to the
url defined by dlr-url (must be url encoded)
hope it helps
_
Did you add dlr-storage = mysql line to core group?
On 8/7/07, Nicholas Amorim [EMAIL PROTECTED] wrote:
Hello people! I'm new on this Kannel/SMS stuff, but I managed Kannel to
work 100% with what I need (send SMS through a sms center using smpp).
But I still got one problem, I set it all in
Yes, I configured mysql DLR storage too. but still empty. I think we have
same problem :-)
On 8/7/07, Nicholas Amorim [EMAIL PROTECTED] wrote:
Yes. Actually, it recognizes the connection, just doesn't send nothing to
the database. Neither mysql nor pgsql (I've also compiled with pgsql
Why don't u start shared your kannel configuration to others?
On 2/7/07, Tushar [EMAIL PROTECTED] wrote:
Hi all,
I am unable to get DLRs in mysql database and even not not able to set
dlr-url…….and also unable to receive any messages in kanel. Plz somebody
help me.
Thanx and
Hi,
This is my configuration file:
group = core
admin-port=13000
smsbox-port = 13001
wapbox-port = 13002
admin-password = hungama
wdp-interface-name = *
log-file = /tmp/bearerbox.log
log-level = 0
group = wapbox
bearerbox-host = localhost
log-file = /tmp/wapbox.log
It seems you haven't set you dlr storage destination in your conf.
And if you plan to use mysql as your dlr storage, you have to add/define
dlr-db group and connection to the db.
It might help to take a look at this URL:
http://kannel.org/download/1.4.1/userguide-1.4.1/userguide.html#AEN452
Hi Andrew.
I suggest you search in archived emails list -
http://www.mail-archive.com/users@kannel.org/
You will find many informations about this issues.
[]s
AA
2006/11/29, andrew teo [EMAIL PROTECTED]:
Hello!!
I am interested in manipulating smses received through Kannel.
The Kannel
Hi all,
The solution is to add mysql support by re-making Kannel:
./configure --with-mysql --with-mysql-dir=/usr/local/mysql
make
make install
Apparently a mysql-devel RPM is required however. I'm still trying to
locate this for Solaris 8.
--
This message has been scanned for viruses and
] On
Behalf Of Navjot Singh
Sent: Wednesday, January 14, 2004 5:15 PM
To: [EMAIL PROTECTED]
Subject: RE: dlr-storage = mysql
did you specify the --with-mysql while running ./configure.
are you sure kannel was successfully compiled with mysql?
-Original Message-
From: [EMAIL PROTECTED] [mailto
: RE: dlr-storage = mysql
Thanks guys,
Yes I did specify --with-mysql but I have now successfully being able to
configure the gateway with mysql and the problem was the --with-mysql
finds mysql libs in /usr/local I located where my libs are and
configured --with-mysql=pathToMyMySQLLibs ok
PROTECTED]
Subject: RE: dlr-storage = mysql
do you have thisline
field-source = source
in your dlr-db group. make sure the same exists in table also.
HTH
navjot singh
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Ted Mwakabaga
Sent: Thursday, January 15, 2004
On Fri, 2004-01-16 at 11:17, Ted Mwakabaga wrote:
No I don't have this line
field-source = source
in my dlr-db group
Looks like a bug in the documentation ;-)
Surely what the application emits is more important.
-Tarun
--
http://www.tarundua.net
Nothing you ever wanted to find about Tarun Dua
did you specify the --with-mysql while running ./configure.
are you sure kannel was successfully compiled with mysql?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Ted Mwakabaga
Sent: Wednesday, January 14, 2004 7:52 PM
To: [EMAIL PROTECTED]
Subject:
On Wed, 2004-01-14 at 19:51, Ted Mwakabaga wrote:
Pls help me, when I run my bearerbox it stops with msg
PANIC dlr : dlr storage of type 'mysql' is not supported
Do you have the mysql client libraries installed.
-Tarun
--
http://www.tarundua.net
Nothing you ever wanted to find about Tarun Dua
about
it?
Thanks
TM
-Original Message-
From: Tarun Dua [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 6:14 PM
To: Ted Mwakabaga
Cc: [EMAIL PROTECTED]
Subject: Re: dlr-storage = mysql
On Wed, 2004-01-14 at 19:51, Ted Mwakabaga wrote:
Pls help me, when I run my bearerbox
23 matches
Mail list logo
