#
# Sample config for MySQL accouting with OpenSIPS 
#
# - db_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 ------------------------

log_level=3            # debug level (cmd line: -dddddddddd)
log_stderror=no    # (cmd line: -E)

/* Uncomment these lines to enter debugging mode */
#debug_mode=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/opensips/tls/user/user-cert.pem"
#tls_private_key = "/usr/local/etc/opensips/tls/user/user-privkey.pem"
#tls_ca_list = "/usr/local/etc/opensips/tls/user/user-calist.pem"

# ------------------ module loading ----------------------------------

# set module path
mpath="/usr/local/lib/opensips/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/opensips_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 true in this config), 
# uncomment also the following parameter)
#
#modparam("auth_db", "password_column", "password")

# -- acc params --
modparam("acc", "db_url", "mysql://opensips:opensipsrw@localhost/opensips")
# 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;
	};

	# subsequent messages withing 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);
	};

	# 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();

	# account all calls
	if(is_method("INVITE")) {
		# set accounting on for INVITE (success or missed call)
		setflag(1);
		setflag(2);
	}

	if (!is_myself("$rd")) {
		# mark routing logic in request
		append_hf("P-hint: outbound\r\n"); 
		# if you have some interdomain connections via TLS
		#if($ru=~"@tls_domain1.net") {
		#	t_relay("tls:domain1.net");
		#	exit;
		#} else if($ru=~"@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 (is_myself("$rd")) {

		if (is_method("REGISTER")) {

			# Uncomment this if you want to use digest authentication
			#if (!www_authorize("opensips.org", "subscriber")) {
			#	www_challenge("opensips.org", "0");
			#	exit;
			#};

			save("location");
			exit;
		};

		if (!is_myself("$rd")) {
			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;
}