# OpenSER and FreeRADIUS integration — Liran Tal

Getting OpenSER to work with FreeRADIUS

Canonical: https://lirantal.com/blog/2007-06-20

This hectic procedure requires some tweaking and patching but most of the information and relevant files can be found at [http://cdrtool.ag-projects.com/freeradius](http://cdrtool.ag-projects.com/freeradius/)

Basically, FreeRADIUS must include the `dictionary.sip` information, be patched against the `rlm_sql` module which requires tweaking for supporting the `Acct-Status-Type` ( = 15 error message) and ofcourse the `sql.conf` must be updated with queries relevant to sip sessions (this means that the database scheme must also be altered, more accurately the `radacct` table but that’s obvious and a patch file is provided for that as well)

Goodluck.

## More writing

[All writing →](/blog)

*   Sep 5, 2026

    ### [Self-Hosting Hermes Agent with Matrix E2EE on Proxmox](/blog/self-host-hermes-agent-matrix-e2ee-proxmox)

*   Aug 2, 2026

    ### [The Practical Second Brain: Building an LLM-Operated Markdown Knowledge Graph](/blog/practical-second-brain-llm-markdown-knowledge-graph)

*   Aug 1, 2026

    ### [Building a Second Brain with LLMs and AI Agents](/blog/building-second-brain-llms-ai-agents)


* * *

Liran Tal is the author of the book [Node.js Secure Coding: Defending Against Command Injection Vulnerabilities](https://www.nodejs-security.com/)

[Start Building Secure Node.js Applications ↗](https://www.nodejs-security.com/)

 [![](/_astro/nodejs-secure-coding-book-3d-style.DiTWpzFs_Z3c7s1.png)](https://www.nodejs-security.com/)