For asterisk 1.6 and above
Create a new database and table in your mysql database. For adding the table use the below query
CREATE TABLE meetme (
confno char(80) NOT NULL default ‘0’,
starttime datetime NOT NULL default ‘0000-00-00 00:00:00’,
endtime datetime NOT NULL default ‘2099-12-31 23:59:59’ ,
pin char(20) default NULL,
opts char(100) default NULL,
adminpin char(20) default NULL,
adminopts char(100) default NULL,
members int(11) NOT NULL default ‘0’,
maxusers int(11) NOT NULL default ‘0’,
PRIMARY KEY (confno,starttime)
);
The above query will create a table meetme, with the needed fields in it.
Now add the following database connection details to /etc/asterisk/res_config_mysql.conf
[context]dbhost = 127.0.0.1
dbname =dbname
dbuser = user
dbpass = password
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
dbcharset = latin1
requirements=warn ; or createclose or createchar
Now edit your extconfig.conf file inside /etc/asterisk and add the following line at the bottom
meetme => mysql,dbname,meetme
Also make sure you have the following parameters in your meetme.conf file inside /etc/asterisk
schedule=yes (starttime and endtime options for meetme conference will work only if this parameter is set to yes. You can schedule a conference with this and the conference will be active only between the startime and endtime)
logmembercount=yes (This parameter helps keep track of members in an active conference. maxusers option in a conference will work only if this parameter is set to yes)
Now reload asterisk and start using asterisk realtime conference
