Advanced Installer Community

apajovejohn

I have added a SQL Query to a functioning predefined SQL connection:
SQLQueryDlg.jpg
I want to call this query as a custom action but when I add the Query SQL Database for Data action, the "Chose SQL Query" dialog box is always empty:
SQLEmptyBox.jpg

I may be missing something, but I can't see ...

apajovejohn

Hi Caitlin,
This was indeed what I meant. It's a seriously niche requirement which I'm not sure many other folks would ever need.

I've worked around it with a PowerShell custom action so I think you can ignore this one.

Thanks for following up

John

apajovejohn

Thanks for confirming, I've worked around it with a PowerShell custom action for now.

apajovejohn

Hello,
Is it possible to set the properties of an IIS website conditionally depending on the value of a property?

Specifically, what I want to do is set some HTTP headers IF the user elects to install on port 443 (FRONTENDPORT=443, but not set them if it is installed on any other port.

Thanks

John

apajovejohn

I am setting IIS Config Headers like this:
ConfigHeader1.jpg

I specify a default property for [SERVERFQDN] and call a custom action to populate this property, I use that property elsewhere in the installer without issue and it is displayed on my final wizard screen. I can also see in the log that ...

apajovejohn

Hi,
Just a heads-up that the new-ish CA for creating a self-signed certificate appears to result in a cert that has no trusted root, so IIS will not render a website bound to it.

A simple fix is to create a PowerShell task to create the cert correctly:

$myFQDN = [System.Net.Dns]::GetHostByName ...

apajovejohn

Liviu, I'm really grateful for your support.

I got it working as you describe, it was not working previously as I had fundamentally misunderstood how to use the AI_LISTBOX_DATA property and was using that as my actual LISTBOX property, it worked, but having a MY_LISTBOX_PROP which I can then check ...

apajovejohn

Hi,
I'm trying to ensure that the user can't click Next until an entry is clicked in a dynamically created ListBox. The ListBox is populated by a PowerShell script custom action (to list certificates for the user to pick for binding to the IIS websites we're creating). This all works great, but ...

apajovejohn

Works like a charm! Many thanks for the quick reply.

apajovejohn

Hi,
I've built an installer based on the Orange Vivid Theme but do not want anything to be orange.

I've had good results of all other dialog entities using AI_CONTROL_VISUAL_STYLE but it doesn't apply to the PreRequisite picker (it seems).

I've attached a screenshot of the problem and a screenshot ...

apajovejohn

Hi all,
Has anyone had any luck creating a dialog view that lets a user select a certificate from the local cert store in a dialog rather than having to copy and paste the thumbprint? I figured this would be built in but it seems not so I'm wondering if a custom action to enumerate all certificates ...

apajovejohn

I've been successfully building this project for years, but suddenly I'm getting:

[SEH_AV_READ_BADPTR] ACCESS_VIOLATION (0xc0000005) at address [0x00a55ee6]

Advanced Installer 16.1 build c9c5c0c9
*** Stack Trace (x86) ***

[0x00a55ee6] -----
[0x01167096] -----
[0x01162bda] -----
[0x01160173 ...

apajovejohn

That looks like just the ticket! Not sure I would ever have come up with that myself!

Many thanks

John

apajovejohn

Apologies for cross-posting but the community area doesn't seem to have any suggestions for me and we do have official support...

I'm trying to work out the best approach for creating an installer for a website and app pool. I have this all working perfectly, but now want to give the user the ...

apajovejohn

Hi folks,
My installer creates a website and associated app pool. I allow the user to specify either local system OR a user account for the app pool to run under.

This leads to be needing to create the app pool with either the default identity, OR an identity with account details.

I imagined that ...

Suggested Articles

User Guide

Videos

Refer & Save Up to 30% On Your Renewal

Search found 19 matches

SQL Query Custom Action Bug?

Re: Conditional IIS Properties

Re: Custom Headers in IIS Config loses variable

Conditional IIS Properties

Custom Headers in IIS Config loses variable

Custom Action to Create Self-Signed Cert does not work for IIS Binding

Re: Disable Next Button until ListBox entry is SELECTED

Disable Next Button until ListBox entry is SELECTED

Re: Set Color of Prerequisite Picker Box

Set Color of Prerequisite Picker Box

Choose certificate for IIS binding from Certificate Store

Suddenly cannot build with Error calling MSI API: 1627 Method: MsiDatabaseImport Table: ControlEvent. Extended Error: 1:

Re: Creating AppPool with different properties

Creating AppPool with different properties

Creating AppPool with different properties