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
>
>
