Define a clean way to use odbc drivers and odbc.ini

[SamEdwardes]

Description

The Workbench Helm chart provides a value for you to specify an odbc.ini file at config.sessionSecret.odbc.ini that gets mounted to /mnt/session-secret/odbc.ini. However, for users to actually use the connections defined here you also need to:

• Set environment variable ODBCSYSINI=/mnt/session-secret
• Mount the odbcinst.ini file to /mnt/session-secret/odbcinst.ini
• Change the permissions of /mnt/session-secret so everyone can read it

For example, my values.yaml would look like this:

config:
  server:
    launcher-env: |
      ODBCSYSINI=/mnt/session-secret
  defaultMode:
    sessionSecret: 0444
  sessionSecret:
    odbc.ini: |
      [ProjectAbcDatabase]
      Database=project_abc
      Driver=PostgreSQL
      Password=password
      Port=5432
      Servername=database-postgresql
      UserName=posit_team
    odbcinst.ini: |
      [PostgreSQL]
      Driver = /opt/rstudio-drivers/postgresql/bin/lib/libpostgresqlodbc_sb64.so
      RStudioVersion = 2022.11.0
      Version = 1.4.54.1001
      Installer = RStudio Pro Drivers

Is there a more simple way this could be done? Could there be an option to specifically mount odbc.ini to /etc/odbc.ini which is the default location for this file?

Related issues

• sessionSecret not mounted into session pods? #270

[MariaSemple]

Hey Sam, thanks for filing this issue! It's typically not possible to mount files directly into an /etc/ folder. As a starting point for improvement on this issue, we think it would be a good idea to document what you've done here. In the longer term we think we could improve this as follows:

• supporting ODBC (inst) ini files by adding them to the config map and having them get mounted
• when those files are set, automatically adding that environment variable to launcher-env