Installation and configuration of the data collection server for Cisco SCE CM

The RDRs (raw data records) generated from the data analyzed by SCE are sent to external devices. The external device can be CM or a third-party collection software. Here we will introduce CM, which supports multiple SCEs for RDRs collection and processing in the adapter (CM Adapters.
CM contains four built-in adapters
1 database adapter
Accept records, process them, and store them in internal databases, such as compatible databases such as sybase and mysql.
2 JDBC adapter
The same database adapter is designed specifically for java databases.
3 comma-separated value adapter
The comma-separated value adapter is used to write RDRs to a file and generate a CSV file.
4 topper/aggregator adapter
The upper-layer aggregation adapter integrates all data from subscribers and provides it to reporter.
In actual use, the adapter number 1-3 may be used.
CM system installation
Strict requirements on the parent operating system. The recommended operating system for cisco is RHEL3 or RHEL4. Here we use Redhat linux AS3 U8, and the minimum operating system is used for the OS. Mysql version can be 4.1.22.
After installing mysql, you need to create a traffic database
# Mysqladmin-u root-p create cot)
Then, you can view one more database under data.
[Root @ localhost data] # ls
Cot
Create a user and grant all database access permissions to the user
The username and password are pqb_admin and pqb_admin. This is the default user name and secret word used for accessing the default database on the BB console. Do not use other names unless you change the configuration of the BBConsole user.
[Root @ localhost data] #/usr/local/mysql/bin/mysql-u root-p
Enter password:
Welcome to the MySQL monitor. Commands end with; or \ g.
Your MySQL connection id is 2 to server version: 4.1.22-standard-log
Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.
Mysql> grant all privileges on your cot. * TO 'pdb _ admin' @ 'localhost' identified by 'pdb _ admin ';
Query OK, 0 rows affected (0.04 sec)
Mysql> grant all privileges on your cot. * TO 'pdb _ admin' @ '%' identified by 'pdb _ admin ';
Query OK, 0 rows affected (0.00 sec)
Mysql>
CM software decompression and Detection
Ftp the five required CM parts to the installation directory:
Scms_cm_bundle_linux_v1__tar.part1
Scms_cm_bundle_linux_v1__tar.part2
Scms_cm_bundle_linux_v1__tar.part3
Scms_cm_bundle_linux_v1__tar.part4
Scms_cm_bundle_linux_v1__tar.part5
Run the following command:
# Cd/usr/tools
# Cat bundle_linux_v1__tar.part3 scms_cm_bundle_linux_v1__tar.part4 scms_cm_bundle_linux_v1__tar.part5> scms_cm_bundle_linux_v1_.tar
A compressed file scms_cm_bundle_linux_v1_.tar will be generated to decompress it to #/usr/local/
Run install-scripts/check_prerequisites.sh to check whether the system meets sybase and cm installation conditions.
[Root @ localhost local] # cd install-scripts/
[Root @ localhost install-scripts] #./check_prerequisites.sh -- cmhome =/usr/local -- datadir =/opt
There will be a series of detection results, including basic system information.
Install CM
[Root @ localhost install-scripts] #./install-cm.sh-d/usr/local/cm
Skip
Creating sym link...
... Done
Done
... Done
Making symlinks in/etc/init. d and rc *. d...
Done
Done installation.
NOTE: The user name created for SCMS-CM is scmscm. You may want to set a password for this account now.
According to the above prompt, we need to change the password of the user scmscm:
Set the password of scmscm
[Root @ localhost bin] #/usr/bin/passwd scmscm
Changing password for user scmscm.
New UNIX password:
Bad password: it does not contain enough DIFFERENT characters
Retype new UNIX password:
Passwd: all authentication tokens updated successfully.
[Root @ localhost bin] #
Restart the server.
Configure the adapters of CM
After installing CM, go ~ Find the configuration files jdbcadapter. conf and taadapter. conf in the/cm/config directory, find the section about the database description, comment out the Sybase section, and then remove the comments in the mysql section. Jdbcadapter. conf and taadapter. conf are modified in the same way as follows:
[Db]
Db_template_dir = dbpacks/sybase/ase12.5.1 (use # To comment out the next row)
# Db_template_dir = dbpacks/oracle/9204e
# Db_template_dir = dbpacks/mysql/4.0.20 (remove the previous #)
Db_template_file = main. vm
Modify the maximum TAAdapter value:
# Cd/usr/local/cm/config/
# Vi cm. conf
Components:
# Comment-out the "adapter.1" line if you won't be updating a DB
Adapter.1 = com. cisco. scmscm. adapters. jdbc. JDBCAdapter
Adapter.2 = com. cisco. scmscm. adapters. CSVAdapter
Adapter.3 = com. cisco. scmscm. adapters. topper. TAAdapter
// Three adapters are used here.
# Uncomment the lines for RAG and/or HTTPC adapters as necessary:
# Adapter.4 = com. cisco. scmscm. adapters. rag. RAGAdapter
# Adapter.5 = com. cisco. scmscm. adapters. httpc. HTTPCAdapter
[Adapter_mem]
Com. cisco. scmscm. adapters. topper. TAAdapter =-Xmx1024M * changed from 512M to 1024 M
Com. cisco. scmscm. adapters. rag. RAGAdapter =-Xmx512M
Check the driver from MySQL to java
Location:
[Root @ localhost 4.0.20] # pwd
/Usr/local/cm/config/dbpacks/mysql/4.0.20
[Root @ localhost 4.0.20] # vi dbinfo. vm
# Set ($ dbinfo. driver = "com. mysql. jdbc. Driver ")
# Set ($ dbinfo. driverjarfile = "mysql-connector-java-5.0.3-bin.jar") # searched for in the same directory as the VM files, if there is the above line, it means OK.
# Set ($ dbinfo. options. host = "localhost ")
# Set ($ dbinfo. options. port = "3306 ")
# Set ($ dbinfo. options. user = "pqb_admin ")
# Set ($ dbinfo. options. password = "pqb_admin ")
# Set ($ dbinfo. options. sid = "cot ")
The user, password, port, and other information of the database and database operations can also be seen.
Modify Timezone-Note: root user operations are not allowed
If you use the root user, an error is reported. This command cannot be executed under the root user. Therefore, you can use scmscm to log on to the system. Run the following command
Cd/usr/local/cm/bin
-Bash-2.05b $./jselect-sce-tz.sh -- offset = 480
TIME_STAMP | OFFSET_MIN |
------------------------ +
09:01:46. 0 | 480 |
Add a Database User:
[Root @ localhost bin] # pwd
/Usr/local/cm/bin
-Bash-2.05b $./p3rpc -- set-user -- username = scm12345 -- password = pqb12345
Command terminated successfully
A user scm12345 whose password is pqb12345 will be created to operate CM from the bbconsole.
Install a mysql-based CM and restart CM.