Cannot access google cloud VM via SSH client through browser after VM restart

See also questions close to this topic

• Azure DevOps Pipeline with GCP Container Registry

  I'm following this tutorial to create an Azure Devops pipeline on the sample container with Music Store App sample. However, I cant solve the authorization problem and getting the error as following. The API is already enabled and the link in the error description does not contain the project id although I put project id everywhere during the steps.

  [error]denied: Token exchange failed for project 'identityserver'. Please enable Google Container Registry API in Cloud Console at

  https://console.cloud.google.com/apis/api/containerregistry.googleapis.com/overview?project=iserver before performing this operation

  resources:
  - repo: self
    fetchDepth: 1
  queue:
    name: Hosted Ubuntu 1604
  variables:
    TargetFramework: 'netcoreapp2.0'
    RestoreBuildProjects: 'samples/**/*.csproj'
    TestProjects: 'test/MusicStore.Test/*.csproj'
    BuildConfiguration: 'Release'
    DockerImageName: 'IServer/musicstore'
  steps:
  - task: DotNetCoreCLI@2
    displayName: Restore
    inputs:
      command: restore
      projects: '$(RestoreBuildProjects)'
      feedsToUse: config
      nugetConfigPath: NuGet.config
  - task: DotNetCoreCLI@2
    displayName: Build
    inputs:
      projects: '$(RestoreBuildProjects)'
      arguments: '--configuration $(BuildConfiguration) --framework=$(TargetFramework)'
  - task: DotNetCoreCLI@2
    displayName: Test
    inputs:
      command: test
      projects: '$(TestProjects)'
      arguments: '--configuration $(BuildConfiguration) --framework=$(TargetFramework)'
  - task: DotNetCoreCLI@2
    displayName: Publish
    inputs:
      command: publish
      publishWebProjects: True
      arguments: '--configuration $(BuildConfiguration) --framework=$(TargetFramework)'
      zipAfterPublish: false
      modifyOutputPath: false
  - task: CmdLine@1
    displayName: 'Lock image version in deployment.yaml'
    inputs:
      filename: /bin/bash
      arguments: '-c "awk ''{gsub(\"MUSICSTORE_IMAGE\", \"gcr.io/$(DockerImageName):$(Build.BuildId)\", $0); print}'' deployment.yaml > $(build.artifactstagingdirectory)/deployment.yaml"'
  - task: PublishBuildArtifacts@1
    displayName: 'Publish Artifact'
    inputs:
      PathtoPublish: '$(build.artifactstagingdirectory)'
  - task: Docker@0
    displayName: 'Build image'
    inputs:
      containerregistrytype: 'Container Registry'
      dockerRegistryConnection: 'gcr-tutorial'
      imageName: '$(DockerImageName):$(Build.BuildId)'
  - task: Docker@0
    displayName: 'Publish image'
    inputs:
      containerregistrytype: 'Container Registry'
      dockerRegistryConnection: 'gcr-tutorial'
      action: 'Push an image'
      imageName: '$(DockerImageName):$(Build.BuildId)'
  
• How to expose externally Prometheus and Grafana Dashboards which is configured in GKE with google click to deploy

  Can somebody please help me to expose externally Prometheus and Grafana Dashboards which is configured in GKE with google click to deploy.
• Scheduling loading multi tab google sheets into GCP CloudSQL

  I’m struggling to find any instructions or tutorials on scheduling an upload of a multi tab google sheet into the GCP Cloud SQL (MySQL) database.

  The file is created and put into a google drive at a regular inyrtval. It comes from a source system so I can’t really change how it is created (I.e. I can’t change it into an Excel or multiple csv files etc. or change the format).

  Ideally I want to schedule the file to be uploaded and some simple transforms and data cleansing done in DataPrep before storing/appending to tables in the MySQL database. I’m just as happy though to skip that and just schedule the upload to the database and I’ll do all of the processing there.

  Unfortunately, all of the information I have found is either for csv files (not useful) or for getting BigQuery to join with a google Sheet (also not what I need or can modify for my need).

  Please let me know if this is possible and steps to set it up. I can’t imagine this is that unique a situation??

  We have a few source systems that we need to upload the data for, some are intra-day, some are daily or weekly and some are monthly). My problem also extends to our Excel files (as some source systems generate a google Sheet whilst others, Excel). I figure once I see the solution for one I hopefully can work out the other file format’s instructions.

  Thanks!