Thank you. I will follow your advise on the indexes.
Regards,
Uriel
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Tilghman
Lesher
Sent: Monday, September 22, 2003 1:43 PM
To: [EMAIL PROTECTED]
Subject: Re: [Asterisk-Users] MY Sql CDR
On Sunday 21
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-0
: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 thinkin
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
EMAIL 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 i
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?
___
2003 10:20 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/aste
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
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
Could someone point me in the right direction for setting up the mysql
cdr function
Thanks
robb
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
10 matches
Mail list logo