Web-Meetme

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