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 amijar...@gmail.com 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

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

sqlbox send_sms and openSMPP

2015-04-14 Thread Ali Kashif
Dear Users, I am trying to create a black list system using sqlbox. I have openSMPP -- SQLBox -- Kannel ### SMPPbox ### group = core dlr-storage = internal group = opensmppbox opensmppbox-id = smppbox1 opensmppbox-port = bearerbox-host = 127.0.0.1 bearerbox-port = 13002

Bearerbox Access Log to MySQL

2015-04-14 Thread Alberto Mijares
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 socket, etc... Have anyone done this before? Any advise before I put my hands on would be appretiated. Thanks in

Re: sqlbox send_sms and openSMPP

2015-04-14 Thread Alvaro Cornejo
Hi As far as I know, openSMPP talks directly to bearerbox in bearerbox language. Sqlbox read sms from send_sms table, send them to bearerbox and move sms to sent_sms table. Regards Alvaro