[Asterisk-Users] ASTCC not billing

[Bernard Cresencia]

If astccdb exists, go to the database configuration
page [Configure] and change the database name to the
correct one. You may have to set up permissions on
this database if it wasn't set up before. If it
doesn't exist, use the 'Create Database' button to
create a new one.
--- Ade Agbero <agberocms at yahoo.co.uk> wrote:

> 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>
_______________________________________________
> 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