Sending CDRs to both file and SQL?
Hello, At present we send all our CDRs to a flat file using Asterisk's format (template "asterisk" in cdr_csv.conf.xml). This file is used by our billing software. For an interim period I would like to send the CDRs to both file and MySQL database (until I finish writing script to retreive the CDRs from the database to a file). Is it possible to send the CDRs to both? Thanks, __Yehavi:
we leave that exercise to the user, there is no module to write cdr's direct to a db. On Mon, Jan 25, 2010 at 9:38 AM, Yehavi Bourvine <yehavi.bourvine@gmail.com>wrote:
Hello,
At present we send all our CDRs to a flat file using Asterisk's format (template "asterisk" in cdr_csv.conf.xml). This file is used by our billing software.
For an interim period I would like to send the CDRs to both file and MySQL database (until I finish writing script to retreive the CDRs from the database to a file). Is it possible to send the CDRs to both?
Thanks, __Yehavi:
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900
hello Yehavi, This is what the wiki suggests anyways, in case you didn't read this yet: http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Example_Perl_Script_for_CDR_into... 2010/1/25 Anthony Minessale <anthony.minessale@gmail.com>:
we leave that exercise to the user, there is no module to write cdr's direct to a db.
On Mon, Jan 25, 2010 at 9:38 AM, Yehavi Bourvine < yehavi.bourvine@gmail.com> wrote:
Hello,
At present we send all our CDRs to a flat file using Asterisk's format (template "asterisk" in cdr_csv.conf.xml). This file is used by our
billing
software.
For an interim period I would like to send the CDRs to both file and MySQL database (until I finish writing script to retreive the CDRs from the database to a file). Is it possible to send the CDRs to both?
Thanks, __Yehavi:
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Thanks. I've seen that. Will try to implement this. Thanks, __Yehavi: 2010/1/25 Milena <testeador01@gmail.com>
hello Yehavi,
This is what the wiki suggests anyways, in case you didn't read this yet:
http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Example_Perl_Script_for_CDR_into...
2010/1/25 Anthony Minessale <anthony.minessale@gmail.com>:
we leave that exercise to the user, there is no module to write cdr's direct to a db.
On Mon, Jan 25, 2010 at 9:38 AM, Yehavi Bourvine < yehavi.bourvine@gmail.com> wrote:
Hello,
At present we send all our CDRs to a flat file using Asterisk's format (template "asterisk" in cdr_csv.conf.xml). This file is used by our
billing
software.
For an interim period I would like to send the CDRs to both file and MySQL database (until I finish writing script to retreive the CDRs from the database to a file). Is it possible to send the CDRs to both?
Thanks, __Yehavi:
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
For what its worth, I wrote a simple Sinatra-based web service to accept the CDRs over HTTP. It then queues them for processing into a database, syslog and/or file. Its easy to load balance and lets me throttle CDR processing so I don't put excessive load on the database server at peak times. Lon
I have another implementation based on fastcgi and libxml2. Source could be easily modified to log into the file as well. http://blog.buta-tech.com/?p=1 On 01/25/2010 10:22 PM, Lon Baker wrote:
For what its worth, I wrote a simple Sinatra-based web service to accept the CDRs over HTTP. It then queues them for processing into a database, syslog and/or file.
Its easy to load balance and lets me throttle CDR processing so I don't put excessive load on the database server at peak times.
Lon
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
xml_cdr is perfect for that, why not use it? On Mon, Jan 25, 2010 at 11:31 PM, Nazim Agabekov <nazim.agabekov@gmail.com> wrote:
I have another implementation based on fastcgi and libxml2. Source could be easily modified to log into the file as well.
http://blog.buta-tech.com/?p=1
On 01/25/2010 10:22 PM, Lon Baker wrote:
For what its worth, I wrote a simple Sinatra-based web service to accept the CDRs over HTTP. It then queues them for processing into a database, syslog and/or file.
Its easy to load balance and lets me throttle CDR processing so I don't put excessive load on the database server at peak times.
Lon
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
We do use it for cdr generation, for parsing every one has it's own recipe. In my opinion php is an easiest way to parse: http://www.0xdecafbad.com/?p=28 Personally, I prefer fastcgi and C. On 01/26/2010 12:14 PM, David Villasmil wrote:
xml_cdr is perfect for that, why not use it?
On Mon, Jan 25, 2010 at 11:31 PM, Nazim Agabekov <nazim.agabekov@gmail.com> wrote:
I have another implementation based on fastcgi and libxml2. Source could be easily modified to log into the file as well.
http://blog.buta-tech.com/?p=1
On 01/25/2010 10:22 PM, Lon Baker wrote:
For what its worth, I wrote a simple Sinatra-based web service to accept the CDRs over HTTP. It then queues them for processing into a database, syslog and/or file.
Its easy to load balance and lets me throttle CDR processing so I don't put excessive load on the database server at peak times.
Lon
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (6)
-
Anthony Minessale
-
David Villasmil
-
Lon Baker
-
Milena
-
Nazim Agabekov
-
Yehavi Bourvine