<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="monospace">Hi,<br>
<br>
Not sure what's the DB issue as I see no errors or DB related
issues in your report.<br>
<br>
In regards to the posted "ERROR" - you call the function for a
sequential/in-dialog request, which has RURI without a username
part - and here the error comes, as the BL functions needs a
username part.<br>
<br>
Regards,<br>
</font>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
<a class="moz-txt-link-freetext" href="https://www.siphub.com">https://www.siphub.com</a></pre>
<div class="moz-cite-prefix">On 28.11.2024 01:13, Saint Michael
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAC9cSODiSQHLXa_ZL+rHyK8Ygi8k_XNS1t-=dwfg8OKrgtMWYw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div class="gmail_default" style="font-size:small">I always get
this error</div>
<div class="gmail_default" style="font-size:small">It never
connects to the database. The table is empty</div>
<div class="gmail_default" style="font-size:small">mariadb
opensips -e "select * from version"<br>
+-----------------+---------------+<br>
| table_name | table_version |<br>
+-----------------+---------------+<br>
| globalblacklist | 2 |<br>
| userblacklist | 2 |</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
<div class="gmail_default" style="font-size:small">ERROR:userblacklist:check_user_blacklist:
cannot parse msg URI</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
<div class="gmail_default" style="font-size:small">xlog("Found
$var(media_ip) \r\n");<br>
if (has_totag()) {<br>
if (!check_user_blacklist("media",
"$var(media_ip)")) {<br>
xlog("Blocked $var(media_ip) \r\n");<br>
send_reply(404, "Forbidden: Media IP
Blacklisted");<br>
exit;<br>
}</div>
<div class="gmail_default" style="font-size:small">
}</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
<div class="gmail_default" style="font-size:small">loadmodule
"userblacklist.so"<br>
modparam("userblacklist", "db_url",
"unixodbc://xxxx:password@localhost/opensips")<br>
modparam("userblacklist", "db_table", "userblacklist")<br>
modparam("userblacklist", "use_domain", 1)<br>
</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
<div class="gmail_default" style="font-size:small">any idea?</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>