[Asterisk-Users] ASTCC not billing

[Ade Agbero]

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     asteriskuser at localhost on asteriskcdrdb
                              4 Query       INSERT INTO cdr 
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode) VALUES ('2005-06-29 05:17:42','\"Mike\" <1234>','1234','777','TEST', 'SIP/1234-f285','SIP/213.45.62.117-1732','Dial','SIP/213.45.62.117/19315461298|30|HL(600000000:60000:30000)',42,42,'ANSWERED',3,'')



Juan Luis Moyano <juanmoyano at southecon.com.ar> 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 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


		
---------------------------------
How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! Photos
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050629/edac99e3/attachment.htm