Packages the upstream vsql-pgjwt extension (signing, verifying and decoding JWTs in SQL (pgjwt port)) as a separate snap that plugs into the villagesql snap through the content interface:
sudo snap install villagesql-pgjwt
sudo snap connect villagesql:extensions villagesql-pgjwt:extensions
sudo snap restart villagesql
sudo villagesql.mysql -uroot -e "INSTALL EXTENSION vsql_pgjwt;"
sudo villagesql.mysql -uroot
-e "SELECT vsql_pgjwt.jwt_sign('{"sub":"u"}', 's', 'HS256');"
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-pgjwt, simply use the following command:
sudo snap install villagesql-pgjwt --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.