RE: [Asterisk-Users] MY Sql CDR

2003-09-22 Thread Uriel Carrasquilla
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

Re: [Asterisk-Users] MY Sql CDR

2003-09-22 Thread Tilghman Lesher
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

RE: [Asterisk-Users] MY Sql CDR

2003-09-21 Thread Uriel Carrasquilla
: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

Re: [Asterisk-Users] MY Sql CDR

2003-09-21 Thread Tilghman Lesher
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

RE: [Asterisk-Users] MY Sql CDR

2003-09-21 Thread Uriel Carrasquilla
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

RE: [Asterisk-Users] MY Sql CDR

2003-09-21 Thread Paul Crick
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? ___

RE: [Asterisk-Users] MY Sql CDR

2003-09-21 Thread Uriel Carrasquilla
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

Re: [Asterisk-Users] MY Sql CDR

2003-09-21 Thread Olle E. Johansson
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

Re: [Asterisk-Users] MY Sql CDR

2003-09-20 Thread Brancaleoni Matteo
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

[Asterisk-Users] MY Sql CDR

2003-09-20 Thread Robert Boardman
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