代码人生

手机一点通系统安装步骤

一、安装升级编译环境

二、安装 mysql

三、建立mobiledb数据库：
/usr/local/mysql/bin/mysql -uroot -p

mysql> create database mobiledb;
Query OK, 1 row affected (0.06 sec)

mysql> grant all on mobiledb.* to easymobile@localhost identified by ‘easysystem’;
Query OK, 0 rows affected (0.00 sec)

use mobiledb;

DROP TABLE IF EXISTS calleridpool;
CREATE TABLE calleridpool (
id int(12) NOT NULL auto_increment,
rowid int(12) NOT NULL default ‘0′,
callerid varchar(20) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS seq_table;

CREATE TABLE seq_table(
refid int(12) NOT NULL default ‘0′,
PRIMARY KEY (refid)
) TYPE=MyISAM;

insert into seq_table values (0);

DROP TABLE IF EXISTS seq_table2;

CREATE TABLE seq_table2(
refid int(12) NOT NULL default ‘0′,
PRIMARY KEY (refid)
) TYPE=MyISAM;

insert into seq_table2 values (0);

DROP TABLE IF EXISTS lastcalleepool;
CREATE TABLE lastcalleepool (
id int(12) NOT NULL auto_increment,
callerid varchar(20) NOT NULL,
lastcallee varchar(20) NOT NULL,
logdate datetime NOT NULL default ‘0000-00-00 00:00:00′,
PRIMARY KEY (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS calleepool1;
CREATE TABLE calleepool1 (
id int(12) NOT NULL auto_increment,
rowid int(12) NOT NULL default ‘0′,
callee varchar(20) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS calleepool2;
CREATE TABLE calleepool2 (
id int(12) NOT NULL auto_increment,
rowid int(12) NOT NULL default ‘0′,
callee varchar(20) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

–
– Table structure for table callhistory
–

DROP TABLE IF EXISTS callhistory;
CREATE TABLE callhistory (
id int(12) NOT NULL auto_increment,
calldate datetime NOT NULL default ‘0000-00-00 00:00:00′,
dst varchar(30) NOT NULL default ”,
billsec int(12) NOT NULL default ‘0′,
accountcode varchar(20) NOT NULL default ”,
dnid varchar(20) NOT NULL default ”,
trunkname varchar(20) NOT NULL default ‘0′,
PRIMARY KEY (id)
) TYPE=MyISAM;

–
– Table structure for table trunks
–

DROP TABLE IF EXISTS trunks;
CREATE TABLE trunks (
id int(12) NOT NULL auto_increment,
trunk_name varchar(20) NOT NULL default ”,
fullname varchar(72) NOT NULL default ”,
routerprovider_name varchar(20) NOT NULL,
trunkaccount varchar(20) NOT NULL default ”,
trunkpasswd varchar(20) NOT NULL default ”,
serverip varchar(255) NOT NULL default ”,
trunktype varchar(20) NOT NULL default ”,
tdmgroup varchar(20) NOT NULL default ”,
addmsd varchar(20) NOT NULL default ”,
active int(1) NOT NULL default ‘0′,
serverport varchar(20) NOT NULL default ”,
localareacode varchar(20) NOT NULL default ”,
capacity int(4) NOT NULL default ‘0′,
codecs varchar(30) NOT NULL default ‘g729′,
callerid varchar(20) NOT NULL default ”,
msdstrip varchar(30) NOT NULL default ”,
insecure varchar(20) NOT NULL default ”,
PRIMARY KEY (id),
UNIQUE KEY UK_routerprovider_name (trunk_name)
) TYPE=MyISAM;

– Table structure for table syssetting

DROP TABLE IF EXISTS syssetting;

CREATE TABLE syssetting(
ready_flag int(1) NOT NULL default ‘0′
) TYPE=MyISAM;

insert into syssetting values (0);

四、安装 FTP 服务器

五、安装 Asterisk

六、安装 Asterisk-addons

七、将如下文件上载至目录 /var/lib/asterisk/agi-bin

mobilelink

simpleforward

downloadcallinfo

uploadcdr2ftp

八、上载配置文件：

将 mblink.conf 放到 /etc 目录

将 sip_mb.conf 放到 /etc/asterisk 目录

将 sip_accounts.conf 放到 /etc/asterisk 目录

编辑 /etc/asterisk/sip.conf 文件，添加如下行至general段：

#include “sip_mb.conf”

#include “sip_accounts.conf”

将 extension_mb.conf 放到 /etc/asterisk 目录

编辑 /etc/asterisk/extensions.conf 文件，添加如下行至general段：

#include “extension_mb.conf”

九、配置FTP目录：

在 /home/vftp/terry/ 目录下，建立如下目录：

caller

cdr

mh

rtc

注意这四个子目录应该是ftp用户可以读写状态。