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

[SoftSwitchDev]

OpenSIPS version

version: opensips 3.4.6 (x86_64/linux)
flags: STATS: On, DISABLE_NAGLE, USE_MCAST, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, HP_MALLOC, DBG_MALLOC, FAST_LOCK-ADAPTIVE_WAIT
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535
poll method support: poll, epoll, sigio_rt, select.
git revision: 40206eeef
main.c compiled on  with gcc 10

Describe the bug
Opensips does not start when using db_text table for the drouting module.

To Reproduce

Steps to reproduce the behavior:

1. Enable drouting and db_text modules in configuration.
2. Fill in the db_text drouting table 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

3. Launching opensips
4. Opensips crashes on startup with an error:

    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"

Expected behavior

Opensips correctly loads drouting information from the db_text dr_gateways file without failures.

Relevant System Logs

$ 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"

OS/environment information

• Debian GNU/Linux 11 (bullseye)
• OpenSIPS installation: debs

[github-actions]

Any updates here? No progress has been made in the last 15 days, marking as stale. Will close this issue if no further updates are made in the next 30 days.

[SoftSwitchDev]

Hi @bogdan-iancu ! Сan you please comment this issue about db_text ?

[github-actions]

Any updates here? No progress has been made in the last 15 days, marking as stale. Will close this issue if no further updates are made in the next 30 days.

[SoftSwitchDev]

up

[SoftSwitchDev]

Checked the issue on opensips version: opensips 3.5.3 (x86_64/linux))

Have the same issue:

/usr/sbin/opensips[24454]: ERROR:drouting:dr_load_routing_info: column gwid has a bad type [4], accepting only [3]
/usr/sbin/opensips[24454]: CRITICAL:drouting:dr_reload_data_head: failed to load routing info

[SoftSwitchDev]

@razvancrainea , could you please check the problem?

I replaced all DB_STRING with DB_STR in modules/drouting/dr_load.c , successfully compiled and launched opensips 3.6, with no error about the gwid column type.
Is this the right fix, or can you recommend something better?