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. Support
  3. Running commands via ssh

Running commands via ssh

Scheduled Pinned Locked Moved Support
4 Posts 4 Posters 1.3k 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.
    • M Offline
      M Offline
      Mythotical
      wrote on last edited by
      #1

      Since Cloudron installs apps differently than if I was to install the stand-alone, how do we access the database or even know what type of database is being used? For example, I need to remove users from Wekan and the only way to do that is through the command line. When I use 'docker ps' it shows MySQL, MongoDB, and PostgreSQL. Which one is Wekan using and what username is it using by default?

      1 Reply Last reply
      0
      • W Offline
        W Offline
        will
        wrote on last edited by
        #2

        Shouldn't Wekan be using the ldap backend?

        1 Reply Last reply
        0
        • murgeroM Offline
          murgeroM Offline
          murgero
          App Dev
          wrote on last edited by
          #3

          If you are looking to access CLI for an app, click the app's setting cog in the dashboard, select Console, then Terminal:

          9f07bbde-782e-4e4c-af2b-63582daaa4d7-image.png

          Just remember, the file system is read only, minus /tmp and /app/data. (and depending on the app maybe one more folder).

          --
          https://urgero.org
          ~ Professional Nerd. Freelance Programmer. ~

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

            The recommended way is what @murgero suggested. Access via the dashboard. The console/terminal gives you a sandbox access to the app.

            At the server level, if you are curious, I can explain a bit.

            root@localhost:~# docker ps
            CONTAINER ID        IMAGE                                                          COMMAND                  CREATED             STATUS              PORTS                                                                                        NAMES
            d9fa2018bc0c        cloudron/org.wordpress.cloudronapp:20200212-180328-807b9bf4d   "/app/pkg/start.sh"      15 hours ago        Up 15 hours         127.0.0.1:36813->8000/tcp                                                                    fe672d3d-d2c2-472e-a46b-a6dda9bb1de5
            c74f48d027f4        cloudron/mail:2.7.0                                            "/addons/mail/start.…"   2 days ago          Up 2 days           0.0.0.0:4190->4190/tcp, 0.0.0.0:25->2525/tcp, 0.0.0.0:587->2525/tcp, 0.0.0.0:993->9993/tcp   mail
            6331068cdae1        cloudron/mongodb:2.1.0                                         "/addons/mongodb/sta…"   9 days ago          Up 2 days           3000/tcp, 27017-27018/tcp                                                                    mongodb
            9c77623d89c6        cloudron/postgresql:2.0.2                                      "/addons/postgresql/…"   9 days ago          Up 2 days           3000/tcp, 5432/tcp                                                                           postgresql
            da5ad557af5e        cloudron/mysql:2.1.0                                           "/addons/mysql/start…"   9 days ago          Up 2 days           3000/tcp, 3306/tcp                                                                           mysql
            f822b1b3397f        cloudron/sftp:0.1.0                                            "/addons/sftp/start.…"   9 days ago          Up 2 days           0.0.0.0:222->22/tcp                                                                          sftp
            6c5788c3924a        cloudron/graphite:2.2.0                                        "/app/code/start.sh"     9 days ago          Up 2 days           127.0.0.1:2003-2004->2003-2004/tcp, 127.0.0.1:8417->8000/tcp                                 graphite
            
            1. The db containers are appropriately named mysql, postgresql and so on. these containers are "shared" by apps.

            2. The app containers can be quickly identified using the image name like cloudron/org.wordpress.cloudronapp.

            3. If you have many apps of the same type (say 10 wordpress), then you can use the container labels to figure it out. You can run docker ps -f label=fqdn=blog.domain.com.

            4. The best way to access "mysql" (or any other db) is not via the mysql container. Instead, exec into the app's container and then use environment variables to access the mysql db. In the web terminal, there is a "mysql" button on the top bar, just click it and it will paste the command required to access mysql. Press enter to get the mysql console.

            5. finally, if web terminal is not very friendly for you, you can also use the CLI tool. After installing it, you can just cloudron exec --app blog.domain.com to get the same shell as the web one. Note, the CLI tool is installed on your PC/laptop and not on Cloudron!

            1 Reply Last reply
            4
            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