Add
max-connections = 2
To your mysql-connection group
Alvaro
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
SMS y GPRS online
Visitenos en www.perusms.NET www.smsglobal.com.mx y
www.pravcom.com
On Tue, Mar 10, 2009 at 7:12 AM, Nikos Balkanas <nbalka...@gmail.com> 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 <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
>> >
>> >
>>
>
>
