COMPOSE Programming

Modified on Friday, 14 October 2016 14:15 by blarke@energianalyse.dk — Categorized as: Uncategorized

Programming infrastructure:

Delphi 2010 Architect
MS SQL 2008 R2 for remote data
SQL 2008 Native Client
Microsoft Access 2007 File Format ACCDB for local data
Microsoft Access Database Engine 2007 Redistributable
Filezilla FTP Server Remotely
Optimax.dll - license required for non-academic users
Open Source Solvers: CoinMP.dll, LPSOLVE.dll, GLPK - integration with CPLEX and GUROBI with custom parameters.
Mathwave SDK for statistical analysis and risk distributions
Woll2Woll InfoPower
Raize Components
ScrewTurn integrated WIKI
TMS Flexcel for non-OLE spreadsheet handling
TMS Diagram Studio
JEDI Debug
TurboPower Abbrevia for compressed file handling.
DCPCrypt for password handling.

Supporting infrastructure:

Server Requirements:

Microsoft SQL Server as default instance on port 14016 allowing remote IP (Setting default instance).
FTP server on port 21 with write access to c:\ftps\compose

Flowdiagram:

Build CBs
Build Demands
CalcProcesses
Optimize Project
CalcResults

Server Setup

Install SQL server, mixed authentication
Rename sa account
Firewall inbound 14016
Router port forward 14016 to host
Set SQL Server Configuration Manager Login as Network Service
Set SQL Server Configuration Manager TCP/IP protocals port 14016
Copy backups and restore cdb, cdbid, energyinteractive
Run autofix on users on ALL three databases

USE EnergyInteractive
GO
EXEC sp_change_users_login 'Auto_Fix', 'username', NULL, 'password'
GO

Make user bulk admin

Install filezilla server
Copy the two zilla xml files to server folder
Open firewall for filezilla program
create folder ftps/compose
Copy test.dll to ftp folder
Copy networktest.sql to ftp folder

install, source, backup not beskrevet
Copy COMPOSE folder minus cdb? Location important?
Setup webserver EnergyInteractive?