Re: Kannel Mysql connectivity

2010-09-16 Thread Elton Hoxha
If message is sent (delivered as well), you will not find that record in dlr table. That is the logic of that table. Being populated with undelivered SMS-s. After each delivery the row is deleted. Thi is the main goal of DLR table. On Thu, Sep 16, 2010 at 7:34 AM, Harbhag Singh Sohal wrote: > On

Re: Kannel Mysql connectivity

2010-09-15 Thread Harbhag Singh Sohal
On Mon, Sep 13, 2010 at 5:09 PM, Harbhag Singh Sohal wrote: > On Mon, Sep 13, 2010 at 4:53 PM, Rene Kluwen wrote: >> See userguide about directive "access-log" in group = core. I did as you said and now in access-log I can see the messages sent. But I dont anything getting stored in the MySQL dat

Re: Kannel Mysql connectivity

2010-09-13 Thread Harbhag Singh Sohal
On Mon, Sep 13, 2010 at 4:53 PM, Rene Kluwen wrote: > See userguide about directive "access-log" in group = core. Alright I will do it and then I will report back here. Thanks

RE: Kannel Mysql connectivity

2010-09-13 Thread Rene Kluwen
See userguide about directive "access-log" in group = core. -Original Message- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Harbhag Singh Sohal Sent: Monday, 13 September, 2010 13:09 To: users@kannel.org Subject: Re: Kannel Mysql connectivity O

Re: Kannel Mysql connectivity

2010-09-13 Thread Nikos Balkanas
Read User's Guide. BR, Nikos - Original Message - From: "Harbhag Singh Sohal" To: Sent: Monday, September 13, 2010 2:08 PM Subject: Re: Kannel Mysql connectivity On Mon, Sep 13, 2010 at 1:26 AM, Rene Kluwen wrote: Otherwise: Check your access logs and possibly par

Re: Kannel Mysql connectivity

2010-09-13 Thread Harbhag Singh Sohal
On Mon, Sep 13, 2010 at 1:26 AM, Rene Kluwen wrote: > Otherwise: Check your access logs and possibly parse them. Where can I find the access logs. in /var/log/kannel there are only bearerbox and wapbox logs. -- Harbhag Singh Sohal Website : http://harbhag.wordpress.com/

RE: Kannel Mysql connectivity

2010-09-13 Thread Rene Kluwen
Ask this question on the Kannel mailinglist. You might get an answer. == Rene -Original Message- From: Harbhag Singh Sohal [mailto:harbhag.so...@gmail.com] Sent: Monday, 13 September, 2010 06:27 To: Rene Kluwen Subject: Re: Kannel Mysql connectivity On Mon, Sep 13, 2010 at 1:26 AM

RE: Kannel Mysql connectivity

2010-09-12 Thread Rene Kluwen
Otherwise: Check your access logs and possibly parse them. -Original Message- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Scott Geller Sent: Sunday, 12 September, 2010 18:55 To: Harbhag Singh Sohal; users@kannel.org Subject: Re: Kannel Mysql connectivity

RE: Kannel Mysql connectivity

2010-09-12 Thread Rene Kluwen
y, 12 September, 2010 18:59 To: users@kannel.org Subject: Re: Kannel Mysql connectivity On Sun, Sep 12, 2010 at 10:25 PM, Scott Geller wrote: > What exactly do you need in the database? > > I've had lots of luck with sqlbox capturing all data I need I want to have Date,Time, IP and con

Re: Kannel Mysql connectivity

2010-09-12 Thread Harbhag Singh Sohal
On Sun, Sep 12, 2010 at 10:25 PM, Scott Geller wrote: > What exactly do you need in the database? > > I've had lots of luck with sqlbox capturing all data I need I want to have Date,Time, IP and content of SMS sent in the database. Is this possible ? What do I need to do for this ? -- Harbhag Si

Re: Kannel Mysql connectivity

2010-09-12 Thread Scott Geller
What exactly do you need in the database? I've had lots of luck with sqlbox capturing all data I need On 9/11/10, Harbhag Singh Sohal wrote: > 2010/9/11 Nikos Balkanas : >> Hi, >> >> DLRs are in there. Read User's guide about dlr-storage. > > I was reading the users guide but I cant understand t

Re: Kannel Mysql connectivity

2010-09-10 Thread Harbhag Singh Sohal
2010/9/11 Nikos Balkanas : > Hi, > > DLRs are in there. Read User's guide about dlr-storage. I was reading the users guide but I cant understand that do I have to define the following all the fields in the database ? group = dlr-db id = dlr-db table = dlr field-smsc = smsc field-timestamp = ts fie

Re: Kannel Mysql connectivity

2010-09-10 Thread Nikos Balkanas
Hi, DLRs are in there. Read User's guide about dlr-storage. BR, Nikos - Original Message - From: "Harbhag Singh Sohal" To: Sent: Saturday, September 11, 2010 9:00 AM Subject: Kannel Mysql connectivity I have successfully connected kannel to MySQL , and when I start the bearerbox I