Web-Meetme

Web-MeetMe is a suite of PHP pages to allow for scheduling and managing conferences on an Asterisk PBX.

Prerequisites

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;