<div dir="ltr">Hi,<div><br></div><div>I think the parameter should be "<span style="color:rgb(0,0,0);font-family:Helvetica,Arial">db_table".</span></div><div>It looks like there is a typo in the docs in the example.<span style="color:rgb(0,0,0);font-family:Helvetica,Arial"></span></div><div><br></div><div>You can also increase log level to debug and try to get more info from logs</div><div><br></div><div>Best regards,</div><div><br></div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Mon, Jun 8, 2026 at 3:36 AM Кисляков Степан Викторович via Users <<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</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"><div class="msg496556525049686600">
<div lang="RU">
<div class="m_496556525049686600WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">Hi!<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">Could you please help me get this working?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">I’m using OpenSIPS v3.6.<br>
I need to set up something like a hunt list: when user 300 is called and is busy or unavailable, the call should be routed to 301 and 302 (just an example).<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">To achieve this, I’m trying to use the CPL_C module.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">This is my config in opensips.cfg:
<br>
modparam("cpl_c", "db_url", "postgres://<a href="http://alfauser:somepass123@127.0.0.1/opensips" target="_blank">alfauser:somepass123@127.0.0.1/opensips</a>")<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">#modparam("cpl_c", "cpl_table", "cpl")<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">modparam("cpl_c", "cpl_dtd_file", "/etc/opensips/cpl.dtd")<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">modparam("cpl_c","log_dir","/var/log/opensips")<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">modparam("cpl_c","username_column","username")<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">modparam("cpl_c","domain_column","domain")<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">modparam("cpl_c","cpl_xml_column","cpl_xml")<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">modparam("cpl_c","cpl_bin_column","cpl_bin")<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">modparam("cpl_c","log_dir","/var/log/opensips/cpl")<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">modparam("cpl_c","case_sensitive",0)<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">I don’t know why, but if I set modparam("cpl_c", "cpl_table", "cpl") – I get error that “cpl_table command is not found in cpl_c module”.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">Anyway if I run: opensips-cli -x mi LOAD_CPL sip:300@local.lcl /usr/share/opensips/cpl_scripts/300.xml<br>
I get "OK"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">I can see a new row in the database, and it looks correct. The cpl_bin and cpl_xml columns contain binary data.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">However, when I run:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">opensips-cli -x mi GET_CPL
<a>sip:300@local.lcl</a> <u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">I get an empty response:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">{<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"> "script": ""<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">}<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">I’ve tried to write very simple script to database in cpl_xml column:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"><?xml version="1.0" encoding="UTF-8"?><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"><cpl><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"> <incoming ><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"> <location url="sip:301@local.lcl" ><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"> <proxy ><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"> <noanswer ><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"> <location url=" sip:302@local.lcl " /><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"> </noanswer><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"> </proxy><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"> </location><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"> </incoming><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"></cpl><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">When I run opensips-cli -x mi GET_CPL
<a>sip:300@local.lcl</a> <u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">I still get the same empty response.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif">I don’t know how to make this work.<br>
I would be very grateful for any advice.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Best regards,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Stepan <u></u>
<u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">VOIP dep.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
</div>
</div>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></blockquote></div>