SIP Users in mysql Database problem

Asterisk Asterisk Support
1

Hello, i want to integrate a database where the SIP Users are stored in a database.
Mainly i want to integrate Asterisk into Opensips and i am going to try now that asterisk takes the opensips users out of the database.

It is not working properly - when a client connects i get the following output:

*CLI> [Apr 22 10:36:55] WARNING[7913]: config.c:1316 find_engine: Realtime mapping for 'sippeers' found to engine 'odbc', but the engine is not available
[Apr 22 10:36:55] WARNING[7913]: config.c:1316 find_engine: Realtime mapping for 'sippeers' found to engine 'odbc', but the engine is not available
[Apr 22 10:36:55] NOTICE[7913]: chan_sip.c:15055 handle_request_register: Registration from '"bob"<sip:bob@192.168.0.103>' failed for '192.168.0.102' - No matching peer found

I have created a mysql database called “asterisk” with a view called “sipusers” on the opensips User database. There are already 2 Users stored in it and should be ready to use.

I configured the following files:
/etc/extconfig.conf

[settings]
sipusers => odbc,asterisk,sipusers
sippeers => odbc,asterisk,sipusers
voicemail => odbc,asterisk,vmusers

/etc/asterisk/modules.conf

[modules]
autoload=yes
preload => res_odbc.so
preload => res_config_odbc.so
preload => res_config_mysql.so
noload => res_config_odbc.so
noload => res_config_pgsql.so
...and some default things..

/etc/asterisk/cdr_odbc.conf

[global]
dsn=MySQL-asterisk
username=root
password=*****
loguniqueid=yes
dispositionstring=yes
table=sipusers
usegmtime=no

/etc/asterisk/res_odbc.conf

[ENV] ;standard code
INFORMIXSERVER => my_special_database ;standard code
INFORMIXDIR => /opt/informix ;standard code
[mysql1]
enabled => yes
dsn => MySQL-asterisk
username => root
password =>*****
pre-connect => yes

/etc/odbc.ini
[MySQL-asterisk]

Description = MySQL Asterisk database
Trace = Off
TraceFile = stderr
Driver = MySQL
SERVER = localhost
USER = root
PASSWORD = *****
PORT = 3306
DATABASE = asterisk

I dont have any further ideas about what could be wrong. I am happy about any idea what i can try to change here.

Thanks a lot for reading and answering.

Best regards
AsteriskTechn

2

is there really no one who can help us ?

push