Hello,
I’m having some troubles when trying to configure my asterisk to read the sip peers and users from a mysql table.
Here is my configs (Asterisk 15.2.0):
modules.conf
…
load = res_odbc_transaction.so
load = res_odbc.so
load = func_odbc.so
load = func_realtime.so
load = pbx_realtime.so
load = chan_sip.so
res_odbc.conf
[asterisk]
enabled = yes
dsn = asterisk-conn
username = asterisk
password = Po2Am8B32Oj4
max_connections = 1
pre-connect = yes
extconfig.conf
[settings]
extensions => odbc,asterisk,asterisk_extensions
sipusers => odbc,asterisk,asterisk_sippeers
sippeers => odbc,asterisk,asterisk_sippeers
sip.conf
[general]
…
rtcachefriends=yes
Executing:
odbc show
ODBC DSN Settings
Name: asterisk
DSN: asterisk-conn
Number of active connections: 1 (out of 1)
ODBC system connection seems to work fine.
So, when i try to connect with sip users inserted on table, asterisk give me a message saying wrong passsword:
NOTICE[12101] chan_sip.c: Registration from ‘sip:1234@XXX’ failed for ‘XXX:38589’ - Wrong password
But the user is registered on the mysql table (i’ve used this same table structure on another server, and it’s work fine).
What i’m doing wrong?