Database Integration for SIP,Extensions

Asterisk Asterisk SIP
1

I have created a table for sip.conf.

CREATE TABLE sip_friends (
name VARCHAR(40) NOT NULL DEFAULT ‘’,
username VARCHAR(40) NULL DEFAULT ‘’,
secret VARCHAR(40) NOT NULL DEFAULT ‘’,
context VARCHAR(40) NOT NULL DEFAULT ‘’,
ipaddr VARCHAR(20) NOT NULL DEFAULT ‘’,
port INT(6) NOT NULL DEFAULT ‘0’,
regseconds INT(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (name)
)

i have installed and configured ODBC. I am using MySQL database.
Along with that i have made entries in extconfig.conf:
sip.conf => odbc,asterisk,sip_friends
But asterisk real time is not working. unable to login with voip client.
What else i need to do?

2

Do you have your odbc.ini and odbcinst.ini files set up correctly? Can you confirm that you can establish a connection using ODBC? The following wiki page might be helpful: https://wiki.asterisk.org/wiki/display/AST/Getting+Asterisk+Connected+to+MySQL+via+ODBC

3

Yes i have configured odbc. kindly go through the screenshots attached.
Do i need to configure anything else?
odbc show all

odbcini

odbcini2

4

how do you know realtime is the problem? What do you mean by “login with voip client”? It won’t register? Can’t make a call?

Have you looked at the Asterisk log? Any warnings or errors of note?

5

Thank you for your answer.
Yes i have configured odbc.ini and odbcinst.ini. they are as follows:

[asterisk-connector]
Description=MySQL connection to 'asterisk' database
Driver=MySQL
Database=asterisk
Server=localhost
user=root
password=voip123
#;Server=178.63.254.99
Port=3306
Socket=/var/lib/mysql/mysql.sock


# 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
Pooling         = Yes
"odbcinst.ini" 24L, 628C

From Asterisk CLI “odbc show all” returning as follows

srv*CLI> odbc show all

ODBC DSN Settings
-----------------

  Name:   root
  DSN:    asterisk-connector
    Number of active connections: 1 (out of 1)
    Logging: Disabled

I have also configured extconfig.conf

[settings]

;sip.conf => MySQL,root,bit_sipfriends
sippeers => odbc,root,sipfriends
extensions => odbc,root,bit_extensions_table

After doing all these setting the connection with asterisk server is not working. When i am trying to login from a mobile app it’s not working.

6

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.