Versions Compared

Key

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

 

Specifications

Server
Section Wiki Markup h4. 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*

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: _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 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)

 

  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}