Hi,
max-pending is flow control optimization and has to do with how many messages
can kannel send to the SMSc before stopping and waiting for an ACK.
BR,
Nikos
----- Original Message -----
From: Elton Hoxha
To: Thomas Gottgens
Cc: Nikos Balkanas ; sangprabv ; kannel users
Sent: Tuesday, March 10, 2009 4:13 PM
Subject: Re: Re[2]: mysql storage frequent complains
Hi guys,
Is there any parameter to optimize the connection between kannel and mysql?
Also, max-pending parameter is refering to the maximum of records that dlr
table can hold or it is something else? Is there any parameter for limiting the
dlr table records?
Elton
On Tue, Mar 10, 2009 at 2:21 PM, Thomas Gφttgens <[email protected]>
wrote:
Hello Nikos, Folks ;-)
mysqld is there, or else the 2 last 'info' log lines would not show a
connection. I've had "MySQL server has gone away" happen with asterisk
cdr_mysql when long-running connections to mysql reach an idle limit and
disconnect silently. On Asterisk that happend after 4 hours of inactivity if i
recall correctly. Best solution would be to implement some kind of mysql
keepalive, because switchung off the idle timeouts on the db server may lead to
'connection eating'.
Tuesday, March 10, 2009, 1:12:05 PM, you wrote:
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 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-03-06 12:01:00 [18950] [6] DEBUG: DLR[mysql]: Adding DLR
smsc=internal1, ts=758389946, src=77777, dst=355672509006, mask=31, boxc=
2009-03-06 12:01:00 [18950] [6] DEBUG: sql: INSERT INTO dlr (smsc,
ts, source, destination, service, url, mask, boxc, status) VALUES ('internal1',
'758389946', '77777', '355672509006', 'a',
'http://10.1.21.236:2469/KannelGetStatus.asmx/GetStatus?dlrv=%d&status=%F&smsid=1111',
'31', '', '0');
2009-03-06 12:01:00 [18950] [6] ERROR: MYSQL: database check failed!
2009-03-06 12:01:00 [18950] [6] ERROR: MYSQL: MySQL server has gone
away
2009-03-06 12:01:00 [18950] [6] DEBUG: DBPool has too few
connections, reconnecting up to maximum...
2009-03-06 12:01:00 [18950] [6] INFO: MYSQL: Connected to server at
10.1.21.184.
2009-03-06 12:01:00 [18950] [6] INFO: MYSQL: server version 5.0.45,
client version 5.0.45.
Regards
Elton
On Tue, Mar 10, 2009 at 11:39 AM, sangprabv <[email protected]>
wrote:
./configure --with-malloc=native --with-mysql-dir=/usr/include/mysql
--with-mysql --prefix=/usr/local/kannel
Willy
On Tue, 2009-03-10 at 11:29 +0100, Elton Hoxha wrote:
> I ran it like this:
>
> ./configure --with-malloc=native
--with-mysql-dir=/usr/include/mysql
> --prefix=/usr/local/kannel
>
> Output:
>
> Configuring DB support ...
> checking whether to compile with MySQL support... disabled
>
> Thanks
>
>
> On Tue, Mar 10, 2009 at 11:11 AM, hafez ahmad
<[email protected]>
> wrote:
> Hi,
>
> or can use "--with-mysql-dir=DIR Where to look for MySQL
libs
> and header files. DIR points to the installation of
MySQL."
>
> Regards,
> Hafez
>
>
>
> On Tue, Mar 10, 2009 at 11:47 AM, Falko Ziemann
> <[email protected]> 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 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!"
> > Which part of kannel is generating this error?
> > I went through the dlr_init just wondering why
is
> > that?
> > if (octstr_compare(dlr_type,
octstr_imm("mysql")) == 0) {
> >
> >
> >
> > handles = dlr_init_mysql(cfg);
> >
> > if (handles == NULL) {
> > panic(0, "DLR: storage type '%s' is not
supported!", octstr_get_cstr(dlr_type));
> >
> >
> >
> > }
> >
> > Why kannel is failing to retrieve the initial
configuration? I suspect, the DLR-storage would fail for every type of database
connection here, oracle postgre.
> >
> >
> >
> >
> > Is it something wrong with my conf file?
> >
> >
> > dlr-storage=mysql
> >
> > group=mysql-connection
> > id=mydlr
> > host=10.1.21.184
> > username=kannel
> > password=kannel
> >
> >
> >
> > 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
> >
> > Thanks
> > Elton
> >
>
>
>
>
>
>
> --
> Hafez A.Ahmad
> Amman-Jordan
> mobile:962-785259011
> 962-795708728
> http://blog.hafezadnan.com
>
>
--
Best regards,
Thomas mailto:[email protected]
