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: 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: 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: chan_sip.c:15055 handle_request_register: Registration from '"bob"<sip:firstname.lastname@example.org>' 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:
[settings] sipusers => odbc,asterisk,sipusers sippeers => odbc,asterisk,sipusers voicemail => odbc,asterisk,vmusers
[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..
[global] dsn=MySQL-asterisk username=root password=***** loguniqueid=yes dispositionstring=yes table=sipusers usegmtime=no
[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
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.