[Asterisk-Users] ASTCC not billing

[Ade Agbero]

the database exists because that is where the cards\PINs are stored, without the card\PIN I can not make a call, so the database exists, the permissions issue also may not be valid because when I set a connection charge the connection charge is recorded as billcost, but the cost of the call is not added to the connection charge to make the total billcost.

So, it seems that the astcc.agi file I am using has a problem, perhaps you can send me your WORKING astcc.agi.

Bernard Cresencia <berncres at rogers.com> wrote:
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 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 
> 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

_______________________________________________
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/e4241016/attachment.htm