Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Matrix (Synapse/Element)
  3. Error when trying to set admin

Error when trying to set admin

Scheduled Pinned Locked Moved Solved Matrix (Synapse/Element)
10 Posts 4 Posters 1.4k Views 4 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • E Offline
    E Offline
    ezdub
    wrote on last edited by
    #1

    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

    1 Reply Last reply
    1
    • nebulonN Offline
      nebulonN Offline
      nebulon
      Staff
      wrote on last edited by
      #2

      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?

      E 1 Reply Last reply
      0
      • nebulonN nebulon marked this topic as a question on
      • nebulonN 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?

        E Offline
        E Offline
        ezdub
        wrote on last edited by ezdub
        #3

        @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

        nebulonN 1 Reply Last reply
        0
        • E 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

          nebulonN Offline
          nebulonN Offline
          nebulon
          Staff
          wrote on last edited by
          #4

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

          E 1 Reply Last reply
          1
          • nebulonN 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>"

            E Offline
            E Offline
            ezdub
            wrote on last edited by ezdub
            #5

            @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

            girishG 1 Reply Last reply
            0
            • E 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

              girishG Offline
              girishG Offline
              girish
              Staff
              wrote on last edited by
              #6

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

              E 1 Reply Last reply
              0
              • girishG girish

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

                E Offline
                E Offline
                ezdub
                wrote on last edited by
                #7

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

                I'll send a screen shot, I think

                E 1 Reply Last reply
                0
                • E ezdub

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

                  I'll send a screen shot, I think

                  E Offline
                  E Offline
                  ezdub
                  wrote on last edited by
                  #8

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

                  jdaviescoatesJ 1 Reply Last reply
                  2
                  • E 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.

                    jdaviescoatesJ Offline
                    jdaviescoatesJ Offline
                    jdaviescoates
                    wrote on last edited by
                    #9

                    @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

                    I use Cloudron with Gandi & Hetzner

                    1 Reply Last reply
                    0
                    • girishG Offline
                      girishG Offline
                      girish
                      Staff
                      wrote on last edited by
                      #10

                      I have pushed out a new package fixing the typo...

                      1 Reply Last reply
                      2
                      • girishG girish has marked this topic as solved on
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • Bookmarks
                      • Search