[OpenSIPS-Users] db_text for drouting - column gwid has a bad type[4], accepting only [3]

[老李-FSGUI,电话机器人]

you can change gwid type to int4 or int



---Original---
From: "Dmitry Gimalayskiy"<8968934 at gmail.com>
Date: Thu, Sep 26, 2024 22:05 PM
To: "users"<users at lists.opensips.org>;
Subject: [OpenSIPS-Users] db_text for drouting - column gwid has a bad type[4], accepting only [3]


Hello everybody!


I am trying to use db_text for drouting, but I am getting an error when loading the opensips:


# tail -f /var/log/opensips/opensips.log | egrep "ERR|CRIT|WAR"
ERROR:drouting:dr_load_routing_info: column gwid has a bad type [4], accepting only [3]"
CRITICAL:drouting:dr_reload_data_head: failed to load routing info"

This is my db_text/dr_gateways: 
# cat db_text/dr_gateways 
id(int)  gwid(str) type(int) address(str) strip(int) pri_prefix(str,null)  attrs(str,null) probe_mode(int) state(int) socket(str,null)  description(str,null)
1:asterisk:0:10.214.0.78:0:::0:0:udp\:10.214.0.77\:5081:test out provider server\n


And opensips version:
# opensips-cli -x mi version
{
    "Server": "OpenSIPS (3.4.5 (x86_64/linux))"
}


How can I fix this error?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20240927/8bc5c429/attachment-0001.html>