[Asterisk-Users] ASTCC not billing

Bernard Cresencia berncres at rogers.com
Wed Jun 29 02:13:13 MST 2005


That looks right, the database is being updated properly. The last call 
lasted 9 seconds and cost you 1.5c so it should show up in the database.

You did create a 2-digit card called '21' right?

----- Original Message ----- 
From: "Juan Luis Moyano" <juanmoyano at southecon.com.ar>
To: "Asterisk Users Mailing List - Non-Commercial Discussion" 
<asterisk-users at lists.digium.com>
Sent: Wednesday, June 29, 2005 12:13 AM
Subject: Re: [Asterisk-Users] ASTCC not billing


> Bernard Cresencia wrote:
>> sorry, I meant my.cnf, not my.conf.
>>
>> Once logging is enabled, I would do tail -f
>> /var/log/myslqd.log and watch as the database is being
>> accessed during a call.
>
>
> I've done what Bernard suggested and this is my output from mysql.log on
> a successful call to number 612 on FWD. I'd like to know if any of you
> see something wrong or rare. Thanks a lot.
>
> Time                 Id Command    Argument
> 050629  1:02:02       1 Connect     root at localhost on astcc
> 050629  1:02:04       1 Query       SELECT * FROM cards WHERE number='21'
>                      1 Query       SELECT * FROM cards WHERE number='21'
>                      1 Query       SELECT * FROM cards WHERE number='21'
>                      1 Query       SELECT * FROM cards WHERE number='21'
>                      1 Query       UPDATE cards SET used='1801' WHERE
> number='21'
>                      1 Query       UPDATE cards SET inuse='1' WHERE
> number='21'
> 050629  1:02:10       1 Query       SELECT * FROM routes WHERE '612'
> RLIKE pattern ORDER BY LENGTH(pattern) DESC
> 050629  1:02:25       1 Query       SELECT * FROM cards WHERE number='21'
>                      1 Query       SELECT * FROM trunks WHERE name='FWD'
> 050629  1:02:37       1 Query       INSERT INTO cdrs
> (cardnum,callerid,callednum,trunk,disposition,billseconds,billcost,callstart)
> VALUES ('21', '\"Coco\" <21>', '612', 'FWD', 'ANSWER', '9', '150', 'Wed
> Jun 29 01:02:37 2005')
>                      1 Query       UPDATE cards SET used='1951' WHERE
> number='21'
>                      1 Query       UPDATE cards SET inuse='0' WHERE
> number='21'
>                      1 Query       SELECT * FROM cards WHERE number='21'
>                      1 Query       UPDATE cards SET used='1951' WHERE
> number='21'
>                      1 Query       UPDATE cards SET inuse='0' WHERE
> number='21'
>                      1 Quit
>
> -- 
> Juan Luis Moyano
> juanmoyano at southecon.com.ar
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users 




More information about the asterisk-users mailing list