Unsolved Error when trying to set admin

[ezdub]

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

[nebulon]

Just installed a matrix instance and I can't reproduce this. The users table does have a column name. Did you encounter any initial app startup errors maybe? Also can you try to re-install synapse to see if this is reproducible on your server?

[ezdub]

@nebulon Yes I just did a fresh install thinking that perhaps my username did not like having a - in it but I made the username one word and still had the same issue.

Please note name in the error is just a substitution for my actual user name

Matrix & Element seem to work OK from what I can tell but not having used it before I don't really know

[nebulon]

@ezdub the error you have posted suggests though that whatever you have substituted there, was considered as a table column and not an actual value for a column.

Note the column is called name and thus has to be name="<here goes your username + domain>"

[ezdub]

@nebulon Sorry about that I used the <here goes your username + domain> that was shown when the window popped up when first time usage. IE @airbuster@matrix.mydomainname.com

And when I entered the command it said airbuster not found

If it helps I can do a screenshot

[girish]

@ezdub I would double check the quoting. Otherwise, you can send us a screenshot of the command to support@cloudron.io .

[ezdub]

@girish Tried it with ' either side and not both did not work.

I'll send a screen shot, I think

[ezdub]

@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.

[jdaviescoates]

@ezdub said in Error when trying to set admin:

the popup is shown on first time usage with the name @airbuster@matrix.mydomainname.com

Sounds like that's a typo that ought to be fixed