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