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 )
  • No labels