<DIV>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, <U>but the cost of the call is not added to the connection charge</U> to make the total billcost.<BR></DIV>
<DIV>So, it seems that the astcc.agi file I am using has a problem, perhaps you can send me your WORKING astcc.agi.</DIV>
<DIV><BR><B><I>Bernard Cresencia <berncres@rogers.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">If astccdb exists, go to the database configuration<BR>page [Configure] and change the database name to the<BR>correct one. You may have to set up permissions on<BR>this database if it wasn't set up before. If it<BR>doesn't exist, use the 'Create Database' button to<BR>create a new one.<BR>--- Ade Agbero <AGBEROCMS@YAHOO.CO.UK>wrote:<BR><BR>> The reason for the problem is clear below, the<BR>> ASTERISKCDRDB database is being updated instead of<BR>> the ASTCCDB database which holds the cdrs and<BR>> BILLCOST.<BR>> <BR>> How can this problem be corrected???<BR>> <BR>> <BR>> 3 Query UPDATE cards SET used='0' WHERE<BR>> number='58767059'<BR>> 3 Query UPDATE cards SET<BR>> inuse='0' WHERE number='58767059'<BR>> 3 Query SELECT * FROM cards<BR>> WHERE number='58767059'<BR>> 3 Query UPDATE cards SET<BR>> used='0' WHERE number='58767059'<BR>>
3 Query UPDATE cards SET<BR>> inuse='0' WHERE number='58767059'<BR>> 3 Quit <BR>> 4 Connect <BR>> asteriskuser@localhost on asteriskcdrdb<BR>> 4 Query INSERT<BR>> INTO cdr <BR>><BR>(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode)<BR>> VALUES ('2005-06-29 05:17:42','\"Mike\"<BR>> <1234>','1234','777','TEST',<BR>><BR>'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,'')<BR>> <BR>> <BR>> <BR>> Juan Luis Moyano <JUANMOYANO@SOUTHECON.COM.AR><BR>> wrote:<BR>> Bernard Cresencia wrote:<BR>> > sorry, I meant my.cnf, not my.conf.<BR>> ><BR>> > Once logging is enabled, I would do tail -f<BR>> > /var/log/myslqd.log and watch as the database is<BR>> being<BR>> > accessed during a call.<BR>> <BR>> <BR>> I've done what Bernard suggested and this is
my<BR>> output from mysql.log on<BR>> a successful call to number 612 on FWD. I'd like to<BR>> know if any of you<BR>> see something wrong or rare. Thanks a lot.<BR>> <BR>> Time Id Command Argument<BR>> 050629 1:02:02 1 Connect root@localhost on astcc<BR>> 050629 1:02:04 1 Query SELECT * FROM cards WHERE<BR>> number='21'<BR>> 1 Query SELECT * FROM cards WHERE number='21'<BR>> 1 Query SELECT * FROM cards WHERE number='21'<BR>> 1 Query SELECT * FROM cards WHERE number='21'<BR>> 1 Query UPDATE cards SET used='1801' WHERE<BR>> number='21'<BR>> 1 Query UPDATE cards SET inuse='1' WHERE<BR>> number='21'<BR>> 050629 1:02:10 1 Query SELECT * FROM routes WHERE<BR>> '612'<BR>> RLIKE pattern ORDER BY LENGTH(pattern) DESC<BR>> 050629 1:02:25 1 Query SELECT * FROM cards WHERE<BR>> number='21'<BR>> 1 Query SELECT * FROM trunks WHERE name='FWD'<BR>> 050629 1:02:37 1 Query INSERT INTO
cdrs<BR>><BR>(cardnum,callerid,callednum,trunk,disposition,billseconds,billcost,callstart)<BR>> VALUES ('21', '\"Coco\" <21>', '612', 'FWD',<BR>> 'ANSWER', '9', '150', 'Wed<BR>> Jun 29 01:02:37 2005')<BR>> 1 Query UPDATE cards SET used='1951' WHERE<BR>> number='21'<BR>> 1 Query UPDATE cards SET inuse='0' WHERE<BR>> number='21'<BR>> 1 Query SELECT * FROM cards WHERE number='21'<BR>> 1 Query UPDATE cards SET used='1951' WHERE<BR>> number='21'<BR>> 1 Query UPDATE cards SET inuse='0' WHERE<BR>> number='21'<BR>> 1 Quit<BR>> <BR>> -- <BR>> Juan Luis Moyano<BR>> juanmoyano@southecon.com.ar<BR>> <BR>> _______________________________________________<BR>> Asterisk-Users mailing list<BR>> Asterisk-Users@lists.digium.com<BR>><BR>http://lists.digium.com/mailman/listinfo/asterisk-users<BR>> To UNSUBSCRIBE or update options visit:<BR>><BR>http://lists.digium.com/mailman/listinfo/asterisk-users<BR>> <BR>>
<BR>> <BR>> ---------------------------------<BR>> How much free photo storage do you get? Store your<BR>> holiday snaps for FREE with Yahoo! Photos. Get<BR>> Yahoo! Photos><BR>_______________________________________________<BR>> Asterisk-Users mailing list<BR>> Asterisk-Users@lists.digium.com<BR>><BR>http://lists.digium.com/mailman/listinfo/asterisk-users<BR>> To UNSUBSCRIBE or update options visit:<BR>> <BR>http://lists.digium.com/mailman/listinfo/asterisk-users<BR><BR>_______________________________________________<BR>Asterisk-Users mailing list<BR>Asterisk-Users@lists.digium.com<BR>http://lists.digium.com/mailman/listinfo/asterisk-users<BR>To UNSUBSCRIBE or update options visit:<BR>http://lists.digium.com/mailman/listinfo/asterisk-users<BR></BLOCKQUOTE><p>
<hr size=1><font face="Arial" size="2">How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. <a href="http://us.rd.yahoo.com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.com/"><b>Get Yahoo!
Photos</b></a></font>