Databases

const { MongoClient } = require('mongodb');

const client = new MongoClient(
  'mongodb://user:[email protected]:27017/default',
  {
    tls: true,
    tlsCAFile: 'ca.pem',
    tlsCertificateKeyFile: 'client-bundle.pem',
  }
);

const { createClient } = require('redis');

const client = createClient({
  url: 'rediss://user:[email protected]:6379',
  socket: {
    tls: true,
    ca: fs.readFileSync('ca.pem'),
  }
});

const mysql = require('mysql2/promise');

const connection = await mysql.createConnection({
  host: 'your-database.db.vertracloud.app',
  port: 3306,
  user: 'your-user',
  password: 'your-password',
  database: 'default',
  ssl: {
    ca: fs.readFileSync('ca.pem'),
    cert: fs.readFileSync('client-cert.pem'),
    key: fs.readFileSync('client-key.pem'),
  }
});

import psycopg2

conn = psycopg2.connect(
    host='your-database.db.vertracloud.app',
    port=5432,
    user='your-user',
    password='your-password',
    dbname='default',
    sslmode='verify-full',
    sslcert='client-cert.pem',
    sslkey='client-key.pem',
    sslrootcert='ca.pem'
)

import (
    "database/sql"
    "crypto/tls"
    "crypto/x509"
    "os"
    "github.com/go-sql-driver/mysql"
)

func connect() {
    caCert, _ := os.ReadFile("ca.pem")
    clientCert, _ := os.ReadFile("client-cert.pem")
    clientKey, _ := os.ReadFile("client-key.pem")

    cert, _ := tls.X509KeyPair(clientCert, clientKey)
    caCertPool := x509.NewCertPool()
    caCertPool.AppendCertsFromPEM(caCert)

    mysql.RegisterTLSConfig("custom", &tls.Config{
        RootCAs: caCertPool,
        Certificates: []tls.Certificate{cert},
    })

    db, _ := sql.Open("mysql", "user:password@tcp(your-database.db.vertracloud.app:3306)/default?tls=custom")
}

import (
    "github.com/go-redis/redis/v8"
    "crypto/tls"
    "crypto/x509"
    "os"
)

func connect() {
    caCert, _ := os.ReadFile("ca.pem")
    caCertPool := x509.NewCertPool()
    caCertPool.AppendCertsFromPEM(caCert)

    rdb := redis.NewClient(&redis.Options{
        Addr: "your-database.db.vertracloud.app:6379",
        Password: "your-password",
        TLSConfig: &tls.Config{
            RootCAs: caCertPool,
        },
    })
}