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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved [Suggestion] Server-Wide Database Manager and File Browser

    Feature Requests
    feature-request filemanagement
    7
    23
    1109
    Loading More Posts
    • 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.
    • gabrielcossette
      gabrielcossette last edited by girish

      Hi,

      For Cloudron to be really useful to Web developers, I believe it needs to offer a way to manage all databases and files (Docker volumes, i.e. /app/data) on the server. For example, WordPress developers like to edit theme files directly through SFTP or a Web File Manager.

      I know the LAMP app supports SFTP and phpMyAdmin but it is restricted only to this app (not able to manage the WordPress app for example).

      The ideal way would be to integrate these features directly in the admin dashboard (like the Terminal), with the added important advantage of 2FA integration (missing in LAMP app).

      Good candidates are phpMyAdmin (DB), https://pydio.com (Web File Manager) and SFTP server with TOTP module... but the two first are PHP applications so not compatible with the current Node.js based dashboard so I'm not too sure how we could work this out. I've seen some ways to apparently run PHP through Node.js but more investigation would be needed.

      I'm ready to help if there is interest. Happy to hear your thoughts, thanks! 🙂

      1 Reply Last reply Reply Quote 5
      • girish
        girish Staff last edited by

        @gabrielcossette Thanks for the suggestion! We actually investigated this a couple of releases back and it's not simple to add. For the file browser, the UI parts are actually straight forward but the complication is with accessing the docker volumes. Accessing the data inside docker volumes will require the box code to somehow know the container user (to get the right permissions for files) and will also require the box code to run as root. This requires quite some engineering work.

        Just giving some background on why this has not been done yet.

        christiaan robi 2 Replies Last reply Reply Quote 2
        • christiaan
          christiaan @girish last edited by

          This post is deleted!
          1 Reply Last reply Reply Quote 0
          • marcusquinn
            marcusquinn last edited by

            Maybe some inspiration from how this Wordpress plugin does it with Adminer:

            https://github.com/andrewcy86/ari-adminer

            https://www.adminer.org

            Covers all the DB types too:

            https://www.adminer.org/en/phpmyadmin/

            We're not here for a long time - but we are here for a good time :)
            Jersey/UK
            Work & Ecommerce Advice: https://brandlight.org
            Personal & Software Tips: https://marcusquinn.com

            1 Reply Last reply Reply Quote 0
            • girish
              girish Staff last edited by

              We now have a simple file browser in 5.4

              marcusquinn 1 Reply Last reply Reply Quote 1
              • marcusquinn
                marcusquinn @girish last edited by marcusquinn

                @girish And very nice work too!

                Just in case you didn't note, Adminer I've tried before in WP stacks and it's covered all I could imagine needing for DB Admin and seems designed for this kind of embedded use. Not sure what other options there are in this space but it might save you re-inventing.

                We're not here for a long time - but we are here for a good time :)
                Jersey/UK
                Work & Ecommerce Advice: https://brandlight.org
                Personal & Software Tips: https://marcusquinn.com

                1 Reply Last reply Reply Quote 1
                • M
                  msbt App Dev last edited by

                  @girish great stuff, but is it possible to have a column which shows the date when a file was created/changed and maybe sort accordingly?

                  1 Reply Last reply Reply Quote 0
                  • Lonkle
                    Lonkle last edited by

                    I edit my WP databases with PHPMyAdmin a lot. I wonder if I can add it to those apps...unless Remote SQL is a feature on Cloudron (then I'll just locally run Sequel Pro).

                    marcusquinn 1 Reply Last reply Reply Quote 0
                    • marcusquinn
                      marcusquinn @Lonkle last edited by

                      @Lonk Add /phpmyadmin/ to the URL and PhPMyAdmin should be there:

                      https://docs.cloudron.io/apps/wordpress/#database-access

                      We're not here for a long time - but we are here for a good time :)
                      Jersey/UK
                      Work & Ecommerce Advice: https://brandlight.org
                      Personal & Software Tips: https://marcusquinn.com

                      Lonkle 1 Reply Last reply Reply Quote 0
                      • Lonkle
                        Lonkle last edited by

                        Your link says in it's first sentence: "Cloudron does not support PHPMyAdmin" - but I'll try it out. ☺️

                        1 Reply Last reply Reply Quote 0
                        • Lonkle
                          Lonkle @marcusquinn last edited by

                          @marcusquinn I tried it and it didn't work. I'll just see if I can get Sequel Pro working via Remote SQL. ☺️

                          marcusquinn 1 Reply Last reply Reply Quote 0
                          • marcusquinn
                            marcusquinn @Lonkle last edited by

                            @Lonk Ahh, maybe it was just the LAMP app and I'm thinking of FTP for Wordpress. Sometimes things change before Docs updates though.

                            https://docs.cloudron.io/apps/lamp/#phpmyadmin

                            We're not here for a long time - but we are here for a good time :)
                            Jersey/UK
                            Work & Ecommerce Advice: https://brandlight.org
                            Personal & Software Tips: https://marcusquinn.com

                            Lonkle 1 Reply Last reply Reply Quote 1
                            • Lonkle
                              Lonkle @marcusquinn last edited by

                              @marcusquinn Ah, so it is possible to maybe get that working with Wordpress but I'd rather get Remote SQL working instead like you said you managed to do on another post. My attempts haven't worked up till now.

                              marcusquinn 1 Reply Last reply Reply Quote 0
                              • marcusquinn
                                marcusquinn @Lonkle last edited by

                                @Lonk Old guy memory here, I think I only used phpmyadmin with the LAMP app and was thinking of FTP. Agree though, it'd be handy.

                                I've recommended https://www.adminer.org before as a handy way to make it part or Cloudron.

                                We're not here for a long time - but we are here for a good time :)
                                Jersey/UK
                                Work & Ecommerce Advice: https://brandlight.org
                                Personal & Software Tips: https://marcusquinn.com

                                1 Reply Last reply Reply Quote 0
                                • Lonkle
                                  Lonkle last edited by

                                  Do you like Adminer better than PHPMyAdmin? Tbh, I don't really love PHPMyAdmin.

                                  marcusquinn 1 Reply Last reply Reply Quote 0
                                  • robi
                                    robi @girish last edited by

                                    @girish I have a solution to this if we can add a new container type to use for this. It's called sysbox from nestybox. You have an email from me about this.

                                    It allows for running full machine images in sysbox container managed by docker. No root required, but you get root inside + full OS mount options for storage, etc..

                                    Also should look at mayadata.com and OpenEBS which is flexible storage attachment for containers.

                                    Friends of both 😄

                                    Life of Advanced Technology

                                    1 Reply Last reply Reply Quote 2
                                    • marcusquinn
                                      marcusquinn @Lonkle last edited by

                                      @Lonk I got what I needed done with it as a WP plugin, although it was removed from wordpress.org:

                                      • https://wordpress.org/plugins/ari-adminer/
                                      • https://github.com/andrewcy86/ari-adminer
                                      • https://github.com/ginsterbusch/ari-adminer
                                      • https://wpvulndb.com/plugins/ari-adminer

                                      We're not here for a long time - but we are here for a good time :)
                                      Jersey/UK
                                      Work & Ecommerce Advice: https://brandlight.org
                                      Personal & Software Tips: https://marcusquinn.com

                                      Lonkle 1 Reply Last reply Reply Quote 0
                                      • Lonkle
                                        Lonkle @marcusquinn last edited by

                                        @marcusquinn Thanks, I'll check those out, but I usually like database management to be detached from the Wordpress backend for security reasons.

                                        marcusquinn 1 Reply Last reply Reply Quote 0
                                        • marcusquinn
                                          marcusquinn @Lonkle last edited by marcusquinn

                                          @Lonk Yeah, of course - but it's a way to get DB access when it's not otherwise available externally. I tend to delete them after use just to be sure.

                                          We're not here for a long time - but we are here for a good time :)
                                          Jersey/UK
                                          Work & Ecommerce Advice: https://brandlight.org
                                          Personal & Software Tips: https://marcusquinn.com

                                          1 Reply Last reply Reply Quote 1
                                          • girish
                                            girish Staff last edited by

                                            @Lonk @marcusquinn This is part of https://forum.cloudron.io/topic/2760/what-s-coming-in-6-0. The "unify PHPMyAdmin across apps" part. We haven't really investigated what is the best way to implement it.

                                            robi Lonkle 2 Replies Last reply Reply Quote 1
                                            • robi
                                              robi @girish last edited by

                                              @girish perhaps an addition to the cloudron-build App that allows access to the shared mysql instance for all others?

                                              Life of Advanced Technology

                                              1 Reply Last reply Reply Quote 0
                                              • Lonkle
                                                Lonkle @girish last edited by Lonkle

                                                @girish I missed that, thanks for pointing it out for me. You just showed me, today, how to get Sequel Pro working so I don't have any use for PHPMyAdmin anymore. But, I do think having a way into PHPMyAdmin would be useful if an urgent db change needed to be made and I only had my phone (it's happened before).

                                                Does "unify PHPMyAdmin across apps" across apps mean you would log into a single PHPMyAdmin instance and see all applicable subcontainer's tables?

                                                1 Reply Last reply Reply Quote 0
                                                • Lonkle
                                                  Lonkle last edited by

                                                  Oh, wanted to mention - despite PHPMyAdmin being worked on rn; if anyone has an interest in connecting a remote SQL client app (like Sequel Pro) to Cloudron apps on an app-per-app basis. Here are instructions to do so here: https://forum.cloudron.io/topic/3237/remote-sql-support-on-a-per-app-basis

                                                  In my experience this is a much better, faster way to work with databases than PHPMyAdmin could ever dream to be.

                                                  1 Reply Last reply Reply Quote 1
                                                  • First post
                                                    Last post
                                                  Powered by NodeBB