MySQL Storage

Hi everyone. im trying to work with Kannel since some month now and ive successfull let it work as the company where i work want.. now.. my next step is save SMS into a DB so ive recompiled Kannel with latest SVN (yesterday 06/12/11) with mysql option enabled (and ofc mysql-devel installed).

MySQL Storage

Hi everyone. im trying to work with Kannel since some month now and ive successfull let it work as the company where i work want.. now.. my next step is save SMS into a DB so ive recompiled Kannel with latest SVN (yesterday 06/12/11) with mysql option enabled (and ofc mysql-devel installed).

mysql storage

hi all, i've finalled gotten round to trying mysql storage. i compiled mysql support in, and included the following in smskannel.conf: group = mysql-connection id = mydlr host = localhost username = kannel password = kannel database = kannel max-connections = 1 group = dlr-db id = mydlr

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

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

Mysql storage engine

Hello, I wish to know what is the suitable mysql engine(MYISAM or INNODB) for dlr and sqlbox (send_sms and sent_sms table) from kannel. I currently have high load of traffic and RAM is not a problem. Please suggest. -- Regards, Ashish

MySQL Storage Example

Hello, Do you have a config example for MySQL storage ? - config for kannel.conf - SQL schema Thanks ! ;) Mickael.

RE: mysql storage

ect: mysql storage hi all, i've finalled gotten round to trying mysql storage. i compiled mysql support in, and included the following in smskannel.conf: group = mysql-connection id = mydlr host = localhost username = kannel password = kannel database = kannel max-connections = 1 group = dl

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

mysql storage probs!!

hi i am using kannel-1.2.0 with CMG smsc and my problem remain the same as it is going to the default service anyhow even i defined so many and another problem is it is not storing DLR into mysql my kannel.conf is look like that and it is running fine without file-syntax error .. # Kannel

Using MySQL storage

eued, using mysql storage (I just played with that table so the 1 row has been inserted by me not by the smsbox daemon.) Although I can send SMS with http://localhost:13002/cgi-bin/sendsms?to=0764611551&username=foo&password=bar&text=Hello and Kannel confirms the built-in MySQL

DLR MySQL storage

Well, as I see, noone would like to reply to my e-mail (Sent on 25st February, ~16:20; Subject: "DLR handling"). So, anyway, I'd like to try once more, but now with another question. Is there any way to make Kannel work with MySQL 4.1.x? For now it does not compile, because of confli

MySQL Storage Fails

Hello, When I try to run kannel with "dlr-storage = mysql", it simply doesn't start, and log files don't say anything, I have love level at 0, but the deamon simply doesn't even start, thus no logging, and I don't know what is wrong. I have below for my mysql configuration in kannel.conf: #

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

= source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc -Original Message- From: users@kannel.org [EMAIL PROTECTED] Sent: 14 ? 2008 ?. To: seik Subject:MySQL Storage Example > Hello, > Do you have a config example for

Re: MySQL Storage Example

Example Hello, Do you have a config example for MySQL storage ? - config for kannel.conf - SQL schema Thanks ! Mickael.

help with mysql storage

hi !! i'm using kannel and all works well(connection to the simulator(smpp), sms sending and receiving), but though i put the mysql storage i find the sms in the table for only submit_sm. and if we can send the messages through http we can set the dlr-mask value.but how we can set a dlr

mysql storage frequent complains

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

RE: Using MySQL storage

- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Reto Hersiczky Sent: vrijdag 5 maart 2004 1:34 To: [EMAIL PROTECTED] Subject: Using MySQL storage I want to store each SMS delivery log entry directly into a MySQL table. I could verify Kannel is able to read from the related database

Re: Using MySQL storage

orked away everything that has been waiting for me in the month that I have been away from my desk. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Reto Hersiczky Sent: vrijdag 5 maart 2004 1:34 To: [EMAIL PROTECTED] Subject: Using MySQL storage

RE: Using MySQL storage

sqlbox logs MO, MT and DLR messages. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pedro B. Sent: vrijdag 19 maart 2004 0:31 To: [EMAIL PROTECTED] Subject: Re: Using MySQL storage Hello, First of all, i apologise if this question

RE: Using MySQL storage

: Using MySQL storage sqlbox logs MO, MT and DLR messages. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pedro B. Sent: vrijdag 19 maart 2004 0:31 To: [EMAIL PROTECTED] Subject: Re: Using MySQL storage Hello, First of all, i apologise if

RE: Using MySQL storage

Nowhere yet. They are 'under construction'. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roman Alonso Sent: dinsdag 23 maart 2004 14:05 To: 'Rene Kluwen'; 'Pedro B.'; [EMAIL PROTECTED] Subject: RE: Using

Re: DLR MySQL storage

Do you have older mysql (3.23.x) installed, which must be tru should you have chosen full OS installtion? Compile kannel with the client library from 3.23 installation. Once, the kannel is compiled, you can use it with mysql 4.1.x. HTH Navjot Singh On Mon, 28 Feb 2005 11:47:50 +0200, Kaspars Fo

Re: DLR MySQL storage

prepend list-delete with 'gw'. This fix should be in cvs. Aarno On 28.2.2005, at 10:47, Kaspars Foigts wrote: Well, as I see, noone would like to reply to my e-mail (Sent on 25st February, ~16:20; Subject: "DLR handling"). So, anyway, I'd like to try once more, but now with another question

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

DLR queued, using mysql storage

Hello support, Am wondering how to delete/flush queued dlrs as its showing in my status and seems to be slowing down things DLR: received 1109, sent 0 DLR: inbound (0.51,0.51,0.54) msg/sec, outbound (0.00,0.00,0.00) msg/sec DLR: 2339007 queued, using mysql storage your assistance would be of

Re: help with mysql storage

www.perusms.NET www.smsglobal.com.mx y www.pravcom.com On Mon, Feb 16, 2009 at 11:00 AM, pandu reddy wrote: > hi !! > i'm using kannel and all works well(connection to the > simulator(smpp), sms sending and receiving), but > though i put the mysql storage i find the sms > in the table

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

Re: mysql storage frequent complains

!) 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 tha

Re: mysql storage frequent complains

AM, Falko Ziemann 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 r

Re: mysql storage frequent complains

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

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

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

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

Regards > Falko > > Am 10.03.2009 um 10:42 schrieb Elton Hoxha: > > > > Hi guys, > > > > I have been searching in the list a lot regarding >

Re: mysql storage frequent complains

then compile (!) kannel with ./configure --with-mysql > > > > > > Regards > > Falko > > > > Am 10.03.2009 um 10:42 schrieb Elton Hoxha: > > > > > > > Hi guys, >

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,

DLR: queued, using mysql storage

dear list pl help i am getting a message when i open status page of kannel. *DLR: 2578 queued, using mysql storage* why it is being, how can i clear queued message, i am using sqlbox for sending message. regards abhi

HUGE DRL QUEUE MYSQL STORAGE

: 753643 queued, using mysql storage Regards, Chris

Re: DLR queued, using mysql storage

1109, sent 0 DLR: inbound (0.51,0.51,0.54) msg/sec, outbound (0.00,0.00,0.00) msg/sec DLR: 2339007 queued, using mysql storage your assistance would be of greatvalue Chris -- Tervitades/Best Wishes, Gert Tamm Süsteemiadministraator/System administrator E-mail: g...@messenger.ee Direct Messenger OÜ

DLR: 0 queued, using mysql storage

: received 0 (0 queued), sent 0 (0 queued) SMS: received 0 (0 queued), sent 3 (0 queued), store size 0 SMS: inbound 0.00 msg/sec, outbound 0.00 msg/sec DLR: 0 queued, using mysql storage Box connections: smsbox:(none), IP 127.0.0.1 (0 queued), (on-line 0d 0h 14m 6s) SMSC connections: wavecom_1

Re: 0 queued, using mysql storage

DP: received 0 (0 queued), sent 0 (0 queued) > SMS: received 0 (0 queued), sent 3 (0 queued), store size 0 > SMS: inbound 0.00 msg/sec, outbound 0.00 msg/sec > DLR: 0 queued, using mysql storage > Box connections: > smsbox:(none), IP 127.0.0.1 (0 queued), (on-line 0d 0h 14m 6s) &g

Re: 0 queued, using mysql storage

255), > > > #ts VARCHAR(255), > > > #destination VARCHAR(255), > > > #service VARCHAR(255), > > > #url VARCHAR(255), > > > #mask VARCHAR(255), > > > #status VARCHAR(255), > > > #boxc VARCHAR(255), > > > #source VARCHAR(255

Re: DLR: queued, using mysql storage

It might be you set dlr-mask and your telco does't enable the DLR and Kannel keeps waiting for the final DLR from telco. On Dec 5, 2012, at 3:21 PM, alok srivastava wrote: > dear list > pl help > i am getting a message when i open status page of kannel. > > DLR: 2578

RE: HUGE DRL QUEUE MYSQL STORAGE

. You can clear that queue by deleting the entry from that table. -Original Message- From: "christopher kamutumwa" Sent: ‎08-‎07-‎2017 06:38 To: "users" Subject: HUGE DRL QUEUE MYSQL STORAGE Hello Team I have DLRs being queued which seems to be big as below

Re: HUGE DRL QUEUE MYSQL STORAGE

the operator. Otherwise it will be on that queue only. > You can clear that queue by deleting the entry from that table. > -- > From: christopher kamutumwa > Sent: ‎08-‎07-‎2017 06:38 > To: users > Subject: HUGE DRL QUEUE MYSQL STORAGE > > Hello Team

RE: HUGE DRL QUEUE MYSQL STORAGE

I don't think you can set auto removal.. You have to do it manually It is better to clear it for fast dlr receival -Original Message- From: "christopher kamutumwa" Sent: ‎08-‎07-‎2017 12:35 To: "robin c" Cc: "users" Subject: Re: HUGE DRL Q

Re: Re[2]: mysql storage frequent complains

erver and fails. Try "pgrep -fl mysqld" >> and if it's not running, start it. >> >> >> >> BR, >> >> Nikos >> >> - Original Message - >> >> From: Elton Hoxha >> >> To: sangprabv >> >> Cc: k

Re: Re[2]: mysql storage frequent complains

: Tuesday, March 10, 2009 4:13 PM Subject: Re: Re[2]: mysql storage frequent complains Hi guys, Is there any parameter to optimize the connection between kannel and mysql? Also, max-pending parameter is refering to the maximum of records that dlr table can hold or it is something

Re: 0 queued, using mysql storage (final post)

Last question before I accept I'm stupid and should not be bothering anyone with more questions > there could have been my fault or version mismatch but as of 1.3.1, there > are 2 variables *dlrurl* and *dlrmask*. I take it as I'm using kannel-cvs (a week or two old) the above still applies, howe

Re: 0 queued, using mysql storage (final post)

Jarl, > I take it as I'm using kannel-cvs (a week or two old) the above still > applies, however I get the message > saying use dlr-mask in my smsbox... any ideas why? There has been a move away from dlrmask to dlr-mask. In future releases you will need to use the later. Cheers, Alan

Re: 0 queued, using mysql storage (Yet more Questions)

This is rather embarrassing, however after having read all the great replies and thinking nothing can go wrong now, things still seem a bit odd. However this is most likely due to some misunderstanding on my side, which is why I'm going to try to clear this out once and for all. You might woun

RE: 0 queued, using mysql storage (Yet more Questions)

Jarlco, You seems to be in hurry. Please calm down. Read this link http://www.kannel.org/download/1.3.1/userguide-1.3.1/userguide.html#AEN3199 Read the details of dlrurl an dlrmask here. http://www.kannel.org/download/1.3.1/userguide-1.3.1/userguide.html#AEN3530 and think thoroughly. >2. >what

Re: 0 queued, using mysql storage (Yet more Questions)

Hi Jarl, I'm not sure but probably you mix up what Kannel do and what Kannel doesn't do (which we must do or create ourselves). 1) If you need to store the outgoing SMS (and its DLR status), you need to stop pursue using Kannel built-in dlr features (I might miss something, but the "group = d

Re: 0 queued, using mysql storage (PLEASE Check this thread again)

gt; Hostname jarlco, IP 192.168.0.10. Libxml version 20508. Using OpenSSL > 0.9.6k > > 30 Sep 2003. Using MySQL 4.0.14. Using native malloc. > > Status: running, uptime 0d 0h 22m 7s > > WDP: received 0 (0 queued), sent 0 (0 queued) > > SMS: received 0 (0 queued), sent 3 (0 q

RE: 0 queued, using mysql storage (PLEASE Check this thread again)

>Jarlco >Sent: Monday, November 10, 2003 5:40 AM >To: [EMAIL PROTECTED] >Subject: Re: 0 queued, using mysql storage (PLEASE Check this thread >again) > > >I've found an old post by "Navjot Singh", in the thead at: > http://www.mail-archive.com/[EMAIL PROTECTED]

Re: 0 queued, using mysql storage (PLEASE Check this thread again)

RCHAR(255), > > > #PRIMARY KEY(smsc) ) > > > #; > > > > > > However when I check the actual database after sending/recieving > > messages > > > > there is nothing in it > > > The status of the boxes looks like this: > > > >

Kannel CVS and DLRs MySQL storage / "can not decode PDU to a message"

Hi everybody, Below an issue I am faced trying to configure DLR management and kannel. Environnement: Kannel CVS 20091124 installed using RPM patch from Alejandro MySQL DLR storage configured Issue: "can not decode PDU to a message" I have configure DLR to use mysql (config file below) I send

Re: Kannel CVS and DLRs MySQL storage / "can not decode PDU to a message"

Adding some informations, I notice when using a Nokia 6230 on another kannel server that it works well and I have the following: ==> /var/log/kannel/access.log <== 2009-12-04 14:08:20 Receive DLR [SMSC:nokia6230] [SVC:alt] [ACT:] [BINF:] [FID:48] [from:687971204] [to:+687773502] [flags:-1:-1:-1:

Re: Kannel CVS and DLRs MySQL storage / "can not decode PDU to a message"

December 04, 2009 5:39 AM Subject: Re: Kannel CVS and DLRs MySQL storage / "can not decode PDU to a message" Adding some informations, I notice when using a Nokia 6230 on another kannel server that it works well and I have the following: ==> /var/log/kannel/access.log

Re: Kannel CVS and DLRs MySQL storage / "can not decode PDU to a message"

nit-string in your modem definition: > > "...;+CMEE=1" or 2. > > But it seems to me a waste of time. > > BR, > Nikos > > - Original Message - > *From:* Emmanuel CHANSON > *To:* users > *Sent:* Friday, December 04, 2009 5:39 AM > *Subjec

Re: Kannel CVS and DLRs MySQL storage / "can not decode PDU to a message"

you tried changing it? Anyway, CMEE might be able to tell you more. BR, Nikos - Original Message - From: Emmanuel CHANSON To: users Sent: Friday, December 04, 2009 11:54 AM Subject: Re: Kannel CVS and DLRs MySQL storage / "can not decode PDU to a message" Thanks

Re: Kannel CVS and DLRs MySQL storage / "can not decode PDU to a message"

Friday, December 04, 2009 11:54 AM > *Subject:* Re: Kannel CVS and DLRs MySQL storage / "can not decode PDU to > a message" > > Thanks Nikos for your reply, > > But I am a little bit surprised about > *As the rest goes, the advice is simple: Use another modem.* > >

Re: Kannel CVS and DLRs MySQL storage / "can not decode PDU to a message"

; Nikos >> >> - Original Message - >> *From:* Emmanuel CHANSON >> *To:* users >> *Sent:* Friday, December 04, 2009 11:54 AM >> *Subject:* Re: Kannel CVS and DLRs MySQL storage / "can not decode PDU to >> a message" >> >> Thanks N