OpengateMup - MAC address update system

Summary

This system updates the expiration date of an MAC address registered in the database.  It includes following two programs.

• opengatemmail: Program to send warning e-mail to the user whose expiretion date is soon.  It run under cron.
  
• opengatemup.cgi: CGI program to update, delete, and pause the MAC address registration.
  

Installation

1. This system cooperates with opengateMd, OpengateMsql, and opengateMreg. 
   
   
2. To run this, the following access relations must be maitained.
   openateMup --- > opengateMsql < --- opengateMreg/opengateMd
   
   
3. Install MySql, SQLite3, and Apache. 　If you select authentication method requiring specific modules, install it.
   
   
4. Edit /etc/syslog.conf to save log entries for OpengateM.  And create the log file [e.g.:  touch /var/log/opengate.log ].
   
             | * Separate by TAB code
             V
   local1.*  /var/log/opengate.log
   
   
5. Unpack the archive and install it, where [0.0.0] means  the version number.
   
   tar xzvf opengatem0.0.0.tar.gz
   cd opengatem0.0.0/mngsrc
   make installmup
   
   
6. Modify the configuration file to adjust to the environment.  Refer documentation of opengateMreg.
   
   cp opengatemmng.conf.sample opengatemmng.conf
   vi opengatemmng.conf
   
   
7. When you select Shibboleth or HttpBasic for general user authentication, Add authentication setting for opengatemup.cgi in [.htaccess].  Remove the setting, if you select other method.
   
   ====if select Shibboleth====
   <FILES opengatemup.cgi>
    AuthType shibboleth
    ShibRequestSetting requireSession 1
    ShibRequireSession On
    ShibUseHeaders On
    Require valid-user
   </FILES>
   ====if select HttpBasic====
   <FILES opengatemup.cgi>
   AuthType Basic
   AuthUserFile /tmp/passwd.dat
   AuthName "Enter Your ID and Password"
   Require valid-user
   </FILES>
   
   
8. Check the warning mail sender.  Set the [limitDate] as tomorrow, and run [opengatemmail] on root privilege.  If warning mail is not received, check opengate.log and maillog.
   
   mysql
   use opengatem;
   update macaddrs set limitDate=adddate(now(), interval 1 day) where userId='user1';
   select * from macaddrs;
   exit
   sudo opengatemmail
   
   
9. Add the following line to [/etc/crontab] in order to send warning mail before expiration. It means to run the sender at 07:46 every morning.  Or prepare a file to execute this command in the derectory [/etc/periodic/daily/].  Be care to set on one site only.  If you set on plural sites, plural mails are received.
   
   46      7       *       *       *       root    /usr/local/bin/opengatemmail
   

Usage

• The content of the warning e-mail is [/etc/opengate/warningmail].
• In configuration file [/etc/opengate/opengatemmng.conf], you can modify the timing of warning e-mail,     expiration date and others.
• The link to CGI opengatemup.cgi should be settled on some page where users can easily reach, such as Opengate page or network management office page.
  

Database

• MySQL: opengatem R/W (Management DB)
• SqLite3: opengatemmng.db R/W  (Local work DB to hold temporary data)