Why no basic username/password login?

Unless I’m missing something, according to the docs there is no simple way to enable authenctication with just a simple username and password login. It appears my only options are some form of single sign on or GristConnect.

I am just a homelabber who loves data ownership and has been scammed by the cloud services, but I would like to be able to share a few things with others with their own logins.

Every other home hosted software I use can do this via a simple users interface, but that doesn’t seem to be the case here, or if it is then the docs are unclear?

Hello :slight_smile:

Try to have a look there GitHub - gristlabs/grist-omnibus: an opinionated Grist+Dex+Traefik package for first-time self-hosters , this should meets your needs.
Initial post here : Making Grist easier to self-host

Have a nice day.

Thanks for your reply. Sadly it looks unlikely to work for me as I already have a reverse proxy set up with something else, and I also used a Proxmox helper script to get set up originally as I can’t get my head around docker. Thanks for the suggestion though!

It should really be part of the core though. As that initial post is from 2022, it’s really sad that Grist lacks such basic login functionality. I’d love to move to Grist full time but sadly looks like Excel or Sheets is still the way to go for collaborative access :frowning:

This was also my problem before. I already have grist-oss up and running and moving to grist omnibus just for the login method seems too troublesome. Apparently you can apply OIDC to your existing grist just by simply add few docker environment.

Use this documentation:

For google auth you just need to add environment:

GRIST_OIDC_IDP_ISSUER= https://accounts.google.com
GRIST_OIDC_IDP_CLIENT_ID= your id
GRIST_OIDC_IDP_CLIENT_SECRET= your secret
GRIST_OIDC_SP_HOST= yourdomain.com
GRIST_OIDC_IDP_SKIP_END_SESSION_ENDPOINT= true

while your client ID and secret can be obtained by creating new project on google developer, and create new API, for free. I believe you can also limit who can register to your grist there. Here’s the guide:

That’s it, you’re good to go. Don’t forget to change your initial grist user to your gmaila account, otherwise after activating the OIDC you can’t use the previous account anymore (because you will be forced to use gmail account).

Trouble with that one is it uses Google, so they’re getting more data. Sure, I can home host some software to do it, but that’s out of my skill level (I know that’s on me), but it should also be just a basic part of the software.

Proxmox - Own login system
NPMPlus - Own login system
Chronicle - Own login system
2FAuth…
Home Assistant…
Uptime Kuma…
Change Detection…
Meshcentral…

I promise I’m not here just to moan as I really do adore the software itself but not having a basic username and password login system seems like as big of an omission as no autofill. Having read reddit it appears others are getting put off too and would move to Nextcloud Office which also doesn’t require a seperated system

Such a shame :frowning: