ProSBC:FreeRadius configuration for Accounting - Revision history

Serdar Civici: /* Store Telcobridges CDR Attributes in the FreeRadius Database */

2021-10-18T07:29:36Z

Store Telcobridges CDR Attributes in the FreeRadius Database

← Older revision		Revision as of 03:29, 18 October 2021
Line 71:		Line 71:
	* update the MySQL db with a new schema. run the following command and restart the FreeRadius		* update the MySQL db with a new schema. run the following command and restart the FreeRadius

	<pre> ~~mySQL~~ -u username -ppassword -dbname < schema.sql </pre>		<pre> mysql -u username -ppassword -dbname < schema.sql </pre>
	* Under the '''/etc/raddb/mods-config/sql/main/mysql''', update the '''queries.sql''' to match attribute and new added column in the '''schema.sql'''. In the column_list add '''tbremotesipip''', column_list will become;		* Under the '''/etc/raddb/mods-config/sql/main/mysql''', update the '''queries.sql''' to match attribute and new added column in the '''schema.sql'''. In the column_list add '''tbremotesipip''', column_list will become;
	<pre> column_list = "\		<pre> column_list = "\

Serdar Civici: /* Store Telcobridges CDR Attributes in the FreeRadius Database */

2021-10-18T07:29:18Z

Store Telcobridges CDR Attributes in the FreeRadius Database

← Older revision		Revision as of 03:29, 18 October 2021
Line 69:		Line 69:
	framedipaddress varchar(15) NOT NULL default '',		framedipaddress varchar(15) NOT NULL default '',
	tbremotesipip varchar(15) NOT NULL default '', </pre>		tbremotesipip varchar(15) NOT NULL default '', </pre>
			* update the MySQL db with a new schema. run the following command and restart the FreeRadius

			<pre> mySQL -u username -ppassword -dbname < schema.sql </pre>
	* Under the '''/etc/raddb/mods-config/sql/main/mysql''', update the '''queries.sql''' to match attribute and new added column in the '''schema.sql'''. In the column_list add '''tbremotesipip''', column_list will become;		* Under the '''/etc/raddb/mods-config/sql/main/mysql''', update the '''queries.sql''' to match attribute and new added column in the '''schema.sql'''. In the column_list add '''tbremotesipip''', column_list will become;
	<pre> column_list = "\		<pre> column_list = "\

Serdar Civici: /* FreeRadius Configuration */

2021-09-29T07:41:58Z

FreeRadius Configuration

← Older revision		Revision as of 03:41, 29 September 2021
Line 37:		Line 37:
	$INCLUDE dictionary.telcobridges		$INCLUDE dictionary.telcobridges
	* Restart the FreeRadius		* Restart the FreeRadius
	* Make a test call and check the folder /var/log/radius/radacct to see if new logs are created.		* Make a test call and check the folder '''/var/log/radius/radacct''' to see if new logs are created.

	===Store Telcobridges CDR Attributes in the FreeRadius Database===		===Store Telcobridges CDR Attributes in the FreeRadius Database===
	* Modify the SQL files to store Telcob attributes in MySQL. In this example, we will be going to add a Remote SIP IP address to the MySQL from Telcob-RemoteSipIP attribute		* Modify the SQL files to store Telcob attributes in MySQL. In this example, we will be going to add a Remote SIP IP address to the MySQL from the Telcob-RemoteSipIP attribute
	* To create a new column in the radacct table we need to update the '''schema.sql''' file which is under the folder '''/etc/raddb/mods-config/sql/main/mysql'''. In this example we are adding tbremotesipip in the CREATE Table radacct		* To create a new column in the radacct table we need to update the '''schema.sql''' file which is under the folder '''/etc/raddb/mods-config/sql/main/mysql'''. In this example we are adding tbremotesipip in the CREATE Table radacct
	<pre> CREATE TABLE radacct (		<pre> CREATE TABLE radacct (

Serdar Civici: /* FreeRadius Configuration */

2021-09-29T07:41:20Z

FreeRadius Configuration

← Older revision		Revision as of 03:41, 29 September 2021
Line 33:		Line 33:
	}		}

	* Copy dictionary.telcobridges file to the /usr/share/freeradius directory. dictionary.telcobridges file located in the /usr/lib/tb/toolpack/pkg/3.1.124.1/web/radius_dictionary/. The file name is dictionary.vendor, after copying to the FreeRadius change this name to dictionary.telcobridges. '''3.1.124.1''' is the active package of the ProSBC.		* Copy dictionary.telcobridges file to the '''/usr/share/freeradius''' directory. dictionary.telcobridges file located in the '''/usr/lib/tb/toolpack/pkg/3.1.124.1/web/radius_dictionary/'''. The file name is dictionary.vendor, after copying to the FreeRadius change this name to dictionary.telcobridges. '''3.1.124.1''' is the active package of the ProSBC.
	* Add the following line to the dictionary file. If not exist you can create it;		* Add the following line to the dictionary file. If not exist you can create it;
	$INCLUDE dictionary.telcobridges		$INCLUDE dictionary.telcobridges

Serdar Civici: /* FreeRadius Configuration */

2021-09-29T07:40:50Z

FreeRadius Configuration

← Older revision		Revision as of 03:40, 29 September 2021
Line 25:		Line 25:
	}		}
	**'''secret = ''' Need to be same as configured in the Telcobridges Radius configuration		**'''secret = ''' Need to be same as configured in the Telcobridges Radius configuration

	Example;		Example;

Line 31:		Line 32:
	shortname = LabSystem		shortname = LabSystem
	}		}


	* Copy dictionary.telcobridges file to the /usr/share/freeradius directory. dictionary.telcobridges file located in the /usr/lib/tb/toolpack/pkg/3.1.124.1/web/radius_dictionary/. The file name is dictionary.vendor, after copying to the FreeRadius change this name to dictionary.telcobridges. '''3.1.124.1''' is the active package of the ProSBC.		* Copy dictionary.telcobridges file to the /usr/share/freeradius directory. dictionary.telcobridges file located in the /usr/lib/tb/toolpack/pkg/3.1.124.1/web/radius_dictionary/. The file name is dictionary.vendor, after copying to the FreeRadius change this name to dictionary.telcobridges. '''3.1.124.1''' is the active package of the ProSBC.

Serdar Civici: /* FreeRadius Configuration */

2021-09-29T07:40:39Z

FreeRadius Configuration

← Older revision		Revision as of 03:40, 29 September 2021
Line 24:		Line 24:
	shortname = shortname of the device		shortname = shortname of the device
	}		}
			**'''secret = ''' Need to be same as configured in the Telcobridges Radius configuration
	Example;		Example;

Line 31:		Line 32:
	}		}

	**'''secret = ''' Need to be same as configured in the Telcobridges Radius configuration
	* Copy dictionary.telcobridges file to the /usr/share/freeradius directory. dictionary.telcobridges file located in the /usr/lib/tb/toolpack/pkg/3.1.124.1/web/radius_dictionary/. The file name is dictionary.vendor, after copying to the FreeRadius change this name to dictionary.telcobridges. '''3.1.124.1''' is the active package of the ProSBC.		* Copy dictionary.telcobridges file to the /usr/share/freeradius directory. dictionary.telcobridges file located in the /usr/lib/tb/toolpack/pkg/3.1.124.1/web/radius_dictionary/. The file name is dictionary.vendor, after copying to the FreeRadius change this name to dictionary.telcobridges. '''3.1.124.1''' is the active package of the ProSBC.
	* Add the following line to the dictionary file. If not exist you can create it;		* Add the following line to the dictionary file. If not exist you can create it;

Serdar Civici: /* FreeRadius Configuration */

2021-09-29T07:40:16Z

FreeRadius Configuration

← Older revision		Revision as of 03:40, 29 September 2021
Line 26:		Line 26:
	Example;		Example;

	client 192.168.1.10 {		client 192.168.1.10 {
	secret = Test123		secret = Test123
	shortname = LabSystem		shortname = LabSystem

Serdar Civici: /* FreeRadius Configuration */

2021-09-29T07:40:02Z

FreeRadius Configuration

← Older revision		Revision as of 03:40, 29 September 2021
Line 20:		Line 20:

	* Add access for each Telcobridges device editing the clients.conf file located in the /etc/raddb directory.		* Add access for each Telcobridges device editing the clients.conf file located in the /etc/raddb directory.
	client IPAddressof ~~theTB~~ {		client IPAddressof the Telcobridges {
	secret = server_secret		secret = server_secret
	shortname = shortname of the device		shortname = shortname of the device
	}		}
			Example;

			client 192.168.1.10 {
			secret = Test123
			shortname = LabSystem
			}

	**'''secret = ''' Need to be same as configured in the Telcobridges Radius configuration		**'''secret = ''' Need to be same as configured in the Telcobridges Radius configuration
	* Copy dictionary.telcobridges file to the /usr/share/freeradius directory. dictionary.telcobridges file located in the /usr/lib/tb/toolpack/pkg/3.1.124.1/web/radius_dictionary/. The file name is dictionary.vendor, after copying to the FreeRadius change this name to dictionary.telcobridges. '''3.1.124.1''' is the active package of the ProSBC.		* Copy dictionary.telcobridges file to the /usr/share/freeradius directory. dictionary.telcobridges file located in the /usr/lib/tb/toolpack/pkg/3.1.124.1/web/radius_dictionary/. The file name is dictionary.vendor, after copying to the FreeRadius change this name to dictionary.telcobridges. '''3.1.124.1''' is the active package of the ProSBC.

Serdar Civici: /* Prerequisites */

2021-09-29T07:38:55Z

Prerequisites

← Older revision		Revision as of 03:38, 29 September 2021
Line 8:		Line 8:
	=Prerequisites=		=Prerequisites=
	*[[ProSBC\|ProSBC]] devices must be installed as described in their respective with release 3.0.x/3.1.x. [[Product_Installation_SBC\|installation guides]].		*[[ProSBC\|ProSBC]] devices must be installed as described in their respective with release 3.0.x/3.1.x. [[Product_Installation_SBC\|installation guides]].
	*FreeRadius. For additional information on FreeRadius, visit [https://freeradius.org/ FreeRadius official web site].		*FreeRadius. Must be installed. For additional information on FreeRadius, visit [https://freeradius.org/ FreeRadius official web site].

	= Configuration Steps =		= Configuration Steps =

Serdar Civici at 07:37, 29 September 2021

2021-09-29T07:37:14Z

← Older revision		Revision as of 03:37, 29 September 2021
Line 74:		Line 74:
	<pre>'%{Telcob-RemoteSipIP}'</pre>		<pre>'%{Telcob-RemoteSipIP}'</pre>

	For example, the start will become like following;		For example, the start will become like the following;

	<pre>		<pre>
Line 109:		Line 109:
	'%{Telcob-RemoteSipIP}')"		'%{Telcob-RemoteSipIP}')"
	</pre>		</pre>

			You can download the schema.sql and queries.sql files modified for all Telcobridges attributes from the following links;

			[[Media:queries.zip\|MySQL queries.conf file edited for Telcobridges attributes]] <br>
			[[Media:schema.zip‎\|MySQL schema.sql file edited for Telcobridges attributes]]