Routine Maintenance Activities

To keep the sites running it is important to perform the following activities:

Using an SCP Client, connect to the ClicFlic EC2 instance as root (get credentials from mike's keypass), go to /backup/dbms and delete old copies of the database backup files.  

The servers should run for some time. 

Reboot - Weekly, or when there is a problem.

Reboot all server instances weekly to deal with memory leaks. No issues have been experienced in some time, but ...

To reboot, you can do one of two things.

Method 1. First (and easiest) log onto the AWS console and go to EC2 -> Instances.  Then for each instance choose the reboot action. This will fully reboot the server.

Method 2: Second (and safest since it shuts down the application server before rebooting) SSH into each server. For ClicFlic and HR Avatar, change directories to /backup/scripts then execute the reboot script by typing /reboot.sh  Wait a minute and it should reboot itself.  For the Discern and CFShare server, simply ssh as root and type shutdown -r 0  which will reboot the server.

All servers except the discern server will come back fully on reboot. For discern you must manually restart the essay programs. To do this you must log on to the discern server via SSH as ec2-user (DO NOT LOG ON AS ROOT FOR THIS), then change directory to /work, then execute the script startdiscern.sh by typing /startdiscern.sh  That's it. Just log off after you type that and it should say "OK"

Remove old database records - Weekly

Using WinSCP, connect to the ClicFlic server and navigate to /backup/dbms - delete files over a week old. Should be handled automatically by a script called cleanlogs.sh in /backup/scripts and copied to /etc/cron.daily

Remove old export directories - Weekly

Via http://www.clicflic.com/stutil, go to Clean old Media Files and click on "Clear Local Export Folders."

Clean up some dbms records - Weekly

Via http://www.clicflic.com/stutil, go to "Video and ActX Conversions" and click on "Clean Act Archive Records."  Then click on "Clean Old File Conversion Job Records."

Clean out old deploy folders - Weekly

Via http://www.clicflic.com/stutil, go to Clean old Media Files and click on the button under "Clean Standalone Deploy Directories"  The code for this is "forlake"

Clean out old IMO Media - Quarterly

Via http://www.clicflic.com/stutil, go to Clean old Media Files and click on the button under "Delete Media From Old, Deleted Scripts"  The code for this is "forlake"

Archive ActHistory Records on ClicFlic - Quarterly 
Log on to http://www.clicflic.com using an admin logon and go to Admin -> Archive ActHistory Records.

Archive Test Event records on HR Avatar - Quarterly

Go to http://www.simajob.com and log on using an admin logon. Then go to Admin -> clean/archive to start the process. 

Review IMO Media and delete extraneous files - Annual

Via http://www.clicflic.com/stutil, go to Clean old Media Files and click on the button under "Clean Old/Unused Media Files"  The code for this is "forlake"  Leave actId at 0 to review all IMOs.