Web Application Installer

Updated Wiki: Home

bernhardfrank — Thu, 13 Nov 2008 09:02:52 GMT

As you have experienced yourself developing a web application isn’t that easy and quite time consuming. You spend a lot of hours thinking about software design, security problems and of course how to improve end user’s usability. Why not lowering the barrier for installing (trying out) your software - using a common technology.

Get the whole idea...

Goal:
This project will enable you to build a Windows Installer package for your Web Application within 30 minutes- by only utilizing open source software.
The following technologies are supported:

Scripting:

ASP.NET
PHP
Perl

Databases:

Microsoft SQL Server (2005 and 2008)
MySQL Server

See the steps - one by one: Screen1

You will be able to create a MSI that is cabable of:

Creating a new website
Adding a virtual directory to an existing website
Creating an application pool and setting up a website/folder as ASP.NET 2 application
Creating a new Microsoft SQL Database, Logins and Users
Configuring your web application (e.g. web.config) and setting values collected in wizard mode
A lot of user guidance, messages and validations

Lazy? Wan't to download something? Go FZI - these are packages the FZI has created an tested.

See: Projects using the WAI template

Don't believe it can be done in 30 minutes? - check it out!
web application installer - V2

Updated Wiki: Home

bernhardfrank — Thu, 13 Nov 2008 09:01:16 GMT

Scripting:

ASP.NET
PHP
Perl

Databases:

Microsoft SQL Server (2005 and 2008)
MySQL Server

See the steps - one by one: Screen1

You will be able to create a MSI that is cabable of:

Creating a new website
Adding a virtual directory to an existing website
Creating an application pool and setting up a website/folder as ASP.NET 2 application
Creating a new Microsoft SQL Database, Logins and Users
Configuring your web application (e.g. web.config) and setting values collected in wizard mode
A lot of user guidance, messages and validations

Lazy? Wan't to download something? Go http://paris143.server4you.de/pakete/ - these are packages the FZI has created an tested.

See: Projects using the WAI template

Don't believe it can be done in 30 minutes? - check it out!
web application installer - V2

Updated Release: web application installer - V2 (Oct 29, 2007)

bernhardfrank — Thu, 30 Oct 2008 13:34:02 GMT

This is the 2nd release of the Web Application Installer

You just need to unzip wai-2.0.zip into a directory of your choice and start reading "Creating a MSI for your Web Application.pdf" this will guide you through the process of creating your own Windows Installer (*.msi) file for your web application.

This will create *.msi packages to be installed on Windows Server 2003 (IIS6), Windows Vista (with IIS7), Longhorn Server (IIS7)

Added with version 2.0:
Added support for PHP + MySQL

Changelog:
2.0.1 - Minor bug fixes
2.0.2 - PHP FastCGI Support for IIS 5.1+ / 6
2.0.5 - Fixed some bugs (e.g. wrong url when installing in existing website), Added logging and a few other properties, Extended scriptparse functionality to replace more @@properties@@, PHP/FastCGI support for IIS7 (vista) and Built Windows Installer for WAI
2.0.6 - Fixed scripts (removed CRLF problem in createScriptConfig.vbs )
Added new Properties: checkIfIUSRisListedOnPHPUploadDir, WANTinstalllogFile
2.0.7 - Added new properties: checkMYSQL40 and SETREADONLY
2.0.8 - Added support for SQL Server 2008 made some modifications to better work for PERL
2.0.9 - minor additions only for PERL
2.0.10 - MySQL Connector/ODBC 5.1 (5.1.5) support (better query mechanism to detect used odbc connector)
2.0.11 - added a x64 bit template to be used for creating packages targeted for x64 platforms
2.0.12 - removed the x64 template - run buildx64config.vbs to autogenerate a x64 installer package from your existing *.wxs file
2.0.13 - bugfixes:
• GenerateSourceConfig.vbs now sets only sets folder permissions (no longer also on files) - files inherit the folders permissions
• If you grant the Networkservice write permissions to a folder the IUSR gets also write permissions (required when working with php and fastcgi impersonation)
• GenerateSourceConfig.vbs now creates valid fileIDs (e.g. typo3 has files with special chars WIX would not like)
added Property IIS7REQUIREDMODULES this comma separated list gets checked when the your msi is run on IIS7

Released: web application installer - V2 (Oct 29, 2007)

Thu, 30 Oct 2008 13:34:01 GMT

Source code checked in, #18457

bernhardfrank — Tue, 28 Oct 2008 18:19:52 GMT

Source code checked in, #18456

bernhardfrank — Tue, 28 Oct 2008 18:03:08 GMT

New Post: No add/remove programs entry

mikemcclaran — Wed, 22 Oct 2008 04:47:57 GMT

I followed the instructions in the pdf for creating an msi for my web application. Everything seems to work as expected, except that I don't have a entry in control panel add/remove programs to uninstall my application. What am I missing? Running on Vista.

Any help would be greatly appreciated.

Thanks,

--Mike

Updated Release: web application installer - V2 (Oct 29, 2007)

bernhardfrank — Tue, 21 Oct 2008 14:58:42 GMT

Released: web application installer - V2 (Oct 29, 2007)

Tue, 21 Oct 2008 14:58:42 GMT

Source code checked in, #18311

bernhardfrank — Tue, 21 Oct 2008 14:48:50 GMT

2.0.12

Updated Release: web application installer - V2 (Oct 29, 2007)

bernhardfrank — Mon, 20 Oct 2008 14:59:35 GMT

Source code checked in, #18285

bernhardfrank — Mon, 20 Oct 2008 14:52:37 GMT

comments

Source code checked in, #18283

bernhardfrank — Mon, 20 Oct 2008 14:46:50 GMT

2.0.11

Commented Issue: Add support for later version of MySQL ODBC driver

bernhardfrank — Mon, 20 Oct 2008 09:05:25 GMT

Currently the checkRequirements.vbs script checks explicitly for the 3.51 ODBC driver. There are considerably later versions available for download from mysql.org. The test being used requires accessing the registry under an explicit key (it seems like there should be an easier way). Presently that key is

iODBCVersion = getRegistryKey("SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{9A854ED3-C3B1-493D-8104-C4B5AC459B7A}", "DisplayVersion", False)

The 5.1 version uses a different key (this is probably an error, but it's outside your control). On my box, that key is:

iODBCVersion = getRegistryKey("SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{29042B1C-0713-4575-B7CA-5C8E7B0899D4}", "DisplayVersion", False)

Please note that if the geniuses at MySQL continue to make this error, the x64 version of the driver will likely have a different key yet again.

I've added my own support for this key, but I'm not really a VB coder, so this probably isn't a very good way to do it.

Function checkMySQLODBC ()
Dim iODBCVersion, oShell

On Error Resume Next

iODBCVersion = getRegistryKey("SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{9A854ED3-C3B1-493D-8104-C4B5AC459B7A}", "DisplayVersion", False)

if Not iOBBCVersion Is NullString Then
Session.Property("MYSQL_ODBC_DRIVER") = "MySQL ODBC 3.51 Driver"

If iODBCVersion >= "3.51.21" Then
Session.Property("SQLSERVERCheck") = "OK"
checkMySQLODBC = ERROR_SUCCESS
Else
Session.Property("SQLSERVERCheck") = "BAD"
checkMySQLODBC = ERROR_INSTALL_FAILURE
End If

Exit Function
End If

'{29042B1C-0713-4575-B7CA-5C8E7B0899D4} is the key for ODBC 5.1. There must be a better way to do this.
iODBCVersion = getRegistryKey("SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{29042B1C-0713-4575-B7CA-5C8E7B0899D4}", "DisplayVersion", False)

if Not iOBBCVersion Is NullString Then
Session.Property("MYSQL_ODBC_DRIVER") = "MySQL ODBC 5.1 Driver"

If iODBCVersion >= "5.1.0" Then
Session.Property("SQLSERVERCheck") = "OK"
checkMySQLODBC = ERROR_SUCCESS
Else
Session.Property("SQLSERVERCheck") = "BAD"
checkMySQLODBC = ERROR_INSTALL_FAILURE
End If

Exit Function
End If

' Explain why odbc drive is need
iAnswer = MsgBox("In order to enable this installer to setup a " &_
"MySQL Database, this machine requires a MySQL ODBC Connector. " &_
"I could not find either a v3.51.x or a v.5.1.x version installed. " &_
"These drivers can be obtained from: " & vbCrLf & vbCrLf &_
"|- http://dev.mysql.com/downloads/connector/odbc" & vbCrLf &_
"|-- Windows downloads" & vbCrLf &_
"|--- Windows MSI Installer (x86)" & vbCrLf & vbCrLf &_
"Do you want to open this URL?", 36, "MySQL ODBC Connector missing...")

If Not iAnswer = 7 Then
Set oShell = CreateObject("Shell.Application")
oShell.ShellExecute Session.Property("IEXPLOREEXE"), "http://dev.mysql.com/downloads/connector/odbc", "", "open", 1
End if

Session.Property("SQLSERVERCheck") = "BAD"
checkMySQLODBC = ERROR_INSTALL_FAILURE
End Function
Comments: ** Comment from web user: bernhardfrank **

Hi Austin,

added this functionality in version 2.0.10 - rather than querying the registry I use windows installer to query for odbc connector packages:

'we ask windows installer database whether a MySQL Connector/ODBC is installed
Set wiInstaller = CreateObject("WindowsInstaller.Installer")
for each product in wiInstaller.Products
productName = wiInstaller.ProductInfo(product,"ProductName")
if (InStr(1, productName,"MySQL Connector/ODBC") <> 0) then
select case productName
case "MySQL Connector/ODBC 3.51"
Session.Property("MYSQL_ODBC_DRIVER") = "MySQL ODBC 3.51 Driver"
case "MySQL Connector/ODBC 5.1"
Session.Property("MYSQL_ODBC_DRIVER") = "MySQL ODBC 5.1 Driver"
case else 'best guess
VersionMajor = wiInstaller.ProductInfo(product,"VersionMajor")
VersionMinor = wiInstaller.ProductInfo(product,"VersionMinor")
Session.Property("MYSQL_ODBC_DRIVER") = "MySQL ODBC " & VersionMajor & "." & VersionMinor & " Driver"
end select
Session.Property("SQLSERVERCheck") = "OK"
checkMySQLODBC = ERROR_SUCCESS
Exit Function
end if
next
set wiInstaller = nothing

this works for me.

Thanks for the hint

Bernhard

Updated Release: web application installer - V2 (Oct 29, 2007)

bernhardfrank — Mon, 20 Oct 2008 09:01:54 GMT

Source code checked in, #18277

bernhardfrank — Mon, 20 Oct 2008 08:57:15 GMT

2.0.10

Source code checked in, #18276

bernhardfrank — Mon, 20 Oct 2008 08:44:47 GMT

2.0.8 added support for ODBC 5.1 connector

Updated Release: web application installer - V2 (Oct 29, 2007)

bernhardfrank — Wed, 08 Oct 2008 16:14:31 GMT

Updated Wiki: Home

bernhardfrank — Thu, 02 Oct 2008 14:35:20 GMT

Scripting:

ASP.NET
PHP
Perl

Databases:

Microsoft SQL Server (2005 and 2008)
MySQL Server

See the steps - one by one: Screen1

You will be able to create a MSI that is cabable of:

Creating a new website
Adding a virtual directory to an existing website
Creating an application pool and setting up a website/folder as ASP.NET 2 application
Creating a new Microsoft SQL Database, Logins and Users
Configuring your web application (e.g. web.config) and setting values collected in wizard mode
A lot of user guidance, messages and validations

See: Projects using the WAI template

Don't believe it can be done in 30 minutes? - check it out!
web application installer - V2

Updated Release: web application installer - V2 (Oct 29, 2007)

bernhardfrank — Thu, 02 Oct 2008 14:28:27 GMT