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
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
16 matches
Mail list logo