Re: Bearerbox Access Log to MySQL

2015-04-15 Thread Tapan Kumar Thapa
I am using GET (CGI-BIN/SENDSMS) to inject sms at kannel and the performance of kannel is just gr8 as i am not using any SQL operations at Kannel level so that it can work at full speed without any dependency. On Wed, Apr 15, 2015 at 4:56 PM, Makhanu Sinja wrote: > Tapan By using curl to send po

Re: Bearerbox Access Log to MySQL

2015-04-15 Thread Makhanu Sinja
Tapan By using curl to send post to kannel, would the performance equal to what you stated? On 4/15/15, Tapan Kumar Thapa wrote: > I do not want any fight here however here is my comments. > > If we use SQLBOX, below are the extra operations which happened. > > 1. Select from send_sms table > 2.

Re: Bearerbox Access Log to MySQL

2015-04-15 Thread Tapan Kumar Thapa
I do not want any fight here however here is my comments. If we use SQLBOX, below are the extra operations which happened. 1. Select from send_sms table 2. Delete from send_sms table 3. Insert into sent_sms table 4. Update sent_sms table once DLR received FOR EVERY SMS. As per my experience, if

Re: Bearerbox Access Log to MySQL

2015-04-15 Thread spameden
2015-04-15 7:13 GMT+03:00 Tapan Kumar Thapa : > If application is going to send huge number of messages via kannel than i > think we should not configure kannel anyhow with MySQL (Or Any other > database) as All databases actually slow the performance of kannel due to > select/insert/update/delete

Re: Bearerbox Access Log to MySQL

2015-04-14 Thread Alberto Mijares
Got it. I think it won't be like "huge number of messages"; anyway, what I'm gonna do is to process the log file via the OS log management utility (newsyslog in my case) with the help of a small Perl script. Thank you for your tips. Best regards, Alberto Mijares On Tue, Apr 14, 2015 at 11:43

Re: Bearerbox Access Log to MySQL

2015-04-14 Thread Tapan Kumar Thapa
If application is going to send huge number of messages via kannel than i think we should not configure kannel anyhow with MySQL (Or Any other database) as All databases actually slow the performance of kannel due to select/insert/update/delete operations. We should make our own application in fro

Re: Bearerbox Access Log to MySQL

2015-04-14 Thread Alberto Mijares
I do, but I'm setting up a new SMS gateway with 2 layers of accounting. The lower layer must have the MT's actually sent by Bearerbox. I know that sent_sms table already has this information; however, there may be another SQLBox running against the same Bearerbox. Do you see my approach? Thank you

Re: Bearerbox Access Log to MySQL

2015-04-14 Thread Willy Mularto
Why don’t you use SQLBox? > On Apr 15, 2015, at 5:24 AM, Alberto Mijares wrote: > > Hi guys, > > I'd like to send bearerbox access logs directly to a MySQL table. I > think I could try > > group = core > ... > access-log = "/path/to/any/socket" > ... > > and have a script reading the socke