<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Good point. I have got this kind of behavior (cdrs push model) in my
current system (using radius servers).<br>
The only drawback of this method is that if you want to be absolutely
sure that all the cdrs were handled by<br>
the web server (or radius server) you have to check at certain
intervals every cdr one by one (and handle those left<br>
unhandled for various reasons (network, excessive web server load etc.))<br>
<br>
But for my next project I am somewhat forced to use a "cdrs-pull"
method where a process will "pull" cdrs<br>
from the server at its own pace making this extra check unnecessary.<br>
<br>
I will wait for an automatic log rotation as Shawn Lewis wrote. I think
that will do the job. <br>
<br>
Michael Collins wrote:
<blockquote
cite="mid:251B739C905BF64FBACCF028D963A5FB0294AD42@exchange.fcnetwork.com"
type="cite">
<blockquote type="cite">
<pre wrap="">Yes, the xml files give you tons of info... but isn't it a little
insufficient - performance wise -
to open and close so many files in such a little time. In a PBX
environment that wouldn't be an
issue but if we get to the small-voip-carrier level (some thousand
</pre>
</blockquote>
<pre wrap=""><!---->cdrs
</pre>
<blockquote type="cite">
<pre wrap="">per hour)
that could slow things down considerably, wouldn't it?
Thanks again for your prompt replies,
</pre>
</blockquote>
<pre wrap=""><!---->
At that level of activity then I would assume you'd want a more robust
solution which obviously would involve a server handling the CDRs
separately. That's where XML is a real winner: it can POST CDRs to a web
server and the webserver can handle all the pre-processing and db fun
stuff. And if the connection to the webserver failed, the CDRs would be
put on disk so that they aren't lost forever. Also, the webserver could
cache the CDRs to its disk (or whatever storage) if the db itself went
down but the webserver stayed up.
Just a thought, anyway. It may be extra layers but it's also extra
control.
-MC
</pre>
<blockquote type="cite">
<pre wrap="">Michael Collins wrote:
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Yes, I agree. But one could use the two methods combined (csv or
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->xml +
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">db) for redundancy.
Is there any consideration regarding automatic log rotation (e.g.
hourly, or user specified)
without the need of a HUP? Now, that could make things a lot easier
</pre>
</blockquote>
<pre wrap="">for
</pre>
<blockquote type="cite">
<pre wrap="">the development of
an external csv to db aggregation script because the script would
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->read
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">from a closed (not used by freeswitch
at the time) CDRs file. And the developer could be sure that the
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->cdrs
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">contained in that file would
have a hangup timestamp that could be described by the filename
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->(e.g.
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">20080101_010000.csv).
</pre>
</blockquote>
<pre wrap="">For the record, I've been dumping all my XML CDRs into a particular
directory and letting a script pick them up and process them. I
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->think
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">this is the best of both worlds: you get individual files with tons
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->of
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">info on each call and you can have a process that picks up those
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->files
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">and inserts them into the db. If the db is down then the CDRs aren't
lost - they just accumulate in the directory until you get the
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->db/script
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">thing working again.
Just my $.02
-MC
_______________________________________________
Freeswitch-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Freeswitch-users@lists.freeswitch.org">Freeswitch-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap=""><a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
Freeswitch-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Freeswitch-users@lists.freeswitch.org">Freeswitch-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
</pre>
<blockquote type="cite">
<pre wrap=""><a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
Freeswitch-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Freeswitch-users@lists.freeswitch.org">Freeswitch-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
</body>
</html>