Packages the upstream vsql-oauth2 extension (JWT-based account authentication via OAuth2/OIDC (CREATE USER ... IDENTIFIED WITH vsql_oauth2)) as a separate snap that plugs into the villagesql snap through the content interface:
sudo snap install villagesql-oauth2
sudo snap connect villagesql:extensions villagesql-oauth2:extensions
sudo snap set villagesql vsql-allow-preview-extensions=ON
sudo snap restart villagesql
sudo villagesql.mysql -uroot -e "INSTALL EXTENSION vsql_oauth2;"
sudo villagesql.mysql -uroot
-e "SELECT @@vsql_oauth2.jwks_refresh_interval;"
Preview extension: it uses VEF APIs that may change between VillageSQL releases and only loads when the server runs with vsql_allow_preview_extensions=ON.
Needs a villagesql snap built from the repository on or after 2026-10-21: the 0.0.7 store revisions published before that do not ship the shared libraries this bundle links against (see docs/extensions.md) and cannot load it.
Thank you for your report. Information you provided will help us investigate further.
There was an error while sending your report. Please try again later.
Snaps are applications packaged with all their dependencies to run on all popular Linux distributions from a single build. They update automatically and roll back gracefully.
Snaps are discoverable and installable from the Snap Store, an app store with an audience of millions.
Snap can be installed on elementary OS from the command line. Open Terminal from the Applications launcher and type the following:
sudo apt update
sudo apt install snapd
Either log out and back in again, or restart your system, to ensure snap’s paths are updated correctly.
To install villagesql-oauth2, simply use the following command:
sudo snap install villagesql-oauth2 --edge
Browse and find snaps from the convenience of your desktop using the snap store snap.
Interested to find out more about snaps? Want to publish your own application? Visit snapcraft.io now.