CockroachDB

• Name: CockroachDB
• Category: Database

​

Configuration

​

Usage

​

.configu store declaration

stores:
  my-store:
    type: cockroachdb
    configuration:
      host: localhost
      username: test
      password: test
      database: test

​

CLI Examples

​

Upsert command

configu upsert --store "my-store" --set "test" --schema "./start.cfgu.json" \
    -c "GREETING=hello" \
    -c "SUBJECT=configu"

​

Eval and export commands

configu eval --store "my-store" --set "test" --schema "./start.cfgu.json" \
 | configu export

​

Common Errors and Solutions

1. Connection Timeout Troubleshooting
   • Solution: Increase the connectTimeout or acquireTimeout in the configuration options to handle long-running connection setups. Ensure the database is accessible.
2. Authentication Failures
   • Solution: Verify the provided username and password, and confirm the user has access to the specified database. Use a CockroachDB client to check credentials.
3. SSL Certificate Issues
   • Solution: Ensure the correct SSL certificate paths are provided if ssl is enabled. Verify that the certificates match the CockroachDB server configuration.
4. Database Permissions Issues
   • Solution: Make sure the database user has READ and WRITE permissions for the specified table. Use the following SQL command to grant permissions:
   GRANT ALL ON TABLE config_store TO <username>;
   

​

References

• Integration documentation: CockroachDB Documentation
• TypeORM documentation: https://typeorm.io