AOLIS Report 2005

This report is an addendum and update to the AOLIS Report 2004 and therefore not as specific, elaborative, and inclusive or all things about aolis. The reader is advised to digest the AOLIS Report 2004 with this document.

AOLIS Services by Priority
Active Projects
Coming Projects
Operations Manual
- Daily Tasks
- Weekly Tasks
- Monthly Tasks
- Termly Tasks
- Yearly Tasks
- Automated Tasks
Ongoing Research and Development for future projects
- VOIP
- Samba PDC
- Linux'ation of some office workstations

AOLIS Services by Priority

Priority Service
5        Backups
4        Student Accounts
4        Grades
4        Cafeteria System
3        Reports
3        Desktop Support
3        AOLIS Website
2        Telephone and Email Directory
2        Bellringer
2        Academic Internet
1        Wifi Service
1        Student Info
1        Data Recovery
1        AOLIS Personal ATM

Active Projects

Accounting AOLISation
some modules usable already, a lot still 'work-in-progress'.
Undergrounding of Sci-Annex & Dentistry Datalines

Coming Projects

Online enrollment

Operations Manual

This section aims to transfer technology between successions of AOLIS Personnel. It is assumed that workers know how to read and write, and need minimum or no teaching to understand and implement new technologies.

Systems Administration Job

The AOLIS Systems Administrator's job is to monitor and keep AOLIS Services up and running not only during regular office hours but also 24 hours a day, 7 days a week, 365.25 days a year for AOLIS Internet Services. Making sure the services are available to office users (during office hours) and worldwide users (24/7/365.24).

Daily Tasks

check email for critical updates for all servers
audit /var/log/secure of all servers
audit /var/log/messages of all servers
check disk free of all servers
look for expired login attempts in aolis (verify authenticity and re-enable expired accounts)
look for other failures in logs
check connectivity specifically with caf2.aolis.aup.edu.ph
check connectivity to www.google.com and put necessary proxy announcement to reduce telephone calls
check backup1.aolis.aup.edu.ph backup logs
take a visiting walk to accounting office, registrars', and dsf
take a visiting walk to administration offices, graduate school, COH, COB, CAST, dentistry, music, pe, education, pic
wait for service calls by bringing long range telephone

Weekly Tasks

download antivirus updates
check slashdot for new stuff
copy pictures for students from ro to aolis:/pictures for scheduled organizepictures.php to process
(2008-june-05) dump and restore all databases
- aolis (friday afternoon)
- cafeteria (thursday night)

Monthly Tasks

burn files modified in the last 30 days to CD/DVD (from backuppc)

Termly Tasks

adjust year and sem in configuration files (aolis.conf, charges.conf, etc...)
adjust year and sem in congrats
adjust year and sem in shell environment variables
delete table permissions
adjust dates in accounting programs
adjust dates in shell environment variables

Yearly Tasks

make yearly report

Automated Tasks

postgresql aolis backup (every two hours from 7am to 7pm)
postgresql databasewide backup (every friday 4pm)
generation of Enrollment List Summary (every 3 hours)
generation of Enrollment List (every 3 hours)
generation of misc sso & dsf reports (every 4am)
organizing pictures for cafeteria (every 9pm)
bellringer (every and 10 mins before between periods)
copy of dumps from aolis.aolis.aup.edu.ph to db.aolis.aup.edu.ph (every night)
backup of all hosts to backup1.aolis.aup.edu.ph (non-specific times)

Ongoing Research and Developments for future projects

VOIP
(Voice-Over-Internet-Protocol) when in collaborative arrangements with co-Adventist establishments local, and specially abroad, will give the benefit of free local calls to peered-to call terminators with only the cost of internet bandwidth.
Samba PDC
Setting up most workstations in the offices in Domain mode will increase productivity by orchestrating software updates which will greatly reduce if not extinguish virus and spyware proliferation in the campus network. Roaming profiles will lower downtime in servicing of workstations.
Linux'ation of some office workstations
The benefits of linux workstations are
1. zero software cost
2. lowered maintenance and downtime (terminal services)
3. savings on hardware brought by the decrease in hardware requirements due to more efficient use
4. no viruses
5. easier administration