Re: [SR-Users] logging error events to database

Not directly from Kamailio, unless you want to "log" manually using sql_query(). Commonplace approaches for this: 1) Forward Kamailio syslog data to a syslog-ng server - i.e. in your local /etc/rsyslog.conf or whatever: local0.error @remote.server:514 syslog-ng supports PostgreSQL and other storage destinations: https://wiki.archlinux.org/index.php/syslog-ng#PostgreSQL_Destination And it can filter and parse entries based on regular expressions to make what you store more selective. However, beware of the uncertain performance characteristics of this setup under heavy loads, and also the poor suitability of RDBMs to short-lived data sets that constantly turn over. Lessons learned the hard way. 2) The Elasticsearch way -- which originally required Elasticsearch + Logstash, but now apparently can work through syslog-ng directly:

Of course, you can still go the traditional Logstash route. I haven't personally used Elasticsearch, but it sounds like the better way to go than a traditional RDBM if you're dealing with large volumes of syslog data that are rotated out frequently. On the other hand, if you're only looking to log occasional critical errors, not "everything", then just about any approach will work fine. -- Alex On 1/29/21 1:16 PM, Sergiu Pojoga wrote: -- Alex Balashov | Principal | Evariste Systems LLC Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/ _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users