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