[Freeswitch-users] SIP dump to DB

[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 somewhere ALL sip messages going
through the server. And ALL means "really all" (well, it will be very
helpful if I can skip OPTIONS and other nat-keep-alive related messages).
So I need something like "sipgrep dump" but I should be able to simply
corelate messages to user (in case of MESSAGE, REGISTER etc.) and to
user+call (in case of INVITE, BYE, CANCEL etc.).

-------------
BTW:
I'm sure it will be challenge for DB - and thus I made some tests with
mentioned siptrace.
One SIP call is about 18-21 SIP messages, so for 100 cps I should make a
little bit over 2.000 INSERTs per second. 900 REGISTERs per second will
generate about 5.500 INSERTs per second => I need to fire cca 8.000
INSERTs per second...
-------------

But, may be, better solution exists - without DB.
Any hint is very appreciated :-)

Best regards,

kokoska.rokoska


> On Fri, Feb 20, 2009 at 5:24 AM, kokoska rokoska
> <kokoska.rokoska at post.cz <mailto:kokoska.rokoska at post.cz>> wrote:
> 
> 
>     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 on not trivial SIP messages amount -
>     say hundreds messages per second.
> 
>     My questions are:
>     1. Do you have any suggestion how to do it with FreeSWITCH?
>     2. Or it is not possible now, and "bounty" is necessary? :-)
>     3. How hard it will be to implement?
> 
>     ----------
>     FYI:
>     I think something like SER/Kamailio/OpenSIPS siptrace is what I'am
>     (probably) looking for:
>     http://www.kamailio.org/docs/modules/1.4.x/siptrace.html
>     It could go (based on my tests) up to 7-10.000 messages per second till
>     MySQL "dies"...
>     ----------
> 
>     Thanks for your time :-)
> 
>     Best regards,
> 
>     kokoska.rokoska
> 
> 
>     _______________________________________________
>     Freeswitch-users mailing list
>     Freeswitch-users at lists.freeswitch.org
>     <mailto:Freeswitch-users at 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/
> 
> AIM: anthm
> MSN:anthony_minessale at hotmail.com
> <mailto:MSN%3Aanthony_minessale at hotmail.com>
> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
> <mailto:PAYPAL%3Aanthony.minessale at gmail.com>
> IRC: irc.freenode.net <http://irc.freenode.net> #freeswitch
> 
> FreeSWITCH Developer Conference
> sip:888 at conference.freeswitch.org
> <mailto:sip%3A888 at conference.freeswitch.org>
> iax:guest at conference.freeswitch.org/888
> <http://iax:guest@conference.freeswitch.org/888>
> googletalk:conf+888 at conference.freeswitch.org
> <mailto:googletalk%3Aconf%2B888 at conference.freeswitch.org>
> pstn:213-799-1400
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Freeswitch-users mailing list
> Freeswitch-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org