<div dir="auto">Hey Sergiu,</div><div dir="auto"><br></div><div dir="auto">I’m curious, have you seen that happen by any chance on the kams your have taking with MSTeams?</div><div dir="auto"><br></div><div dir="auto">Joel. </div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jan 29, 2021 at 11:31 Sergiu Pojoga <<a href="mailto:pojogas@gmail.com">pojogas@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thanks Alex & Daniel for suggesting these ingenious potential solutions.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jan 29, 2021 at 2:09 PM Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">To add a little bit, look at log_custom, the log message can be<br>
forwarded over udp to another application, which can be developed for<br>
specific purposes, like writing to database, probably easy to do using<br>
golang or python.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
On 29.01.21 19:32, Alex Balashov wrote:<br>
> Not directly from Kamailio, unless you want to "log" manually using<br>
> sql_query().<br>
><br>
> Commonplace approaches for this:<br>
><br>
> 1) Forward Kamailio syslog data to a syslog-ng server - i.e. in your<br>
> local /etc/rsyslog.conf or whatever:<br>
><br>
> local0.error               @remote.server:514<br>
><br>
> syslog-ng supports PostgreSQL and other storage destinations:<br>
><br>
> <a href="https://wiki.archlinux.org/index.php/syslog-ng#PostgreSQL_Destination" rel="noreferrer" target="_blank">https://wiki.archlinux.org/index.php/syslog-ng#PostgreSQL_Destination</a><br>
><br>
> And it can filter and parse entries based on regular expressions to<br>
> make what you store more selective.<br>
><br>
> However, beware of the uncertain performance characteristics of this<br>
> setup under heavy loads, and also the poor suitability of RDBMs to<br>
> short-lived data sets that constantly turn over. Lessons learned the<br>
> hard way.<br>
><br>
> 2) The Elasticsearch way -- which originally required Elasticsearch +<br>
> Logstash, but now apparently can work through syslog-ng directly:<br>
><br>
> <a href="https://www.syslog-ng.com/community/b/blog/posts/logging-to-elasticsearch-made-simple-with-syslog-ng" rel="noreferrer" target="_blank">https://www.syslog-ng.com/community/b/blog/posts/logging-to-elasticsearch-made-simple-with-syslog-ng</a><br>
><br>
><br>
> Of course, you can still go the traditional Logstash route.<br>
><br>
> I haven't personally used Elasticsearch, but it sounds like the better<br>
> way to go than a traditional RDBM if you're dealing with large volumes<br>
> of syslog data that are rotated out frequently.<br>
><br>
> On the other hand, if you're only looking to log occasional critical<br>
> errors, not "everything", then just about any approach will work fine.<br>
><br>
> -- Alex<br>
><br>
> On 1/29/21 1:16 PM, Sergiu Pojoga wrote:<br>
><br>
>> Hi there,<br>
>><br>
>> I was wondering if there's a way to log various core error events in<br>
>> some DB.<br>
>><br>
>> For example, below error occurred<br>
>><br>
>> Jan 29 11:43:56 kamailio[11076]: {1 11440 INVITE<br>
>> 28b653bd-8f62-4085-a5ef-f2a4ac0f393d } ERROR: <core><br>
>> [core/parser/sdp/sdp_helpr_funcs.c:499]: extract_mediaip(): no<br>
>> `IP[4|6]' address in `c=' field<br>
>><br>
>> Jan 29 11:43:56 kamailio[11076]: {1 11440 INVITE<br>
>> 28b653bd-8f62-4085-a5ef-f2a4ac0f393d } ERROR: <core><br>
>> [core/parser/sdp/sdp.c:430]: parse_sdp_session(): can't extract<br>
>> common media IP from the message<br>
>><br>
>> Thanks in advance. Regards,<br>
>> --Sergiu<br>
>><br>
>> _______________________________________________<br>
>> Kamailio (SER) - Users Mailing List<br>
>> <a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
>> <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
>><br>
><br>
><br>
> -- <br>
> Alex Balashov | Principal | Evariste Systems LLC<br>
><br>
> Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)<br>
> Web: <a href="http://www.evaristesys.com/" rel="noreferrer" target="_blank">http://www.evaristesys.com/</a>, <a href="http://www.csrpswitch.com/" rel="noreferrer" target="_blank">http://www.csrpswitch.com/</a><br>
><br>
> _______________________________________________<br>
> Kamailio (SER) - Users Mailing List<br>
> <a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
> <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br>
-- <br>
Daniel-Constantin Mierla -- <a href="http://www.asipto.com" rel="noreferrer" target="_blank">www.asipto.com</a><br>
<a href="http://www.twitter.com/miconda" rel="noreferrer" target="_blank">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda" rel="noreferrer" target="_blank">www.linkedin.com/in/miconda</a><br>
Funding: <a href="https://www.paypal.me/dcmierla" rel="noreferrer" target="_blank">https://www.paypal.me/dcmierla</a><br>
<br>
<br>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div></div>