[Asterisk-Users] ASTCC not billing

[Juan Luis Moyano]

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