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" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<[email protected]>
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 [EMAIL PROTECTED] 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
[EMAIL PROTECTED]
_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
