On Sunday 21 September 2003 11:30 pm, Uriel Carrasquilla wrote:
I like it.
I am thinking of putting this query in a C++ but I am a bit concern
on 1) scalability
2) delays in setting up the calls
shoud I be concerned?
The query:
mysql select sum(billsec) from cdr where calldate
'2003-09-01
Look here:
http://www.voip-info.org/tiki-index.php?page=Asterisk+cdr+mysql
/Olle
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
AM
To: [EMAIL PROTECTED]
Subject: Re: [Asterisk-Users] MY Sql CDR
Look here:
http://www.voip-info.org/tiki-index.php?page=Asterisk+cdr+mysql
/Olle
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
You could have an AGI script that runs after an outbound call to update a
running-total figure with the amount of either the last call or all calls to
date in the current period?
That way you're just checking a stored value before allowing/denying an
outbound call?
PROTECTED] Behalf Of Paul Crick
Sent: Sunday, September 21, 2003 8:33 PM
To: [EMAIL PROTECTED]
Subject: RE: [Asterisk-Users] MY Sql CDR
You could have an AGI script that runs after an outbound call to update a
running-total figure with the amount of either the last call or all calls to
date
On Sunday 21 September 2003 18:16, Uriel Carrasquilla wrote:
I have a question regarding MySQL CDR's:
For a given extension I need to limit the number of minutes it can
use in a given week.
I was thinking about using the CDR information in the MySQL table to
see the usage for the week and
:42 PM
To: [EMAIL PROTECTED]
Subject: Re: [Asterisk-Users] MY Sql CDR
On Sunday 21 September 2003 18:16, Uriel Carrasquilla wrote:
I have a question regarding MySQL CDR's:
For a given extension I need to limit the number of minutes it can
use in a given week.
I was thinking about using the CDR
Hi.
create a db with mysql create the table as
in cdr_mysql.txt (you'll find it in asterisk/doc
directory). Then take a look @ /etc/asterisk/cdr_mysql.conf
for enabling it.
For ex. my cdr_mysql.conf is
[global]
hostname=127.0.0.1
dbname=asterisk
password=myownpasswd
user=myownuserid
matteo
Il