Server Section
h4. Specifications
*Server*
(xAMP) Unix/Linux, Apache 2, PHP 5.2.6+, MySQL 5.0.77\+
Wiki Markup
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.
...
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
group name | description |
---|---|
www | primary group for admins transferring files via SFTP to server (e.g. |
...
Admin |
...
SFTP) | |
documents | primary group for other users transferring files via SFTP to server (e.g. |
...
SFTP |
...
via FMP) | |
xfers | group for webform upload folders only |
server user types | description |
---|---|
Admin SFTP | Used by Dreamweaver to transfer files via SFTP (e.g. bbray); group(s): www, documents, xfers |
SFTP via FMP | Used by FMP to transfer files via SFTP (e.g. mitsg_fmp); group(s): documents, www, xfers |
Webserver | What the webserver runs as (e.g. apache); group(s): xfers |
MySQL user types | |
RFP mysql via web | Used by mysql web connect script for RFP db (e.g. PC_user) |
PM mysql via web | Used by mysql web connect script for PM db (e.g. MITSGWF_web) |
mysql via FMP | Used 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}