2013/2/21 Arturo SAnchez <artusa...@gmail.com>: > Willy, > > Yes, but I can't catch all the sms sent from my opensmppbox is what I need. > > To catch all the sms sent from a smpp login for example.
You can do that via simple query: SELECT count(*) from sent_sms WHERE boxc_id='XXX' and momt='MT' where 'XXX' is the third argument in smpplogins.txt file, i.e.: #login #password #boxc_id #IP login password XXX 127.0.0.1 if you omit IP address connections will be allowed from anywhere > > Regards > Arturo > > > 2013/2/20 Willy Mularto <sangpr...@gmail.com> >> >> Why not count them from the table (sent_sms)? I think it contains enough >> information >> >> >> Willy Mularto >> sangpr...@gmail.com >> >> On Feb 21, 2013, at 9:51 AM, Arturo SAnchez <artusa...@gmail.com> wrote: >> >> Hi willy >> >> I see. But I meant is there a way to track how many SMS had sent a user >> using opensmppbox ? >> >> I want to track of the SMS sent by my smpplogins.txt using opensmppbox. >> >> Regards >> Arturo >> >> >> 2013/2/20 Willy Mularto <sangpr...@gmail.com> >>> >>> That's how SQLBox works :) >>> send_sms is the queue, when it has been proceed SQLBox move it to >>> sent_sms. Set your all log-level=0 and tail them. Go insert 1 record to >>> send_sms and watch the log. >>> >>> >>> >>> Willy Mularto >>> sangpr...@gmail.com >>> >>> On Feb 21, 2013, at 9:18 AM, Arturo SAnchez <artusa...@gmail.com> wrote: >>> >>> > Hello >>> > >>> > I have just installed the kannel 1.5 with bearerbox, smsbox and >>> > opensmppbox >>> > >>> > I would like to setup correctly the sqlbox in order to have the details >>> > of all the SMS sent from an smpp account. >>> > >>> > I set the port correctly with the bearerbox but I cannot the inserts in >>> > the sent_sms table, when I insert on send_sms it is sent and added to >>> > sent_sms >>> > >>> > Could you please help me on setting up the sqlbox ? I want to know >>> > which user has sent how many messages by smpp account using opensmppbox. >>> > >>> > Thanks >>> > Arturo >>> >> >> >
