Web-MeetMe

設定 ODBC

編輯 /etc/odbc.ini

[MySQL-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

編輯 /etc/asterisk/res_odbc.conf

[meetme]
dsn => MySQL-Asterisk
username => <db-username>
password => <db-password>
pre-connect => yes

編輯 /etc/asterisk/extconfig.conf

meetme => odbc,meetme,booking

編輯 /etc/asterisk/cdr_adaptive_odbc.conf

[wmm]
connection=meetme    ;Note that this matches res_odbc.conf
table=cdr

編輯 /etc/asterisk/cdr.conf

endbeforehexten=no

設定MySQL資料庫

建立資料庫 meetme

#mysql -uroot -p
mysql> create database meetme; 

匯入資料庫 schema

#cd /var/www/html/web-meetme/
#cd cbmysql/
#mysql -uroot -p meetme < ./db-table-create-v7.txt 

匯入管理員帳號

#mysql -uroot -p meetme < ./db-admin-user-create.txt

Tips:

＊ 預設管理帳號： admin@localhost, 密碼：wmmpw
＊ 如果使用 LDAP 認證，可忽略此步驟。

設定 Web-MeeetMe

編輯 /web-meetme/lib/database.php

$database = 'meetme';
$host = 'localhost';
$username = 'db_user';
$password = 'db_pass';

編輯 /etc/asterisk/manager_custom.conf

[MeetMe]
secret = ami_pass
read = call
write = command,originate

編輯 /web-meetme/phpagi/phpagi.example.conf

[asmanager]
# server to connect to
server=localhost

# default manager port
port=5038

#username for login
username=MeetMe

#password for login
secret=ami_pass

預設的網頁登入是 LDAP 模式，改成資料庫認證。
編輯 /web-meetme/lib/defines.php

// Comment out the following lines to disable authentication
define ("AUTH_TYPE", "sqldb"); // adLDAP or sqldb