How to automate ProGet installation via ansible so that ProGet and SQL EXPRESS gets added to D drive instead of default C drive

[Srinidhi.Patwari_0272]

I need help in following :

1. Automating installation, repaving of ProGet using Ansible
2. During repave VM will be re-constructed so i can see things are going to C drive like SQL EXPRESS, INEDO HUB etc. This should by default go to D drive
3. Restarting of ProGet via ansible should not impact
4. We have SERVICE ACCOUNT that needs access to ProGet.

[atripp]

Hi @Srinidhi-Patwari_0272,

To accomplish this, I would recommend writing a script that does the following:

1. Installs SQL Express with the configuration you desire
2. Download latest version of Inedo Hub
3. Run hub.exe to perform silent installation

Installing SQL Server in an automated manner is not trivial, and you will need to research the best way to do that in your environment. Here is an article I found when searching for that: SQL Server Unattended Installation with PowerShell.

AS for steps #2 and #3, here is an example script from our Silent/Automated Installation Guide that you can adapt as you need:

# create working directories
mkdir C:\InedoHub
cd C:\InedoHub

# download and extract file to working directory
Invoke-WebRequest "https://proget.inedo.com/upack/Products/download/InedoReleases/DesktopHub?contentOnly=zip&latest" -OutFile C:\InedoHub\InedoHub.zip
Expand-Archive -Path InedoHub.zip -DestinationPath C:\InedoHub

# perform silent installation
hub.exe install ProGet:5.2.3 --ConnectionString="Data Source=localhost; Integrated Security=True;"

Best,
Alana

[Srinidhi.Patwari_0272]

@atripp
Thanks for the reply.

I have external DB, so how to attach it in silent installation. Does external DB should have any prior files to work?

I understood that SQL express will be installed if we do silent installation.

In my case i have rules like each 45 days VM must be repaved in that i will lose all SQL stuff.

External DB i am using now. So how to achieve silent installation with external DB?

[atripp]

Hi @Srinidhi-Patwari_0272 ,

I'm not totally sure I understand, but when you do a silent install you need to specify a connection string.

So you would just specify the connection string you need like this I guess

hub.exe install ProGet:5.2.3 --ConnectionString="Data Source=externals,qlserver.corp.local; Databse=ProGet;Integrated Security=True;"

[Srinidhi.Patwari_0272]

Hi @atripp
i applied above command as it is with version and Server change. Proget installed.

But attachment of external DB to my ProGet didn't happen. Can you please suggest any other way?

[Srinidhi.Patwari_0272]

Hi @atripp

I'm able to fix it. Thanks

Now i have last question: How to make ProGet URL accessible to all?
When i added my URL under ProGet.config file i'm able to access but no one else. Is it that we need to make WebServer Enabled="false" in config file or something else?

[dean-houston]

@Srinidhi-Patwari_0272 said in How to automate ProGet installation via ansible so that ProGet and SQL EXPRESS gets added to D drive instead of default C drive:

How to make ProGet URL accessible to all?

If you're able to access ProGet while being logged into the server, then it means the web server is up and running without issues.

From here, you'll need to adjust Windows firewall settings and/or enable DNS so that others can access. There's also certificate settings you'll need possibly. I'd check w/ your network team on this --- definitely not a change you can make inside of ProGet itself.

[Srinidhi.Patwari_0272]

@dean-houston
Thanks for reply

If u shed some more light on how to add certificate would be a great help

[atripp]

@Srinidhi-Patwari_0272 here is some information about HTTPS support on Windows:
https://docs.inedo.com/docs/installation-windows-https-support

However.... as Dean mentioned, this is something you'll need to work with your network team (a domain administrator) on, as the cert needs to be trusted, etc.

[Srinidhi.Patwari_0272]

@atripp Now ProGet installation not working. It's failing while installing. It's not creating ProGet folder under C->ProgramData

[Srinidhi.Patwari_0272]

@atripp kindly ignore above error message. It got resolved.

I still have issue with accessing proget url. I raised ticket to my Domain name where i added "http://abcd.efg.com:8624". So domain name should not include 8624? or how it is?

[dean-houston]

Hi @Srinidhi-Patwari_0272,

The domain name is abcd.efg.com and the port is 8624; it's very likely someone will need to open that port on the firewall as well.

Cheers,
Dean

[Srinidhi.Patwari_0272]

@dean-houston Part of my ProGet.config looks like
<WebServer Enabled="true" Urls="http://abcd.com:8624" />

So there is a need to add port number with url in config file?

Health check is failing and my terraform.tfvars looks like :
paths = [""]
ports = [80,443,8624]
health_port = 8624
health_request_path = ""
health_check_host = "abcd.com"
port_name = "http80"
https_health_check = false

We need http not https but proget url not being accessed in local laptop browsers. Firewall open for 8624 has been done. May i know what i am missing?

[dean-houston]

Hi @Srinidhi-Patwari_0272 ... it sounds like everything's working on the ProGet side, but I'm not familiar enough with troubleshooting Terraform/etc. to advise how to troubleshoot automating that.

[Srinidhi.Patwari_0272]

Hi @dean-houston
What about health check URL for ProGet application? I mean i need path for healthcheck

[dean-houston]

@Srinidhi-Patwari_0272 here is the api for healthcheck:
https://docs.inedo.com/docs/proget-reference-api-health

the url would be /health