소프트스위치

오늘:
701
어제:
2,208
전체:
2,860,592

고객센타 : 070-7752-2000
팩스 : 070-7752-2001
휴대폰 : 010-9513-0019
email : voipkorea@yahoo.co.kr

국민은행
(주)제이에스솔루션
047101-04-155519

Flag Counter
■ 무료 : 유선 집전화 휴대폰 ( 한국 미국 중국 카나다) ↔ (국내 해외 여행자 상사 주재원 유학생) / 가입무 무제한무료■

https://sysadminman.net/blog/2013/a2billing-and-opensips-part-2-4788


This is to confirm that SysAdminMan no longer offers FreePBX or A2Billing hosting.There were a few reasons for this decision but one of that main ones was, in my opinion, Sangoma’s aggressive commercialisation of FreePBX and their “FreePBX” trademark. It did not make commercial sense to continue building a business under these circumstances.According to Google Analytics there are still a couple of thousand visitors a week that use the site, so I will leave it here, but will not be adding new guides or tips.

In this part of the guide I’m going to look at some of the set up required for the example config to work.

We are going to enable IP and USER/SECRET authentication for our A2Billing SIP customer calls. To do that we are going to create a couple of MySQL VIEWS in the ‘opensips’ database that point to tables in the ‘a2billing’ database. This means we can create our A2Billing SIP users as normal, and they will then become valid users in OpenSIPS.

Part 2 and Part 3 of the guide assume the following –

  • OpenSIPS server IP = 1.1.1.1
  • A2Billing server IP = 2.2.2.2
  • MySQL server IP = 2.2.2.2   (same server as A2Billing)
  • domain name for our calls = mya2billingcalls.com

On the A2Billing/Asterisk server

So now we create our VIEWS in the database. We are going to use the ‘address’ table for IP authentications and the ‘subscriber’ table for USER/SECRET authentications.

Here we create the ‘address’ VIEW –

DROP TABLE opensips.address

CREATE VIEW opensips.address AS
SELECT id AS id,
CAST(1 AS DECIMAL) AS grp,
host AS ip,
CAST(32 AS DECIMAL) AS mask,
cast(port as DECIMAL) AS port,
'UDP' AS proto,
'' AS pattern,
accountcode AS context_info
from a2billing.cc_sip_buddies
WHERE host != 'dynamic';

So for any A2Billing SIP customer where the IP address is not set to ‘dynamic’ we are going to create an OpenSIPS user. We are also going to store the A2Billing customers Account Code in a field called context_info. This is not strictly what that field is designed for but it makes it easy for us to access the customers account code from OpenSIPS

Now we create the ‘subscriber’ VIEW –

DROP TABLE opensips.subscriber

CREATE VIEW opensips.subscriber AS
SELECT id AS id,
username AS username,
'openhold.com' AS domain,
secret AS password,
'' AS email_address,
md5(concat(username,':','mya2billingcalls.com',':',secret)) AS ha1,
md5(concat(username,'@','mya2billingcalls.com',':','mya2billingcalls.com',':',secret)) AS ha1b,
accountcode AS rpid
from a2billing.cc_sip_buddies
where username != '';

You will want to change ‘mya2billingcalls.com’ to the domain name you are going to use. We are going to store the customers Account Code in a field called ‘rpid’. Again this is not really what it’s designed for, but it makes it easy to access from OpenSIPS. You can see the ‘where’ clause restricts this to A2Billing customers that do not have a blank username field (they might have this if you were doing IP authentication)

Next we need to modify the Asterisk dial plan a little to tell it to pass all calls coming form the OpenSIPS server to the a2billing.php script.
To do that we are first going to create an entry in sip.conf with the sip details of the OpenSIPS server –

[opensips]
host=1.1.1.1
type=peer
context=a2billing-opensips-sip

So any calls coming from the OpenSIPS server will get passed to the ‘a2billing-opensips-sip’ context.

Now we create that context in extensions.conf –

[a2billing-opensips-sip]
exten => _X.,1,Set(CDR(accountcode)=${SIP_HEADER(P-Accountcode)})
exten => _X.,n,DeadAGI(a2billing.php,1)
exten => _X.,n,Hangup

So we set the A2Billing customer account code (this is going to be passed to us by OpenSIPS) and then we run the a2billing.php script using agi-conf1

On the A2Billing customer PBX

I’m going to assume that our A2Billing SIP customer is using an Asterisk server to connect to us. They could set up their trunk in 2 different ways. One using IP authentication like this –

[mya2billingcalls]
host=1.1.1.1
type=peer

For IP authentication we must have entered the customers PBX IP address in the HOST field in the customers A2Billing SIP account

Or they could use username/password authentication like this –

[mya2billingcalls]
host=1.1.1.1
type=peer
username=XXXXX
secret=XXXXX
fromdomain=mya2billingcalls.com

The ‘fromdomain’ setting must be set to the same one we used when creating our MySQL views.

That’s the Asterisk and MySQL setup done, it part 3 we’ll look at the actual OpenSIPS config file.

조회 수 :
993
등록일 :
2017.08.29
11:28:30 (*.160.88.18)
엮인글 :
http://webs.co.kr/index.php?document_srl=3311336&act=trackback&key=52c
게시글 주소 :
http://webs.co.kr/index.php?document_srl=3311336
List of Articles
번호 제목 글쓴이 날짜 조회 수
140 openssl 을 이용한 인증서 생성 절차를 정리한다. 개인키 CSR SSL 인증서 파일 생성 admin 2017-09-14 839
139 Documentation -> Tutorials -> TLS opensips.cfg admin 2017-09-14 838
138 Using TLS in OpenSIPS v2.2.x admin 2017-09-14 839
137 opensips tls cfg admin 2017-09-14 857
136 How to setup a Jabber / XMPP server on Debian 8 (jessie) using ejabberd admin 2017-09-13 848
135 SIP to XMPP Gateway + SIP Presence Server opensips admin 2017-09-13 852
134 OpenSIPS command line tricks admin 2017-09-13 838
133 Fail2Ban Freeswitch How to secure admin 2017-09-12 874
132 opensips.cfg. sample admin 2017-09-12 848
131 Advanced SIP scenarios with Event-based-Routing admin 2017-09-11 880
130 PUSH SERVER 푸시서버 안드로이드 애플 admin 2017-09-11 878
129 오픈소스 (사내)메신저 서버 구축, 오픈 파이어(openfire) 설치방법과 세팅(리눅스 기준) admin 2017-09-09 900
128 rtpengine config basic and opensips configuration and command admin 2017-09-06 893
127 WebSocket Transport using OpenSIPS configuration 웹 소켓 컨피그레이션 기본 admin 2017-09-06 885
126 OpenSIPS basic configuration script 기본 컨피그 admin 2017-09-05 901
125 rtpengine install and config admin 2017-09-05 936
124 Installing RTPEngine on Ubuntu 14.04 admin 2017-09-05 937
123 compile only the textops module make modules=modules/textops modules admin 2017-09-05 908
122 opensips command /sbin/opensipsctl detail admin 2017-09-04 925
121 2017 08 31 opensips 2.32 install debian8.8 module install compile err modules admin 2017-09-04 934
120 Build-Depends debian 8.8 opensips 2.3 admin 2017-09-04 907
119 What is new in 2.3.0 opensips admin 2017-09-04 977
118 ubuntu 安装配置opensips,rtpproxy,mediaproxy admin 2017-09-04 942
117 How to install Mediaproxy 2.5.2 on CentOS 6 64 bit admin 2017-09-04 958
116 Using TLS in OpenSIPS v2.2.x configuration admin 2017-09-04 950
115 How to 2.3 download , OpenSIPS new apt repository. DEBs for Debian / Ubuntu admin 2017-09-02 933
114 You can install CDRTool in the following ways: admin 2017-09-01 988
113 How to Install OpenSIPS 2.1.2 Server on Ubuntu 15.04 admin 2017-09-01 980
112 Opensips 2.32 download admin 2017-09-01 969
111 OpenSIPS 2.3 install admin 2017-09-01 979
110 JsSIP: The JavaScript SIP Library admin 2017-09-01 966
109 WebSocket Transport using OpenSIPS admin 2017-09-01 976
108 A2Billing and OpenSIPS – Part 1 admin 2017-08-29 1007
» A2Billing and OpenSIPS – Part 2 admin 2017-08-29 993
106 A2Billing and OpenSIPS – Part 3 admin 2017-08-29 1004
105 OpenSIPS 2.3 philosophy admin 2017-08-17 1089
104 The timeline for OpenSIPS 2.3 is admin 2017-08-17 1237
103 OpenSIPS Control Panel and Homer integration admin 2017-08-17 1081
102 Opensips sip capture re designed admin 2017-07-16 1233
101 WebRTC with OpenSIPS WebSocket is a protocol provides full-duplex admin 2015-04-04 5982
100 WebSocket Support in OpenSIPS 2.1 admin 2015-04-04 6581
99 OpenSIPS 2.1 (rc) is available, download now! admin 2015-03-22 6173
98 Service Provision Using Asterisk & OpenSIPS - AstriCon 2014 admin 2015-02-25 7743
97 SIP Signaling-Messages OpenSIPS Running On Multicore Server file admin 2014-11-02 15424
96 opensips.cfg for Asterisk admin 2014-10-20 17528
95 A2Billing and OpenSIPS config admin 2014-10-20 16892
94 Jitsi Videobridge meets WebRTC admin 2014-10-18 16953
93 A Survey of Open Source Products for Building a SIP Communication Platform admin 2014-10-18 16594
92 Script Function , Module Index v1.11 함수 모듈 opensips admin 2014-10-14 16763
91 Opensips TM module enables stateful processing of SIP transactions admin 2014-10-04 14502
90 kamailio.cfg configuration Example admin 2014-10-04 16614
89 opensips NAT Traversal Module admin 2014-10-02 16036
88 UAC Registrant Module admin 2014-09-28 17520
87 MediaProxy 2.3.x & OpenSIPS 1.5.x Integration admin 2014-08-24 16618
86 RTPPROXY Admin Guide admin 2014-08-24 16963
85 CANCEL MESSAGE not handled correctly admin 2014-08-23 16788
84 [Sipdroid] SIP data collection study tour admin 2014-08-23 17395
83 [OpenSIPS-Users] Opensips 1.10 NAT radius aaa admin 2014-08-23 17405
82 OpenSIPS Consultancy Pricing module install Server 판매 또는 설치및 컨설팅 가이드 admin 2014-08-23 17259
81 ICE: The ultimate way of beating NAT in SIP admin 2014-08-23 17048
80 Many OPENSIPS Configuration Examples This will Help you admin 2014-08-23 16751
79 Real-time Charging System for Telecom & ISP environments admin 2014-08-23 17322
78 OPENSIPS EBOOK admin 2014-08-21 17329
77 Opensips Documentation Function admin 2014-08-21 17534
76 Presence Tutorial OpenXCAP setup admin 2014-08-18 16560
75 Opensips Modules Documentation admin 2014-08-18 17405
74 A lightweight RPC library based on XML and HTTP admin 2014-08-18 16914
73 opensips Nat script with RTPPROXY - English Good perfect admin 2014-08-15 15026
72 OpenSIPS Control Panel (OCP) Installation Guide Good admin 2014-08-13 14931
71 Installation and configuration process record opensips opensips-cp admin 2014-08-13 25568
70 OpenSIPS as Homer Capture server admin 2014-08-13 14762
69 OpenSIPS , default script , Types of Routs , Routing in SIP, Video lecture admin 2014-08-13 16681
68 Configuracion de Kamailio 3.3 con NAT Traversal y XCAP. admin 2014-08-12 17095
67 Under RHEL6.5 install OpenSIPS 1.11.1 tls admin 2014-08-12 15966
66 OpenSIPS/OpenSER-a versatile SIP Server cfg admin 2014-08-11 17473
65 Kamailio Nat Traversal using RTPProxy admin 2014-08-11 17054
64 MediaProxy wiki page install configuration admin 2014-08-11 17045
63 오픈소스 (사내)메신저 서버 구축, 오픈 파이어(openfire) 설치방법과 세팅 admin 2014-08-11 25658
62 MediaProxy Installation Guide admin 2014-08-10 16632
61 RTPProxy 1.2.x Installation & Integration with OpenSIPS 1.5x admin 2014-08-10 17791
60 Opensips Installation, How to. Good guide wiki page admin 2014-08-10 14673
59 OpenSIPS Installation Notes admin 2014-08-09 13872
58 Installation and configuration process record opensips 1.9.1 admin 2014-08-09 16470
57 opensips 1.11.2 install Good Giide admin 2014-08-09 16412
56 fusionPBX install debian wheezy admin 2014-08-09 16912
55 opensips 1.11.2 install guide good 인스톨 가이드 admin 2014-08-09 16339
54 SigIMS IMS Platform admin 2014-05-24 17711
53 2013 2012년 분야별 최고의 오픈소스 소프트웨어 124선 admin 2014-04-05 17438
52 Video conference server OpenMCU-ru - Introduction admin 2014-04-01 19786
51 SIPSorcery admin 2014-03-18 17879
50 Ekiga (formely known as GnomeMeeting) is an open source SoftPhone admin 2014-03-12 18291
49 telepresence: Open Source SIP Telepresence/MCU admin 2014-03-12 20208
48 SIP PBX - OpenSIPS and Asterisk configuration admin 2014-03-12 15956
47 Conference Support in Kamailio (OpenSER) admin 2014-03-12 18498
46 OpenSIPS configuration for 2 or more FreeSWITCH installs admin 2014-03-12 15895
45 The Impact of TLS on SIP Server Performance file admin 2014-03-12 18123
44 book-opensips-101 / content / 3.2. SIP TLS Secure Calling.mediawiki admin 2014-03-12 17027
43 Where to check OpenSIPS does not start? admin 2014-03-09 17590
42 opensips-1.10.0_src.tar.gz experimental source code documentation admin 2014-03-09 18509
41 Kamailo OpenSIPs installation on Debian admin 2014-03-09 16841
40 Using the openSIPS Registrant Module admin 2014-03-09 18470
39 RTPproxy Frequentry Asked Questions (FAQ) ¶ admin 2014-03-07 16488
38 Building Telephony Systems with OpenSIPS 1.6 RTPProxy + OpenSIPS 1.7 admin 2014-03-07 18011
37 Installing RTPproxy Start RTPproxy in Bridged mode very good admin 2014-03-07 21933
36 OpenSIPS Control Panel (OCP) Installation Guide admin 2014-03-06 16353
35 OpenSIPS Control Panel install guide admin 2014-03-06 17209
34 rtpproxy Module admin 2014-03-06 18005
33 MediaProxy Installation Guide admin 2014-03-06 18843
32 How to install OpenSIPS on CentOS debian module add xcap admin 2014-03-06 18573
31 Problem with presence_xml module Opensips 1.9 admin 2014-03-06 18131
30 Building Telephony Systems with OpenSIPS 1.6 books file admin 2014-03-06 18955
29 Multimedia Service Platform admin 2014-03-06 17430
28 How to install OpenSIPS on CentOS Debian etc admin 2014-03-05 18423
27 Opensips Installation, How to. admin 2014-03-05 14813
26 100% CPU usage opensips admin 2014-03-05 17687
25 A2Billing and OpenSIPS admin 2014-03-04 18558
24 Opensips_1.9 install guide this is great I like this admin 2014-03-04 22724
23 Opensips install debian admin 2014-03-03 18687
22 Open Source VOIP applications, both clients and servers. admin 2013-11-20 19012
21 OfficeSIP Server is freeware VoIP, SIP server for Windows admin 2013-09-11 19666
20 My new toy: Bluebox-ng admin 2013-04-06 32860
19 Flooding Asterisk, Freeswitch and Kamailio with Metasploit admin 2013-04-06 28561
18 Asterisk Installation Asterisk Realtime configuration admin 2013-04-06 22404
17 The SIP Router Project admin 2013-04-06 21510
16 Kamailio :: A Quick Introduction admin 2013-04-06 18565
15 Welcome to the Smartvox Knowledgebase admin 2013-04-06 19282
14 Kamailio 3.3.x and Asterisk 10.7.0 Realtime Integration using Asterisk Database admin 2013-04-06 22335
13 OpenSIPS vs Asterisk admin 2013-04-06 30190
12 OpenSER_from_an_asterisk_POV file admin 2013-04-06 19234
11 Using SIP Devices behind NAT OPensip Asterisk IPPhone SIP Telephony file admin 2013-03-31 36391
10 rfc5766-turn-server admin 2013-03-21 21080
9 OpenSIPS Kick Start‎: VIDEO admin 2013-02-20 18498
8 OPENSIP Training VIDEO admin 2013-02-20 18403
7 What is new in 1.8.0 opensip admin 2012-05-21 39855
6 Asterisk v1.4x built on FreeBSD v7.1 UNIX admin 2012-01-06 30985
5 SIP 트래픽 생성 테스트 툴 admin 2011-12-23 38774
4 사설 망 환경에서 SIP 의 NAT Traversal 문제 admin 2011-12-23 33498
3 the OpenSIPS Project OpenSIP admin 2011-12-14 18478
2 OpenH323 Gatekeeper - The GNU Gatekeeper admin 2011-12-14 23245
1 The FreeRADIUS Project admin 2011-12-14 19704