Re: MySQL Storage

Hello, Mysql db in Kannel is used to handle dlr report not to store all sms. Have a look to playsms you may find some usefull features. All sms will be stored in mysql db. Playsms.org Playsms-mc.mediacom.nc Br Emmanuel Le 7 déc. 2011 20:51, "Supporto Tecnico - Crazy Network" < supp...@crazynetw

Re: MySQL Storage

Ok, thanks a lot :) Il 07/12/2011 11:08, Emmanuel CHANSON ha scritto: Hello, Mysql db in Kannel is used to handle dlr report not to store all sms. Have a look to playsms you may find some usefull features. All sms will be stored in mysql db. Playsms.org Playsms-mc.mediacom.nc

Re: MySQL Storage

Hi, you can install sqlbox, and you get a table called "sent_sms" with all sms sent and DLR. Cheers. El mié, 07-12-2011 a las 10:49 +0100, Supporto Tecnico - Crazy Network escribió: > Hi everyone. > > im trying to work with Kannel since some month now and ive successfull > let it work as the c

Re: MySQL Storage

Ive managed to solve every problem using playsms with kannel. Everything now is working great, have just to correctly configure playsms for the forwarders :) Regards Il 07/12/2011 14:42, Carlos Massoglia Lillo ha scritto: Hi, you can install sqlbox, and you get a table called "sent_sms" wi

Re: MySQL Storage

Just for stay on same topic. Anyone of you have also experience with playsms or you suggest to write on their own ml? Thanks Il 07/12/2011 14:42, Carlos Massoglia Lillo ha scritto: Hi, you can install sqlbox, and you get a table called "sent_sm

Re: MySQL Storage

Hi, I know of one Emmanuel Chanson. He could really be helpful in matters pertaining PlaySMS. One question to the Kannelers, is it ok to discuss here about Kannel integration scripts like PlaySMS? Kind Regards, Joseph Koech On Wed, Dec 7, 2011 at 7:27 PM, Supporto Tecnico - Crazy Network < supp..

RE: mysql storage

You have to tell Kannel to use MySQL - look at the top of your config for something that says "internal" now and change to whatever the docs say. -Original Message- From: Iain Dooley [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2008 7:09 AM To: users@kannel.org Subject: mysql st

Re: mysql storage

On Tue, Sep 9, 2008 at 4:09 PM, Iain Dooley <[EMAIL PROTECTED]> wrote: > and then created a database kannel, with username kannel and password > kannel. I'm using a table with all the fields as varchars. Works without any problems. CHEERS, Jovan

RE: mysql storage

:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2008 6:18 PM To: Iain Dooley Cc: users@kannel.org Subject: Re: mysql storage On Tue, Sep 9, 2008 at 4:09 PM, Iain Dooley <[EMAIL PROTECTED]> wrote: > and then created a database kannel, with username kannel and password > kannel. I

RE: mysql storage

field-boxc-id = boxc Regards, Remon -Original Message- From: Jovan Kostovski [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2008 6:18 PM To: Iain Dooley Cc: users@kannel.org Subject: Re: mysql storage On Tue, Sep 9, 2008 at 4:09 PM, Iain Dooley <[EMAIL PROTECTED]> wrote

Re: Mysql storage engine

We are using InnoDB. It works just fine with dlr and send_sms, sent_sms tables. InnoDB comparing to MyISAM is more fault proof, so I'd recommend using it, every insert is a transaction, so theoritacally you won't lose more than 1 transaction if something bad happens. Don't forget to add relevant i

Re: Mysql storage engine

Hello, Thanks for your response. What are the fields that should be indexed? On Fri, Mar 23, 2012 at 12:54 AM, spameden wrote: > We are using InnoDB. It works just fine with dlr and send_sms, sent_sms > tables. InnoDB comparing to MyISAM is more fault proof, so I'd recommend > using it, every i

Re: Mysql storage engine

mysql> show indexes from kannel.dlr; +---++-+--+-+---+-+--++--++-+---+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinalit

Re: Mysql storage engine

And how much concurrent connection i.e. max-connection is recommended for high traffic when using innodb. On Fri, Mar 23, 2012 at 12:59 AM, spameden wrote: > mysql> show indexes from kannel.dlr; > > +---++-+--+-+---+

Re: Mysql storage engine

not quite sure about this, we are using 10. the speed mostly depends on your smsc provider(s) actually 2012/3/22 Ashish Agarwal > And how much concurrent connection i.e. max-connection is recommended for > high traffic when using innodb. > > > On Fri, Mar 23, 2012 at 12:59 AM, spameden wrote:

Re: Mysql storage engine

If you need speed (store more than 100 > records per second, give a look to 'INSERT DELAYED' (only MyISAM) later I will suggest to first normalize the DB, and based on your queries made by your frontend/application crete your indexes. either MyISAM/INODB *sql, you will need to implement a queue

Re: MySQL Storage Example

[EMAIL PROTECTED] ~]# cat /opt/installs/kannel/gateway/doc/examples/dlr-mysql.conf # # DLR with MySQL support configuration # # Example defining a MySQL database connection resource and # the required table and field values. # group = mysql-connection id = mydlr host = localhost username = foo pa

Re: MySQL Storage Example

+ dlr-storage = mysql Thanks ! Mickael seik a écrit : [EMAIL PROTECTED] ~]# cat /opt/installs/kannel/gateway/doc/examples/dlr-mysql.conf # # DLR with MySQL support configuration # # Example defining a MySQL database connection resource and # the required table and field values. # group = mys

Re: MySQL Storage Fails

Dear Ali, When you compile the source code use below command. #./configure --with-mysql --with-mysql-dlr=/usr/include/mysql/mysql.h And then check for the same. On Wed, Feb 26, 2014 at 6:04 AM, Ali Ansari wrote: > Hello, > > When I try to run kannel with "dlr-storage = mysql", it simply

Re: MySQL Storage Fails

Thanks for your reply. But I haven't complied from source, I used yum to install kannel. what to do in this case? Kind Regards, *Ali Ansari*

RE: MySQL Storage Fails

Better to compile from source. Its pretty much straight forward and fairly easy Sent from Samsung Mobile. Original message From: Ali Ansari Date:26/02/2014 1:18 PM (GMT+05:00) To: John alero Cc: users@kannel.org Subject: Re: MySQL Storage Fails Thanks for your reply. But I

Re: mysql storage frequent complains

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

Re: mysql storage frequent complains

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 wrote: > Hi, > you have to install the mysql-dev package first and then compile (!) kannel > with ./con

Re: mysql storage frequent complains

Installed: [r...@localhost Desktop]# rpm -ivh mysql-devel-5.0.45-7.el5.i386.rpm warning: mysql-devel-5.0.45-7.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 82fd17b2 Preparing...### [100%] 1:mysql-devel###

Re: mysql storage frequent complains

Doesn't look like you have COMPILED kannel with mysql support... Regards Falko Am 10.03.2009 um 11:11 schrieb Elton Hoxha: Installed: [r...@localhost Desktop]# rpm -ivh mysql-devel-5.0.45-7.el5.i386.rpm warning: mysql-devel-5.0.45-7.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 82fd1

Re: mysql storage frequent complains

Elton, CMIIW, you need also mysql-client. And after successfully install you must reconfigure your Kannel (re install from the first step). Willy

Re: mysql storage frequent complains

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 wrote: > Hi, > > or can use

Re: mysql storage frequent complains

Try to install package like libmysql-devel configure --with-mysql --with-mysql-dir=/path/to/libs Regards, Cezary - Original Message - From: Elton Hoxha To: Falko Ziemann Cc: kannel users Sent: Tuesday, March 10, 2009 10:11 AM Subject: Re: mysql storage frequent complains

Re: mysql storage frequent complains

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

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,

Re: mysql storage frequent complains

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 s

Re: mysql storage frequent complains

sqld" > 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,