Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
A comment and a question about the latest version: First, the question: What is the organizing principle of the "Asterisk Minutes" chart, with respect to the ordering of the various days? It seems random. . . I also assume the last column is the average number of minutes per call? As to the fix, I had to make a change to ~/lib/Class.Table.php in order to pass syntactic muster with Postgres 7.4.1, the corrected version of which is: if (DB_TYPE == "postgres"){ // $sql_limit = " LIMIT $limite"; $sql_limit = " LIMIT $limite OFFSET $current_record"; }else{ $sql_limit = " LIMIT $current_record,$limite"; } } Otherwise it now works beautifully for me (Apache 2.0.49, PHP 5.0.0RC1, Postgres 7.4.1) Thanks. B. ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Sounds like it s missing smth in your php conf ! have a look to this good tutorial http://www.zend.com/zend/tut/tutsweat3.php Check your configuration with the conf information provided there and then try to make working a jpgraph sample on your server... Hope that it will help, Regards,Areski On Thu, 2004-03-25 at 13:18, Robert Boardman wrote: > Hi Areski > > it comes back with a blank page? > > Robb > > Areski <[EMAIL PROTECTED]> said: > > > Can you try: > > > http://yourdomain/asterisk-stat/graph_stat.php?min_call=&fromstatsday_sday=25&days_compare=2&fromstatsmonth_sday=2004-03 > > > > And tell me about the result ! > > -Areski > > > > On Thu, 2004-03-25 at 11:13, Robert Boardman wrote: > > > Yes php sysinfo say gd is complied inb > > > > > > any other clues? > > > > > > Robb > > > > > > Areski <[EMAIL PROTECTED]> said: > > > > > > > Do your php support "GD" ? > > > > > > > > You can simply check it with a phpinfo ! > > > > More info about gd (configuration, installation) : > > > > http://www.php.net/image > > > > > > > > > > > > > > > > On Wed, 2004-03-24 at 21:12, Robert Boardman wrote: > > > > > Hi I'm trying to install but I think I have a problem!!! > > > > > > > > > > Would I be correct in saying if I don't have the jp graph libs, the > > > > > links on the form would be followed but nothing would be displayed > > > > > > > > > > Areski wrote: > > > > > > > > > > >I made an Update, now don't need register_globals on anymore... > > > > > > > > > > > >By the way, I fix some bugs, cause it was not possible to choose > > > > > >criteria and then browse the result page by page... now it's work fine > > > > > >:) > > > > > > > > > > > > > > > > > >So, better to make an update of your version > > > > > >http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_2.tar.gz > > > > > > > > > > > >http://www.areski.net/asterisk-stat-v1/about.php > > > > > > > > > > > > > > > > > > > > > > > >Sorry about all this changes... > > > > > >Regards, > > > > > >Areski > > > > > > > > > > > > > > > > > >On Wed, 2004-03-24 at 16:42, Ryan Thrash wrote: > > > > > > > > > > > > > > > > > >>Does register_globals need to be on to work with this? And if so, any > > > > > >>chance that will be turned off in the (hopefully near) future? > > > > > >> > > > > > >>Thanks, Ryan > > > > > >> > > > > > >>On Mar 24, 2004, at 9:09 AM, Areski wrote: > > > > > >> > > > > > >> > > > > > >> > > > > > >>>I just finished an other version, all my apologies, cause I made it for > > > > > >>>mysql then I ve done the change to support postgresql and forget to > > > > > >>>re-test again... not really professional at all ;) > > > > > >>> > > > > > >>>http://www.areski.net/asterisk-stat-v1/about.php > > > > > >>> > > > > > >>>Download : > > > > > >>>http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz > > > > > >>> > > > > > >>>If you have still some problems, share them with me ! > > > > > >>> > > > > > >>> > > > > > >> > > > > > > > > > > ___ > > > > > 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 > > > > > > > > > > > > > > > > > > > -- > > > Robert Boardman > > > Tel:01617737929 > > > IAXTel:17007737929 > > > FWD:82623 > > > > > > ___ > > > 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 > > > > > > > -- > Robert Boardman > Tel:01617737929 > IAXTel:17007737929 > FWD:82623 > > ___ > 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Hi Areski it comes back with a blank page? Robb Areski <[EMAIL PROTECTED]> said: > Can you try: > http://yourdomain/asterisk-stat/graph_stat.php?min_call=&fromstatsday_sday=25&days_compare=2&fromstatsmonth_sday=2004-03 > > And tell me about the result ! > -Areski > > On Thu, 2004-03-25 at 11:13, Robert Boardman wrote: > > Yes php sysinfo say gd is complied inb > > > > any other clues? > > > > Robb > > > > Areski <[EMAIL PROTECTED]> said: > > > > > Do your php support "GD" ? > > > > > > You can simply check it with a phpinfo ! > > > More info about gd (configuration, installation) : > > > http://www.php.net/image > > > > > > > > > > > > On Wed, 2004-03-24 at 21:12, Robert Boardman wrote: > > > > Hi I'm trying to install but I think I have a problem!!! > > > > > > > > Would I be correct in saying if I don't have the jp graph libs, the > > > > links on the form would be followed but nothing would be displayed > > > > > > > > Areski wrote: > > > > > > > > >I made an Update, now don't need register_globals on anymore... > > > > > > > > > >By the way, I fix some bugs, cause it was not possible to choose > > > > >criteria and then browse the result page by page... now it's work fine > > > > >:) > > > > > > > > > > > > > > >So, better to make an update of your version > > > > >http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_2.tar.gz > > > > > > > > > >http://www.areski.net/asterisk-stat-v1/about.php > > > > > > > > > > > > > > > > > > > >Sorry about all this changes... > > > > >Regards, > > > > >Areski > > > > > > > > > > > > > > >On Wed, 2004-03-24 at 16:42, Ryan Thrash wrote: > > > > > > > > > > > > > > >>Does register_globals need to be on to work with this? And if so, any > > > > >>chance that will be turned off in the (hopefully near) future? > > > > >> > > > > >>Thanks, Ryan > > > > >> > > > > >>On Mar 24, 2004, at 9:09 AM, Areski wrote: > > > > >> > > > > >> > > > > >> > > > > >>>I just finished an other version, all my apologies, cause I made it for > > > > >>>mysql then I ve done the change to support postgresql and forget to > > > > >>>re-test again... not really professional at all ;) > > > > >>> > > > > >>>http://www.areski.net/asterisk-stat-v1/about.php > > > > >>> > > > > >>>Download : > > > > >>>http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz > > > > >>> > > > > >>>If you have still some problems, share them with me ! > > > > >>> > > > > >>> > > > > >> > > > > > > > > ___ > > > > 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 > > > > > > > > > > > > > -- > > Robert Boardman > > Tel:01617737929 > > IAXTel:17007737929 > > FWD:82623 > > > > ___ > > 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 > -- Robert Boardman Tel:01617737929 IAXTel:17007737929 FWD:82623 ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Can you try: http://yourdomain/asterisk-stat/graph_stat.php?min_call=&fromstatsday_sday=25&days_compare=2&fromstatsmonth_sday=2004-03 And tell me about the result ! -Areski On Thu, 2004-03-25 at 11:13, Robert Boardman wrote: > Yes php sysinfo say gd is complied inb > > any other clues? > > Robb > > Areski <[EMAIL PROTECTED]> said: > > > Do your php support "GD" ? > > > > You can simply check it with a phpinfo ! > > More info about gd (configuration, installation) : > > http://www.php.net/image > > > > > > > > On Wed, 2004-03-24 at 21:12, Robert Boardman wrote: > > > Hi I'm trying to install but I think I have a problem!!! > > > > > > Would I be correct in saying if I don't have the jp graph libs, the > > > links on the form would be followed but nothing would be displayed > > > > > > Areski wrote: > > > > > > >I made an Update, now don't need register_globals on anymore... > > > > > > > >By the way, I fix some bugs, cause it was not possible to choose > > > >criteria and then browse the result page by page... now it's work fine > > > >:) > > > > > > > > > > > >So, better to make an update of your version > > > >http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_2.tar.gz > > > > > > > >http://www.areski.net/asterisk-stat-v1/about.php > > > > > > > > > > > > > > > >Sorry about all this changes... > > > >Regards, > > > >Areski > > > > > > > > > > > >On Wed, 2004-03-24 at 16:42, Ryan Thrash wrote: > > > > > > > > > > > >>Does register_globals need to be on to work with this? And if so, any > > > >>chance that will be turned off in the (hopefully near) future? > > > >> > > > >>Thanks, Ryan > > > >> > > > >>On Mar 24, 2004, at 9:09 AM, Areski wrote: > > > >> > > > >> > > > >> > > > >>>I just finished an other version, all my apologies, cause I made it for > > > >>>mysql then I ve done the change to support postgresql and forget to > > > >>>re-test again... not really professional at all ;) > > > >>> > > > >>>http://www.areski.net/asterisk-stat-v1/about.php > > > >>> > > > >>>Download : > > > >>>http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz > > > >>> > > > >>>If you have still some problems, share them with me ! > > > >>> > > > >>> > > > >> > > > > > > ___ > > > 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 > > > > > > > -- > Robert Boardman > Tel:01617737929 > IAXTel:17007737929 > FWD:82623 > > ___ > 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Yes php sysinfo say gd is complied inb any other clues? Robb Areski <[EMAIL PROTECTED]> said: > Do your php support "GD" ? > > You can simply check it with a phpinfo ! > More info about gd (configuration, installation) : > http://www.php.net/image > > > > On Wed, 2004-03-24 at 21:12, Robert Boardman wrote: > > Hi I'm trying to install but I think I have a problem!!! > > > > Would I be correct in saying if I don't have the jp graph libs, the > > links on the form would be followed but nothing would be displayed > > > > Areski wrote: > > > > >I made an Update, now don't need register_globals on anymore... > > > > > >By the way, I fix some bugs, cause it was not possible to choose > > >criteria and then browse the result page by page... now it's work fine > > >:) > > > > > > > > >So, better to make an update of your version > > >http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_2.tar.gz > > > > > >http://www.areski.net/asterisk-stat-v1/about.php > > > > > > > > > > > >Sorry about all this changes... > > >Regards, > > >Areski > > > > > > > > >On Wed, 2004-03-24 at 16:42, Ryan Thrash wrote: > > > > > > > > >>Does register_globals need to be on to work with this? And if so, any > > >>chance that will be turned off in the (hopefully near) future? > > >> > > >>Thanks, Ryan > > >> > > >>On Mar 24, 2004, at 9:09 AM, Areski wrote: > > >> > > >> > > >> > > >>>I just finished an other version, all my apologies, cause I made it for > > >>>mysql then I ve done the change to support postgresql and forget to > > >>>re-test again... not really professional at all ;) > > >>> > > >>>http://www.areski.net/asterisk-stat-v1/about.php > > >>> > > >>>Download : > > >>>http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz > > >>> > > >>>If you have still some problems, share them with me ! > > >>> > > >>> > > >> > > > > ___ > > 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 > -- Robert Boardman Tel:01617737929 IAXTel:17007737929 FWD:82623 ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Do your php support "GD" ? You can simply check it with a phpinfo ! More info about gd (configuration, installation) : http://www.php.net/image On Wed, 2004-03-24 at 21:12, Robert Boardman wrote: > Hi I'm trying to install but I think I have a problem!!! > > Would I be correct in saying if I don't have the jp graph libs, the > links on the form would be followed but nothing would be displayed > > Areski wrote: > > >I made an Update, now don't need register_globals on anymore... > > > >By the way, I fix some bugs, cause it was not possible to choose > >criteria and then browse the result page by page... now it's work fine > >:) > > > > > >So, better to make an update of your version > >http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_2.tar.gz > > > >http://www.areski.net/asterisk-stat-v1/about.php > > > > > > > >Sorry about all this changes... > >Regards, > >Areski > > > > > >On Wed, 2004-03-24 at 16:42, Ryan Thrash wrote: > > > > > >>Does register_globals need to be on to work with this? And if so, any > >>chance that will be turned off in the (hopefully near) future? > >> > >>Thanks, Ryan > >> > >>On Mar 24, 2004, at 9:09 AM, Areski wrote: > >> > >> > >> > >>>I just finished an other version, all my apologies, cause I made it for > >>>mysql then I ve done the change to support postgresql and forget to > >>>re-test again... not really professional at all ;) > >>> > >>>http://www.areski.net/asterisk-stat-v1/about.php > >>> > >>>Download : > >>>http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz > >>> > >>>If you have still some problems, share them with me ! > >>> > >>> > >> > > ___ > 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
RE: [Asterisk-Users] Graphical Interface to display Asterisk CDR /php
I get it... How I can drop the data log from * to database? Best regards, Chris HARIGA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris HARIGA Sent: Wednesday, March 24, 2004 12:07 AM To: [EMAIL PROTECTED] Subject: RE: [Asterisk-Users] Graphical Interface to display Asterisk CDR /php Hi, I get this ... Database error: Invalid SQL: SELECT calldate, channel, src, clid, lastapp, lastdata, dst, dst, disposition, duration FROM cdr ORDER BY calldate DESC LIMIT 0,25 MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist) Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2004-03-01') GROUP BY substring(calldate,1,10) MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist) Database error: Invalid SQL: SELECT count(*) FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2004-03-01') MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist) Database error: next_record called with no query pending. MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist) And I have the database and the table on my mysql :( Best regards, Chris HARIGA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Areski Sent: Wednesday, March 24, 2004 1:35 PM To: Asterisk-Users Mailing-list Subject: Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR /php I made an Update, now don't need register_globals on anymore... By the way, I fix some bugs, cause it was not possible to choose criteria and then browse the result page by page... now it's work fine :) So, better to make an update of your version http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_2.tar.gz http://www.areski.net/asterisk-stat-v1/about.php Sorry about all this changes... Regards, Areski On Wed, 2004-03-24 at 16:42, Ryan Thrash wrote: > Does register_globals need to be on to work with this? And if so, any > chance that will be turned off in the (hopefully near) future? > > Thanks, Ryan > > On Mar 24, 2004, at 9:09 AM, Areski wrote: > > > I just finished an other version, all my apologies, cause I made it for > > mysql then I ve done the change to support postgresql and forget to > > re-test again... not really professional at all ;) > > > > http://www.areski.net/asterisk-stat-v1/about.php > > > > Download : > > http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz > > > > If you have still some problems, share them with me ! > > ___ > 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 ___ 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
RE: [Asterisk-Users] Graphical Interface to display Asterisk CDR /php
Hi, I get this ... Database error: Invalid SQL: SELECT calldate, channel, src, clid, lastapp, lastdata, dst, dst, disposition, duration FROM cdr ORDER BY calldate DESC LIMIT 0,25 MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist) Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2004-03-01') GROUP BY substring(calldate,1,10) MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist) Database error: Invalid SQL: SELECT count(*) FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2004-03-01') MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist) Database error: next_record called with no query pending. MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist) And I have the database and the table on my mysql :( Best regards, Chris HARIGA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Areski Sent: Wednesday, March 24, 2004 1:35 PM To: Asterisk-Users Mailing-list Subject: Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR /php I made an Update, now don't need register_globals on anymore... By the way, I fix some bugs, cause it was not possible to choose criteria and then browse the result page by page... now it's work fine :) So, better to make an update of your version http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_2.tar.gz http://www.areski.net/asterisk-stat-v1/about.php Sorry about all this changes... Regards, Areski On Wed, 2004-03-24 at 16:42, Ryan Thrash wrote: > Does register_globals need to be on to work with this? And if so, any > chance that will be turned off in the (hopefully near) future? > > Thanks, Ryan > > On Mar 24, 2004, at 9:09 AM, Areski wrote: > > > I just finished an other version, all my apologies, cause I made it for > > mysql then I ve done the change to support postgresql and forget to > > re-test again... not really professional at all ;) > > > > http://www.areski.net/asterisk-stat-v1/about.php > > > > Download : > > http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz > > > > If you have still some problems, share them with me ! > > ___ > 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 ___ 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
RE: [Asterisk-Users] Graphical Interface to display Asterisk CDR /php
Noobie question... I have the app installed ok, and set up CDR just now as well, Mysql is also working as expected, however is there something that needs to be added to extensions.conf to enable global CDR logging .. I looked through the Wiki pages and couldn't find any examples.. thanks ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Hi I'm trying to install but I think I have a problem!!! Would I be correct in saying if I don't have the jp graph libs, the links on the form would be followed but nothing would be displayed Areski wrote: I made an Update, now don't need register_globals on anymore... By the way, I fix some bugs, cause it was not possible to choose criteria and then browse the result page by page... now it's work fine :) So, better to make an update of your version http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_2.tar.gz http://www.areski.net/asterisk-stat-v1/about.php Sorry about all this changes... Regards, Areski On Wed, 2004-03-24 at 16:42, Ryan Thrash wrote: Does register_globals need to be on to work with this? And if so, any chance that will be turned off in the (hopefully near) future? Thanks, Ryan On Mar 24, 2004, at 9:09 AM, Areski wrote: I just finished an other version, all my apologies, cause I made it for mysql then I ve done the change to support postgresql and forget to re-test again... not really professional at all ;) http://www.areski.net/asterisk-stat-v1/about.php Download : http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz If you have still some problems, share them with me ! ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
I made an Update, now don't need register_globals on anymore... By the way, I fix some bugs, cause it was not possible to choose criteria and then browse the result page by page... now it's work fine :) So, better to make an update of your version http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_2.tar.gz http://www.areski.net/asterisk-stat-v1/about.php Sorry about all this changes... Regards, Areski On Wed, 2004-03-24 at 16:42, Ryan Thrash wrote: > Does register_globals need to be on to work with this? And if so, any > chance that will be turned off in the (hopefully near) future? > > Thanks, Ryan > > On Mar 24, 2004, at 9:09 AM, Areski wrote: > > > I just finished an other version, all my apologies, cause I made it for > > mysql then I ve done the change to support postgresql and forget to > > re-test again... not really professional at all ;) > > > > http://www.areski.net/asterisk-stat-v1/about.php > > > > Download : > > http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz > > > > If you have still some problems, share them with me ! > > ___ > 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Does register_globals need to be on to work with this? And if so, any chance that will be turned off in the (hopefully near) future? Thanks, Ryan On Mar 24, 2004, at 9:09 AM, Areski wrote: I just finished an other version, all my apologies, cause I made it for mysql then I ve done the change to support postgresql and forget to re-test again... not really professional at all ;) http://www.areski.net/asterisk-stat-v1/about.php Download : http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz If you have still some problems, share them with me ! ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Hello All, I just finished an other version, all my apologies, cause I made it for mysql then I ve done the change to support postgresql and forget to re-test again... not really professional at all ;) By the way, I made some amelioration in the sql queries and now it works even with few hundreds thousand of records... Well, Mysql should now work. I had also an option to get the result by minutes or by seconds. Tested with: PHP Version 4.3.1 - psql (PostgreSQL) 7.2.4 - mysql Ver 11.18 Distrib 3.23.58, http://www.areski.net/asterisk-stat-v1/about.php Download : http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz If you have still some problems, share them with me ! Regards, Areski On Wed, 2004-03-24 at 09:33, Jon Lawrence wrote: > On Wednesday 24 March 2004 06:49, Brian Capouch wrote: > > It might be helpful for us all if the author could let us know more > > about the environment in which this application was built. . > > > > I'm getting all kinds of errors when I try to run it, and I suspect that > > either my Postgres or PHP installations are incompatible with yours. > > > My problem is with MySQL, it doesn't seem to like the queries. > I think it would be useful if the author could post a list of his packages ie > MySQL/PG version, php version etc. > > Jon > > ___ > 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
You need to turn register globals = on in your php.ini file, HOWEVER, this can make things VERY insecure if you have other php scripts that are not thought out right. On Wed, 24 Mar 2004, Peer Oliver schmidt wrote: > Wipeout wrote: > >> Another thing I had to do was changing the defines.php file to reflect > >> my environment. After that, things went smooth. > >> > > On my server the links dont even work in the menu on the left.. Not sure > > what is going on with the code and dont have the time to look right > > now.. I will just have to wait for the next version.. :) > > The links don't work because of a wrong setting in defines.php. Just put > the path on your webserver for the files and things should work. On the > other hand, waiting for something new is another option ;-) > > rgds > pos > > ___ > 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Peer Oliver schmidt wrote: Wipeout wrote: Another thing I had to do was changing the defines.php file to reflect my environment. After that, things went smooth. On my server the links dont even work in the menu on the left.. Not sure what is going on with the code and dont have the time to look right now.. I will just have to wait for the next version.. :) The links don't work because of a wrong setting in defines.php. Just put the path on your webserver for the files and things should work. On the other hand, waiting for something new is another option ;-) rgds pos Just double checked, my paths are correct in defines.php.. Later.. ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Wipeout wrote: Another thing I had to do was changing the defines.php file to reflect my environment. After that, things went smooth. On my server the links dont even work in the menu on the left.. Not sure what is going on with the code and dont have the time to look right now.. I will just have to wait for the next version.. :) The links don't work because of a wrong setting in defines.php. Just put the path on your webserver for the files and things should work. On the other hand, waiting for something new is another option ;-) rgds pos ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Peer Oliver schmidt wrote: Brian Capouch wrote: It might be helpful for us all if the author could let us know more about the environment in which this application was built. . I'm getting all kinds of errors when I try to run it, and I suspect that either my Postgres or PHP installations are incompatible with yours. Another thing I had to do was changing the defines.php file to reflect my environment. After that, things went smooth. On my server the links dont even work in the menu on the left.. Not sure what is going on with the code and dont have the time to look right now.. I will just have to wait for the next version.. :) ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
On Wednesday 24 March 2004 06:49, Brian Capouch wrote: > It might be helpful for us all if the author could let us know more > about the environment in which this application was built. . > > I'm getting all kinds of errors when I try to run it, and I suspect that > either my Postgres or PHP installations are incompatible with yours. > My problem is with MySQL, it doesn't seem to like the queries. I think it would be useful if the author could post a list of his packages ie MySQL/PG version, php version etc. Jon ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Brian Capouch wrote: It might be helpful for us all if the author could let us know more about the environment in which this application was built. . I'm getting all kinds of errors when I try to run it, and I suspect that either my Postgres or PHP installations are incompatible with yours. Another thing I had to do was changing the defines.php file to reflect my environment. After that, things went smooth. ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
Hello Brian, It might be helpful for us all if the author could let us know more about the environment in which this application was built. . I'm getting all kinds of errors when I try to run it, and I suspect that either my Postgres or PHP installations are incompatible with yours. I am not the author, but the skripts use the PHP shortcut. Instead of starting PHP skripts with he uses You can change your PHP.INI to allow for the shortcut. That might help. rgds pos ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
It might be helpful for us all if the author could let us know more about the environment in which this application was built. . I'm getting all kinds of errors when I try to run it, and I suspect that either my Postgres or PHP installations are incompatible with yours. Thx. B. ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
It might be helpful for us all if the author could let us know more about the environment in which this application was built. . I'm getting all kinds of errors when I try to run it, and I suspect that either my Postgres or PHP installations are incompatible with yours. Thx. B. ___ 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
RE: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php
I am getting an error: Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result resource in /usr/local/apache/htdocs/cdr/lib/DB-modules/phplib_postgres.php on line 209 Pls help -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Areski Sent: Wednesday, 24 March 2004 5:29 AM To: Asterisk-Users Mailing-list Subject: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php Hello Asteriskien, I made a Graphical Interface in PHP to display Asterisk CDR. To see quickly all your stat by days and also to compare them. - Support mysql & postgresql Check the screenshots there : http://www.areski.net/asterisk-stat-v1/about.php Download source tar.gz: http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1.tar.gz Hope that this small php application can be useful! I m waiting for your comments, Regards, Areski -_-_-_-_-_-_-_-_-_-_-_-_-_-_ ___ 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
Re: [Asterisk-Users] Graphical Interface to display Asterisk CDR / php / CSV too!
Areski wrote: Hello Asteriskien, I made a Graphical Interface in PHP to display Asterisk CDR. To see quickly all your stat by days and also to compare them. - Support mysql & postgresql While not as pretty, I have a version that works from the CSV file that asterisk creates by default. Code is provided without warranty, if it breaks your machine/* installation, neither my employer nor I are responsible. If anyone wants to tidy this code up a bit, feel free. It was a hack I put together in an afternoon... It's a perl script - so stick it in a cgi-bin directory. The call recording stuff should be fairly easy to figure out (just requires you to create the recorded files in a certain way). Avaliable here: http://www.3ait.co.uk/~jon/ Thanks, Jon ___ 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