[Serusers] logging calls per hour

Iqbal iqbal at gigo.co.uk
Fri Apr 1 12:40:44 CEST 2005


Hi

Thanks, I have all the details being logged into acc table, and I have 
the rating engine all done for my prefixes, and am sure its easy, just 
was wondering if there was way of doing it in one SQL query, my SQL is a 
bit poor

Iqbal

Dirk Willbrandt wrote:

> Hi Iqbal,
>
> i think that is easy...
> Configure your ser with the acc module or better with the radius module.
> The Datas can be written to a mysql database, which is optimal.
>
> Now write a Script in PHP or another language that can connect to a 
> MySQL-
> Database, read out all the calls, and make a graph of this.
>
> This is just one way, but i think, when you want to use accounting and 
> radius authentication,
> then this is the easiest way.
>
> When i goes wrong, correct me :-)
>
> Dirk
>
> Iqbal wrote:
>
>> Hi
>>
>> Anyone know of a simple script to pull calls per hour details out of 
>> acc.
>> I just want a no. calls per hour per day details, so I can throw into a
>> graph.
>>
>> Iqbal
>>
>> _______________________________________________
>> Serusers mailing list
>> serusers at lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>  
>>
>
>
> .
>




More information about the sr-users mailing list