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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>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'< BR>> 3 Query UPDATE cards SET
> inuse='0' WHERE number='58767059'
> 3 Quit
> 4 Connect
> [EMAIL PROTECTED] 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 <[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
> [email protected]
>
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
> [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
How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! Photos
_______________________________________________ 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
