On Mon, 1 Jun 2009, Vincent wrote: > On Mon, 1 Jun 2009 13:21:57 +0100 (BST), Gordon Henderson > <gordon+aster...@drogon.net> wrote: >> You may save yourself a lot of hassle just storing the CDRs in a plain >> text CSV file (which asterisk does for you), then parsing it with PHP >> directly. > > Thanks for the tip. I'll see if I can do without an SQL engine, > although I'll probably need one. This is just for SOHO users, so > big-time CDR isn't needed.
Good luck. FWIW: I have a system to produce a monthly statement and bill out of the raw asterisk CDRs for a small residential home entirley in PHP.. It wasn't hard, although it doesn't store long-term logs - they're handled elsewhere. > Hopefully, a small Linux (uCLinux, AstFin, etc.) + LAMP + Asterisk > will fit in 128MB RAM. Shouldn't have to hope at all. One of my embedded systems: dsx# df -h Filesystem Size Used Avail Use% Mounted on /dev/ram0 136M 70M 66M 52% / the top of 'top': top - 00:54:08 up 2 days, 50 min, 1 user, load average: 0.00, 0.00, 0.00 Tasks: 28 total, 1 running, 27 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 257172k total, 190324k used, 66848k free, 1936k buffers Swap: 0k total, 0k used, 0k free, 30744k cached This is running on a VIA processor - the entire system runs in RAM and as you see takes up 70MB. I could probably make the whole thing run in 128MB, but it's easier in 256MB (of which 140MB is a ramdisk) This is a cut-down Linux, but not that cut-down. No busybox, or uClinux. Runs apache+php, asterisk and perl. Running the code out of 256MB of Flash with 64MB of system RAM should be trivial. Gordon _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users