Configuring Aiven Client to connect to Managed Service for TimescaleDB

1. Change to the install directory that contains the configuration files:

   cd ~/.config/aiven/

2. Open the aiven-credentials.json using any editor and update these lines with your Managed Service for TimescaleDB User email, and the authentication token that you generated:

   \{
     "auth_token": "ABC1+123...TOKEN==",
     "user_email": "your.email@timescale.com"
   \}

3. Save the aiven-credentials.json file.

4. To verify that you can access your services on Managed Service for TimescaleDB, type:

   avn project list

   This command shows a list of all your projects:

    PROJECT_NAME       DEFAULT_CLOUD            CREDIT_CARD
    =============     =======================   ===================
    project-xxxx      timescale-aws-us-east-1   xxxx-xxxx-xxxx-xxxx
    project-yyyy      timescale-aws-us-east-1   xxxx-xxxx-xxxx-xxxx
    project-zzzz      timescale-aws-us-east-1   xxxx-xxxx-xxxx-xxxx

Fork services with Aiven client

When you a fork a service, you create an exact copy of the service, including the underlying database. You can use a fork of your service to:

• Create a development copy of your production environment.
• Set up a snapshot to analyze an issue or test an upgrade.
• Create an instance in a different cloud, geographical location, or under a different plan.

For more information about projects, plans, and other details about services, see [About Managed Service for TimescaleDB][about-mst].

Creating a fork of your service

1. In the Aiven client, connect to your [service][Install and configure the Aiven client].

2. Switch to the project that contains the service you want to fork:

    avn project switch <PROJECT>

3. List the services in the project, and make a note of the service that you want to fork, listed under SERVICE_NAME column in the output.

    avn service list

4. Get the details of the service that you want to fork:

   avn service get <SERVICE_NAME>

5. Create the fork:

   avn service create <NAME_OF_FORK> --project <PROJECT_ID>\
   -t <SERVICE_TYPE> --plan <PLAN> --cloud <CLOUD_NAME>\
   -c service_to_fork_from=<NAME_OF_SERVICE_TO_FORK>

Example

To create a fork named grafana-fork for a service named grafana with these parameters:

• PROJECT_ID: project-fork
• CLOUD_NAME: timescale-aws-us-east-1
• PLAN_TYPE: dashboard-1

   avn service create grafana-fork --project project-fork -t grafana --plan dashboard-1 --cloud timescale-aws-us-east-1  -c service_to_fork_from=grafana

You can switch to project-fork and view the newly created grafana-fork using:

   avn service list

Configure Grafana authentication plugins

Grafana supports multiple authentication plugins, in addition to built-in username and password authentication.

On Managed Service for TimescaleDB, Grafana supports Google, GitHub, and GitLab authentication. You can configure authentication integration using the Aiven command-line client.

Integrating the Google authentication plugin

To integrate Google authentication with Grafana service on Managed Service for TimescaleDB, you need to create your [Google OAuth keys][google-oauth-keys]. Copy your client ID and client secret to a secure location.