Current Stockroom 1.0 servers for reference ( moved to AWS as of 4/27/2017 ):
PRODUCTION 1.0 Windows 2012R2 server running Quickbooks and Quickbooks Web Connector ( aka AS-CHM-VSRV-06, 10.92.150.40 )
- Amazon t2.medium instance with a 120GB AmazonSSD storage attached
- Server access limited to ChemIT staff net ( all ports ), Chem Stockroom Staff ( RDP ), and Stockroom 1.0 Kiosk Server ( all ports ) via Amazon Security Groups - Windows Firewall Turned Off by GP in CUAD
- Windows updates reboot machine every Wednesday at 3:00am
PRODUCTION 1.0 Centos 6 server running Kiosk Web Server ( aka AS-CHM-VSRV-10, 10.92.150.41 )
- Amazon t2.micro instance with a 50GB AmazonSSD storage attached
- Server access limited to ChemIT staff net ( all ports ), Chem Stockroom Staff ( HTTP/HTTPS ), Chem Stockroom Kiosk ( HTTP/HTTPS ), and Stockroom 1.0 Windows Quickbooks Server ( all ports ) via Amazon Security Groups - IPTables turned off
- MySQL installed on this machine - no outside database
- No automatic updating
NO TESTING OR DEVELOPMENT SERVERS for Stockroom 1.0 as of 5/3/2017
New Stockroom 2.0 Servers in AWS:
Stockroom PRODUCTION Quickbooks Server ( aka AS-CHM-ASRV-04 10.92.150.10 )
- Amazon t2.medium instance with a 100GB AmazonSSD storage attached
- Server access limited to ChemIT staff net ( all ports ), Chem Stockroom Staff ( RDP )
Stockroom PRODUCTION Kiosk Server ( aka AS-CHM-ASRV-05 10.92.150.11 )
- Amazon t2.micro instance with a 8GB AmazonSSD storage attached
- Server access limited to
Stockroom TEST Quickbooks Server ( aka AS-CHM-ASRV-06 10.92.150.12 )
- Amazon t2.medium instance with a 100GB AmazonSSD storage attached
- Server access limited to ChemIT staff net ( all ports )
Stockroom TEST Kiosk Server ( aka AS-CHM-ASRV-07 10.92.150.13 ) as of 5/10/2017 doesn't exist
- Server access limited to xxxxxx
Stockroom DEVELOPMENT Quickbooks Server ( aka AS-CHM-ASRV-08 10.92.150.14 )
- Amazon t2.medium instance with a 100GB AmazonSSD storage attached
- Server access limited to ChemIT staff net ( all ports )
Stockroom DEVELOPMENT Kiosk Server ( aka AS-CHM-ASRV-09 10.92.150.15 )
- Amazon t2.micro instance with a 8GB AmazonSSD storage attached
- Server access limited to ChemIT staff net ( all ports ), CIT Regular VPN pool ( all ports ), and CIT Web Dev group ( via CIT.STAFF Department VPN ) ( all ports )
Database servers:
Stockroom PRODUCTION MySQL Database Server - Amazon RDS ( db-prod.kiosk.stockroom.chem.cornell.edu 10.92.150.25 )
- Amazon db.t2.micro instance with 20GB of storage
- MySQL 5.7.16 set to auto minor update - maintenance window Monday 12:00am-12:30am
- Server access limited to ChemIT staff net, Stockroom 2.0 Production Kiosk Server ( aka AS-CHM-ASRV-05 )
Stockroom TEST MySQL Database Server - Amazon RDS ( db-test.kiosk.stockroom.chem.cornell.edu 10.92.150.7 )
- Amazon db.t2.micro instance with 20GB of storage
- MySQL 5.7.16 set to auto minor update - maintenance window Monday 1:00am-1:30am
- Server access limited to ChemIT staff net, Stockroom 2.0 Test Kiosk Server ( aka AS-CHM-ASRV-07 )
Stockroom DEV MySQL Database Server - Amazon RDS ( db-dev.kiosk.stockroom.chem.cornell.edu 10.92.150.59 )
- Amazon db.t2.micro instance with 20GB of storage
- MySQL 5.7.16 set to auto minor update - maintenance window Monday 3:00am-3:30am
- Server access limited to ChemIT staff net, Stockroom 2.0 Development Kiosk Server ( aka AS-CHM-ASRV-09 ), and CIT Web Dev group ( via CIT.STAFF Department VPN )