Page History

h4. Specifications

*Server*

Specifications

(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 file 'docs and settings/all users/app data/360Works/memorysize ("128")'

*Filemaker Pro Plugins Required

*
FTPeek v1.6.33 (May 2013) or later

*Java Required

*
Java 7.25 (May 2013) or later

h4. MySQL Databases

Request for Proposals (RFP) database: _proposal_cycle

_
Project Management (PM) database:

Groups

 _mitsg_


h4. 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}

h4. 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}