If you post your bearerbox log files, maybe it will give a hint about why it
doesn’t want to start.
== Rene
Van: users Namens Arun
Verzonden: donderdag 23 april 2020 16:39
Aan: users@kannel.org
Onderwerp: Re: Adding dlr-storage = mysql , SMSBOX throws error , Connection
Refused
Another observation
when dlr-storage =mysql
netstat -lnptu doesnt show up bearerbox ports
kindly enlighten me please
On Thu, Apr 23, 2020 at 12:31 PM Arun wrote:
> hi all
>
> Below is my Kannel.conf
> I want to store Dlr Messages in MySql
> When I add *dlr-storage = mysql
hi all
Below is my Kannel.conf
I want to store Dlr Messages in MySql
When I add *dlr-storage = mysql *to core Group and start *smsbox *I get
the following error ( Without dlr-storage=mysql works fine)
*0:02:34 [7000] [0] ERROR: connect to <127.0.0.1> failed2020-04-23 10:02:34
[70
You can add a timestamp field to your table with default ON_INSERT
CURRENT_TIME_STAMP.
As this is only dlr table, if you delete all, there won't be any
problem other than an error line in your logs for a dlr coming in and
not having a match.
Hope helps
Alvaro
On 4/3/12, spameden
...@kannel.org] On Behalf
Of Tapan Thapa
Sent: Monday, 02 April, 2012 09:55
To: users@kannel.org
Subject: Kannel - DLR Storage - MySQL
Hello Community,
I had enabled dlr-storage under kannel to store delivery report in mysql
database and now dlr table is having more then 8 (.8 million) lacs records
Hello Community,
I had enabled dlr-storage under kannel to store delivery report in mysql
database and now dlr table is having more then 8 (.8 million) lacs records.
Can any one let me know how should i delete old dlr from database for which
i have not received the delivery report since last 10
Hello Community,
I had enabled dlr-storage under kannel to store delivery report in mysql
database and now dlr table is having more then 8 (.8 million) lacs records.
Can any one let me know how should i delete old dlr from database for which
i have not received the delivery report since last 10
Hello Community,
I had enabled dlr-storage under kannel to store delivery report in mysql
database and now dlr table is having more then 8 (.8 million) lacs records.
Can any one let me know how should i delete old dlr from database for which
i have not received the delivery report since last 10
Hello,
Let me confirm that we are getting proper delivery report from SMSC and the
same is getting deleted automatically from dlr table however as we all know
that we generally don't receive 100% delivery report.
So we use to get 80-90% of delivery report and rest 10-20% delivery report
is still
Hello,
Let me confirm that we are getting proper delivery report from SMSC and the
same is getting deleted automatically from dlr table however as we all know
that we generally don't receive 100% delivery report.
So we use to get 80-90% of delivery report and rest 10-20% delivery report
is still
you can use this query:
delete d from dlr d inner join sent_sms s ON s.dlr_url=d.url where
s.momt='MT' and s.time = UNIX_TIMESTAMP('2012-04-02 08:00');
to delete all dlr's from dlr table before 2012-04-02 08:00
the only thing is you need to double check if sent_sms has dlr_url field
the same
Hello,
I am sorry but your provided query will not work for me as i am not using
sqlbox to send messages.
I am using smsbox to send sms via HTTP API call and at bearerbox's end i am
storing dlr under mysql so that in case bearerbox crashes due to any
reason, i have dlr to restore from MySQL.
If you're using HTTP API call, I guess you're also taking advantage of
dlr_url dlr_mask options to get DLRs, right?
Do you store anywhere message statuses and actual dlr_url ?
The problem is you need to delete only old entries, but dlr table itself
doesn't contain a time field there.
There are
parts_num yours shouldn't have, its my modification ;)
2012/4/3 spameden spame...@gmail.com
If you're using HTTP API call, I guess you're also taking advantage of
dlr_url dlr_mask options to get DLRs, right?
Do you store anywhere message statuses and actual dlr_url ?
The problem is you
Hi,
I am using kannel-1.4.3 with dlr-storage = mysql.
I have noticed when I am using mysql storage, after 30,000 data in DB,
kannel starts processing message slowly. i.e it's just sending 2-3 msg/sec
to upstream smsc, where as smsc TPS is 40.
At that time ,If I am deleting the data in DB
using kannel-1.4.3 with dlr-storage = mysql.
I have noticed when I am using mysql storage, after 30,000 data in DB,
kannel starts processing message slowly. i.e it's just sending 2-3 msg/sec
to upstream smsc, where as smsc TPS is 40.
At that time ,If I am deleting the data in DB,then it's sending
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 using kannel-1.4.3 with dlr-storage = mysql.
I have noticed when I am using mysql storage, after 30,000 data in DB,
kannel starts
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
with dlr-storage = mysql.
I have noticed when I am using mysql storage, after 30,000 data in DB,
kannel starts processing message slowly. i.e it's just sending 2-3
msg/sec to upstream smsc, where as smsc TPS is 40.
At that time ,If I am deleting the data in DB,then it's sending in
normal speed
Hi all, i successfully settup my kannel gateway with one service,now i
want to store my dlr in mysql data base,when i send sms to my
service all is right but no data in my data base.Please can you help me???
Thanks!!
ps: sorry i'm new and i just learn anglish.
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
Cremaschi; Enver ALTIN
Cc: users@kannel.org
Subject: RE: Problem starting kannel with dlr-storage mysql
I don't start the kanne; in a different way when using the
dlr-storage=mysql. And when using internal I don't have the problem. So
how can it be related to the order in which I start the services
I don't start the kanne; in a different way when using the
dlr-storage=mysql. And when using internal I don't have the problem. So
how can it be related to the order in which I start the services?
Anyways, when starting only berearbox I get the following exception:
[EMAIL PROTECTED] sbin
Hi,
I was trying to start the kannel using dlr-storage=mysql, but the it
fails. The logs in the wapbox.log say:
2007-11-09 07:21:48 [2652] [0] INFO: Starting to log to file
/usr/local/kannel/log/wapbox.log level -1
2007-11-09 07:21:48 [2652] [0] DEBUG: syslog parameter is none
2007-11-09 07
On Fri, 2007-11-09 at 10:05 +0200, Knaan Ratosh wrote:
I was trying to start the kannel using dlr-storage=mysql, but the it
fails. The logs in the wapbox.log say:
wapbox.log doesn't help, in order to understand the problem we need the
output from bearerbox.
--
Enver
signature.asc
Description
PROTECTED] wrote:
On Fri, 2007-11-09 at 10:05 +0200, Knaan Ratosh wrote:
I was trying to start the kannel using dlr-storage=mysql, but the it
fails. The logs in the wapbox.log say:
wapbox.log doesn't help, in order to understand the problem we need the
output from bearerbox.
--
Enver
= 14000
smsbox-port = 14001
admin-password = bar
log-file = /export/home/sites/sms/kannel/kannel-test.log
log-level = 1
box-deny-ip = *.*.*.*
box-allow-ip = 127.0.0.1
access-log = /export/home/sites/sms/kannel/beareraccess-test.log
dlr-storage = mysql
Now if I change 'dlr-storage = mysql' to 'dlr
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
Hello @ll, I've a problem running the bearerbox with dlr-storage = mysql, it send s this error: Group "mysql-connection" may not contain field "mysql-username"I've read many posts about it but didn't find any definitive solution.Could someone post here a clear expla
] 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
Hi guys
Pls help me, when I run my bearerbox it stops with msg
PANIC dlr : dlr storage of type 'mysql' is not supported
I changed the in the core group internal storage to mysql as clearly
explained in kannel user's guide. I want to store status report and
other things in my mysql database.
I
-storage = mysql
Hi guys
Pls help me, when I run my bearerbox it stops with msg
PANIC dlr : dlr storage of type 'mysql' is not supported
I changed the in the core group internal storage to mysql as clearly
explained in kannel user's guide. I want to store status report and
other things in my mysql
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
40 matches
Mail list logo