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