Iscriviti   Guestbook   Immagini   Forum   Download   Mappa   63 utenti on line 
Italiano
MENU
CONFIGURAZIONI
RISORSE
INFO
Login

DOWNLOAD
Device
Suggerimenti

 
Sip_conf per MySQL

There is a script in contrib/scripts called:
retrieve_sip_conf_from_mysql.pl

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
keyword: 'account'
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.



 

Valid CSS!