Specifications
Server
(xAMP) Unix/Linux, Apache 2, PHP 5.2.6+, MySQL 5.0.77+
min size = 40GB
requires acquisition of universally-accepted SSL certificates (e.g. GeoTrust)
default umask: restrict 775
PHP
post_max_size = largest acceptable filesize (in MBs)
upload_max_filesize = largest acceptable filesize (in MBs)
sendmail = enabled
allow_url_fopen = on (for recaptcha)
fsockopen = enabled (for recaptcha)
Filemaker Pro
WinXP+/Mac OS 10.4+, Filemaker Pro 11+ (FMP in WinXP requires memorysize file)
Filemaker Pro Plugins Required
FTPeek v1.6.33 (May 2013) or later
Java Required
Java 7.25 (May 2013) or later
MySQL Databases
Request for Proposals (RFP) database: proposal_cycle
Project Management (PM) database: mitsg
Groups
{html}
<TABLE border="0" cellpadding="0" cellspacing="8" mce_style="margin:0;" style="margin:0;" width="100%">
<TBODY>
<TR valign="top">
<TD align="left" width="25%"><B>group name</B></TD>
<TD align="left" width="75%"><B>description</B></TD>
</TR>
<TR valign="top">
<TD align="left">www</TD>
<TD align="left">primary group for admins transferring files via SFTP to server (e.g. Admin SFTP)</TD>
</TR>
<TR valign="top">
<TD align="left">documents</TD>
<TD align="left">primary group for other users transferring files via SFTP to server (e.g. SFTP via FMP)</TD>
</TR>
<TR valign="top">
<TD align="left">xfers</TD>
<TD align="left">group for webform upload folders only</TD>
</TR>
</TBODY></TABLE>
{html} |
Users
{html}
<TABLE border="0" cellpadding="0" cellspacing="8" mce_style="margin:0;" style="margin:0;" width="100%">
<TBODY>
<TR valign="top">
<TD align="left" width="25%"><B>server user types</B></TD>
<TD align="left" width="75%"><B>description</B></TD>
</TR>
<TR valign="top">
<TD align="left">Admin SFTP </TD>
<TD align="left">Used by Dreamweaver to transfer files via SFTP (e.g. bbray); group(s): www, documents, xfers</TD>
</TR>
<TR valign="top">
<TD align="left">SFTP via FMP</TD>
<TD align="left">Used by FMP to transfer files via SFTP (e.g. mitsg_fmp); group(s): documents, www, xfers</TD>
</TR>
<TR valign="top">
<TD align="left">Webserver </TD>
<TD align="left">What the webserver runs as (e.g. apache); group(s): xfers</TD>
</TR>
<TR valign="top">
<TD align="left" width="25%"><B>mysql user types</B></TD>
<TD align="left" width="75%"></TD>
</TR>
<TR valign="top">
<TD align="left">RFP mysql via web </TD>
<TD align="left">Used by mysql web connect script for RFP db (e.g. PC_user)</TD>
</TR>
<TR valign="top">
<TD align="left">PM mysql via web </TD>
<TD align="left">Used by mysql web connect script for PM db (e.g. MITSGWF_web)</TD>
</TR>
<TR valign="top">
<TD align="left">mysql via FMP </TD>
<TD align="left">Used by ODBC to connect FMP interfaces to mysql (e.g. fmpuser3cc)</TD>
</TR>
</TBODY></TABLE>
{html} |
|