There is a script in contrib/scripts called:
Asterisk sip conf from mysql
Another example is attached with this post.
This can be used to write a file to be #included in sip.conf
(by default it's called sip_additional.conf)
Create database (NB The username specified in the script only needs to have SELECT priviliges on this database):
CREATE TABLE sip (
id INT(11) DEFAULT -1 NOT NULL,
keyword VARCHAR(20) NOT NULL,
data VARCHAR(50) NOT NULL,
flags INT(1) DEFAULT 0 NOT NULL,
PRIMARY KEY (id,keyword)
Each user has several records which are linked by sharing the same 'id'
One of these records must have
data: username to be written out as [username]
Normally the minimal other record would be one with keyword: 'secret'
Records with id: '0' are applied to all users.
If flags is set to 1, then that record is not included in the output file
Asterisk needs to be reloaded after running this script in order to see the changes activated.
Back to Asterisk configuration from database
Please update this page with new information, just login and click on the "Edit" or "Discussion" tab. Get a free login here: Register Thanks! - Find us on Google+