- OpenPowerNet
Contents
1. schema2 iii Bi EEB the indicated data praias A User data source is para visible to yy and can only be used on the current machine online mode E Selection File ODBC DSN remote T jon 3 2013 08 30 10 40 05 Figure 12 The use of ODBC by OpenPowerNet 2 3 8 Installation of MATLAB runtime environment The OpenPowerNet Analysis Tool requires the MATLAB runtime environment The installation file can be found on DVD under ThirdPartyPrograms MCRInstaller R2013b 82 win64 exe Follow the installer instructions and use the default options 2 4 Installation of OpenPowerNet Extract the zip file O penPowerNet OpenPowerNet 1 5 2 zip from DVD This file contains all program files and documentation of OpenPowerNet IFB DD Il_OPN_33_01 05 02 docx Page 13 of 18 DMJ 2014 05 08 SpenPowerNet Page 14 of 18 Installation Instruction Issue issue 2014 05 08 05 08 There are two options to install OpoenPowerNet Option 1 is to have a shared installation for all users e g under C Program Files and option 2 is to have an individual installation for each user e g in his home directory OpenPowerNet uses the Eclipse framework Eclipse is based on plugins and features The installation resp update of the features and plugins is stored in the installation directory For option 1 all users share the same features For option 2 each user is able to update and install plugins and features by himself and to adapt Eclipse2. Oa Institut fur Bahntechnik GmbH OpenPowerNet Installation Instruction Institut fur Bahntechnik GmbH Branch Office Dresden Document No OPN 33 1 5 2 I opn 10_documents 20_program_documentation 10_installation_instruction ii_opn_33_01 05 02 docx Author Review Release Martin Jacob Harald Scheiner Dr Jorg von Lingen Revision Record Change Reason 2014 05 08 Update chapter for updating add update OPN from server 2014 02 10 Update chapter for updating add OPN update 2013 10 11 Update system requirements third party software database and ODBC setup 2013 02 12 Update chapter for updating 2012 07 10 Update chapter for updating 2012 05 07 Introduce of MariaDB 2011 06 29 Rework update table 2010 05 17 Add Dongle ID configuration 2010 03 31 Add create database user script and Excel regional settings 2010 01 07 Add update handling 2009 09 15 Add more detailed description all chapters ms ds a os a oa NN WO BA S OO gt O N O Nh 2009 06 26 Update because of GUI installation all chapters 2008 11 24 Reworked 2006 04 10 Created IFB DD II_OPN_33_01 05 02 docx Page 1 of 18 DMJ 2014 05 08 SpenPowerNet Page 2 of 18 Installation Instruction Issue Issue 2014 05 08 05 08 Table of Contents 1 EOU CO AEAEE cca ENEA A EENEN EEE NAE A RAE 3 1 1 VST CW E E E E E E E E 3 1 2 CONTOU O UON
3. x Remove MS Access Database Microsoft Access Driver mdb accdb MySQL ODBC 5 2 Unicode Driver Configure 4 mW p m4 An ODBC User data source stores information about how to connect to the indicated data provider A User data source is only visible to you and can only be used on the current machine 0K Econ Figure 14 ODBC Data Source Administrator dialog 2 Step To create the localhost connection select tab System DSN and click Add In the next screen see Figure 15 select the MySQL ODBC 5 2 Unicode Driver and click Finish Create New Data Source lt Select a driver for which you want to set up a data source Name Version Cc MySQL ODBC 5 2 ANSI Driver 5 02 05 00 Or A Geenen orane ca 5 02 05 00 Or SQL Server 6 01 7601 17514 Mi Baci Finish Cancel Figure 15 Create New Data Source dialog A dialog to configure the new data source appears see Figure 16 Fill in the empty fields as shown in the figure For a local database installation the field TCP IP Server may be left empty Otherwise it is also possible to configure a connection to a remote computer here the Data Source Name should also be adopted then e g matching the remote host name Input IFB DD Il _OPN_33_01 05 02 docx Page 15 of 18 DMJ 2014 05 08 SpenPowerNet Page 16 of 18 Installation Instruction Issue Issue 2014 05 08 05 08 the user data as configured earlier in 2 3 6 1 The default us
4. gt Info Panel It is also possible to keep the existing OpenTrack installation and copy the update version to a different location on the hard disk drive However to keep a better overview of the setup this is recommended only if necessary After installing OpenTrack create or modify a link to OpenTrack exe on the desktop or in the start menu Add the parameter opn to the link target to enable the OpenPowerNet interface Set the compatibility mode to Windows XP Service Pack3 by editing the OpenTrack exe properties Open the properties via context menu and set the compatibility mode on tab Compatibility 2 3 6 Installation of MariaDB The MariaDB installation file can be found on DVD under ThirdPartyPrograms mariadb 5 5 30 winx64 msi In case there is no or only an old version of MariaDB installed on your please install MariaDB version 5 5 30 after removing the old version OpenPowerNet is tested with this version and may have problems with other particularly older versions MariaDB setup installs the MariaDB server application and HeidiSQL tool suite In the MariaDB installer follow the instructions and use the settings from the following figures Set and note a database administrator root password see Figure 7 IFB DD II_OPN_33_01 05 02 docx Page 9 of 18 DMJ 2014 05 08 GpenPowemNet zZ Institut f r Bahntechnik GmbH Page 10 of 18 Installation Instruction Issue Issue 2014 05 08 05 08 Te User settings Defa
5. 2 3 6 2 Create OpenPowerNet user account o ssnsensnsensnrenrnrerrrrerrnrerrersrrenne 12 ZO Doala OF IVIY OD BC rere eepe E E E E E 13 2 3 8 Installation of MATLAB runtime EnvirOnMent cccceceseeceeeeeeeeeeeeenees 13 2 4 Installation of OpenPowerNet cc ccecceeceeeceeeeeeeeeteeeeseceeeeeeteeeeeeeeeneees 13 2 9 Creation of OpenPowerNet database ccccccceccseeceeeeeeeeeeeeeeeeeeeeeeeees 14 2 6 Definition of Data Source NAMES ccccceeceeteeeeeeeeeeeeeseceeeeeeeseteeeees 14 2 1 Firewall settings isietctmitceniiracestanielsexctsvejiceciui vaialyeaveiuevigecus cactus ucilyeaesacueawsreutondeatioeeen 17 2 8 DOMOIe UD CONIU AU OM eee e E EE E EE ER 17 IFB DD II _OPN_33_01 05 02 docx Page 2 of 18 DMJ 2014 05 08 SpenPowerNet Page 3 of 18 Installation Instruction Issue Issue 2014 05 08 05 08 1 Introduction Please read the installation instructions carefully and follow them step by step 1 1 Overview The purpose of this document is to describe the steps that have to be carried out by the system administrator to prepare the usage of the program OpenPowerNet This document corresponds to OpenPowerNet release 1 5 2 some of the used package names are brand names registered by other companies than IFB Please refer to the license descriptions coming with that software packages 1 2 Configuration OpenPowerNet requires the following versions of associated applications Addition
6. Finish Cancel Figure 4 The available updates dialog Click twice Next gt and accept the license agreement Then click Finish and then the update will be installed Accept the security warning see Figure 5 After installation OpenPowerNet has to be restarted z E3 Security Warning Warning You are installing software that contains unsigned content The authenticity A or validity of this software cannot be established Do you want to continue with the installation Cancel Details gt gt Figure 5 Installation process security warning 2 2 2 Update OpenPowerNet from Server Start OpenPowerNet and then go to menu Window gt Preferences gt Install Update gt Available Software Sites see Figure 1 Only OpenPowerNet update should be enabled Close the dialog and go to menu Help gt Check for Updates F Login required gt _ ee Please provide login details for download openpowernet de Username Password Save password ere E Figure 6 The update login dialog A login is required to update OpenPowerNet and therefore a login dialog as in Figure 6 pops up Enter the user name and password as provided by IFB and click OK then a dialog opens showing the available updates see Figure 4 IFB DD II _OPN_33_01 05 02 docx Page 7 of 18 DMJ 2014 05 08 SpenPowerNet Page 8 of 18 Installation Instruction Issue issue 2014 05
7. account The database user account is needed to save the simulation results of the program to the database for later analysis Each user may have an own MariaDB database user name and password but the database will be the same for all users on this computer unless different installations are used or the permissions are set manually It is recommended to keep the single user setup using the default user name A script is available to create a MariaDB database user for OpenPowerNet with without password and all necessary rights The default user is opndbusr without a password e From OpenPowerNet DVD OpenPowerNet run createUser bat and follow the instructions e If you get a message like mysql is not recognized as an internal or external command operable program or batch file IFB DD Il _OPN_33_01 05 02 docx Page 12 of 18 DMJ 2014 05 08 SpenPowerNet Page 13 of 18 Installation Instruction Issue 2014 05 08 2014 05 08 please modify the PATH system variable Open Control Panel gt System gt Advanced gt Environment Variables and add the corresponding path MariaDB Install Dir MariaDB 5 5 bin tothe end use as separator 2 3 7 Installation of MyODBC OpenPowerNet uses Windows ODBC API to connect to the MariaDB database see Figure 12 The installation wizard can be found on DVD under ThirdPartyPrograms mysql connector odbc 5 2 5 winx64 msi Follow the installer instructions and use the default options It is n
8. e g by adding an XML editor or other features Furthermore option 2 does not have to deal with special file permissions It is recommended to use option 2 and to provide the above mentioned zip file to each user After unpacking of the zip file create a link to openpowernet exe on the desktop or in the start menu 2 5 Creation of OpenPowerNet database For configuration of the Data Source Names in 2 6 it is recommended to create a new empty OpenPowerNet database using the GUI to enable the connection test Start OpenPowerNet and select Create new empty OpenPowerNet database from menu OpenPowerNet The dialog in Figure 13 opens Insert the schema name pscresults and the database host and user details see below for default and click Create new database E3 Create new OpenPowerNet database Database Host localhost Port 3306 User name opndbusr Password Schema name MALEN HE Create new database Cancel Figure 13 The GUI dialog to create a new database 2 6 Definition of Data Source Names This chapter describes how to setup ODBC connections using Windows ODBC Data Source Administrator The OpenPowerNet tool chain needs at least one working ODBC connection see Figure 12 It will allow the simulation modules to write results to the database and enable the different analysis tools to read this data back The connection settings include hostname user name and password that are needed to connect to the database service T
9. eea E E 3 1 3 Acronyms and abbreviations cccccecceccsecceeceeeceeceecaeeceeseeeeeeseesaeeneesass 3 2 Installation under Microsoft WINGOWS cccccceeceeceeeceeeeeeseeeeeeeeeeeeaeeees 4 2 1 DVS eM TSCM CHING IIS o5 cec5cerssecedersdsontecnsseniconsscndacsdccnicesisosicenisoniseniecstecsteasen 4 2 2 Update from previous versions cccccsecceeceeeseeteeeeeeceeeeesneteeeeeeeeeeeneeeees 4 2 2 1 Update OpenPowerNet from DVD cccceccsecceeeeeeseeteeeeeeeeeteeeeeeeeeeeenaes 5 2 2 2 Update OpenPowerNet from Server ccccceecceeceeeseeeeeeeeeseeeeeeeeeeeeeeeenees T 2 2 3 WOO ARS FAAS Fils COMMON 6 corsier eier Sn nE E E E 8 2 3 Preparing the OpenPowerNet environment cccecceeeseeeeeeeeeeeeeeeeeeenees 8 2 3 1 Installation of JAVA runtime environment ccccecceeceeeeeeseeteeeeeeeeeeeeeees 8 2 0 2 Installation of Microsoft Visual C runtime libraries ccccceeee seen eeee es 8 2 3 3 Installation of Sentinel HASP runtime environment ccseceeeeeeeeeeeees 8 2 3 4 Installation of OpenStep and Open Track ccccccceccsseceeeseeseeteeceeeeeeeeeeees 8 23 0 Update of OpenTrack to tested version ccccccceecceceeeeeeeeeeeeeeeeeeeeeneeees 9 2 3 6 Installation of MariaDB ccccccceecseeeeeeeeeceeeeeeeeeteeeaseceeeeeeseteeeeeeneeneeees 9 2 3 6 1 Delete OpenPowerNet user account nonnennnnsnnnnerrensrrerrrrerrrrerrrrerrerne 11
10. 08 05 08 Click twice Next gt and accept the license agreement Then click Finish and then the update will be installed Accept the security warning see Figure 5 After installation OpenPowerNet has to be restarted 2 2 3 Update HASP HL dongle To execute the new version of OpenPowerNet it may be necessary to update the hardware dongle that was purchased with the OpenPowerNet license If not stated differently an executable update file lt dongle number gt 1 5 2 2014 05 08 exe can be found on the separate Dongle Update CD Please run this file on the computer the dongle is connected to and follow the instructions of the update wizard after installing the new Sentinel HASP runtime environment according to 2 3 3 if advised by the update matrix in 2 2 If the update wizards prompts to save a confirmation file in C2V format please save this file to your hard drive and send it to support openpowernet de This helps to prevent problems with later updates as the status of the dongle can be held in sync with the management software 2 3 Preparing the OpenPowerNet environment 2 3 1 Installation of JAVA runtime environment If not already available install the Java runtime environment version 7u55 using the default settings The installation file can be found on DVD under ThirdPartyPrograms jre 7u55 windows x64 exe 2 3 2 Installation of Microsoft Visual C runtime libraries OpenPowerNet needs the Microsoft Visual C runtime libraries Th
11. DD with low access time accelerates handling of the simulation results A powerful computer with at least 4 GB of RAM is required For large networks 8 GB of RAM and an SSD are recommended The following software needs to be installed but is not provided with the installation DVD e A program to unzip files integrated function of Windows Explorer is sufficient e Microsoft Excel 2007 2010 or 2013 to analyse the simulation results 2 2 Update from previous versions First determine the actual installed version Start OpenPowerNet and check the printout in the console view of the GUI The printout should look like this OpenPowerNet 1 2 1 Module PSC built Dec 11 2009 15 39 34 Institut fuer Bahntechnik GmbH Then stop and close OpenPowerNet Next is to check Table 3 for the relevant chapters to follow The table contains the old version numbers of OpenPowerNet in the table header Please use the column with the actual installed version e g 1 4 x and follow all chapters marked with X or follow the short description Old versions of third party software may be uninstalled from the Windows Control Panel if it is not intended to use the old OpenPowerNet version anymore or any other software that may use these Example For existing version 1 4 3 follow all chapters marked in column 1 4 x Note With OpenPowerNet 1 5 0 support for Windows versions older than Windows 7 was dropped and the processor architecture was changed from 32 B
12. ID leave blank if any separate multiple with EXE S aE gt Team Validation Shutdown OPN modules after simulation gt AML Restore Defaults Figure 18 The OpenPowerNet preferences END OF DOCUMENT IFB DD Il_OPN_33_01 05 02 docx Page 18 of 18 DMJ 2014 05 08
13. Name OPN update Location file Z update Figure 2 The dialog to specify the update folder Close the Add Site dialog with OK E Preferences type filter text Available Software Sites General Help 4 Install Update Automatic Updates Name Location Available Software Sites Model Validation OpenPowerNet PSC Viewer PSC Viewer Diagram type filter text E A Eclipse 4 2 Juno http download eclipse org releases juno i OPN update file Z update E Al Subversion http download eclipse org technology subversiv E Al Subversion Connectors http community polarion com projects subversi Team Validation XML Figure 3 The available software sites selection for updating only OpenPowerNet IFB DD Il _OPN_33_01 05 02 docx Page 6 of 18 DMJ 2014 05 08 SpenPowerNet Page 7 of 18 Installation Instruction Issue Issue 2014 05 08 05 08 Deselect all other update sites then the just added update folder and close the Preferences dialog with OK see Figure 3 Check for updates via menu Help gt Check for Updates then a dialog opens showing the available updates see Figure 4 E E Available Updat KB Availa e Updates eae a ial Available Updates al Check the updates that you wish to install P Name Version Id WEE Open Power et nnn 191201312030900 de bahntechnik dd opm aa 3 Select All Deselect All Details lt Back Next gt
14. ally the OpenPowerNet software and documentation have their own version 7 SP1 or higher 64 Bit Microsoft Excel MariaDB Database Server MySQL ODBC Driver OpenPowerNet OpenTrack 1 7 4 2014 02 05 OPN Database OPN User Manual Sentinel HASP Runtime Environment Table 1 Configuration table of documents and application versions 1 3 Acronyms and abbreviations The following abbreviations are used within this document ATM DSN DVD GUI HDD OPN PSC RAM IFB DD II_OPN_33_01 05 02 docx Page 3 of 18 DMJ 2014 05 08 SpenPowerNet Page 4 of 18 Installation Instruction Issue Issue 2014 05 08 05 08 Solid State Disk Drive User Account Control Windows Vista or higher Table 2 Acronymes and abbreviations 2 Installation under Microsoft Windows OpenPowerNet and the associated software packages are designed for target systems running Microsoft Windows 7 SP1 or higher 64 Bit Edition utilising the latest updates Note Before starting the installation make sure that you have sufficient administration rights on the target system Under Microsoft Windows some operations may require elevated rights if User Account Control is enabled 2 1 System requirements The performance demands of OpenPowerNet significantly depend on the size and complexity of the electrical network to simulate It is important that all data fits into RAM to prevent a notable performance drop caused by memory swapping to HDD Furthermore a fast H
15. e installation file can be found on DVD under ThirdPartyPrograms vcredist x64 exe 2 3 3 Installation of Sentinel HASP runtime environment To enable the execution of the OpenPowerNet the runtime environment for the HASP SRM dongle is needed The installation files can be found on DVD under ThirdPartyPrograms Sentinel HASP 6 60 MDOBT If any older version of the runtimes should already be installed to the PC it is advised to run uninstall bat and reboot before installing the new version to prevent some serious problems on UEFI based computers Run install bat to install the new Sentinel HASP runtime environment and the vendor libraries The HASP HL dongle should then be listed in the Sentinel Admin Control Center nttp localhost 1947 int devices html or AdminControlCenter 1nk If the dongle is connected to another computer than the OpenPowerNet installation computer the port 1947 may need to be opened for TCP and UDP connections in the firewall 2 3 4 Installation of OpenStep and OpentTrack In order to run OpenTrack a working installation of OpenStep is needed The installation file can be found on the separate OpenTrack CD under IFB DD II_OPN_33_01 05 02 docx Page 8 of 18 DMJ 2014 05 08 SpenPowerNet Page 9 of 18 Installation Instruction Issue Issue 2014 05 08 05 08 OpenStep Windows 64 Bit OPENSTEP msi Follow the instructions of the installer and reboot the computer as advised Note The setting of the PATH sys
16. ecessary to install both the 32 Bit and the 64 Bit drivers for the OpenPowerNet tool chain z EF Prepared Excel 1 Files odbcDsn pscresults Y Y Y m Project File 1 4 ae aa Database pscresults Database odbcDsn pscresults pscresults Database schema 3x ODBC Data Source Administrator pes User DSN System DSN File DSN Drivers Tracing Connection Pooling About User Data Sources ame Driver Add Ne localhost MySQL ODBC 5 2 Unicode Driver pscresults MySQL ODBC 5 2 Unicode Driver a emote MySQL ODBC 5 2 Unicode Driver Project File 2 Database schemat odbcDsn localhost databaseSchema schema2 Project File 3 Database schema2 Database Database isi schema3 Database at Database at local PC remote PC Usecases 1 The prepared Excel Files use always the ODBC DSN pscresults The Excel files display the results of database schema at local PC 2 The Project File 1 uses the same ODBC DSN as the prepared Excel files of usecase 1 and record the simulation data into database schema at local PC 3 The Project File 2 uses the ODBC DSN localhost with host defined as localhost and uses the data from database schema2 at local PC 4 The Project File 3 uses the ODBC DSN remote with host defined as another PC and uses the data from database schema2 5 The Selection File choose the simulation 3 in schema3 at the remote PC odbcDsn remote databaseSchema
17. ecutable file instead of the port number make sure to update the firewall setting if OpenPowerNet is updated because the folder of anpserver64 exe will be changed In case a dongle is used that is connected to another computer in the LAN it might be necessary to open port 1947 for TCP and UDP also see chapter 2 3 3 2 8 Dongle ID configuration In case OpenPowerNet is used with different licenses it might be necessary to specify the dongle per installation To find out the dongle IDs attach all dongles to your PC and open the Sentinel Admin Control Center in your browser http localhost 1947 int devices html The configuration is done in the OpenPowerNet GUI under Menu Window gt Preferences gt OpenPowerNet see Figure 18 The following options are available e Any dongle gt do not insert anything e One dongle gt enter one dongle ID e Multiple dongles gt enter multiple IDs separated by IE IFB DD II _OPN_33_01 05 02 docx Page 17 of 18 DMJ 2014 05 08 Oa OPN 33 1 5 2 Cpe nPowerNet hhh Institut f r Bahntechnik GmbH Page 18 of 18 Installation Instruction Issue 2014 05 08 gt Preferences fon type filter text OpenPowerNet pime General gt Help Install Update GUI language restart required gt Model Validation gt OpenPowerNet PSC Viewer Working directory C Users lt user gt OpenPowerNet General OQpenPowerNet properties Maximum lines per console ns ner ae Dongle
18. er is opndbusr without password No database schema has to be selected for this connection as it will be selectable later from OpenPowerNet Click Test to verify that the connection is working It should report Connection successful otherwise check back the steps in chapters 2 3 6 and 2 3 7 MySQL Connector ODBC Data Source Configuration AS MySQL Connector ODBC E Connection Parameters Data Source Name localhost Description TCP IP Server Port 3306 Named Pipe User opndbusr Password Database Details gt gt OK Figure 16 MySQL Connector ODBC Data Source Configuration for localhost connection Click OK to save the setup The connection should now be shown on the tab System DSN 3 Step To create the pscresults connection login as the user that shall execute OpenPowerNet and open the ODBC Data Source Administrator as shown in Step 1 Select tab User DSN and click Add In the next screen see Figure 15 select the MySQL ODBC 5 2 Unicode Driver and click Finish A dialog to configure the new data source appears see Figure 17 Fill in the empty fields as shown For a local database installation the field TCP IP Server may be left empty Otherwise it is also possible to configure a connection to a remote computer the prepared Excel files will be able to use this if the Data Source Name pscresults Is kept Input the user data as configured earlier in 2 3 6 1 The default user is opndbu
19. et user account lf advised for update process in chapter 2 2 open HeidiSQL login as root using the password from MariaDB installation via the session manager Figure 10 and open the user management via menu Tools gt User manager The dialog as in Figure 11 opens It allows to delete existing database users IFB DD Il_OPN_33_01 05 02 docx Page 11 of 18 DMJ 2014 05 08 mons GpenPowerNet 22 gt Institut f r Bahntechnik GmbH Page 12 of 18 Installation Instruction Issue issue 2014 05 08 05 08 W Session manager Session name amp Settings a SSL options Statistics MQ MarnaDB 9 Networktype MySQL TCP IP Hostname IP 127 0 0 1 E Prompt for credentials Use Windows authentication User root Password ELI Port 3306 z E Compressed client server protoci Databases Separated by semicolon Startup script Figure 10 HeidiSQL session manager w User manager opndbusr o me Select user account Credentials Limitations SSL options Add Clone Delete Username Host User name opndbusr PBN opndbusr a is localhost 5 Password PNTE E Repeat password 127 0 0 1 al Allow access to Q Add object d aw Global privileges EXECUTE a PROCESS W SELECT E SHOW DATABASES W SHOW VIEW W ALTER This user has an empty password Bj Save a Discard x Close Figure 11 MariaDB user manager 2 3 6 2 Create OpenPowerNet user
20. he recommended ODBC setup for OpenPowerNet consists of 2 ODBC connections e localhost connects to the local MariaDB database and is used by the simulation modules and Automatic Analysis It is a system wide connection and may be set up by the administrator The database schema to use is selectable through the particular application The 64 Bit Unicode driver is sufficient e pscresults Is needed for the prepared Excel files see User Manual as these files are configured to use only this connection It should be a per user connection to allow IFB DD II_OPN_33_01 05 02 docx Page 14 of 18 DMJ 2014 05 08 GpenPowerNet 72 gt Institut f r Bahntechnik GmbH Page 15 of 18 Installation Instruction Issue Issue 2014 05 08 05 08 each user to select from the different database schemas independently The 32 Bit Unicode driver is needed to interact with Excel Follow the steps below to create and configure the two ODBC data sources 1 Step Open the ODBC Data Source Administrator either e by running Control Panel gt Administrative Tools gt Data Sources ODBC e by executing odbcad32 exe from the Windows Run dialogue or e by using the menu or button in OpenPowerNet GUI A dialog similar to Figure 14 will appear ODBC Data Source Administrator Xn User DSN System DSN File DSN Drivers Tracing Connection Pooling About User Data Sources Name Driver Excel Files Microsoft Excel Driver 2ds xdsx xdsm
21. it to 64 Bit Please check 2 1 System requirements before updating to the new version IFB DD II_OPN_33_01 05 02 docx Page 4 of 18 DMJ 2014 05 08 SpenPowerNet Page 5 of 18 Installation Instruction Issue Issue 2014 05 08 05 08 2 2 1 Update OpenPowerNet 2 2 2 Update OpenPowerNet DVD or Server from Server 2 2 3 Update HASP HL donge X X S o o arme o e runtime EnVir onmEn gemee o gt o Visual C runtime libraries pomme gt HASP A E environment gerere and OpenTrack 2 3 5 Update of OpenTrack D 2 3 6 Installation of MariaDB Spp 2 3 6 1 Delete OpenPowerNet user account 2 3 6 2 Create OpenPowerNet e daaa E fox E 2 3 7 Installation of MyODBC X X S o Pr E ox S runtime environment G X OpenPowerNet seems fame E a Names 2 7 Firewall settings XxX T x y 2 8 Dongle ID configuration lo ooo Soo o o Table 3 List of chapters to follow to update OpenPowerNet from the corresponding version Previous OpenPowerNet installations may have used MySQL You do not need to change to the new MariaDB but you can do if you wish If you install the new MariaDB uninstall MySQL first Right now both databases are supported 2 2 1 Update OpenPowerNet from DVD To update OpenPowerNet the functionality provided in the GUI is used A Start OpenPowerNet and then go to menu Window gt Preferences gt Install Update gt Available Software Sites Note With OpenPowerNet 1 5 0 the processor architect
22. ot recommended to choose the system drive Be sure that the Windows account IFB DD Il _OPN_33_01 05 02 docx Page 10 of 18 DMJ 2014 05 08 SpenPowerNet Page 11 of 18 Installation Instruction Issue issue 2014 05 08 05 08 SYSTEM has full access permissions to the new location should be by default otherwise the database service will not start e Copy the folder MariaDB Install Dir MariaDB 5 5 data mysql to the path specified for datadir otherwise the database service will not start e Set the variable key buffer size as large as possible according to the available RAM to maximise the database performance but do not set to a value bigger than a third of the physical RAM e Restart the database service using the context menu at service MySQL Modify the logon credentials of the service e This is necessary to upload dump files from user profile folder C Users e Stop the running database goto Control Panel gt Administration gt Services gt MySQL and stop the service from the context menu e Open Properties from context menu e Select Tab Log On e Select Local System account see below Figure 9 and click OK e Restart the database service using the context menu at service MySQL MySQL Properties Local Computer A Nlow se service to interact with desktop gt This account Help me configure user account log on options Figure 9 Service properties dialog 2 3 6 1 Delete OpenPowerN
23. sr without password Select the database schema to use for this connection e g pscresults As this is a per user connection the user will be able to select a different database schema later Click Test to verify that the connection is working It should report Connection successful otherwise check back the steps in chapters 2 3 6 2 3 7 and 2 5 IFB DD II_OPN_33_01 05 02 docx Page 16 of 18 DMJ 2014 05 08 SpenPowerNet Page 17 of 18 Installation Instruction Issue Issue 2014 05 08 05 08 MySQL Connector ODBC Data Source Configuration M mx Connector ODBC E Connection Parameters Data Source Name Pscresults Description TCP IP Server Port 3306 Named Pipe User opndbusr Password Database pscresults a E Figure 17 MySQL Connector ODBC Data Source Configuration for pscresults connection Click OK to save the setup The connection should now be shown on the tab User DSN see Figure 14 Repeat Step 3 for each OpenPowerNet user account or instruct the user how to do so 2 Firewall settings In order to allow the TCP IP communication from OpenPowerNet to OpenTrack it is necessary to open the port 9004 for apserver64 exe and port 9002 for OpenTrack exe The executable files can be found in the OpenPowerNet installation directory under plugins de bahntechnik dd opn bin 1 5 2 YYYYMMDDHHmm bin Please refer to the manual of your firewall software If the firewall setting relies on the ex
24. tem variable should be saved to a text file from Control Panel gt System gt Advanced gt Environment Variables as OpenStep installer may overwrite this variable with its own settings After reboot copy the saved path in front of the new path if only entries like C NEXT remain As OpenPowerNet is tested against OpenTrack version 1 7 4 2014 02 05 it is possible to skip installation of the CD version and proceed with chapter 2 3 5 However to get all data like manuals and tutorial files it is recommended to run the installer from the OpenTrack CD OpenTrack setup exe following the instructions and accepting the default settings Set the compatibility mode to Windows XP Service Pack3 by editing the OpenTrack exe properties Open the properties via context menu and set the compatibility mode on tab Compatibility Activate your OpenTrack license according to the separate instructions 2 3 5 Update of OpenTrack to tested version The OpenPowerNet DVD contains OpenTrack version 1 7 4 2014 02 05 Although newer OpentTrack versions should work as well it is recommended to use this version as OpenPowerNet is tested against it The folder DVD OpenTrack contains a zip file with the folder OpenTrack app Close OpentTrack in case it is running and extract the folder from the zip file into the OpenTrack installation directory overwriting the already existing folder OpenTrack app Start OpenTrack and check the version via menu Info
25. ult instance properties MariaDB 5 5 x64 database configuration MaraDB V Modify password for database user root New root password EEE Enter new root password Confirm TET Retype the password F Enable access from remote machines for root user E Create An Anonymous Account This option will create an anonymous account on this server Please note this setting can lead to insecure systems FJ Use UTFS8 as default server s character set Figure 7 MariaDB default instance settings te Database settings Default instance properties MariaDB 5 5 x64 database configuration nal a al MariaDB V Install as service service Name MySQL V Enable networking TCP port Figure 8 Deselect the Optimize for transactions option After the installer finishes replace and adopt settings in my ini e Stop the database service goto Control Panel gt Administrative Tools gt Services gt MySQL and stop the service from the context menu e Replace the MariaDB configuration file my iniinMariaDB Install Dir MariaDB 5 5 data my ini with the provided file from DVD OpenPowerNet my ini This configuration file is optimised for the needs of OpenPowerNet e Replace the path following directive datadir with the path where you want to store the content of the database e g E MySQL data It is recommended to choose the fastest drive available e g an SSD Please note that this folder may become very big It is n
26. ure was changed from 32 Bit to 64 Bit Therefore the update procedure is not applicable when updating from an older version Please follow the instructions in chapter 2 4 instead IFB DD II_OPN_33_01 05 02 docx Page 5 of 18 DMJ 2014 05 08 SpenPoweet z Institut fur Bahntechnik GmbH Page 6 of 18 Installation Instruction Issue 2014 05 08 2014 05 08 Fa Preferences type filter text Available Software Sites Pryov y General type filter text 4 Install Update Automatic Updates Name n _ Location Enabled Add ae Softens Sites Eclipse 4 2 Juno http download eclipse org releases juno Disabled Edi o 7 j sn 7 Al OpenPowerNet update http download openpowernet de 1 5 update Enabled a p a l Subversion http download eclipse org technology subversive 1 0 update site 1 0 1 Disabled A PSC Viewer Diagram l Subversion Connectors http community polarion com projects subversive download eclipse 3 0 update site Disabled gt Team Reload Validation Enable XML Export AN Q Figure 1 The available software site lists all available update locations Use the button Add from the dialog in Figure 1 to specify the update directory of the installation DVD Then the dialog from Figure 2 will open Use the button Local to add the update folder from DVD e g F update in case the DVD drive is mounted as F Press OK to close the dialog G h Add Site
Download Pdf Manuals
Related Search