Hi Perl lovers,

               I am a newbee to perl studiying  perl manuals since 20 days
and started little programing on additions and regexps and so, on...

Here i need a suggestion from you guys regarding the mysql database and
writing a script on RAW CDRs so that i can make billing on that ,

i will explain my problem some more clearly :-(
                                                                     for
every call my Freeradius server is writing records in mysql server, lets say
more than one record for ever call may be 2 or may be 10 , but for every
record of a call there is unique acctsession id so here i want to take that
acctsession id as a key and manipulate the database and write on different
table or on different file .

                               the sample record for a call is as follows :

RadAcctId   |        AcctSessionId
      |   callingstationid         |       calledstation       |
acctstarttime          |  acctstoptime
  101          |       0051e13de766a328NmY2MmFhZWNmNWE0   |
32331001              |        12345               |   2006-08-10 13:30:04
|  0000-00-00 00:00:00
  102          |       0051e13de766a328NmY2MmFhZWNmNWE0   |
32331001              |          12345             |   0000-00-00 00:00:00|
2006-08-10 13:32:06

so this is my problem : in some cases for a call i am getting more than 5
records

so Gurus, please give me an out line scenario how to solve this and so that
i can write a new table or a new file with manipulating these type of
records and get a one record .

   I hope i will get some suggestions,
                                                                 Thank you.

regards,
Ravi.

Reply via email to