Transcript
STATISTIC SWEDEN
Installation guideline
Installing PX-Web 2008 on Windows7, IIS7 Peter Holm 2011-04-18
This is a first version of on guideline for installing PX-Web on Windows 7 and IIS7. Installation is done on a Win7 with 32-bits system but some necessary actions for 64-bits system are mentioned. www.scb.se/pc-axis
Author: Peter Holm
Date: April 2011
Content 1.
Prerequisites.................................................................................................................................... 2
2.
Install and configure IIS7 ................................................................................................................. 2
3.
Install PX-Web components ............................................................................................................ 3
4.
Install PX-Web Asp-files................................................................................................................... 6 4.1.
5.
6.
Configure folder permissions .................................................................................................. 6
4.1.1.
Write protection .............................................................................................................. 6
4.1.2.
Write permissions............................................................................................................ 7
Configure IIS7 .................................................................................................................................. 9 5.1.
Start IIS manager ................................................................................................................. 9
5.2.
Add application pool ......................................................................................................... 10
5.3.
Allow use of 32-Bits programs (applies to 64-Bits OS only) .............................................. 10
5.4.
Add Webb site ................................................................................................................... 11
5.5.
Activate parent search path .............................................................................................. 13
5.6.
Set folder permissions for Application pool ...................................................................... 14
Test IIS ........................................................................................................................................... 17
1
Author: Peter Holm
Date: April 2011
1. Prerequisites In most of the actions described in this guideline is it necessary to be logged in as administrator or having administrator rights on the local machine. This guideline is using PX-Web 2008 installed on a Swedish version of Windows 7, 32-bits OS, IIS7 and MS Office 2010. Because of the fact that this guideline is based on a Swedish PC some translations and images may vary to your PC.
2. Install and configure IIS7 Let’s start with installing and configuring IIS7. Navigate to Control panel -> Add/Remove programs -> Activate or inactivate Windows-functions. Select “Internet Information Services”
2
Author: Peter Holm
Date: April 2011
Make sure that the option for supporting classical Asp is selected:
Press OK and let the installation proceed. Close all open Windows after finished installation.
3. Install PX-Web components Open your browser and navigate to http://www.scb.se/Pages/List____314056.aspx and download installation components for your version of PX-Web. Extract the Zip-file locally on your machine. Right click on the setup file and click on Run as administrator. If you get any questions or warnings before installation starts, press Allow or Continue.
3
Author: Peter Holm Click Next.
Click Next.
4
Date: April 2011
Author: Peter Holm Click Next.
Installation is proceeding.
5
Date: April 2011
Author: Peter Holm
Date: April 2011
Click Finish.
Installation of necessary PX-Web components is now finished and we can proceed with installing Asp-files.
4. Install PX-Web Asp-files To make sure that everything is working properly is it advisable to download and install a test application and database. In your Internet browser, go back to the download page (http://www.scb.se/Pages/List____314056.aspx) and download the Asp-files and test database. Extract all files into a new folder located in inetpub\wwwroot folder called pxweb2008. Extract to the path C:\inetpub\wwwroot\pxweb2008.
4.1.Configure folder permissions Before proceeding, we need to set some permission on some folders for PX-Web database. 4.1.1. Write protection Open explorer and navigate to the C:\inetpub\wwwroot folder. Right click the pxweb2008 folder, click on Properties. If the Write protected check box is ticked, unselect it and click Apply. Click OK to make sure that this action will be done on all subfolders and its content.
6
Author: Peter Holm
Date: April 2011
4.1.2. Write permissions Open the pxweb2008 folder and right click the Database folder, click on Properties. Click on the security tab and check if the user Everyone exists.
If not, click on Edit, Add, write Everyone and click on Check name.
7
Author: Peter Holm
Date: April 2011
When Everyone is found, click OK to go back to the security tab. Tick all the check boxes to make sure that user Everyone has full read and write permission to the database folder.
Click OK to return to Explorer. Repeat the actions in 4.1.2 for the C.\inetpub\wwwroot\pxweb2008\temp folder as well.
8
Author: Peter Holm
Date: April 2011
5. Configure IIS7 We now need to configure the IIS for our PX-Web application. 5.1. Start IIS manager Go to Control panel, System and security, Administration tools and open the IIS7 manager. It should look something like the picture below but this can vary depending on if IIS is newly installed or not:
9
Author: Peter Holm
Date: April 2011
5.2. Add application pool Either right click below Connections and choose Add application pool, or click on Add application pool below the panel Action to the right. Give the Program pool a name, e.g. pxweb and click OK.
pxweb should now exist in Application pools.
5.3. Allow use of 32-Bits programs (applies to 64-Bits OS only) If you are running on 64-Bits system you need to configure the IIS to use of 32-Bits programs. Select your pxweb2008 Program pool and select Settings. Make sure that the option Activate 32-Bits applications is set to True.
10
Author: Peter Holm
Date: April 2011
5.4. Add Webb site Right click your top node in the connection window and choose to Add a new website. Enter pxweb2008 as the name of the site.
Press the Choose button to select your previously made pxweb Program pool.
Press OK and you will return to the Add website form.
11
Author: Peter Holm
Date: April 2011
Click on the button (…) to choose the physical path to your application. Browse to and select your C:\inetpub\wwwroot\pxweb2008 folder.
Press OK to return to the Add website form.
12
Author: Peter Holm
Date: April 2011
Keep port 80 if this is your first website, otherwise change it to something that isn’t used e.g. Port 81. Press OK and now should pxweb2008 website appears under the Websites folder.
5.5. Activate parent search path Select the pxweb2008 website in the connection window. Double click the ASP icon in the IIS section (make sure that View functions tab is selected, NOT view content) and change the option Activate parent search path to True.
13
Author: Peter Holm
Date: April 2011
5.6. Set folder permissions for Application pool To set the correct permissions for the IIS and application pool on the application folders follow this procedures. Open a command window as Administrator. Go to Start -> All programs -> Accessories, right click on Command prompt and choose Run as Administrator.
Next thing is to set permissions for your application pool to Database- and Temp-folder in your website application folder.
14
Author: Peter Holm
Date: April 2011
Type following at the command prompt: icacls C:\inetpub\wwwroot\APPLICATION_NAME\database /grant “IIS APPPOOL\NAME_ON_APPLICATIONPOOL”:(OI)(CI)M. Replace APPLICATION_NAME and NAME_ON_APPLICATIONPOOL with the name of your website and IIS application pool. For our application the first command will be: ICACLS C:\inetpub\wwwroot\pxweb2008\database /grant “IIS appPOOL\pxweb”:(OI)(CI)M Hit Enter. Execute the same command also for the temp table: ICACLS C:\inetpub\wwwroot\pxweb2008\temp /grant “IIS appPOOL\pxweb”:(OI)(CI)M Hit Enter.
Close Command prompt by typing exit and hit Enter.
15
Author: Peter Holm
16
Date: April 2011
Author: Peter Holm
Date: April 2011
6. Test IIS Now when everything is configured can we open IE Explorer to test the new PX-Web website. Open IE and type http://localhost:81/SelectDB.asp. Note that the port number may vary depending on what port you set when the web site was created in your IIS.
You will only have the Swedish database on your screen.
17
Author: Peter Holm Press Go and you should see something like this:
18
Date: April 2011
Author: Peter Holm Click on Database for Sweden and your screen should be similar to this:
19
Date: April 2011
Author: Peter Holm Click on Population and you should now come to the window for selecting table:
20
Date: April 2011
Author: Peter Holm
Date: April 2011
Let’s choose the first table, click on Select part, this brings us to the window where variables should be selected:
21
Author: Peter Holm
Date: April 2011
Select some rowes for each variable and press Continue:
This means that the installation and configuration of PX-Web and IIS7 is working and you can continue to implement your own databases in PX-Web.
22
