Web-Meetme
NOTE: I am currently experiencing compile errors. Due to the fact the instruction are not complete until I can resolve the issues.
Web-MeetMe is a suite of PHP pages to allow for scheduling and managing conferences on an Asterisk PBX.
Prerequisites
Apache
Generally if you are already using Asterisk, Apache will already be installed and running. If it is not, then see the Apache page for instructions on how to install. You will only need to refer to the Installation section.
MySQL
yum install mysql-server mysql-devel chkconfig mysqld on service mysqld start
PHP
yum install php-mysql php-dba php-gd
GD
yum install gd
PHP pear
yum install php-pear
If you are using a proxy server enter the details as below.
config-set http_proxy http://username:password@yourproxy:80
pear install MDB2 pear install MDB2_Driver_mysql
Create a Global MySQL password
mysqladmin -u root password password_goes_here
Create MySQL Databses
mysql -p
Create a username and password for Web-Meetme.
Crerate a database called meetme with a username of meetme and a password of mypassword
CREATE DATABASE meetme; USE meetme; GRANT ALL on meetme.* to 'meetme'@'localhost' IDENTIFIED BY 'mypassword'; flush privileges; quit;
Create Tables
Log into the databse meetme using username meetme
mysql -u meetme -p -D meetme
Create the 1st table called booking.
CREATE TABLE `booking` ( `bookId` int(10) unsigned NOT NULL auto_increment, `clientId` int(10) unsigned default '0', `roomNo` varchar(30) default '0', `roomPass` varchar(30) NOT NULL default '0', `silPass` varchar(30) NOT NULL default '0', `startTime` datetime NOT NULL default '0000-00-00 00:00:00', `endTime` datetime NOT NULL default '0000-00-00 00:00:00', `dateReq` datetime NOT NULL default '0000-00-00 00:00:00', `dateMod` datetime NOT NULL default '0000-00-00 00:00:00', `maxUser` varchar(30) NOT NULL default '10', `status` varchar(30) NOT NULL default 'A', `confOwner` varchar(30) NOT NULL default '', `confDesc` varchar(100) NOT NULL default '', `aFlags` varchar(10) NOT NULL default '', `uFlags` varchar(10) NOT NULL default '', `sequenceNo` int(10) unsigned default '0', `recurInterval` int(10) unsigned default '0', PRIMARY KEY (`bookId`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=145 ;
Create the 2nd table called cdr.
CREATE TABLE `cdr` ( `bookId` int(11) default NULL, `duration` varchar(12) default NULL, `CIDnum` varchar(32) default NULL, `CIDname` varchar(32) default NULL, `jointime` datetime default NULL, `leavetime` timestamp NULL default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
These tables are needed if you will be storing user accounts for authenitication in a database
Create the 3rd table called participants'.
CREATE TABLE `participants` ( `id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `book_id` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=782 ;
Create the 4th table user.
CREATE TABLE `user` ( `id` int(11) NOT NULL auto_increment, `email` varchar(100) NOT NULL default '', `password` varchar(25) default NULL, `first_name` varchar(50) default NULL, `last_name` varchar(50) default NULL, `telephone` varchar(15) default NULL, `admin` varchar(5) NOT NULL default 'User', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
If all went well you should now have a DataBase with 4 tables and a user that Web-MeetMe will use to access the tables.
show tables;
Installation
Download
Check for the latest version
cd /usr/src wget http://internode.dl.sourceforge.net/sourceforge/web-meetme/Web-MeetMe_v3.1.0.tgz tar xvfz Web-MeetMe_v3.1.0.tgz mv web-meetme/ /var/www/html/
CBMySQL
cd /var/www/html/web-meetme/cbmysql make make install