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>