Hello All,
Just migrating to Opensips 3.0 and I am using opensip-cli for the first
time.
When I issue a opensips-cli -x database create command some of the
operations fail with:
Error: (1709, 'Index column size too large. The maximum column size is
767 bytes.')
I will paste the full error below.
The "subst_exp" and "repl_exp" fields can be left empty (defaults) for
your use-case.
You only need to set the "match_exp" one, and dp_translate() will match
just fine.
Cheers,
Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com
On 28.08.2019 17:27, Mark Farmer wrote:
Untested
Now that made it really easy.
Untested as yet but added the UA strings to the dialplan table with a
repl_ext of "BogusUA".
Then:
if (dp_translate(1, $ua, $var(BogusUA))) {
xlog("CUSTOM_LOG: BogusUA Detected! ($ua)");
}
if $var(BogusUA)=BogusUA {
Hi all,
If reloading the table whenever you update your banned UA list isn't a
problem, then the optimal
answer is the dialplan module and its dp_translate [1] function in order
to test against your UA list.
It works with in-memory data so it is super fast.
Best regards,
[1]:
Thanks Giovanni, that looks like the function I was looking for :)
Mark.
On Wed, 28 Aug 2019 at 13:41, Giovanni Maruzzelli wrote:
> ...and this is the standard OpenSIPS SQL DB interface:
>
> https://opensips.org/html/docs/modules/3.0.x/avpops.html#func_avp_db_query
>
> On Wed, Aug 28, 2019 at
Thanks for the reply, certainly a few options to consider :)
To be more specific, the table contains $ua identifiers:
MariaDB [tt]> select * from user_agent;
++--+
| id | ua |
++--+
| 1 | sipcli |
| 2 | sipvicious |
| 3 |
...and this is the standard OpenSIPS SQL DB interface:
https://opensips.org/html/docs/modules/3.0.x/avpops.html#func_avp_db_query
On Wed, Aug 28, 2019 at 2:34 PM Giovanni Maruzzelli
wrote:
>
> You may use the standard OpenSIPS SQL db interface, with mysql module...
>
>
You may use the standard OpenSIPS SQL db interface, with mysql module...
https://opensips.org/html/docs/modules/3.0.x/db_mysql.html
On Wed, Aug 28, 2019 at 1:59 PM Mark Farmer wrote:
> Hi everyone
>
> Say I have a small & simple MariaDB table with some data beyond what is
> stored for
Hi Mark,
I haven't understood well enough what data do you store in the table.
Something designed by OpenSIPS developers? E.g. 'subscribers' table.
Or some custom data which you use in your script say via AVPs?
If it's possible to store it as key-value pairs, I'd recommend you using
local cache
Hi everyone
Say I have a small & simple MariaDB table with some data beyond what is
stored for modules etc (just a short list of strings), what is the best way
to search that data from within a script route for each SIP request?
I'm using DB_MYSQL as usual but I don't seem to see any functions
Hi Ping,
I have yet to hear about such behavior. Since 2.4.1, there have been
several fixes in rest_client, including
one related to memory management, which may be related to your
experience. I suggest you install the 2.4 nightly
package [1] and see if the issue persists. We can put more
Hi Bogdan. Did you reproduce the problem?
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Hi,
If you are using a 2.4 build newer than 8 July, you can set the the
following modparam to configure the seed node to also try to find a sync
donor within a given interval:
...
modparam("clusterer", "seed_fallback_interval", 5)
...
Otherwise, this improvement is not included in the
13 matches
Mail list logo