Book Image

Building Telephony Systems with OpenSER

Book Image

Building Telephony Systems with OpenSER

Overview of this book

Table of Contents (18 chapters)
Building Telephony Systems with OpenSER
Credits
About the Author
About the Reviewers
Preface
6
Building the User Portal with SerMyAdmin
Index

Migrating the Script from Chapter 10 to openser 1.3.1


I had to change the following instructions to migrate the script openser.chapter10-2 to the version 1.3.1. After the changes I tested a call from two phones and two phones behind NAT. It worked fine, but I did not test the script thoroughly, so it is possible that you find a few issues.

Step 1: Migrate the gw table in the database (according to the web page cited above). The old table will be dropped.

mysql
use openser
drop table gw;
delete from version where table_name='gw'; (formatted as code in text)
insert into version values('gw', 5);
CREATE TABLE 'gw' ( 'id' int(10) unsigned NOT NULL auto_increment, 'gw_name' varchar(128) NOT NULL, 'grp_id' int(10) unsigned NOT NULL, 'ip_addr' varchar(15) NOT NULL, 'port' smallint(5) unsigned default NULL, 'uri_scheme' tinyint(3) unsigned default NULL, 'transport' tinyint(3) unsigned default NULL, 'strip' tinyint(3) unsigned default NULL, 'prefix' varchar(16) default NULL, 'dm' tinyint(3) unsigned...