-
Notifications
You must be signed in to change notification settings - Fork 909
/
acc-mysql.cfg
242 lines (204 loc) · 6.44 KB
/
acc-mysql.cfg
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
# $Id$
#
# Sample config for MySQL accouting with Kamailio 1.2.0
#
# - mysql module must be compiled and installed
#
# - new columns have to be added since by default only few are recorded
# - here are full SQL statements to create acc and missed_calls tables
#
# CREATE TABLE `acc` (
# `id` int(10) unsigned NOT NULL auto_increment,
# `method` varchar(16) NOT NULL default '',
# `from_tag` varchar(64) NOT NULL default '',
# `to_tag` varchar(64) NOT NULL default '',
# `callid` varchar(128) NOT NULL default '',
# `sip_code` char(3) NOT NULL default '',
# `sip_reason` varchar(32) NOT NULL default '',
# `time` datetime NOT NULL default '0000-00-00 00:00:00',
# `src_ip` varchar(64) NOT NULL default '',
# `dst_user` varchar(64) NOT NULL default '',
# `dst_domain` varchar(128) NOT NULL default '',
# `src_user` varchar(64) NOT NULL default '',
# `src_domain` varchar(128) NOT NULL default '',
# INDEX acc_callid (`callid`),
# PRIMARY KEY (`id`)
# );
#
# CREATE TABLE `missed_calls` (
# `id` int(10) unsigned NOT NULL auto_increment,
# `method` varchar(16) NOT NULL default '',
# `from_tag` varchar(64) NOT NULL default '',
# `to_tag` varchar(64) NOT NULL default '',
# `callid` varchar(128) NOT NULL default '',
# `sip_code` char(3) NOT NULL default '',
# `sip_reason` varchar(32) NOT NULL default '',
# `time` datetime NOT NULL default '0000-00-00 00:00:00',
# `src_ip` varchar(64) NOT NULL default '',
# `dst_user` varchar(64) NOT NULL default '',
# `dst_domain` varchar(128) NOT NULL default '',
# `src_user` varchar(64) NOT NULL default '',
# `src_domain` varchar(128) NOT NULL default '',
# INDEX acc_callid (`callid`),
# PRIMARY KEY (`id`)
# );
#
#
# ----------- global configuration parameters ------------------------
debug=3 # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=no # (cmd line: -E)
/* Uncomment these lines to enter debugging mode
fork=no
log_stderror=yes
*/
check_via=no # (cmd. line: -v)
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
port=5060
children=4
#
# uncomment the following lines for TLS support
#disable_tls = 0
#listen = tls:your_IP:5061
#tls_verify_server = 1
#tls_verify_client = 1
#tls_require_client_certificate = 0
#tls_method = TLSv1
#tls_certificate = "/usr/local/etc/kamailio/tls/user/user-cert.pem"
#tls_private_key = "/usr/local/etc/kamailio/tls/user/user-privkey.pem"
#tls_ca_list = "/usr/local/etc/kamailio/tls/user/user-calist.pem"
# ------------------ module loading ----------------------------------
# set module path
mpath="/usr/local/lib/kamailio/modules/"
# Uncomment this if you want to use SQL database
# - MySQL loaded for accounting as well
loadmodule "db_mysql.so"
loadmodule "sl.so"
loadmodule "tm.so"
loadmodule "rr.so"
loadmodule "maxfwd.so"
loadmodule "usrloc.so"
loadmodule "registrar.so"
loadmodule "textops.so"
loadmodule "acc.so"
loadmodule "mi_fifo.so"
# Uncomment this if you want digest authentication
# db_mysql.so must be loaded !
#loadmodule "auth.so"
#loadmodule "auth_db.so"
# ----------------- setting module-specific parameters ---------------
# -- mi_fifo params --
modparam("mi_fifo", "fifo_name", "/tmp/kamailio_fifo")
# -- usrloc params --
#modparam("usrloc", "db_mode", 0)
# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
modparam("usrloc", "db_mode", 2)
# -- auth params --
# Uncomment if you are using auth module
#
#modparam("auth_db", "calculate_ha1", yes)
#
# If you set "calculate_ha1" parameter to yes (which is true in this config),
# uncomment also the following parameter)
#
#modparam("auth_db", "password_column", "password")
# -- rr params --
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)
# -- acc params --
modparam("acc", "db_url", "mysql://kamailio:kamailiorw@localhost/kamailio")
# flag to record to db
modparam("acc", "db_flag", 1)
modparam("acc", "db_missed_flag", 2)
# flag to log to syslog
modparam("acc", "log_flag", 1)
modparam("acc", "log_missed_flag", 2)
# use extra accounting to record caller and callee username/domain
# - take them from From URI and R-URI
modparam("acc", "log_extra", "src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd")
modparam("acc", "db_extra", "src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd")
# ------------------------- request routing logic -------------------
# main routing logic
route{
# initial sanity checks -- messages with
# max_forwards==0, or excessively long requests
if (!mf_process_maxfwd_header("10")) {
sl_send_reply("483", "Too Many Hops");
exit;
};
if (msg:len >= 2048 ) {
sl_send_reply("513", "Message too big");
exit;
};
# we record-route all messages -- to make sure that
# subsequent messages will go through our proxy; that's
# particularly good if upstream and downstream entities
# use different transport protocol
if (!is_method("REGISTER"))
record_route();
# subsequent messages within a dialog should take the
# path determined by record-routing
if (loose_route()) {
# mark routing logic in request
append_hf("P-hint: rr-enforced\r\n");
if(is_method("BYE")) {
# account BYE for STOP record
setflag(1);
}
route(1);
};
# account all calls
if(is_method("INVITE")) {
# set accounting on for INVITE (success or missed call)
setflag(1);
setflag(2);
}
if (!uri==myself) {
# mark routing logic in request
append_hf("P-hint: outbound\r\n");
# if you have some interdomain connections via TLS
#if(uri=~"@tls_domain1.net") {
# t_relay("tls:domain1.net");
# exit;
#} else if(uri=~"@tls_domain2.net") {
# t_relay("tls:domain2.net");
# exit;
#}
route(1);
};
# if the request is for other domain use UsrLoc
# (in case, it does not work, use the following command
# with proper names and addresses in it)
if (uri==myself) {
if (is_method("REGISTER")) {
# Uncomment this if you want to use digest authentication
#if (!www_authorize("kamailio.org", "subscriber")) {
# www_challenge("kamailio.org", "0");
# exit;
#};
save("location");
exit;
};
if (!uri==myself) {
append_hf("P-hint: outbound alias\r\n");
route(1);
};
# native SIP destinations are handled using our USRLOC DB
if (!lookup("location")) {
sl_send_reply("404", "Not Found");
exit;
};
append_hf("P-hint: usrloc applied\r\n");
};
route(1);
}
route[1] {
# send it out now; use stateful forwarding as it works reliably
# even for UDP2TCP
if (!t_relay()) {
sl_reply_error();
};
exit;
}