Pbx_functions.c:608 ast_func_read: Function ODBC_MyFunction not registered

Hello

I have this error: pbx_functions.c:608 ast_func_read: Function ODBC_TeamWoxDB not registered

please tell me what is my mistake?
Asterisk Version: 16.27.0
FreePBX: 16.0.21.9

[dynroute-1] ; TeamWox-test
include => dynroute-1-custom
exten => s,1,Set(dynroute=)
exten => s,n,Set(dynroute=${ODBC_TeamWoxDB("select user_id from TW_USERS_EXTENDED where phone_work='${CALLERID(num)}'")})
exten => s,n,Set(dynroute=${STRREPLACE(dynroute,"\"","")})
exten => s,n,GotoIf($["${dynroute}" = ""]?dynroute-1,1,1)
exten => s,n,GotoIf($["${dynroute}" = "1006"]?callback,${EXTEN},1)
exten => s,n,Goto(dynroute-1,1,1)

exten => 1,1,Goto(app-blackhole,musiconhold,1)
exten => 1,n,Hangup

exten => 4,1,Goto(dynroute-1,1,1)

;--== end of [dynroute-1] ==--;

my res_odbc.conf

;--------------------------------------------------------------------------------;
; Do NOT edit this file as it is auto-generated by FreePBX. All modifications to ;
; this file must be done via the web gui. There are alternative files to make    ;
; custom modifications.                                                          ;
;--------------------------------------------------------------------------------;
;
; This file is part of FreePBX.
;
;    FreePBX is free software: you can redistribute it and/or modify
;    it under the terms of the GNU General Public License as published by
;    the Free Software Foundation, either version 2 of the License, or
;    (at your option) any later version.
;
;    FreePBX is distributed in the hope that it will be useful,
;    but WITHOUT ANY WARRANTY; without even the implied warranty of
;    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
;    GNU General Public License for more details.
;
;    You should have received a copy of the GNU General Public License
;    along with FreePBX.  If not, see <http://www.gnu.org/licenses/>.
;
; Copyright (C) 2012 Astrogen LLC (USA)

#include res_odbc_custom.conf
#include res_odbc_additional.conf

res_odbc_custom.conf

[TeamWoxDB]
enabled=>yes
dsn=>TeamWoxDB
pre-connect=>yes
max_connections=>5

/etc/etcodbc.ini

[MySQL-asteriskcdrdb]
Description=MySQL connection to 'asteriskcdrdb' database
driver=MySQL
server=localhost
database=asteriskcdrdb
Port=3306
Socket=/var/lib/mysql/mysql.sock
option=3
Charset=utf8


[TeamWoxDB]
Description     = Firebird
Driver          = Firebird
Dbname          = 192.168.101.214:C:\Program Files\TeamWox\db\TEAMWOX.FDB
User            = sysdba
Password        = XXXXX
Role            =
CharacterSet    =
ReadOnly        = No
NoWait          = No

/etc/odbcinst.ini


# Example driver definitions

# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description	= ODBC for PostgreSQL
Driver		= /usr/lib/psqlodbcw.so
Setup		= /usr/lib/libodbcpsqlS.so
Driver64	= /usr/lib64/psqlodbcw.so
Setup64		= /usr/lib64/libodbcpsqlS.so
FileUsage	= 1


# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description	= ODBC for MySQL
Driver		= /usr/lib/libmyodbc5.so
Setup		= /usr/lib/libodbcmyS.so
Driver64	= /usr/lib64/libmyodbc5.so
Setup64		= /usr/lib64/libodbcmyS.so
FileUsage	= 1

# Driver from the Firebird-connector-odbc package
[Firebird]
Description = Firebird ODBC Driver
Driver      = /usr/lib/libOdbcFb.so
Setup       = /usr/lib/libOdbcFb.so
Threading 	= 1
FileUsage   = 1
CPTimeout   =
CPReuse     =

pbx*CLI> odbc show

ODBC DSN Settings
-----------------

  Name:   TeamWoxDB
  DSN:    TeamWoxDB
    Number of active connections: 1 (out of 5)
    Logging: Disabled

  Name:   asteriskcdrdb
  DSN:    MySQL-asteriskcdrdb
    Number of active connections: 2 (out of 5)
    Logging: Disabled
[root@pbx ~]# isql -v TeamWoxDB
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

https://community.freepbx.org/t/missunderstanding-about-func-odbc/80219/4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.