Cloudron Forum

@ezdub Sorted now, when the popup is shown on first time usage with the name @airbuster@matrix.mydomainname.com

It added an @ instead of a :

So it should look like this @airbuster:matrix.mydomainname.com

And that works when adding the admin account.

I've just installed Matrix & element and seem to have them running but when I try and set the admin in Matrix using this command via the cloudron terminal.

PGPASSWORD=${CLOUDRON_POSTGRESQL_PASSWORD} psql -h ${CLOUDRON_POSTGRESQL_HOST} -p ${CLOUDRON_POSTGRESQL_PORT} -U ${CLOUDRON_POSTGRESQL_USERNAME} -d ${CLOUDRON_POSTGRESQL_DATABASE} -c "UPDATE users SET admin=1 WHERE name='@user:example.com'"

And I changed the name=@user:example.com to the one that was provided on the first time usage pop up.

When I run the command I get

ERROR: column "name" does not exist

Can anyone help with this, thanks