Current Stockroom 1.0 servers for reference ( moved to AWS as of 4/27/2017 ):
PRODUCTION 1.0 Quickbooks Server ( 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 Server 2012R2
- Quickbooks Premier Edition 2013 23.0D with Quickbooks Web Connector 2.1.0.30
- Windows updates reboot machine every Wednesday at 3:00am
PRODUCTION 1.0 Kiosk Web Server ( aka AS-CHM-VSRV-10, aka kiosk.stockroom.chem.cornell.edu aka 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 5.1.69 installed on this machine
- Centos 6.0 with Apache 2.2.15, PHP 5.3.3, and CUWebAuth 2.2.1.210
- No docker
- No automatic patching schedule
- Quickbooks PHP (Webconnector framework) V1.5.3
NO TESTING OR DEVELOPMENT SERVERS for Stockroom 1.0 as of 5/3/2017
Stockroom 1.5 intermediate upgrade Servers in AWS:
Stockroom TEST 1.5 Kiosk Server ( aka AS-CHM-ASRV-11 )
- Amazon t2.micro instance with a 50GB AmazonSSD storage attached
- Server access limited to ChemIT staff net ( all ports ), and Stockroom 2.0 Windows Test Quickbooks Server ( all ports ) via Amazon Security Groups - IPTables turned off
- MySQL 5.1.69 installed on this machine
- Centos 6.4 with Apache 2.2.15, PHP 5.3.3, and CUWebAuth 2.3.0.238
- No automatic patching schedule
- Quickbooks PHP (Webconnector framework) V1.5.3
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
- Windows Server 2016 with weekly patching Wednesday at 3:00am
- Quickbooks Premier Edition 2017 R5 with Quickbooks Web Connector 2.2.0.71
- Excel 2016, Acrobat DC 2017, Firefox ESR 52.1.1
- Server access limited to ChemIT staff net ( all ports ), Chem Stockroom Staff ( RDP ) via Amazon Security Groups - Windows Firewall Turned Off by GP in CUAD
Stockroom PRODUCTION Kiosk Server ( aka AS-CHM-ASRV-05 aka prod.stockroom.chem.cornell.edu 10.92.150.11 )
- Amazon t2.micro instance with a 8GB AmazonSSD storage attached
- Centos 7.2 with Apache 2.4.6, PHP 5.4.16, and CUWebAuth 2.3.0.238
- No docker
- No automatic patching schedule
- Server access limited to ChemIT staff net ( all ports ), Chem Stockroom Staff ( HTTP/HTTPS ), and Chem Stockroom Kiosks ( HTTP/HTTPS )
- Quickbooks PHP (Webconnector framework) V2.0.0 (Now is V1.5.3)
Stockroom TEST Quickbooks Server ( aka AS-CHM-ASRV-06 10.92.150.12 )
- Amazon t2.medium instance with a 100GB AmazonSSD storage attached
- Windows Server 2016 with weekly patching Wednesday at 3:00am
- Quickbooks Premier Edition 2017 R5 with Quickbooks Web Connector 2.2.0.71
- Excel 2016, Acrobat DC 2017, Firefox ESR 52.1.1
- Server access limited to ChemIT staff net ( all ports ) via Amazon Security Groups - Windows Firewall Turned Off by GP in CUAD
Stockroom TEST Kiosk Server ( aka AS-CHM-ASRV-07 aka test.kiosk.stockroom.chem.cornell.edu aka 10.92.150.13 ) as of 5/10/2017 doesn't exist
Stockroom DEVELOPMENT Quickbooks Server ( aka AS-CHM-ASRV-08 10.92.150.14 )
- Amazon t2.medium instance with a 100GB AmazonSSD storage attached
- Windows Server 2016 with weekly patching Wednesday at 3:00am
- Quickbooks Premier Edition 2017 R5 with Quickbooks Web Connector 2.2.0.71
- Excel 2016, Acrobat DC 2017, Firefox ESR 52.1.1
- Server access limited to ChemIT staff net ( all ports ), Chem Department VPN pool ( for Brightworks ) ( all ports ) via Amazon Security Groups - Windows Firewall Turned Off by GP in CUAD
Stockroom DEVELOPMENT Kiosk Server ( aka AS-CHM-ASRV-09 aka dev.kiosk.stockroom.chem.cornell.edu aka 10.92.150.15 )
- Amazon t2.micro instance with a 8GB AmazonSSD storage attached
- Centos 7.2 with Apache xxx, PHP xxx, and CUWebAuth xxx
- No automatic patching schedule
- Server access limited to ChemIT staff net ( all ports ), Chem Department VPN pool ( for Brightworks ) ( all ports ), and CIT Web Dev group ( via CIT.STAFF Department VPN ) ( all ports )
- Quickbooks PHP (Webconnector framework) V2.0.0 (Now is V1.5.3)
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 )