Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

section 

Specifications

Server
(xAMP) Mac OS/ 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
max_execution_time = 14400?
max_input_time = 14400?
max_file_uploads = 20?
post_max_size = 2000M? largest acceptable filesize (in MBs)
upload_max_filesize = 2000M? largest acceptable filesize (in MBs)
sendmail = enabled
display_errors = off
allow_url_fopen = on (for recaptcha)
fsockopen = enabled (for recaptcha)

Filemaker Pro (FMP)
WinXP+/Mac OS 10.4+, Filemaker Pro 10+11+; FMP in WinXP requires file 'docs and settings/all users/app data/360Works/memorysize ("128")'

Filemaker Pro Plugins Required
FTPeek

Groups

Wiki Markup
{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

Wiki Markup{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}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
 

group namedescription
wwwprimary group for admins transferring files via SFTP to server (e.g. Admin SFTP)
documentsprimary group for other users transferring files via SFTP to server (e.g. SFTP via FMP)
xfersgroup for webform upload folders only

Users
 

server user typesdescription
Admin SFTPUsed by Dreamweaver to transfer files via SFTP (e.g. bbray); group(s): www, documents, xfers
SFTP via FMPUsed by FMP to transfer files via SFTP (e.g. mitsg_fmp); group(s): documents, www, xfers
WebserverWhat the webserver runs as (e.g. apache); group(s): xfers
MySQL user types 
RFP mysql via webUsed by mysql web connect script for RFP db (e.g. PC_user)
PM mysql via webUsed by mysql web connect script for PM db (e.g. MITSGWF_web)
mysql via FMPUsed by ODBC to connect FMP interfaces to mysql (e.g. fmpuser3cc)