BExIS 2.7.0 Installation Manual - Friedrich-Schiller
Contents
1. Establishing connection Done 2 3 2 DB2 Express C 2 3 2 1 Download DB2 Express C Depending on your hardware and your installed OS select either the 32bit or 64bit version from the following link Download DB2 Express C Log in with the IBM user account If you have no IBM user account you tions Services Products Support downiosdisr My IBM Vesicome Davis Siaa Not you7 BM Sign in DB2 Express C database server need to create one Returning visitors New visitors monet IBM ID usually e mail address ir Qro xi without an IBM ID Forgot your fal Consider the benefits and ID Once you are registered return to this Getan IBM IT page to sign in 2Download DB2 Express C 2 3 2 2 Installation of DB2 Express C Execute the downloaded installer file exe FEST a T Welcome Welcome Install a Product Release information Fe Pre installation planning gt Click Install New to launch the DB2 Setup wizard for the desired product and to install the de product to a new location If you want to update upgrade or add features to an existing Upgrade information product click Work with Existing You can also launch other product installations by clicking Install for the corresponding product gt Install a Product i Install Data Studio DB2 Express C Version 10 1 2 components a DB2 Express C Edition has the same base functionality of DB2 Enterprise S2. m a e n amp 5 ISAPI Extensions Ju ISAPI Filters Server Side Includes Common HTTP Features a Health and Diagnostics SSsqg E E3 E E E E E d Performance Features m Security FE Internet Information Services Hostable Web Core al am First select Internet Information Service IIS and Wi Media Features m E Microsoft NET Framework 3 5 1 m EL Microsoft Message Queue MSMQ Server O p e n t h i S n O d e m Print and Document Services D Remote Differential Compression Open Web Management Tools and select tick o IIS Management Console o IIS Management Scripts and Tools o IIS Management Service Below IIS open World Wide Web Services Application Development Features and select tick o Net Extensibility o Asp o Asp NET Click OK Button 3 2 Register Net Framework 4 0 in IIS o Open cmd as administrator and go to folder windir Microsoft NET Framework64 v4 0 30319 or windir Microsoft NET Framework v4 0 30319 o type here aspnet_regiis exeir 4 Deploy BExIS web application 4 1 Configure server components Perhaps some of the following configuration settings are already in place But please check them out 4 1 1 Create application user Open Control Panel Administrative Computer Management Select Local Users and Groups Select Users and right click it Open New User o Add a user called
3. Password ERSTE Test connection 6 Administration Explorer Task Launcher New database 3 _ bie sx z f nn o Ei New SS E ds 2 New database All e a T d New application development or testing might require you to create a new database 3 DB u a E Learn about database design View the command reference 5 localhost 50000 DB2_01 gt Connection localhost DB2_01 Not applicable amp Working Sets Settings Specify any additional settings to use Click Run when you are done lt Preview Command f Run 1 Detais Specify the information for the new database 2 Storage 3 Locale R Enterthe name for the database and tailor the database to your requirements For Windows If DB2_CREATE_DB_ON_PATH is not set or set to NO the database location can only be a letter drive Database name a Database location Alias Comment E Restrict access to system catalogs Default buffer pool and table space page size Default 4KB v u u Default extent size 1 256 5 Data Project Explorer 8 p BS Oo Number of segments in default table spaces 1 256 Choose a database name e g BExIS and select Run Enter your db2admin password again After successful creation you will see the new database under your Instance in the left side File Edit Navigate Search Project Data Run Window Bee Task Navigator DI d T Administration Explorer aes Fl
4. 6 1 IBM Installation Manager More info Repository C Users admin AppData Local Temp pft22C0 tmp Accept the license agreements ll a IBM Installation Manager PS eas Install Packages 4 Read the following license agreements carefully Install Licenses Location Features Summary IBM Data Studio client International Program License Agreement a IBM Data Studio client La Noti Part 1 General Terms otices IBM DB2 Analytics Accelerator Studio By DOWNLOADING INSTALLING COPYING ACCESSING CLICKING ON AN ACCEPT BUTTON OR OTHERWISE USING THE License Agreement PROGRAM LICENSEE AGREES TO THE TERMS OF THIS AGREEMENT IF YOU ARE ACCEPTING THESE TERMS ON BEHALF OF Notices LICENSEE YOU REPRESENT AND WARRANT THAT YOU HAVE FULL AUTHORITY TO BIND LICENSEE TO THESE TERMS IF IBM Installation Manager YOU DO NOT AGREE TO THESE TERMS license Agreement DO NOT DOWNLOAD INSTALL COPY ACCESS CLICK ON AN ACCEPT BUTTON OR USE THE PROGRAM AND PROMPTLY RETURN THE UNUSED MEDIA DOCUMENTATION AND PROOF OF ENTITLEMENT TO THE PARTY FROM WHOM IT WAS OBTAINED FOR A REFUND OF THE AMOUNT PAID IF THE PROGRAM WAS DOWNLOADED DESTROY ALL COPIES OF THE PROGRAM 1 Definitions Authorized Use the specified level at which Licensee is authorized to execute or run the Program That level may be measured by number of users millions of service units MSUs Processor Value Units PVUs or other level of use specified by IB
5. Glara Server Groups E B Servers 1 S PostgreSQL 9 3 localhos H E Databases 2 GS Tablespaces 2 ey Group Roles 0 H A Login Roles 1 Retrieving details on databases Dq 4 1 4 2 Create empty database on DB2 If you already have a database from a previous release you can skip this step Open IBM Data Studio as admin On first startup IBM Data Studio will ask for a workspace use the selected one Select a workspace IBM Data Studio stores your projects in a folder called a workspace Choose a workspace folder to use for this session Workspace Use this as the default and do not ask again On the left side you find all databases Click the dropdown button New in the Administration Explorer panel Select New Database ia eae ene SS a oa a ee a Lid Administration Explorer _ O EE Task Launcher 2 S E New E oo ed a All Da 2 New Connection to a database jew i A 5 F New Database y di New SQL Script ask Oven Workin g Sets Desic Tasks Now connect to your instance Default Values o Host Name localhost o Port 50000 o Instance DB2 Choose Version 10 1 Add db2admin with password and test connection f a New Database Specify instance details Instance details DB2 for Linux UNIX and Windows Host name localhost Port 50000 Instance name DB User name db2a Admin
6. connection between server e g web server that is hosting the website and client typically a browser That connection allows sensitive information e g login credentials to be transmitted securely through the web Otherwise that data would be sent as plain text between browsers and web servers leaving you vulnerable to eavesdropping If an attacker is able to intercept all data being sent between a browser and a web server they can see and use that information You are free to enable or even enforce SSL for your website inside IIS Internet Information Service Just use the following steps Gy Internet Information Services MS Manager 2 G SERAPH Sites BENS i 0 Open IIS Fie View Help Connections Actions a BEAS Home 2 elect proper wepsite lETT pane a 3 SERAPH SERAPH Sven A ie d Application Pool Filter we Show All Group by Ares v r J App ools my 78 a ze Select Bindi right seus 4 elec InNaINgS Fl ane A App at V Areas NET NET JET Error ET T Profile JETT Applicatio ec Machine Key bun npil Pages i L Settings J F Content g Scripts g w Manage Web Site 1 Themes Pages and SMTP E mail z Views 2 Workspac a Browse Web Site a a a amp is w Authentic Auti horizat ca mpress fault Dire Error Pages Fail Rules Document Browsing equest Tra m Configure sb gt hi ae m Er 2 io laj J r a Handler HTTP HTTP IP Address ISAP Filters Leggi
7. file name E users acmin Documents PROD_EXPC rsp InstallShield Select the installation folder use the default path J DB2 Setup D82 Express C DB2COPY1 The DB2 Setup wizard installs DB2 Express C in the following folder To select a different folder click Change or type a directory Directory C Program Files VEMISQUIB Space required 1029 MB InstallShield Use default J DB2 Setup DB2 Express C DB2COPY1 Select the IBM SSH server installation folder and startup option The IBM Secure Shell SSH server for Windows provides a secured platform to run commands from remote machines The DB2 setup wizard installs IBM SSH server in the following folder To select a different folder click Change Directory or type a directory Directory c Program Files IBM IBM SSH Server Space required 1029 MB The IBM SSH server can be automatically started at the system startup or it can be started manually from the Windows services dialog Autostart the IBM SSH server at system startup Choose this option if you are installing SSH the first time and have no other SSH servers on the system Do not autostart the IBM SSH server Choose this option if you already have a third party SSH server running to avoid conflicts in your SSH settings You must start the IBM SSH server manually InstallShield Canel te Define the db2admin password Please make sure you recall the
8. uni jena de bexis download and unzip the file 2 1 NET Framework 4 0 Open folder Prerequisites NET 4 and start dotNetFx40_Full_ x86_x64 exe as admin Or download it here Download net Framework 4 0 follow the steps in the installation window 2 2 ASP NET MVC 3 Open folder Prerequisites ASP NetMVC3 and start MVC3 exe as admin Or download it here Download ASP NET MVC 3 follow the steps in the installation window Web Platform Installer 4 5 PREREQUISITES INSTALL ONFIGURE FINISH fof following list of third party application software Microsoft products and components to be installed and ponentsto be turned on Third party applications and products are provided by the third parties listed riti ants you no rights for third party software You are responsible for and must separately locate reac iner d party license terms ASP NET MVC 3 Tools Update Installer Dependency 20 39 MB View license terms Direct Download Link Privacy Terms Total file download size 20 39 MB By clicking I Accept you agree to the license terms for the third party and Microsoft software listed above If you do not agree to all of the license terms click I Decline 1 First step shows the prerequisites of mvc3 After the Prerequisites window another window with some installation options will appear Go to Products Select Frameworks Here you need to find MVC3 and NET 4 If this not ins
9. BExIS 2 7 0 Installation Manual Authors David Blaa Andreas Ostrowski Nafiseh Navabpour Roman Gerlach Contact Website http fusion cs uni jena de bexis Email bexis support uni jena de Phone 49 0 3641 948968 Acknowledgement The development of the BExIS software would not be possible without the German Research Foundation DFG funding the BExIS project BExIS is a collaboration of the Friedrich Schiller University Jena Germany Dept of Computer Science Dept for Geography Dept of Ecology and the Max Planck Institute for Biogeochemistry Jena Germany Content 1 2 5 BES PACK Eee a oe ee 3 Additional Software Prerequisites ueeessssssssssnnnnnnnnnnnnnnnnnnnnnennnneennssnnnnnnnnnnnnnnnnnnnnnnnnnnesessnnnnnnnnnn 3 2 NEFT OMEWOIKAN nee ee 3 22 PSP INE MYC een neueren 3 23 Datibase 5 SCC ee ee ee en ee ee een 4 2 3 1 POP ES ee ee ee een 4 2 311 Download PostgreSQL usa 4 2 3 1 2 HStallatlon or Pos ere Oe een een 4 2 3 2 DPR2EIDES SS ne ee ee ee ee 5 2 3 2 1 Download DB2 Express nee ee ee 5 2322 Installation OF DB2 EXhresst ann 5 2 3 2 3 Install IBM Data Studio cccccccccssssssseccecccecaeesseeecccccsseeesseecceceessauasseeeceeesssaaeaseeeeeees 8 Setup Internet Information Service IS nenn 12 Sl Ace NST ee ee ee ee ee ee 12 3 2 Register Net Framework 4 0 in IIS ee cseessssssessnessessnennnesnnnnnennnnnnnsnnnnnennnnnnennnnnnnnsnnnnnennnnnnn 12 Deploy BEXIS WED app
10. L Settings 2 eG mii SERAPH SERRE LI en This page lets you modify the SSL settings for the content of a Web site or application _ e Application Pools sie Require SSL Beds Client certificates App_GlobalResour T Areas Ignore F bin Accept a Sanien Require E Script gt Them A View E Worksp a N E Features View Content View Configuration localhost applicationHost config lt location path BExS gt amp kK 4 2 3 Start Website Open the IIS and select your Website Start your website Click it and choose Start on the right side Open Browser and enter localhost open configuration file C inetpub wwwroot Your_Websitename Web config with a text editorset CreateDatabase to false in section appSettings 5 Errors ERROR 08004 IBM SQL30061 Check if database exist If not create this database name in the connection string o Localhost 50001 Check SSL settings in Browse Web Site by clicking on Browse 443 https right panel Web Browser should bring up the website in https if everything is set up in the right way It s possible to run the website in https ONLY Select proper website left panel Select SSL settings Tick Require SSL Click Apply right panel If you run more than one instances of db2 you need to add another port number to the server ERROR 08001 IBM SQL30081n Please check if
11. M IBM International Business Machines Corporation or one of its subsidiaries License Information LI a document that provides information and any additional terms specific to a Program The Program s LI is available at www ibm com software sla The LI can also be found in the Program s directory by the use of a system command or as a booklet included with the Program Program the following including the original and all whole or partial copies 1 machine readable instructions and data 2 components files and modules 3 audio visual content such as images text recordings or pictures and 4 related licensed materials such as keys and documentation Proof of Entitlement PoE evidence of Licensee s Authorized Use The PoE is also evidence of Licensee s eligibility for warranty future update prices if any and potential special or promotional opportunities If IBM does not provide Licensee v Print All I do not accept the terms in the license agreements eres eee O r Specify directories for default is ok o Shared Resources o Installation Manager Specify the directory for the IBM Data Studio default is ok Select a language Choose configuration of the help system Access help from the Web Start to install After the installation of DB2 and IBM Data Studio you need to check if the database groups DB2ADMNS and DB2USERS are registered Control Panel Ad
12. New ote FE pay ed a All Databases H DB BEXIS bgc jena mpg de 4 5 localhost a amp DB Eg BEAIS DB2 Alias gt EB TOOLSDB DB2 Alias gt amp DB2 01 E Working Sets 4 2 Install BExIS package 4 2 1 Deploy Website new installation 1 Copy all files from the application folder BPPR27 Website of your unzipped BExIS 2 7 0 full package folder to C inetpub wwwroot Your_Websitename 2 Copy the whole workspace folder Workspace from your unzipped BExIS 2 7 0 full package folder to C inetpub wwwroot 3 open configuration file C inetoub wwwroot Your_Websitename Web config with a text editor o check and adapt database name in section connection strings o set CreateDatabase to true in section appSettings ATTENTION If you want to use an existing database with data inside set CreateDatabase to false otherwise the database will be cleared o check and adapt workspace path in section appSettings o check and adapt Data path in section appSettings 4 The IIS_IUSRS user need modify permissions to the same folders and files o BExlSppTemplate_Clean xlsm under Workspace path Modules RPM Template o Lucene folder under Workspace path Modules DDM o Data folder under Data path 4 2 2 SSL Setup Nowadays the demand of security in the internet is increasing tremendously An important step to achieve that requirement is using SSL Secure Sockets Layer With SSL it is possible to establish an encrypted
13. applications Built to extend the Eclipse framework and SQL model components combines Eclipse technology and shared repository extensions for database development Download IBM Date Studio Learn More About IBM Data Studio 2 3 2 3 Install IBM Data Studio Select Download IBM Data Studio SEEN http www ibm com develop O BOX ED Download IBM Data Studi X Downloads IBM Data Studio provides database developers and DBAs with an integrated modular Technical environment for development and productive administration of DB2 for Linux UNIX and ay Windows databases It also provides collaborative database development tools for DB2 for Community amp forums z OS DB2 for i and Informix databases Additionally you can optimize secure and simplify database applications that are enabled with infoSphere Optim pureQuery Runtime Note Data Studio now includes Optim Development Studio Optim Database Administrator Data Studio Health Monitor and the client for InfoSphere Optim Query Workload Tuner You can also download the IBM DB2 Analytics Accelerator Studio with the Data Studio client Considering a purchase Request a quote Email IBM Or call us at 800 966 9875 Priority code 109HFOIW Related links IBM software downloads IBM software product finder Product main page Overview of Data Studio components Supported data servers by feature so IBM Data Studio is a fully li
14. censed product available at no charge and with no time restrictions System requirements Quick start installation instructions Product support 7 a Tell your boss Use IBM Installation Manager to select download and install only the code features or product extensions that you want Product extensions allow you to extend your install beyond the Data Studio feature set To download the full product images for all platiorms see the Optional downloads section For most installations you need the client component for job management and health monitoring you also need the web console component Component Version Size Method Operating system Data Studio client and V3 2 3rd party product extensions Red Hat Linux SUSE Linux Windows 112MB Installation Manager Data Studio Web Console V3 2 Red Hat Linux SUSE Linux Windows 112MB Installation Manager Third party product extensions for the Data Studio client IBM DB2 Analytics Accelerator Studio V3 1 is a component of the DB2 Analytics Accelerator for z OS program that provides a GUI for the administration of DB2 Analytics Accelerator For Linux operating systems You cannot install or upgrade to the 64 bit version of IBM Installation Manager if existing 32 bit products are installed on your computer The 32 bit products that you previously installed with Installation Manager do not support the 64 bit version of Installation Manager You must
15. download the 32 bit version of the Linux package which includes a 32 bit version of Installation Manager You can use the 32 bit version of Installation Manager to install either a 32 bit or 64 bit version of the product Download Integrated data management Managing data across ils lifecycle Optimize database application performance pre and post production Essential resources Getting started with IBM Data Studio for DB2 Data Studio information center Forum Data Studio DB2 e kit for Database Professionals Select the first one Data Studio client and 3rd party product extensions Red Hat Linux SUSE Linux Windows OR Start the installer shipped with the Prerequisites zip file o Open folder Prerequisites IBM Data Studio o Start IBMIM_win32 exe as admin Password from the IBM Account is required The IBM Installation Manager Select all packages and click next IBM Installation Manager a m Install Packages Select packages to install Installation Packages Status Vendor License Key Type BD IBM Installation Manager AG Version 1 6 1 Will be installed IBM No key required W IBM Data Studio client W lip Version 3 2 0 0 Will be installed IBM 7 iy IBM DB2 Analytics Accelerator Studio E E Version 3 1 0 0 Will be installed IBM Corporation E Show all versions Check for Other Versions Fixes and Extensions Details IBM Installation Manager 1
16. e Key 2m h anen Daner ne MD Somane x 1 mE i change it Scripts z Manage Web Site Themes Pages and Tyi Type P add Port i z e fe Be e A a roo ee ra Select SSL certificate 7 z b Browse Web Site u En z Confirm settings by clicking OK Not selected i 1s Configure Hendler meel put Mappings 9 Deploy Reque L ings rite WebDAV 2 Fiherin Author amp Management 2 oO o Configurat Web Edie Piatfor F onten amp Internet Information Services IS Manager File View Help Connections a Q gt SERAPH Sites BEIS ted BExIS Home 4 amp SERAPH SERAPH Sven 2 Application Pools 4 8 Sites 4 BEAS Pr App_GlobalResour C Areas Filter Go g1ShowAll Group by Area ASP NET a oe ope RB ASP Authentic Authorizat CGI Compression Default Rules D Request SSL Settings URL Rewrite WebDAV Authori Filtering Authori N E Features View liz Content View BH amp R NET NET NET Error NET NET Profile NET Trust Application Connection Machine Key F bin Authorizat Compilation Pages Globalization Levels Settings Strings an Conte m E Script g T Them Pages and Session State SMTP E mail Views Controls E Works Bs p Is g er W 4 d o Ready amp m amp Internet Information Services IS Manager B xs Go gt SERAPH Sites BENS gt lg File View Help Connections SS
17. erver Edition but with limits Exit on the number of CPUs and amount of memory DB2 Express C Edition is targeted to meet the needs of the small and medium business SMB market This productis available for Linux and Windows operating systems If you require IBM support and maintenance for this no charge data server you can purchase it with a renewable 12 month subscription Choose the installation type typical is appropriate in most cases J DB2 Setup DB2 Express C DB2COPY1 Select the installation type Approximately 600 800 MB Approximately 600 800 MB Approximately 600 1200 MB Information about the installation type The typical setup includes basic database server function database administration tools and most product features and functionality To add features for application development and other optional functionality later in the setup process click Custom InstallShield Select Installation or response file or both J DB2 Setup DB2 Express C DB2COPY1 Select the installation response file creation or both The DB2 Setup Wizard can install DB2 Express C on this computer create a response file that you can use to install this product on a computer later or both Install DB2 Express C on this computer Save my installation settings in a response file No software will be installed on this computer t Install DB2 Express C on this Response
18. lication berace 13 Ad Configure server COMPONENTS nenne 13 4 1 1 Create application USer een 13 4 1 2 Oi UI I ea ee ee ee 13 4 1 3 AS WV DIE ee E E erg 13 4 1 4 Create empty Cea aD Presenter 14 4 1 4 1 Create empty database on POStEreSQL ccccccessccceessececeesececceseceeeeeseceeseeceeeuecesseeeeeeees 14 4 1 4 2 Create empty database on DB2 un ehe 15 4 2 WAST DES Backare een een 18 4 2 1 Deploy Website new installation cescccccccssssecceeceeseececeeeeseeceeseeeeeeceeeeeeeeeeeseeeenes 18 4 2 2 SEALE WERE nee een 18 OU e ee Da ee ee 20 ERROR 08004 IBM SOL30061 eee eecccccccsssesssseeccccesseeesseeececeesseeesseeececeesseeeaseeeseeesssaaaaeeeeeess 20 ERROR 08001 IBM SOL30081n eee eecccccccssassssseececcesseeessecececeesseaeseecceceessueauseeeceeesssaaaaeeeeeeess 21 ERROR EIITR ERRORAOS EA esse ea ne rare 21 ERROR HTTP ERROR 404 2 seascair nir are enera r AE EN E ENEE ANa EAEri 21 ERROR SOLTE ee E E E 21 1 BExIS Package First download following package from http fusion cs uni jena de bexis download BExIS_2 7 0_full zip For a new installation Unzip BExIS 2 7 0_xxx zip Usage of contained files and folders is described in section 4 2 Additional Software Prerequisites The following software is needed to run the BExIS web application If they are installed on your computer already please jump to section 3 If not please download Prerequisites zip from http fusion cs
19. ministrative Tools Computer Management Local Users and Groups File Action View Help Bl AG a2 BR EY Computer Management Locall Warne Description 5 if yami Taos Jel Administratoren Administratoren haben uneingesc d ras Fe Benutzer Benutzer k nnen keine zuf lligen a a Distributed COM Ben Mitglieder dieser Gruppe k nnen a en Geass a Ereignisprotokollleser Mitglieder dieser Gruppe d rfen E I G ste G ste besitzen standardm ig die Groups Hauptbenutzer Hauptbenutzer sind eingeschlos by amp Peformance Jel TS IUSRS Von Internetinformationsdiensten ge Kryptografie perator ge Leistungsprotokollbe Fe Leistungs berwachun Die Mitglieder sind berechtigt kry Mitglieder dieser Gruppe k nnen gay Device Manager a EH Storage Disk Management Mitglieder dieser Gruppe k nnen gt Es Services and Applications Ze Replikations Operator DB2ADMNS Ze DB2USERS 8 Helnl ihrarvl Indaters Db2 Groups a Netzwerkkonfiguratio ge Remotedesktopbenut de S cherungs peratoren Mitglieder dieser Gruppe verf ge Mitglieder dieser Gruppe haben di Unterst tzt Dateireplikation in Do Sicherungs Operatoren k nnen i Diese Gruppe und lokale Administ Diese Gruppe erh lt ber das Betri f not you need to create these groups o Right click on groups and select new group o First Group DB2ADMNS and add the db2admi
20. n on cookies You can now hide this message or find out more about cookies j Blog Forum Login Register Downloads g sms Store S Contact Us 000060 somom a ENTERPRISE Products Services Training Solutions Success Stories Resources Partner Programs About Us Download PostgreSQL Advanced Serve sehen NOTE April 4 14 The installers for PostgreSQ 43 9 1 to inch t T tgr Please Not atf A Linux x86 32 A Linux x66 64 Ay Win x86 32 ay Wein xB8 64 ff Moc OSX ni anag atior taller version Version 9 1B Replication A Linux x86 32 A Linux x86 64 ae Win x86 32 Ae Win xassa fi macosx 191 taste 2 3 1 2 Installation of PostgreSQL The installation of PostgreSQL is easy It is enough to run the Installer and follow the steps During installation when asked please e enter postgres as user e enter 1 as password e enter 5432 as port number Launch Stack Builder that is asked in the last step is not recommended When the installation is finished run PgAdmin and add a connection to the server that you want to work on it OP pgAdmin I hn un 6 File Edit Plugins View To FIG On Ser Regi ee SSL SSH Tunnel Advanced Object browser Name bE Server Groups j Host E i Databases 2 H H Tablespaces 2 Ag Group Roles 0 4 Login Roles 1 Port Service Maintenance DB postgres Username postgres Password Store password V Colour Group Servers
21. n to this group and select create DEZADMNS Create DBZADMNS group Second Group DB2Users 3 Setup Internet Information Service IIS IIS is needed to host a website on the server If your IIS is already activated and NET framework is registered move on to section 4 If you don t know if your IIS is activated or if NET is registered please follow the steps below 3 1 Active lIS7 Open Control Panel Programs and Features Onthe left side click the Turn Windows features on off link S F TER u Turn Windows features on or off Kena F l Control Panel All Control Panel items Pro grams and Features To turn a feature on select its check box To turn a feature off clear its check box A filled box means that only part of the feature is turned on amp 972 Control Panel Home h Internet Explorer 9 ree 5 Internet Information Services Uninstall or change a program Dana 5 E Web Management Tools I 156 Management Compatibility u IS Management Console 5 IS Management Scripts and Tools I IS Management Service World Wide Web Services ead CCC View installed updates To uninstall a program select it from the list at j E Turn Windows features on or off a m Organize Application Development Features 2 NET Extensibility Install a program from the Asp v ASP NET network Name E 7 Zip 9 20 x64 edition E AccelerometerP11
22. ng MIME Types Modules Output Mapping Redwect Respon and Doma Cachir gt Deploy ih t 1 SSL Settings UR ed me itho utn amp ment D oO t Web Piatfor Feat Ready Sy Internet Information Services MS Manager 5 G gt SERAPH Sites gt B amp S tti lt i OSOSCS S E i ng Select Add u n Fie View Help z Connections Actions XIS Hom ey BEXI e 2 u SERAPH SERAPH Sven sa Filter we Show All Group by Ares J Application Pools Edit Site W Sites ASP NET Bed 4 9 App_Glob oh u Areas JET NET JET NET ET f NET Trust pl Connection Machine Key Liahsiasiina men Kage aj ben ar Bindirs T i Cont a 7 E ip Manage Web Site T Themes p d Type HostName P IP Address ding I Add Fes l http amp x k a t Browse Web Site gt ed tTra Configure If Handler lose p Mappings 1 Deploy 2 amp 2 oo Req SSL Settings DA 2 Fites thor f utho ment 2 oO onfigurat Web Piatfor F View vt Ready a Gy Internet Information Services as Manager amp e E s gt SERAPH Sites BENS ZZ a a u w h u ee en E Select https as Type Connections Exs Home T Check Port by default this is 4 SERAPH SERAPH Sven a 2 a Filter we Show All Group by Ares bd u Application Pools Edit Site 2 443 but maybe you have to m a ne Resour wa y re in y y _ Areas NET NET NET NET T Profi NET Trust Appl nnectio Asch n
23. password later on J DB2 Setup DB2 Express C DB2COPY1 Set user information for the DB2 Administration Server The DB2 Administration Server DAS runs on your computer to provide support required by the DB2 tools Specify the required user information for the DAS It is highly recommended that you use a local user or domain user account instead of the LocalSystem account Further details are available by clicking Help Fonnssnnsunsssusssnssusnssusssnnsenssunsnsnsssnssunsssunssnnsenssnnsssunsunnsunnser Local user or Domain user account User information Domain None use local user account db 2admin u User name V Use the same account for the remaining DB2 services InstallShield Welcome First Steps gets you up and rumning quickly on IBM OB2 Version 10 1 for Linux UNIX and Windows with links to useful references common tasks and tooling lt p SEES Laurn more about getting stertad with O52 Version 10 3 with formation for first time users upgrading to 10 1 enabling the DEZ oureScale Feature and migrating applications to DE2 Vi0 1 Getting Started Creete o sampile database to start working with DB2 V10 1 reste sample database Download IBM Data Sugo database management and appbcation development tools IBM Data Studio provides applicat on developers with a single integrated davalopmant environment that can ba used to create deploy and dabug data centric
24. rties Stop your website Click it and choose stop on the right Net Framework Version 4 0 side Pipeline mode Integrated Site name bexispp ASP NET v4 0 Content Directory Physical path C inetpub wwwroot BExISpp Pass through authentication Connect as Test Settings Binding Type IP address http v All Unassigned Host name Example www contoso com or marketing contoso com V Start Web site immediately 4 1 4 Create empty database Depending on which database system is installed on your computer and you prefer to use PostgreSQL or IBM DB2 you need to create an empty database before you are able to restore one of the two databases provided with the BExIS installation package 4 1 4 1 Create empty database on PostgreSQL Open pgAdmin Double click on the PostgreSQL 9 3 localhost 5432 A popup window will open where you need to enter the password for user postgres Please enter 1 as the password you defined when you installed PostgreSQL Server Groups El B Servers 1 Value 4 i PostgreSQL 9 3 localhost 5432 vr PostgreSQL 9 3 E localhost Please enter password for user postgres on server PostgreSQL 9 3 localhost E Store password Retrieving details on server localhost Done 0 00 secs Then in the Object browser section Right click on Databases node and create a new database Enter BExIS as a database name C3 pgAdmin II
25. standard o Specify a password for your user o Click Create New User m S lt Standard Properties a g User name standard Full name standard J DB2ADMNS Description Bexis App User Password Confirm password Changes to a user s group membership are not effective until the next time the user logs on Gwen So The user must be a member of the group DB2ADMNS Right click on standard user and open properties o Select the Member Of tab o Click Add Click Advanced Click Find Now o Select DB2ADMNS Group and click OK 4 1 2 Configure IIS Configure application pool o Open IIS Control Panel Administrative Tools o Select Application Pools and right click in ASP NET v4 0 and select Set Application Pool Defaults Change General Enable 32 Bit Applications to True Change Process Model Identity to NetworkService 4 1 3 Create Website Open IIS Control Panel Administrative Tools Stop Default Website Click it and choose stop on the right side Create anew Website right click on sites and choose Add Web Site Select Application pool ASP NET v4 0 not Classic Select physical path Select Application co C inetpub wwwroot Your_Websitename Application pool ASP NET v4 0 r Confirm your selections by pressing the ok button Prope
26. talled click on the add button and start the installation E Web Platform Installer 4 5 u Spotlight Products Applications P Name Released Install EAN OEE Django 1 4 Python 3 23 2012 Add H Server Frameworks a MySQLdb 32 bit Python 2 7 7 22 2010 Add Database Tools J Workflow Client 1 0 Beta 6 14 2012 Add Windows Azure evr Windows Identity Foundation 2 17 2012 Add sw Node js extensions for IS 7 x 9 22 2011 Add AMIR ASP NET MVC 4 with Language Packs August 2012 8 15 2012 Add U KT ASP NET MVC 3 Visual Studio 2010 4 11 2011 Installed Vi ASP NET MVC 3 Tools Update Language Packs 5 10 2011 Add sw Microsoft NET Framework 4 4 12 2010 Installed sw NET Framework 3 5 SP 1 11 18 2008 Installed a Windows PowerShell 2 0 4 16 2010 Installed ate 222 f 0 Items to be installed Options Install Exit 2 3 Database System BExIS 2 needs a database management system to be available on your server You are free to choose between PostgreSQL and IBM DB2 Express C If not available already please follow one of the installation instructions below 2 3 1 PostgreSQL 2 3 1 1 Download PostgreSQL Depending on your hardware and your installed operating system select either the 32bit or 64bit version from the following link http www enterprisedb com products services trainin download windows Thank you for accepting cookies Hide this message More informatio
27. the Database Instance is running If not start the instance ERROR HTTP ERROR 403 14 Net is not registered for IIS 7 Open the BExIS 2 7 0 folder and start aspnet_regiis exe as admin ERROR HTTP ERROR 404 2 change apppool in II7 to integrated asp net 4 ERROR SQL1159 Initialization error with DB2 NET Data Provider reason code 10 for user IIS APPPOOL ASP NET v4 0 has something to do with App pool identity Set the app pool identity as Network service this group has already read access to C Program Files IBM SQLLIB BIN Open IIS Select Application Pools and right click in ASP NET v4 0 and select Set Application Pool Defaults Process Model Identity change to NetworkService
Download Pdf Manuals
Related Search