dlr storage with mysql

2009-09-16 Thread freeburn
if i use fakesmsc does the mysql database gets any entry in the
specified fields? because my kannel runs without any warning and in the
log i can see that connection with mysql is established.

but when i looked through the database i havent seen any entry. 

is it ok? or there is a problem.




Re: dlr storage with mysql

2009-09-16 Thread Alejandro Guerrieri
Dlr records are only kept on the database while the messages are in
transit. Once a message gets accepted/rejected (any final status) the
record is removed from the DB.

Hope it help,

Alejandro
On Wed, Sep 16, 2009 at 8:41 PM, freeburn hoss...@finder-lbs.com wrote:

 if i use fakesmsc does the mysql database gets any entry in the
 specified fields? because my kannel runs without any warning and in the
 log i can see that connection with mysql is established.

 but when i looked through the database i havent seen any entry.

 is it ok? or there is a problem.





DLR: storage type 'mysql' is not supported!

2009-07-08 Thread abhishek jain
Hi friends,
When i place the following line in
group = core
dlr-storage = mysql



i get the following errror:
2009-07-08 16:44:54 [21654] [0] PANIC: DLR: storage type 'mysql' is
not supported!


Pl. advice, i have installed kannel via yum command,
mysql and mysql-devel are installed on  my sytem,
also kannel-devel is installed.
-- 
Thanks and kind Regards,
Abhishek jain



Re: DLR: storage type 'mysql' is not supported!

2009-07-08 Thread abhishek jain
Hi,
For info:

i have kannel-1.4.1-2.el5.i386
and kannel-devel-1.4.1-2.el5.i386


Thanks
abhi
On Wed, Jul 8, 2009 at 4:44 PM, abhishek jainabhishek.netj...@gmail.com wrote:
 Hi friends,
 When i place the following line in
 group = core
 dlr-storage = mysql



 i get the following errror:
 2009-07-08 16:44:54 [21654] [0] PANIC: DLR: storage type 'mysql' is
 not supported!


 Pl. advice, i have installed kannel via yum command,
 mysql and mysql-devel are installed on  my sytem,
 also kannel-devel is installed.
 --
 Thanks and kind Regards,
 Abhishek jain




RE: DLR: storage type 'mysql' is not supported!

2009-07-08 Thread Bashir Jahed
This may be of assistance to you: 
Very easy and reliable way and you will get the latest as it is based on a CVS 
install:

http://www.blogalex.com/archives/23

-Original Message-
From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of 
abhishek jain
Sent: 08 July 2009 01:17 PM
To: users@kannel.org
Subject: Re: DLR: storage type 'mysql' is not supported!

Hi,
For info:

i have kannel-1.4.1-2.el5.i386
and kannel-devel-1.4.1-2.el5.i386


Thanks
abhi
On Wed, Jul 8, 2009 at 4:44 PM, abhishek jainabhishek.netj...@gmail.com wrote:
 Hi friends,
 When i place the following line in
 group = core
 dlr-storage = mysql



 i get the following errror:
 2009-07-08 16:44:54 [21654] [0] PANIC: DLR: storage type 'mysql' is
 not supported!


 Pl. advice, i have installed kannel via yum command,
 mysql and mysql-devel are installed on  my sytem,
 also kannel-devel is installed.
 --
 Thanks and kind Regards,
 Abhishek jain





DLR storage in MySQL

2006-08-29 Thread David Ritchie

We're storing DLRs in MySQL successfully but the DLRs aren't being deleted 
which seems at odds with other people's experience (i.e. 
http://www.kannel.org/pipermail/users/2006-August/000294.html) but makes sense, 
since often we include a dlr-mask value (e.g. 12) which result in multiple DLRs 
being returned.

Can anybody outline any successful DLR archiving or deletion strategies they've 
implemented, or perhaps outline how we can delete DLRs after a certain expiry 
date? Is there a danger (other than disk space issues) in letting the DLR table 
grow?

Thanks!

David R



Re: DLR storage in MySQL

2006-08-29 Thread Stipe Tolj

David Ritchie wrote:


We're storing DLRs in MySQL successfully but the DLRs aren't being deleted 
which seems at odds with other people's experience (i.e. 
http://www.kannel.org/pipermail/users/2006-August/000294.html) but makes sense, 
since often we include a dlr-mask value (e.g. 12) which result in multiple DLRs 
being returned.

Can anybody outline any successful DLR archiving or deletion strategies they've 
implemented, or perhaps outline how we can delete DLRs after a certain expiry 
date? Is there a danger (other than disk space issues) in letting the DLR table 
grow?


Kannel will delete DLRs from the storage, as soon as the status is final. Of 
course it can happen -- don't ask me for reasons -- that SMSCs never report a 
final state, and DLRs are still in storage.


Kannel does no cleaning up of too old messages on it's own AFAIR. Please don't 
shoot me if Alex or anyone else did implement this.


Actually this wouldn't be a too hard thing to implement. It would be a cleaning 
thread that sleeps for a predefined time and then loops the storage and removes 
all outdated DLR entries.


Stipe

---
Kölner Landstrasse 419
40589 Düsseldorf, NRW, Germany

tolj.org system architecture  Kannel Software Foundation (KSF)
http://www.tolj.org/  http://www.kannel.org/

mailto:st_{at}_tolj.org   mailto:stolj_{at}_kannel.org
---



Re: DLR storage in MySQL

2006-08-29 Thread Stipe Tolj

Vincent CHAVANIS wrote:


We delete DLR after 2 months after their creations if they are still in our db.
A simply SQL request would do that easily.


@Vinc: this would be a perfect coding task for you:
Implement the Kannel DLR cleaner thread that cleans entries uppon a specific 
time from the storage space (all types ;)


Stipe

---
Kölner Landstrasse 419
40589 Düsseldorf, NRW, Germany

tolj.org system architecture  Kannel Software Foundation (KSF)
http://www.tolj.org/  http://www.kannel.org/

mailto:st_{at}_tolj.org   mailto:stolj_{at}_kannel.org
---



DLR : storage type 'mysql' not supported

2006-04-28 Thread Jay
Guys,I am using MySQL 5.0Kannel version 1.4.0did this;./configure --with-mysql --with-mysql-dir=/usr/local/mysqlmakemake installa part of the ./configure output :Configuring DB support ...checking whether to compile with MySQL support... searchingchecking for mysql_config... (cached) /usr/bin/mysql_configchecking mysql version... 5.0.19checking mysql reentrant libs... -L/usr/local/lib -L/usr/local/mysql/lib -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolvchecking for mysql_init in -lmysqlclient_r... (cached) yeschecking mysql includes... -I/usr/local/mysql/includechecking for mysql/mysql.h... (cached) nochecking for mysql/mysql_version.h... (cached) nochecking whether to compile with
 MySQL support... yeschecking whether to compile with LibSDB support... disabledchecking whether to compile with SQLite support... disabledchecking whether to compile with Oracle support... disabledchecking whether to compile with PostgresSQL support... disabledchecking for Ct-Lib support... nochecking for FreeTDS Ct-Lib support... noare the ones highlighted the possible cause???thanks...regards,Roland
		How low will we go? Check out Yahoo! Messenger’s low  PC-to-Phone call rates.

Re: DLR : storage type 'mysql' not supported

2006-04-26 Thread Sriram
Yes, for MySQL u need the latest CVS version. I recommend you try out with
version 3.23 or so with kannel. it works for me

Sriram
- Original Message -
From: Roman Yeryomin [EMAIL PROTECTED]
To: users@kannel.org
Sent: Tuesday, April 25, 2006 8:36
Subject: Re: DLR : storage type 'mysql' not supported


 On Tuesday 25 April 2006 17:35, Jay wrote::
  Hi guys,
 
  I've read that most of the answer to my problem is to recompile kannel
 
  ./configure --with-mysql --with-mysql-dir=/usr/local/mysql
  make
  make install
 
  but still problem persists...
 
  is it possible that my mysql version (5.0) is not supported? ot is there
a
  valid reason for this?
 
  help pls..
 
  thanks
 
 
  -
  Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low
rates.

 did you try with mysql 4.1?





Re: DLR : storage type 'mysql' not supported

2006-04-26 Thread Willy
Sriram,
Can you share to us the error message?

Regards


Willy
- Original Message - 
From: Sriram [EMAIL PROTECTED]
To: Roman Yeryomin [EMAIL PROTECTED]; users@kannel.org
Sent: Wednesday, April 26, 2006 3:44 PM
Subject: Re: DLR : storage type 'mysql' not supported


 Yes, for MySQL u need the latest CVS version. I recommend you try out with
 version 3.23 or so with kannel. it works for me

 Sriram
 - Original Message -
 From: Roman Yeryomin [EMAIL PROTECTED]
 To: users@kannel.org
 Sent: Tuesday, April 25, 2006 8:36
 Subject: Re: DLR : storage type 'mysql' not supported


  On Tuesday 25 April 2006 17:35, Jay wrote::
   Hi guys,
  
   I've read that most of the answer to my problem is to recompile kannel
  
   ./configure --with-mysql --with-mysql-dir=/usr/local/mysql
   make
   make install
  
   but still problem persists...
  
   is it possible that my mysql version (5.0) is not supported? ot is
there
 a
   valid reason for this?
  
   help pls..
  
   thanks
  
  
   -
   Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low
 rates.
 
  did you try with mysql 4.1?
 
 





RE: DLR : storage type 'mysql' not supported

2006-04-26 Thread Rayson Lee








Dear Jay,



MySQL version 5.0 works
fine. Please make sure you have installed the shared library.



Best regards,



Rayson Lee

InnoAge Hong Kong Limited











From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay
Sent: Tuesday, April 25, 2006
10:36 PM
To: users@kannel.org
Subject: DLR : storage type
'mysql' not supported





Hi guys,

I've read that most of the answer to my problem is to recompile kannel 

./configure --with-mysql --with-mysql-dir=/usr/local/mysql
make
make install

but still problem persists...

is it possible that my mysql version (5.0) is not supported? ot is there a
valid reason for this?

help pls..

thanks







Yahoo!
Messenger with Voice. PC-to-Phone calls for ridiculously low rates.








DLR : storage type 'mysql' not supported

2006-04-25 Thread Jay
Hi guys,I've read that most of the answer to my problem is to recompile kannel ./configure --with-mysql --with-mysql-dir=/usr/local/mysqlmakemake installbut still problem persists...is it possible that my mysql version (5.0) is not supported? ot is there a valid reason for this?help pls..thanks
		Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.

Re: DLR : storage type 'mysql' not supported

2006-04-25 Thread Roman Yeryomin
On Tuesday 25 April 2006 17:35, Jay wrote::
 Hi guys,

 I've read that most of the answer to my problem is to recompile kannel

 ./configure --with-mysql --with-mysql-dir=/usr/local/mysql
 make
 make install

 but still problem persists...

 is it possible that my mysql version (5.0) is not supported? ot is there a
 valid reason for this?

 help pls..

 thanks


 -
 Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.

did you try with mysql 4.1?



RE: DLR : storage type 'mysql' not supported

2006-04-25 Thread Rene Kluwen



What 
is the output from ./configure?

Does 
it tell you that it can find all the MySQL libraries?

Rene 
Kluwen
Chimit

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of JaySent: 
  dinsdag 25 april 2006 16:36To: users@kannel.orgSubject: 
  DLR : storage type 'mysql' not supportedHi 
  guys,I've read that most of the answer to my problem is to recompile 
  kannel ./configure --with-mysql 
  --with-mysql-dir=/usr/local/mysqlmakemake installbut still 
  problem persists...is it possible that my mysql version (5.0) is not 
  supported? ot is there a valid reason for this?help 
  pls..thanks
  
  
  Yahoo! 
  Messenger with Voice. PC-to-Phone calls for ridiculously low 
rates.


DLR storage type 'mysql' not supported?

2006-02-23 Thread Ngurah Bagus
Hi, 

I'm trying to set up a DLR storage using mysql, but when I put dlr-storage = mysql in group=core, I get
2006-02-24 11:50:06 [4800] [0] PANIC: DLR: storage type 'mysql' is not supported!
Can anyone shed a light to this matter? Thanks!

I wonder if my bearerbox is also outdated, like my FakeSMSC :) For info, it's 1.4.0

Cheers,-- A. A. Ngurah Bagus W.Systems AdministratorPT. Pintar Media Indonesia


Re: DLR storage type 'mysql' not supported?

2006-02-23 Thread Ngurah Bagus
Done :)
Thanks a lot! I'm not used to this whole 'compile your own with stuff you only need' thing.

Cheers,On 2/24/06, Sriram [EMAIL PROTECTED] wrote:







Hi

You need to recompile kannel with dlr support 
(./configure --with-mysql) . Make sure you install MySQL client libraries before 
that

Cheers
Sriram

  - Original Message - 
  
From: 
  Ngurah 
  Bagus 
  To: 
users@kannel.org 
  Sent: Friday, February 24, 2006 
  10:20
  Subject: DLR storage type 'mysql' not 
  supported?
  Hi, I'm trying to set up a DLR storage using 
  mysql, but when I put dlr-storage = mysql in group=core, I get2006-02-24 
  11:50:06 [4800] [0] PANIC: DLR: storage type 'mysql' is not supported!Can 
  anyone shed a light to this matter? Thanks!I wonder if my bearerbox is 
  also outdated, like my FakeSMSC :) For info, it's 1.4.0Cheers,-- A. A. Ngurah Bagus W.Systems AdministratorPT. 
  Pintar Media Indonesia 

-- A. A. Ngurah Bagus W.Systems AdministratorPT. Pintar Media Indonesia


Re: external dlr-storage to Mysql couldn't be set

2005-05-04 Thread Aarno Syvänen
Try newer version. There is a name conflict with mysql
in older ones.
Aarno
On 2.5.2005, at 18.56, chouaieb ben Smail wrote:
hi again,
First of all, i'd like to thank you for your
explanation and support, Mr Sadok, but the external
dlr-storage (Mysql) isn't yet set when compiling since
an other error is generated (as you could see below)
even after changing the occurence of list_delete to
gw_list_delete in the specified *.c,*.h from
directories (/gwlib, /gw):
libwap.a(wsp_push_client.o): In function
`push_client_machine_destroy':
wsp_push_client.o(.text+0xa62): undefined reference to
`list_delete_equal'
libwap.a(wsp_session.o): In function
`machine_destroy':
wsp_session.o(.text+0x348a): undefined reference to
`list_delete_equal'
libwap.a(wsp_session.o): In function
`handle_method_event':
wsp_session.o(.text+0x45e5): undefined reference to
`list_delete_equal'
libwap.a(wsp_session.o): In function
`handle_push_event':
wsp_session.o(.text+0x4aac): undefined reference to
`list_delete_equal'
libwap.a(wtp_init.o): In function
`init_machine_destroy':
wtp_init.o(.text+0x358): undefined reference to
`list_delete_equal'
libwap.a(wtp_resp.o)(.text+0x2032): more undefined
references to `list_delete_equal' follow
collect2: ld a retourné 1 code d'état d'exécution
make: *** [gw/wapbox] Erreur 1
 So, i ask you kindly if you could propose me a
solution for that,
All the best,
chouaieb ben smail



__
Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour  
vos mails !
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com/





external dlr-storage to Mysql couldn't be set

2005-05-02 Thread chouaieb ben Smail
hi,
i'm asking about why i couldnt't use the external DLR
storage (MySQL) in the core configuration, when i
execute the bearerbox with the config-file indicating
dlr-storage=mysql, the result is shown below: 

[EMAIL PROTECTED] gw]$ ./bearerbox -v 1 smstest.conf
2005-04-30 11:04:51 [6481] [0] INFO: Debug_lvl = 1,
log_file = none, log_lvl = 0
2005-04-30 11:04:51 [6481] [0] PANIC: DLR: storage
type ''mysql'' is not supported!
2005-04-30 11:04:51 [6481] [0] PANIC:
./bearerbox(gw_panic+0x175) [0x80c9c9f]
2005-04-30 11:04:51 [6481] [0] PANIC:
./bearerbox(dlr_init+0x1ee) [0x805d296]
2005-04-30 11:04:51 [6481] [0] PANIC:
./bearerbox(main+0x18d) [0x805260b]
2005-04-30 11:04:51 [6481] [0] PANIC:
./bearerbox(__libc_start_main+0xa4) [0x420158d4]
2005-04-30 11:04:51 [6481] [0] PANIC:
./bearerbox(SSL_write+0x51) [0x8051699]

so i tried to reconfigure the gateway  
./configure --with-mysql
--with-mysql-dir=/var/lib/mysql
i have the following error in makefile (sorry there is
some words written in frensh, i gave translation
between : 


Dans le fichier inclus à partir de  in the included
file from 
/usr/include/mysql/mysql.h:62,
  à partir de from gw/dlr_mysql.c:74:
/usr/include/mysql/my_list.h:32: types conflictuels
pour conflictuals types for « list_delete »
gwlib/list.h:179: déclaration précédente de previous
statement of « list_delete »
make: *** [gw/dlr_mysql.o] Erreur 1

So could you help me for that i should do, how to
reconfigure the gateway...  

all the best thanx for your help,










__ 
Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos mails ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com/



Re : external dlr-storage to Mysql couldn't be set

2005-05-02 Thread Mohamed Sadok MOUHA




Hi,



you may change source code of Kannel and recompile it. Just modify any occurence of list_delete by gw_list_delete (in gw/*.c *.h and gwlib/*.c *.h). 



@+

Sadok




external dlr-storage to Mysql couldn't be set

2005-05-02 Thread chouaieb ben Smail
hi again, 
First of all, i'd like to thank you for your
explanation and support, Mr Sadok, but the external
dlr-storage (Mysql) isn't yet set when compiling since
an other error is generated (as you could see below)
even after changing the occurence of list_delete to
gw_list_delete in the specified *.c,*.h from
directories (/gwlib, /gw):


libwap.a(wsp_push_client.o): In function
`push_client_machine_destroy':
wsp_push_client.o(.text+0xa62): undefined reference to
`list_delete_equal'
libwap.a(wsp_session.o): In function
`machine_destroy':
wsp_session.o(.text+0x348a): undefined reference to
`list_delete_equal'
libwap.a(wsp_session.o): In function
`handle_method_event':
wsp_session.o(.text+0x45e5): undefined reference to
`list_delete_equal'
libwap.a(wsp_session.o): In function
`handle_push_event':
wsp_session.o(.text+0x4aac): undefined reference to
`list_delete_equal'
libwap.a(wtp_init.o): In function
`init_machine_destroy':
wtp_init.o(.text+0x358): undefined reference to
`list_delete_equal'
libwap.a(wtp_resp.o)(.text+0x2032): more undefined
references to `list_delete_equal' follow
collect2: ld a retourné 1 code d'état d'exécution
make: *** [gw/wapbox] Erreur 1


 So, i ask you kindly if you could propose me a
solution for that, 
All the best,

chouaieb ben smail 







__ 
Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos mails ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com/



Re: external dlr-storage to Mysql couldn't be set

2005-05-02 Thread Alexander Malysh
Hi,
just try latest cvs snapshot...
Thanks,
Alex
chouaieb ben Smail schrieb:
hi again, 
First of all, i'd like to thank you for your
explanation and support, Mr Sadok, but the external
dlr-storage (Mysql) isn't yet set when compiling since
an other error is generated (as you could see below)
even after changing the occurence of list_delete to
gw_list_delete in the specified *.c,*.h from
directories (/gwlib, /gw):

libwap.a(wsp_push_client.o): In function
`push_client_machine_destroy':
wsp_push_client.o(.text+0xa62): undefined reference to
`list_delete_equal'
libwap.a(wsp_session.o): In function
`machine_destroy':
wsp_session.o(.text+0x348a): undefined reference to
`list_delete_equal'
libwap.a(wsp_session.o): In function
`handle_method_event':
wsp_session.o(.text+0x45e5): undefined reference to
`list_delete_equal'
libwap.a(wsp_session.o): In function
`handle_push_event':
wsp_session.o(.text+0x4aac): undefined reference to
`list_delete_equal'
libwap.a(wtp_init.o): In function
`init_machine_destroy':
wtp_init.o(.text+0x358): undefined reference to
`list_delete_equal'
libwap.a(wtp_resp.o)(.text+0x2032): more undefined
references to `list_delete_equal' follow
collect2: ld a retourné 1 code d'état d'exécution
make: *** [gw/wapbox] Erreur 1
 So, i ask you kindly if you could propose me a
solution for that, 
All the best,

chouaieb ben smail 



	
		
__ 
Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos mails ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com/





Re: Kannel Panic using dlr-storage with mysql

2004-03-30 Thread tiago_mendonca

Thank you Arief for your tip! I'll try to configure like that...
I haven't choose that option before because I would like that my Kannel could 
use internal dlr mode or mysql. I think if we choose this option the Kannel 
will always be on mode Mysql, is that correct?

Thank you!
Tiago

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
Ariee
Sent: terça-feira, 30 de Março de 2004 2:43
To: [EMAIL PROTECTED]
Subject: Fw: Kannel Panic using dlr-storage with mysql

please recompile kannel and add this --with-dlr=mysql
so your configure line will be like this :

./configure  --with-malloc=native --enable-start-stop-daemon=no --with-mysql
=/usr/local --enable-mysql --prefix=/usr/local
i386-portbld-freebsd4.9 --with-dlr=mysql


Regards,



Arief
http://ariee.psend.com

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
[EMAIL PROTECTED]
Sent: segunda-feira, 29 de Março de 2004 21:42
To: [EMAIL PROTECTED]
Subject: Kannel Panic using dlr-storage with mysql


Hello Kannel Users,
I have Kannel Gateway 1.2.1 running on FreeBsd V4.9 (I used the Kannel port of 
this system to install the Kannel).

The problem I have is when I try to use the Kannel with dlr-storage on mysql, 
it gives the error:

[0] PANIC: DLR: storage type defined as 'mysql', but no MySQL support build in!

In fact I have MySQL 4.0.17 and configured Kannel as the Users Guide 
recommends. I also read on the Kannel Maillist, posts from other users 
reporting the same problem and reffering to the location of the mysql 
libraries, and I think got it well! 

I configured the Kannel during the installation like this:

./configure  --with-malloc=native --enable-start-stop-daemon=no --with- 
mysql=/usr/local --enable-mysql --prefix=/usr/local i386-portbld-freebsd4.9

I check the config.log (file where the result of the kannel configure is 
kept), and it seems that the compilation of kannel was well done with mysql.

Does anyone have a clue on why this happens or how can I solve the problem?

I also give you an example of my Kannel configuration file:

group = core
admin-port = 13003
smsbox-port = 13004
admin-password = password
log-file = /var/log/kannel/bearerbox.log
log-level = 0
box-deny-ip = *.*.*.*
box-allow-ip = 127.0.0.1
access-log = /var/log/kannel/beareraccess.log
store-file = /var/log/kannel/kannel.store
dlr-storage = mysql

group = mysql-connection
id = mydlr
host = testhost
mysql-username = user
mysql-password = password
database = dlr

group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-service = service
field-url = url
field-mask = mask
field-status = status
field-source = source 


__
Continua a preferir gastar mais? Adira à ligação Portugalmail.
http://acesso.portugalmail.pt/compare



Re: Kannel Panic using dlr-storage with mysql

2004-03-30 Thread Alejandro Guerrieri
I´ll have to check again, but if I'm not wrong, I've checked that option 
when compiling Kannel but I´ve got the same error.

I'll have to try compiling it again...

Thanks,

At 14:42 30/03/2004, you wrote:

Thank you Arief for your tip! I'll try to configure like that...
I haven't choose that option before because I would like that my Kannel could
use internal dlr mode or mysql. I think if we choose this option the Kannel
will always be on mode Mysql, is that correct?
Thank you!
Tiago
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Ariee
Sent: terça-feira, 30 de Março de 2004 2:43
To: [EMAIL PROTECTED]
Subject: Fw: Kannel Panic using dlr-storage with mysql
please recompile kannel and add this --with-dlr=mysql
so your configure line will be like this :
./configure  --with-malloc=native --enable-start-stop-daemon=no --with-mysql
=/usr/local --enable-mysql --prefix=/usr/local
i386-portbld-freebsd4.9 --with-dlr=mysql
Regards,



Arief
http://ariee.psend.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: segunda-feira, 29 de Março de 2004 21:42
To: [EMAIL PROTECTED]
Subject: Kannel Panic using dlr-storage with mysql
Hello Kannel Users,
I have Kannel Gateway 1.2.1 running on FreeBsd V4.9 (I used the Kannel 
port of
this system to install the Kannel).

The problem I have is when I try to use the Kannel with dlr-storage on mysql,
it gives the error:
[0] PANIC: DLR: storage type defined as 'mysql', but no MySQL support 
build in!

In fact I have MySQL 4.0.17 and configured Kannel as the Users Guide
recommends. I also read on the Kannel Maillist, posts from other users
reporting the same problem and reffering to the location of the mysql
libraries, and I think got it well!
I configured the Kannel during the installation like this:

./configure  --with-malloc=native --enable-start-stop-daemon=no --with-
mysql=/usr/local --enable-mysql --prefix=/usr/local i386-portbld-freebsd4.9
I check the config.log (file where the result of the kannel configure is
kept), and it seems that the compilation of kannel was well done with mysql.
Does anyone have a clue on why this happens or how can I solve the problem?

I also give you an example of my Kannel configuration file:

group = core
admin-port = 13003
smsbox-port = 13004
admin-password = password
log-file = /var/log/kannel/bearerbox.log
log-level = 0
box-deny-ip = *.*.*.*
box-allow-ip = 127.0.0.1
access-log = /var/log/kannel/beareraccess.log
store-file = /var/log/kannel/kannel.store
dlr-storage = mysql
group = mysql-connection
id = mydlr
host = testhost
mysql-username = user
mysql-password = password
database = dlr
group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-service = service
field-url = url
field-mask = mask
field-status = status
field-source = source
__
Continua a preferir gastar mais? Adira à ligação Portugalmail.
http://acesso.portugalmail.pt/compare
--
Alejandro Guerrieri
Magicom
[EMAIL PROTECTED]