Prerequisites:
Trixbox 2.8 fresh install
Downloaded a copy of web meetme (assumed in home directory)
Procedure
1.Ssh into trixbox then execute the following:
[trixbox1.localdomain ~]# tar zxf Web-MeetMe_v4.0.2.tgz
[trixbox1.localdomain ~]# mv web-meetme/ /var/www/html/
[trixbox1.localdomain ~]# yum -y install mysql-connector-odbc
2.edit /etc/odbcinst.ini and uncomment the MySQL section and change the driver to use /usr/lib/libmyodbc3.so
3.Add following to /etc/odbc.ini
[Asterisk]
Description = ODBC for MySQL
Driver = MySQL
Server = 127.0.0.1
Database = meetme
Port = 3306
Socket = /tmp/mysql.sock
Option =
Stmt =
Trace = yes
TraceFile = /tmp/odbc.log
4.Add following to /etc/asterisk/res_odbc.conf
[meetme]
dsn => Asterisk
username => root
password => passw0rd
pre-connect => yes
5.Change /etc/asterisk/extconfig.conf
from:
;meetme => mysql,conferences
to:
meetme => odbc,meetme,booking
6.For CDR logs create /etc/asterisk/cdr_adaptive_odbc.conf:
[wmm]
connection=meetme ;Note that this matches res_odbc.conf
table=cdr
7.Create /etc/asterisk/cdr.conf
[general]
endbeforehexten=no
8.Modify /etc/asterisk/extensions_custom.conf
from:
exten => s,n,CBMysql()
to:
exten => s,n,MeetMe()
9.Add Following to /etc/asterisk/phpagi.conf
[asmanager]
server=localhost
username=meetme
secret=passw0rd
10.Add Following to /etc/asterisk/manager_custom.conf
[MeetMe]
secret = passw0rd
read = call
write = command,originate
11.Execute the following commands:
[trixbox1.localdomain web-meetme]# mysql -ppassw0rd < /var/www/html/web-meetme/cbmysql/upgrade-db.txt
[trixbox1.localdomain web-meetme]# amportal restart
[trixbox1.localdomain web-meetme]# chkconfig memcached –add
[trixbox1.localdomain web-meetme]# chkconfig memcached on
[trixbox1.localdomain web-meetme]# /etc/init.d/memcached restart
12.Modify /var/www/html/web-meetme/lib/defines.php
from:
define ("AUTH_TYPE", "adLDAP"); // adLDAP or sqldb
to:
define ("AUTH_TYPE", "sqldb"); // adLDAP or sqldb
13.In that file there are some other options that you can change to suit the specific server that we are dealing with. But one thing with the outcall defaults is to make sure that the context = from-internal for trixbox as per below
define ("OUT_CONTEXT", "from-internal"); //Select a context to place the call from
14.modify /var/www/html/web-meetme/lib/database.php
from:
$password = '';
to:
$password = 'passw0rd';
15.Modify /var/www/html/web-meetme/conf_actions.php
from:
include (dirname(__FILE__)."/phpagi/phpagi-asmanager.php");
to:
include ("/var/lib/asterisk/agi-bin/phpagi-asmanager.php");
16.goto maint section of trixbox via a web browswer
17.Make sure module Custom Destinations is installed
18.Create a Custom Destination as per image below: