Administrative Scripts

• start: Starts the specified process or all processes.
• stop: Stops the specified process or all processes.
• restart: Restarts the specified process or all processes.
• forcestop: Forcefully stops the specified process or all processes.
• status: Checks current status of the specified process or all processes.

If a process name is not mentioned along with the action, then the respective action is taken for all processes related to policy provisioning application.

The script prompts the user to enter a password. This password is stored in the database. The sample output is shown below:

Please enter the password
for superuser.

password:new_password

Password for superuser
changed successfully.

If an existing password is specified, when prompted to enter the new superuser password, following messages are displayed:

Password update for
superuser failed.

New password cannot
be same as old password.

To restore the database no other parameters except restore are required.

Backup and restore operations for the PPT application:

• Can be performed on the same version of PPT application, i.e., if backup is generated from the version x.y of PPT application then it can be restored on version x.y only.
• Are permitted across the platform , i.e. backup can be generated from the application on Solaris platform and this backup can be restored on the Linux platform and vice versa.
• Upon execution this script generates complete backup, incremental backup feature is not enabled for this version of PPT application.

Trap Name and Probable Cause	Solution
starPPTDBBackupDestinationNotAccessible: Backup directory is not accessible or PPT administrator does not have enough permissions to access it.	Provide complete path of backup directory,
starPPTDBBackupNotEnoughDiskSpace: The disk on which backup is to be taken is full.	Ensure that enough space is available on the disk where backup is being generated.

For example, to generate backup of the database, execute the following command:

./backupAndRestore.sh
backup backup_dir_path.

During PPT installation a cron entry for backup script is added.Default backup time interval is configured as 1 day. This time interval can be modified using the script: <ppt-install-dir>/scripts/updateBackupInterval.sh. By default, backup is generated at midnight each day. If backup interval is modified by user, then backup operation will be performed at following time intervals:

• hourly - start of the hour
• daily - at midnight
• weekly - at midnight on the weekday configured by user
• monthly- at midnight on 1st day of month

The script prompts user to specify backup interval. The valid options include: 1 - hourly, 2 - daily, 3 - weekly, and 4 - monthly. If weekly option is selected then, the script prompts for the day of week on which to generate the backup. In such case the valid options are: 0 - Sun, 1 - Mon, 2 - Tue, 3 - Wed, 4 - Thu, 5 - Fri, and 6 - Sat. Depending on the user input, backup interval in cron entry for PPT backup is modified. The sample output is shown below:

=======================================

Please select any one
of the following

options for backup
interval

1 - hourly

2 - daily

3 - weekly

4 - monthly

=======================================

Enter your option and
press [ENTER]:3

[0]Sun, [1]Mon, [2]Tue, [3]Wed, [4]Thu, [5]Fri, [6]Sat

Enter the weekday and
press [ENTER]:1

Cron updated successfully.
Crontab contents are as follows

0,5,10,15,20,25,30,35,40,45,50,55 * * * * sh /root/users/ppt//cronjobs/sessCleanup.sh

0 0 * * 1
 /root/users/ppt//scripts/backupAndRestore.sh backup /root/users/ppt/backup_dir

Sample output, generated without any option is given below:

Number of days prior
to which data is to be deleted is not specified.

Using default value:
30 days.

Do you want to change
the number of days? (yes/no):yes

Number of days:5

30 records deleted
from database, which were older than 5 days.

Data purged by executing this script will not be recovered.

It asks for confirmation. If you wish to continue then, enter ‘yes’. Script performs vacuum operation on the database and displays success or failure message. The sample output is shown below:

Vacuuming will be done
for database.

Proceed (yes/no):yes

Password:postgres_password

Vacuum was done successfully.

When prompted for the password, if you enter an incorrect password to access Postgres database, then following message is displayed:

Vacuum operation failed:
vacuumdb: could not connect to database pptdb: FATAL: password authentication
failed for user "pptadmin".

Maximum of five SNMP targets can be configured.

The sample output of this script is shown below:

The list of SNMP targets
configured is as follows. Maximum of 5 targets can be configured.

===================================================

IP address - Port number
- SNMP version - Community

 ===================================================

 127.0.0.1 -     162          -
1 -        public

Select option to Add/Delete
SNMP target (Add/Delete/Exit):Add

Please enter SNMP target
details

IP address:1.2.3.4

Port: 667

SNMP version (1 / 2c):2c

Community: test

SNMP target added successfully

The list of SNMP targets
configured is as follows. Maximum of 5 targets can be configured.

===================================================

IP address - Port number
- SNMP version - Community

 ===================================================

 127.0.0.1 -     162          -
1 -        public

 1.2.3.4 -       667          -
2c -       test

Select option to Add/Delete
SNMP target (Add/Delete/Exit): Exit

While reporting any issue with PPT application, attach this gzip along with the problem report (PR).

Level 1 debug includes following information:

• Recent log files
• Current status of the product indicating whether it is in active or hanged state.
• Current Config files of the product
• Installation logs
• Database logs, if available
• Web server logs, if available
• Operating system information. For Solaris, it collects the OS version and patch information and for Linux, only OS version is captured
• Crontab entries
• Output of following commands, depending upon the configuration:
  • netstat -an
  • ifconfig -a
  • df -k
  • ipcs
  • ps -eaf
  • env
  • "prstat 1 1" (SunOS) / "top -d 1 -n 1 -b" (Linux)
  • "cat /etc/release" (SunOS) / "cat /etc/redhat-release" (Linux)
  • /opt/VRTSvcs/bin/hares -state
  • /opt/VRTSvcs/bin/hagrp -state

Specifies the XML file to be used to collect the log information. Default xml file is getSupportDetails.xml located in same directory as the script. This XML file allows the user to configure the gzip file name and directory where gzip file is to be stored.

CAUTION:

To execute this script for level 2 debugging with XML file name testXML, execute the following command:

./getSupportDetails.pl --level=2 --xmlfile=/tmp/testXML.xml

To terminate session associated with specific user:

• Log in with administrative privileges.
• Execute the script with u option and name of the user whose session you want to terminate.
• The script displays session details for this user and asks for confirmation to terminate the session.

  ./user_session_cleanup

  Please enter the username
  for which session is to be terminated.

  Username:test

  User session details
  are as follows:==========================================================  

  Username     | 
     IP address   | Session Expiry Time =============================================================== 

  test        | 
   64.103.156.106  |   2012-03-22 06:43:34 ==================================================================== 
          

  Do
  you wish to terminate the session? (yes/no):

  If you want to terminate the session, enter yes or else no.
• On receiving confirmation, the script terminates session and removes session information from PPT database.