The reason for the problem is clear below, the ASTERISKCDRDB database is being updated instead of the ASTCCDB database which holds the cdrs and BILLCOST.
How can this problem be corrected???
3 Query UPDATE cards SET used='0' WHERE number='58767059'
3 Query UPDATE cards SET inuse='0' WHERE number='58767059'
3 Query SELECT * FROM cards WHERE number='58767059'
3 Query UPDATE cards SET used='0' WHERE number='58767059'
3 Query UPDATE cards SET inuse='0' WHERE number='58767059'
3 Quit
4 Connect [EMAIL PROTECTED] on asteriskcdrdb
4 Query INSERT INTO cdr
Juan Luis Mo yano <[EMAIL PROTECTED]> wrote:
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
Asterisk-Users@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
How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! Photos
_______________________________________________ Asterisk-Users mailing list Asterisk-Users@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