already logrotate is doing the file split every month. how do you serve it in a webpage and which CGI script?
On Thu, Apr 24, 2014 at 3:18 PM, A J Stiles <[email protected]>wrote: > On Thursday 24 Apr 2014, binary dreamer wrote: > > hello everyone. > > I am running asterisk and all of my CDRs are in the default csv. > > the system is so limited to ram (only 256) and I cannot run MySQL or any > > other program to give CDRs a fancy view. > > at the moment the only other software running is nginx for a static > webpage > > with guidance on the system. > > I do now want to move to sql or similar databases because the machine > > cannot handle it (I have already tried and it wastes ram from calls). > > > > > > is there a way to present to a webpage the CDRs from the csv, please? > > If you can't stretch to a separate machine to run a database (even a > scrapper > will do for this) and you can't increase the RAM in your Asterisk machine, > then you will have to resort to manipulating the CSV file. > > Use a cron job to rotate the master CDR daily or weekly, to keep it from > becoming unmanageably large. This needs to be done at a time when you are > not > expecting any incoming calls. You really need to stop Asterisk while you > do > this and restart it afterwards. The whole operation (cp Master.csv > cdr_$DATE.csv; echo -n "" > Master.csv) should be over within a few > ringing > periods; so even if a call does come through in the meantime, Asterisk > ought > to just pick it up as soon as it restarts. > > Then write a simple CGI script to serve up the cdr*.csv files. As long as > you > send the appropriate content-type, then it ought just to open straight up > in > OpenOffice.org calc. > > > -- > AJS > > Note: Originating address only accepts e-mail from list! If replying off- > list, change address to asterisk1list at earthshod dot co dot uk . > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
