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
> <tho...@ist.schuldig.de>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 <elt...@gmail.com>
>>
>> To: sangprabv <sangpr...@gmail.com>
>>
>> Cc: kannel users <users@kannel.org>
>>
>> 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 <sangpr...@gmail.com> 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 <hafezad...@gmail.com>
>>
>> > 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
>>
>> > <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 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:tho...@ist.schuldig.de<tho...@ist.schuldig.de>
>>
>
>