Asterisk Realtime - ODBC to Sql Server

1

Hi,

Im trying to perform migration from postgres to to SQL Server DB. Basic connection to database is working.
I have a problem with MS SQL namespaces with schema’s.

I have a table sip_conf in schema ‘test’.

But when im adding entry:

sippeers => odbc,mssql,test.sip_conf
sipusers => odbc,mssql,test.sip_conf

to extconfig.conf im receiving warnings:

[Apr 15 14:23:44] WARNING[22192] res_config_odbc.c: Realtime table test.sip_conf@mssql requires column ‘ipaddr’, but that column does not exist!
[Apr 15 14:23:44] WARNING[22192] res_config_odbc.c: Realtime table test.sip_conf@mssql requires column ‘port’, but that column does not exist!
[Apr 15 14:23:44] WARNING[22192] res_config_odbc.c: Realtime table test.sip_conf@mssql requires column ‘regseconds’, but that column does not exist!
[Apr 15 14:23:44] WARNING[22192] res_config_odbc.c: Realtime table test.sip_conf@mssql requires column ‘defaultuser’, but that column does not exist!
[Apr 15 14:23:44] WARNING[22192] res_config_odbc.c: Realtime table test.sip_conf@mssql requires column ‘fullcontact’, but that column does not exist!
[Apr 15 14:23:44] WARNING[22192] res_config_odbc.c: Realtime table test.sip_conf@mssql requires column ‘regserver’, but that column does not exist!
[Apr 15 14:23:44] WARNING[22192] res_config_odbc.c: Realtime table test.sip_conf@mssql requires column ‘useragent’, but that column does not exist!
[Apr 15 14:23:44] WARNING[22192] res_config_odbc.c: Realtime table test.sip_conf@mssql requires column ‘lastms’, but that column does not exist!

how to add schema to table mapping in extconfig.conf?

2

I forgot to mention,
Those columns are present in this table:

CREATE TABLE phone.sip_conf ( id int NOT NULL IDENTITY(1,1),
name varchar(80) NOT NULL,
…

Why realtime does not see those columns when tables are in a microsoft schema?