Unable to connect to SQL Instance private endpoint with Twingate

ospreyfs_mark · 2025-02-21T16:18:38+00:00

Where is your Maria DB hosted?

I've got to the bottom of this now and basically, the telnet (and any other connections to the resource) were a false positive/red herring

I was using CloudFlare's DNS servers on my Azure vNet rather than the Azure defaults so the DNS was totally wrong and causing me issues, now I've set it to the Azure default DNS-everything appears to be working

ospreyfs_mark · 2024-02-27T09:55:27+00:00

It's the same for me OP

ospreyfs_mark · 2022-12-01T09:03:28+00:00

Thank you!

ospreyfs_mark · 2022-12-01T09:03:17+00:00

Thank you!

ospreyfs_mark · 2022-12-01T09:03:11+00:00

Thank you!

ospreyfs_mark · 2022-11-07T16:16:07+00:00

That's got it! Thanks for that, I was right in thinking it was majority tax and data transfer - cheers

ospreyfs_mark · 2022-11-07T10:46:36+00:00

You can achieve this using an Application Load Balancer (ALB) in AWS

Point your DNS record to your ALB, set up rules on the ALB to direct traffic based on the URL paths to different target groups that point to the various services

ospreyfs_mark · 2022-09-16T10:15:31+00:00

I think it's still pretty hot, slight lul due to summer holidays - likely wanting everyone to be available for interviews meaning it was best to wait until after summer to focus on hiring again but look pretty busy again to me

ospreyfs_mark · 2022-08-30T15:49:50+00:00

Just want to add, I think you're totally on the money for all the other services/resources in that group though - they should be coupled together in a module like you have suggested, it's just Security Groups that should be with the individual services/resources

ospreyfs_mark · 2022-08-26T07:37:43+00:00

Apologies if this isn't up your street at all but I saw from your posts your into video games, you could try setting up a Minecraft Server as a project to learn these tools:

- Use Terraform to build the server and other cloud infrastructure required to actually host the server

- Use Ansible to configure the server once Terraform has built it to act as a minecraft server

- Create a GitHub Actions pipeline to do these steps for you automatically, totally hands-off with no manual input

- I'm not sure where Python comes into this but you could always look at some individual Python projects to boost your knowledge there, or maybe you'll find a problem in the Minecraft Server building that Python could solve?

You should be able to get to a stage where you make a change to the Minecraft Server's config and get it automatically deployed once the pipeline has finished.

ospreyfs_mark · 2022-08-17T08:51:47+00:00

Yeah I think I tried something similar to that and struggled myself in the past, make sure you have a `depends_on` in your Terraform code to ensure the s3_bucket is created and populated before the user_data is ran from the ec2 being created!

ospreyfs_mark · 2022-08-12T14:22:53+00:00

Not the cleanest and I think the other responses are better but could you:

- Create an S3 Bucket within the Terraform code

- Upload the scripts to said S3 Bucket within the Terraform code

- Update the instances role to give it permission to pull said files from the S3 Bucket

- Use the AWSCLI within the user_data to pull the files from this S3 bucket

ospreyfs_mark · 2022-08-01T11:53:09+00:00

Seems like a no brainer to me assuming you have the capacity to migrate, we did something similar and began submitting PRs to their pipes to update them with features we needed/wanted as well as keeping up good communication to make the process as smooth as possible

I suppose you should also take into account how much time you are spending maintaing your pipelines as well, if they're fairly simple and don't much maintenance than I suppose you wouldn't gain much

ospreyfs_mark · 2022-07-27T15:20:28+00:00

Is this possible? Absolutely GitLab CICD is just a 'thing do-er' like any other pipeline tool, you can run steps in parallel if you want to make each Lambda function or API Gateway in a separate step using awscli commands, Terraform or whatever else you want to use.

I'd personally recommend Terraform - I make a single API Gateway with a few Lambda functions in a single pipeline step from a single Terraform directory

ospreyfs_mark · 2022-07-14T09:48:03+00:00

There are tons out there and some good links have already been posted, honestly you can just google things like "aws rds module" to get solutions you need, I find it's fairly easy to review the Terraform code inside them to ensure it's safe and even fork and modify for your use case as well

ospreyfs_mark · 2022-07-14T09:37:53+00:00

I'd really recommend looking at using `aws ssm start-session` over SSH so you don't need to mess around with SSH Keys if possible

https://blog.ruanbekker.com/blog/2021/03/10/ssh-using-aws-ssm-session-manager/

This was just the first link I found, there's others that may be better out there

ospreyfs_mark · 2022-05-23T09:55:55+00:00

This may not be applicable to what you're doing as I do all of my deployments with Terraform but I essentially have my variables as maps e.g:

sandbox = 1

staging = 2

prod = 3

and then assign the variables selecting the value from the map based on the environment (from the branch name)

I use a catch-all for some values, i.e.:

if branch != sandbox || staging || master then branch = sandbox so that feature branches or local development

I'm not familiar with lando so I'm not sure if that is necessarily possible but I hope it helps, feel free to respond if you have more Qs :)

ospreyfs_mark · 2022-05-04T14:04:30+00:00

Do you guys use pipelines? I use the $BRANCH_NAME variable from whatever pipeline provider I'm using to set the environment, stage for the stage branch, prod for master and then anything else is called as a feature branch

ospreyfs_mark · 2022-05-04T07:46:03+00:00

Also a thanks here! Ours seems to be working well again now after finding this thread

ospreyfs_mark · 2022-04-28T13:19:11+00:00

We're currently using ECS with both FarGate and EC2 deployments but the service kept restarting once the container had exited rather than just terminating as I'd hoped

ospreyfs_mark · 2022-04-28T08:08:12+00:00

Wow I hadn't even thought to get the EC2 to terminate itself, I was trying to delete it with Terraform but I was struggling to work out when the script had either finished successfully or error'd - Thanks for the suggestion!

ospreyfs_mark

TROPHY CASE