Re: [Freeswitch-users] SIP dump to DB

2009-05-18 Thread Helmut Kuper
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, maybe this helps: http://www.wesip.com/mediawiki/index.php/SipSpy regards helmut On 17.05.2009 20:33, Ron McCarthy wrote: Kokoska, Did you ever find a solution for this? I have been working on this as well, trying to write some perl

Re: [Freeswitch-users] SIP dump to DB

2009-05-17 Thread Ron McCarthy
Kokoska, Did you ever find a solution for this? I have been working on this as well, trying to write some perl application to read the data from ngrep and parse it, but have got no where. I hope you have better luck then I have! On Mon, Feb 23, 2009 at 11:13 PM, kokoska.rokoska

Re: [Freeswitch-users] SIP dump to DB

2009-05-17 Thread kokoska rokoska
Ron McCarthy napsal(a): Kokoska, Did you ever find a solution for this? I have been working on this as well, trying to write some perl application to read the data from ngrep and parse it, but have got no where. I hope you have better luck then I have! I'm sorry, Ron, but I still

Re: [Freeswitch-users] SIP dump to DB

2009-02-23 Thread Joseph Bajin
Basically, you are trying to build what Empirix has with their Hammer tool. You can create an application that is basically a mix of tshark and a database feeder. You sniff with tshark and going to basically pipe it to another application that will read the pcap file, parse it, and load it into

Re: [Freeswitch-users] SIP dump to DB

2009-02-23 Thread kokoska.rokoska
Joseph Bajin napsal(a): Basically, you are trying to build what Empirix has with their Hammer tool. Thank you very much, Joseph, for your interest! I have never heard about Empirix (I'll look at it), but what I'm trying to build is something like SER/Kamailio/OpenSIPS sip_trace module. You

Re: [Freeswitch-users] SIP dump to DB

2009-02-23 Thread Joseph Bajin
If you write it correctly it will work just fine. That is how most of all the other correlation engines work. Your setup is not going to be bigger than some of the large telecoms that use these systems today. On 2/23/09, kokoska.rokoska kokoska.roko...@post.cz wrote: Joseph Bajin napsal(a):

Re: [Freeswitch-users] SIP dump to DB

2009-02-23 Thread kokoska.rokoska
Joseph Bajin napsal(a): If you write it correctly it will work just fine. Yes, this is challenge I have talked about :-) That is how most of all the other correlation engines work. I don't have enough informations but from what I heard from friendly competitors they are usualy log (SIP|ISUP)

[Freeswitch-users] SIP dump to DB

2009-02-20 Thread kokoska rokoska
Hi all, I'm facing the problem I need all SIP messages going thru FreeSWITCH (I know FS i B2BUA - so, better to say just all SIP messages) logged somewhere and this log have to be searchable (by call-id etc) and I should be able to simply delete old messages... And more over - it should be done

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread Anthony Minessale
what exact info do you need? That's likely to be a challenge with any database to store at that speed. On Fri, Feb 20, 2009 at 5:24 AM, kokoska rokoska kokoska.roko...@post.czwrote: Hi all, I'm facing the problem I need all SIP messages going thru FreeSWITCH (I know FS i B2BUA - so, better

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread Adam Long
To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] SIP dump to DB what exact info do you need? That's likely to be a challenge with any database to store at that speed. On Fri, Feb 20, 2009 at 5:24 AM, kokoska rokoska kokoska.roko...@post.cz wrote: Hi all, I'm facing

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread kokoska rokoska
Anthony Minessale napsal(a): what exact info do you need? That's likely to be a challenge with any database to store at that speed. Thank you very much, Anthony, for your reply! I should say: Personally I don't need it (I see preformance penalty), but few people around me need to store

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread kokoska rokoska
Adam Long napsal(a): MySQL MEMORY/HEAP table might be ideal for this. This data is prob not critical and is probably being used for diagnosing peer connectivity issues anyway. If it is critical well then... there are always trade offs right :) Thank you very much, Adam, for interest!

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread Shelby Ramsey
Why not just use NGREP and then dump the packets at a more reasonable pace? You aren't going to be able to analysis in real time anyway. ___ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread kokoska rokoska
Shelby Ramsey napsal(a): Why not just use NGREP and then dump the packets at a more reasonable pace? Thank you very much, Shelby, for your interest! I can't use ngrep because the dump is not searchable IMO :-) See below, please. You aren't going to be able to analysis in real time

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread Anthony Minessale
you could try sippcapdump but i hear it needs work but it snoops the wire and tries to make individual files out of each call. On Fri, Feb 20, 2009 at 9:27 AM, kokoska rokoska kokoska.roko...@post.czwrote: Shelby Ramsey napsal(a): Why not just use NGREP and then dump the packets at a more

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread Shelby Ramsey
Sorry .. I didn't give enough detail. My point was to dump it via NGREP ... parse it using something else to get it into a database where it would be usable. Then you can match calls from the CDR (using the UUID) to the database. The benefit is that you don't have to put the burden on your FS

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread jonathan augenstine
You can tcpdump and then use wireshark to graph the calls. When the dump is displayed in wireshark, select 'Statistics' - VoIP Calls. You will see a display of all VoIP calls. Select the one you want graphed, or select them all and you will see REINVITE and REFER interaction as well as RTP

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread kokoska rokoska
Anthony Minessale napsal(a): you could try sippcapdump but i hear it needs work but it snoops the wire and tries to make individual files out of each call. Thank you very much, Anthony, for the suggestion! I will look at it. Best regards, kokoska.rokoska

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread kokoska rokoska
Shelby Ramsey napsal(a): Sorry .. I didn't give enough detail. My point was to dump it via NGREP ... parse it using something else to get it into a database where it would be usable. This is good point! Thank you very much, Shelby! Then you can match calls from the CDR (using the UUID) to

Re: [Freeswitch-users] SIP dump to DB

2009-02-20 Thread kokoska rokoska
jonathan augenstine napsal(a): You can tcpdump and then use wireshark to graph the calls. When the dump is displayed in wireshark, select 'Statistics' - VoIP Calls. You will see a display of all VoIP calls. Select the one you want graphed, or select them all and you will see REINVITE and