TMG:Automatic Text CDR Retrieval - Revision history

Luc Morissette: Removed install section from this page - it is always included now

2024-06-13T19:16:20Z

Removed install section from this page - it is always included now

@@ Line 18: / Line 18: @@
 *Move all *.gz files and $TMG_TEMP_DIR/$LOG_FILE to this folder
 *Archive the folder in a gzipped tar file (cdr_2016_01_30_$hostname.tgz)
 = Configuration =

Anestis Mavrofillidis: /* Offline Install */

2024-03-18T10:24:33Z

Offline Install

← Older revision		Revision as of 06:24, 18 March 2024
Line 29:		Line 29:
	If you do not have direct access to the repository from the Tmedia, you can manually install the package on your Tmedia.<br><br>		If you do not have direct access to the repository from the Tmedia, you can manually install the package on your Tmedia.<br><br>
	1. Retrieve the ''tb_tools'' rpm package from the repository.		1. Retrieve the ''tb_tools'' rpm package from the repository.
	*CentOS 7: [http://repo.telcobridges.com/centos/7_dev/os/x86_64/Packages/tb_tools-1.2-32.el7.tb.noarch.rpm tb_tools-1.2-32.el7.tb.noarch.rpm]		*CentOS 7: [http://repo.telcobridges.com/centos/7_dev/os/x86_64/Packages/tb_tools-1.2-49.el7.tb.noarch.rpm tb_tools-1.2-49.el7.tb.noarch.rpm]
	*CentOS 5: [http://repo.telcobridges.com/centos/5_dev/os/x86_64/CentOS/tb_tools-1.2-32.el5.noarch.rpm tb_tools-1.2-32.el5.noarch.rpm]		*CentOS 5: [http://repo.telcobridges.com/centos/5_dev/os/x86_64/CentOS/tb_tools-1.2-32.el5.noarch.rpm tb_tools-1.2-32.el5.noarch.rpm]
	<br>		<br>
Line 35:		Line 35:
	2. Copy the rpm package to the Tmedia (using a sftp client) and install:		2. Copy the rpm package to the Tmedia (using a sftp client) and install:
	*CentOS 7:		*CentOS 7:
	yum --nogpgcheck localinstall tb_tools-1.2-32.el7.tb.noarch.rpm		yum --nogpgcheck localinstall tb_tools-1.2-49.el7.tb.noarch.rpm
	*CentOS 5:		*CentOS 5:
	yum --nogpgcheck localinstall tb_tools-1.2-32.el5.noarch.rpm		yum --nogpgcheck localinstall tb_tools-1.2-32.el5.noarch.rpm

Anestis Mavrofillidis: /* Installation with access to internet */

2024-03-18T10:23:56Z

Installation with access to internet

← Older revision		Revision as of 06:23, 18 March 2024
Line 21:		Line 21:
	= Install =		= Install =
	== Installation with access to internet ==		== Installation with access to internet ==
	The ''tbcopycdr'' and ''tbarchivecdr'' scripts are included in the ''tb_tools'' packages 1.2-32.el7 (CentOS7) and 1.2-32.el5 (CentOS5).		The ''tbcopycdr'' and ''tbarchivecdr'' scripts are included in the ''tb_tools'' packages 1.2-49.el7 (CentOS7) and 1.2-32.el5 (CentOS5).
	yum install tb_tools		yum install tb_tools
	yum list tb_tools		yum list tb_tools
	tb_tools.noarch '''1.2-32'''.el7.tb		tb_tools.noarch '''1.2-49'''.el7.tb

	== Offline Install ==		== Offline Install ==

Luc Morissette: Removed instructions for password less - they were outdated.

2021-09-20T22:12:10Z

Removed instructions for password less - they were outdated.

@@ Line 87: / Line 87: @@
 = Remote Server Copy =
-You must create an SSH key pair and copy it to the remote server, if the remote server copy is configured. This will enable Tmedia to copy the backup files to the remote host without asking for a password:
+You must create an SSH key pair and copy it to the remote server, if the remote server copy is configured. This will enable copy the backup files to the remote host without asking for a password. Follow the instructions here:
 * [[Password_less_ssh|Password-less SSH]]
 =Troubleshooting =

Allyntree: General Edit

2021-07-08T15:01:09Z

General Edit

← Older revision		Revision as of 11:01, 8 July 2021
Line 1:		Line 1:
	{{DISPLAYTITLE:Automatic Text CDR Retrieval}}		{{DISPLAYTITLE:Automatic Text CDR Retrieval}}

	This procedure ~~shows~~ how to configure a Tmedia and [[ProSBC]] to send its Call Detail Records (CDR) files to a remote server automatically and perform daily (or monthly) file archives.		This procedure describes how to configure a Tmedia and [[ProSBC]] to send its Call Detail Records (CDR) files to a remote server automatically and perform daily (or monthly) file archives.

	= Overview =		= Overview =
	The ''tbcopycdr'' script ~~support~~ the following features:		The ''tbcopycdr'' script supports the following features:
	*Move cdr files from TMG_CDR_DIR to TMG_TEMP_DIR		*Move cdr files from TMG_CDR_DIR to TMG_TEMP_DIR
	*Send files to remote server		*Send files to a remote server
	*Move sucessfully sent files (rename to .sent.gz) from TMG_TEMP_DIR to TMG_ARCHIVE_DIR (ARCHIVE=true)		*Move sucessfully sent files (rename to .sent.gz) from TMG_TEMP_DIR to TMG_ARCHIVE_DIR (ARCHIVE=true)
	*Rename sucessfully sent files (.sent.gz) in TMG_TEMP_DIR (ARCHIVE=false; ERASE_AFTER_SEND=false)		*Rename sucessfully sent files (.sent.gz) in TMG_TEMP_DIR (ARCHIVE=false; ERASE_AFTER_SEND=false)
Line 12:		Line 12:
	*If a file failed to be sent to remote server, it is kept in TMG_TEMP_DIR until it is successfully sent		*If a file failed to be sent to remote server, it is kept in TMG_TEMP_DIR until it is successfully sent
	<br>		<br>
	The ''tbarchivecdr'' script ~~create~~ a gzip tar archive with all gz files copied by ''tbcopycdr'' in TMG_ARCHIVE_DIR		The ''tbarchivecdr'' script creates a gzip tar archive with all gz files copied by ''tbcopycdr'' in TMG_ARCHIVE_DIR
	*Change directory to TMG_ARCHIVE_DIR		*Change directory to TMG_ARCHIVE_DIR
	*Create a temporary folder with the current date (~~ie.~~ 2016-01-30)		*Create a temporary folder with the current date (for example: 2016-01-30)
	*Sleep for 90 second		*Sleep for 90 second
	Move all .gz files and $TMG_TEMP_DIR/$LOG_FILE to this folder		Move all .gz files and $TMG_TEMP_DIR/$LOG_FILE to this folder
Line 27:		Line 27:

	== Offline Install ==		== Offline Install ==
	If you ~~don't~~ have direct access to the repository from the Tmedia, you can manually install the package on your Tmedia.<br><br>		If you do not have direct access to the repository from the Tmedia, you can manually install the package on your Tmedia.<br><br>
	1. ~~Get~~ the ''tb_tools'' rpm package from the repository.		1. Retrieve the ''tb_tools'' rpm package from the repository.
	*CentOS 7: [http://repo.telcobridges.com/centos/7_dev/os/x86_64/Packages/tb_tools-1.2-32.el7.tb.noarch.rpm tb_tools-1.2-32.el7.tb.noarch.rpm]		*CentOS 7: [http://repo.telcobridges.com/centos/7_dev/os/x86_64/Packages/tb_tools-1.2-32.el7.tb.noarch.rpm tb_tools-1.2-32.el7.tb.noarch.rpm]
	*CentOS 5: [http://repo.telcobridges.com/centos/5_dev/os/x86_64/CentOS/tb_tools-1.2-32.el5.noarch.rpm tb_tools-1.2-32.el5.noarch.rpm]		*CentOS 5: [http://repo.telcobridges.com/centos/5_dev/os/x86_64/CentOS/tb_tools-1.2-32.el5.noarch.rpm tb_tools-1.2-32.el5.noarch.rpm]
Line 73:		Line 73:
	CONNECT_TIMEOUT=10		CONNECT_TIMEOUT=10

	*''ARCHIVE'': true or false. If set to true, move ~~sucessfully~~ sent files (rename to .sent.gz) from TMG_TEMP_DIR to TMG_ARCHIVE_DIR. Default is false.		*''ARCHIVE'': true or false. If set to true, move successfully sent files (rename to .sent.gz) from TMG_TEMP_DIR to TMG_ARCHIVE_DIR. Default is false.
	ARCHIVE=false		ARCHIVE=false
	*''TMG_ARCHIVE_DIR'': Directory where the cdrs are moved if ARCHIVE=true		*''TMG_ARCHIVE_DIR'': Directory where the cdrs are moved if ARCHIVE=true
	TMG_ARCHIVE_DIR=/lib/tb/toolpack/setup/12358/cdr_archive		TMG_ARCHIVE_DIR=/lib/tb/toolpack/setup/12358/cdr_archive
	*''ARCHIVE_MAX_DAYS'': Define how many days archive file (.tgz) should be kept in TMG_ARCHIVE_DIR. This user variable is used by ''tbarchivecdr'' only.		*''ARCHIVE_MAX_DAYS'': Define how many days the archive file (.tgz) should be kept in TMG_ARCHIVE_DIR. This user variable is used by ''tbarchivecdr'' only.
	# Assign no value to disable		# Assign no value to disable
	ARCHIVE_MAX_DAYS=		ARCHIVE_MAX_DAYS=
Line 84:		Line 84:
	ERASE_AFTER_SEND=false		ERASE_AFTER_SEND=false

	Note: if you set ERASE_AFTER_SEND to false the CDR text file will be available in the /home/telcobridges/cdr/ directory and ~~rename~~ *.gz.already_send.		Note: If you set ERASE_AFTER_SEND to false, the CDR text file will be available in the /home/telcobridges/cdr/ directory and renamed *.gz.already_send.

	= Remote Server Copy =		= Remote Server Copy =
	You must create an SSH key pair and copy it to the remote server, if the remote server copy is configured. This will enable ~~the~~ Tmedia to copy the backup files to the remote host without asking for a password:		You must create an SSH key pair and copy it to the remote server, if the remote server copy is configured. This will enable Tmedia to copy the backup files to the remote host without asking for a password:

	*Connect to ~~the~~ Tmedia using SSH as root		*Connect to Tmedia using SSH as root

	*Create Tmedia public/private dsa key pair		*Create Tmedia public/private dsa key pair
	ssh-keygen -t rsa		ssh-keygen -t rsa
	Note: Do not add a pass phrase~~, simply~~ press enter until the key pair is ~~generate~~.		Note: Do not add a pass phrase. Simply press enter until the key pair is generated.
	*Append the ~~content~~ of the public key to the remote host authorized keys		*Append the contents of the public key to the remote host authorized keys

	Tmedia public key location		Tmedia public key location
Line 110:		Line 110:
	tbcopycdr -v		tbcopycdr -v

	If no ~~error were~~ seen on the shell, your configuration is correct. ~~Also~~, you should have a hello_world.log file on the remote host.		If no errors are seen in the shell, your configuration is correct. In addition, you should have a hello_world.log file on the remote host.

	== Log File ==		== Log File ==
Line 119:		Line 119:
	*Create a new crontab on the [[Tmedia]]		*Create a new crontab on the [[Tmedia]]
	crontab -e		crontab -e
	*Add new ~~line~~ with the cron configuration		*Add new lines with the cron configuration

	'''''tbcopycdr''''':		'''''tbcopycdr''''':

Luc Morissette: Added title

2021-07-02T13:44:47Z

Added title

← Older revision		Revision as of 09:44, 2 July 2021
Line 1:		Line 1:
	This procedure shows how to configure a Tmedia and [[ProSBC]] to send its CDR files to a remote server automatically and perform daily (or monthly) file archives.		{{DISPLAYTITLE:Automatic Text CDR Retrieval}}

			This procedure shows how to configure a Tmedia and [[ProSBC]] to send its Call Detail Records (CDR) files to a remote server automatically and perform daily (or monthly) file archives.

	= Overview =		= Overview =

Luc Morissette: Updated for ProSBC

2021-07-02T13:43:04Z

Updated for ProSBC

← Older revision		Revision as of 09:43, 2 July 2021
Line 1:		Line 1:
	This procedure shows how to configure a Tmedia to send its CDR files to a remote server automatically and perform daily (or monthly) file archives.		This procedure shows how to configure a Tmedia and [[ProSBC]] to send its CDR files to a remote server automatically and perform daily (or monthly) file archives.

	= Overview =		= Overview =

Luc Morissette at 18:30, 26 August 2020

2020-08-26T18:30:07Z

← Older revision		Revision as of 14:30, 26 August 2020
Line 119:		Line 119:
	*Add new line with the cron configuration		*Add new line with the cron configuration

	'''''~~tbcopcdr~~''''':		'''''tbcopycdr''''':
	{\| cellpadding="5" border="1" class="wikitable"		{\| cellpadding="5" border="1" class="wikitable"
	\|-		\|-

Luc Morissette at 20:31, 29 March 2018

2018-03-29T20:31:27Z

← Older revision		Revision as of 16:31, 29 March 2018
Line 18:		Line 18:

	= Install =		= Install =
			== Installation with access to internet ==
	The ''tbcopycdr'' and ''tbarchivecdr'' scripts are included in the ''tb_tools'' packages 1.2-32.el7 (CentOS7) and 1.2-32.el5 (CentOS5).		The ''tbcopycdr'' and ''tbarchivecdr'' scripts are included in the ''tb_tools'' packages 1.2-32.el7 (CentOS7) and 1.2-32.el5 (CentOS5).
	yum install tb_tools		yum install tb_tools
Line 23:		Line 24:
	tb_tools.noarch '''1.2-32'''.el7.tb		tb_tools.noarch '''1.2-32'''.el7.tb

			== Offline Install ==
	If you don't have direct access to the repository from the Tmedia, you can manually install the package on your Tmedia.<br><br>		If you don't have direct access to the repository from the Tmedia, you can manually install the package on your Tmedia.<br><br>
	1. Get the ''tb_tools'' rpm package from the repository.		1. Get the ''tb_tools'' rpm package from the repository.

Lucas Trottier at 20:37, 23 January 2017

2017-01-23T20:37:24Z

← Older revision		Revision as of 16:37, 23 January 2017
Line 18:		Line 18:

	= Install =		= Install =
	~~== From repository ==~~		The ''tbcopycdr'' and ''tbarchivecdr'' scripts are included in the ''tb_tools'' packages 1.2-32.el7 (CentOS7) and 1.2-32.el5 (CentOS5).
	The ''tbcopycdr' and ''tbarchivecdr'' ~~scripst is~~ included in the ''tb_tools'' packages 1.2-32.el7 (CentOS7) and 1.2-32.el5 (CentOS5).		yum install tb_tools
	#yum install tb_tools		yum list tb_tools
	#yum list tb_tools		tb_tools.noarch '''1.2-32'''.el7.tb
	tb_tools.noarch '''1.2-32'''.el7.tb

	~~== Manually ==~~		If you don't have direct access to the repository from the Tmedia, you can manually install the package on your Tmedia.<br><br>
	If you don't have access to the repository from the Tmedia ~~or the tb_tools package not yet updated on TB repository~~, you can ~~manual~~ install the ~~script~~.<br>		1. Get the ''tb_tools'' rpm package from the repository.
	1. Get the ~~script here~~: [[~~Media~~:~~tbcopycdr~~.~~gz\|tbcopycdr~~.~~gz [click to download]]~~]		*CentOS 7: [http://repo.telcobridges.com/centos/7_dev/os/x86_64/Packages/tb_tools-1.2-32.el7.tb.noarch.rpm tb_tools-1.2-32.el7.tb.noarch.rpm]
			*CentOS 5: [http://repo.telcobridges.com/centos/5_dev/os/x86_64/CentOS/tb_tools-1.2-32.el5.noarch.rpm tb_tools-1.2-32.el5.noarch.rpm]
			<br>

	2. Copy the ~~scrips~~ to Tmedia (using a sftp client)		2. Copy the rpm package to the Tmedia (using a sftp client) and install:
	~~gunzip tbcopycdr~~.gz		*CentOS 7:
	~~tar xf tbcopycdr~~.~~tar~~		yum --nogpgcheck localinstall tb_tools-1.2-32.el7.tb.noarch.rpm
	~~cp tbcopycdr/tbcopycdr /usr/bin/~~.		*CentOS 5:
	~~cp tbcopycdr/tbarchivecdr /usr/bin/~~.		yum --nogpgcheck localinstall tb_tools-1.2-32.el5.noarch.rpm
	~~chmod +x /usr/bin/tbcopycdr /usr/bin/tbarchivecdr~~
	rm -~~fr tbcopycdr~~

	= Configuration =		= Configuration =