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. Feature Requests
  3. Remote SQL Support on a per app basis

Remote SQL Support on a per app basis

Scheduled Pinned Locked Moved Solved Feature Requests
mysql
15 Posts 3 Posters 3.5k 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.
  • LonkleL Lonkle

    @girish Just bookmarked your reply since I know I'll need it for other apps in the future. You have no idea how grateful I am. ☺️

    marcusquinnM Offline
    marcusquinnM Offline
    marcusquinn
    wrote on last edited by
    #5

    @lonk I'm getting errors connecting with both Sequel Pro and MySQL Workbench. Did you do anything special other than the above? Needing to connect to a bunch of EspoCRM instances for faster data reviews & exports etc.

    Web Design https://www.evergreen.je
    Development https://brandlight.org
    Life https://marcusquinn.com

    girishG 1 Reply Last reply
    0
    • marcusquinnM marcusquinn

      @lonk I'm getting errors connecting with both Sequel Pro and MySQL Workbench. Did you do anything special other than the above? Needing to connect to a bunch of EspoCRM instances for faster data reviews & exports etc.

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

      @marcusquinn What errors are you getting? Any screenshots? You have to select "Standard TCP/IP over SSH"

      marcusquinnM 1 Reply Last reply
      0
      • girishG girish

        @marcusquinn What errors are you getting? Any screenshots? You have to select "Standard TCP/IP over SSH"

        marcusquinnM Offline
        marcusquinnM Offline
        marcusquinn
        wrote on last edited by
        #7

        @girish A colleague has tried with both Sequel Pro and MySQL Workbench too and hit the same issues - but had success connecting with DBeaver using all the same settings. (we're both on Mac)

        So it is certainly curious but that's a possible solution but I'm time-poor this week so will have to come back with more diagnostics.

        The errors aren't really meaningful and suggest SP and MSWB issues with SSH somehow, which I guess is less commonly used.

        Sorry, I'll come back with a but more when I get to look again. I do think this app justifies having a SQL webapp add-on though, just because there's data in the database people will likely want access too that the App doesn't provide for in protecting from most users, where a DB Admin would know what they are doing and access with care anyway.

        Web Design https://www.evergreen.je
        Development https://brandlight.org
        Life https://marcusquinn.com

        LonkleL 1 Reply Last reply
        0
        • marcusquinnM marcusquinn

          @girish A colleague has tried with both Sequel Pro and MySQL Workbench too and hit the same issues - but had success connecting with DBeaver using all the same settings. (we're both on Mac)

          So it is certainly curious but that's a possible solution but I'm time-poor this week so will have to come back with more diagnostics.

          The errors aren't really meaningful and suggest SP and MSWB issues with SSH somehow, which I guess is less commonly used.

          Sorry, I'll come back with a but more when I get to look again. I do think this app justifies having a SQL webapp add-on though, just because there's data in the database people will likely want access too that the App doesn't provide for in protecting from most users, where a DB Admin would know what they are doing and access with care anyway.

          LonkleL Offline
          LonkleL Offline
          Lonkle
          wrote on last edited by
          #8

          @marcusquinn Gonna mark this unread and go check my settings. I use a Mac with Sequel Pro, my favorite editor. But I'll figure out if I did anything differently.

          By the time nebulon gave me those settings, I think I did have to change one thing. But essentially if you can get in via SSH, then this should work - I'll double check. But for now I'm gonna mark this as unread to come back to it. 🙂

          marcusquinnM 1 Reply Last reply
          1
          • LonkleL Lonkle

            @marcusquinn Gonna mark this unread and go check my settings. I use a Mac with Sequel Pro, my favorite editor. But I'll figure out if I did anything differently.

            By the time nebulon gave me those settings, I think I did have to change one thing. But essentially if you can get in via SSH, then this should work - I'll double check. But for now I'm gonna mark this as unread to come back to it. 🙂

            marcusquinnM Offline
            marcusquinnM Offline
            marcusquinn
            wrote on last edited by
            #9

            @lonk Thanks, while looking at DBeaver (Java apps ain't my favourite), I found Beekeeper Studio for Mac, which looks pretty, so might give that a try too.

            Sequel Pro looks like it hasn't been updated in a couple of years, I like it but they may have left space for more innovation.

            Web Design https://www.evergreen.je
            Development https://brandlight.org
            Life https://marcusquinn.com

            1 Reply Last reply
            0
            • marcusquinnM Offline
              marcusquinnM Offline
              marcusquinn
              wrote on last edited by
              #10

              OK, connected with DBeaver.

              I'm wondering if the other apps are crapping out due to the way I created my ssh key because I can't connect with Beekeeper Studio either. I thought I was all standard but maybe missing something obvious why all the other Apps don't work but DBeaver is handling it?

              Web Design https://www.evergreen.je
              Development https://brandlight.org
              Life https://marcusquinn.com

              girishG 1 Reply Last reply
              0
              • marcusquinnM marcusquinn

                OK, connected with DBeaver.

                I'm wondering if the other apps are crapping out due to the way I created my ssh key because I can't connect with Beekeeper Studio either. I thought I was all standard but maybe missing something obvious why all the other Apps don't work but DBeaver is handling it?

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

                @marcusquinn Any screenshots on what the error is with other apps?

                marcusquinnM 1 Reply Last reply
                0
                • girishG girish

                  @marcusquinn Any screenshots on what the error is with other apps?

                  marcusquinnM Offline
                  marcusquinnM Offline
                  marcusquinn
                  wrote on last edited by
                  #12

                  @girish A few but kinda meaningless:

                  I'm pretty certain I have all the right settings and values in the right places, as they work with DBeaver.

                  Sequel Pro:
                  116af0f8-1495-48e0-a8d5-3017e578e2dd-image.png

                  MySQL Workbench:
                  97700caf-9eb3-4a53-9970-1652501e10f9-image.png

                  Beekeeper Studio:
                  b1f5eaea-dfcb-4fed-804a-0de3952c104e-image.png

                  Web Design https://www.evergreen.je
                  Development https://brandlight.org
                  Life https://marcusquinn.com

                  girishG 1 Reply Last reply
                  0
                  • marcusquinnM Offline
                    marcusquinnM Offline
                    marcusquinn
                    wrote on last edited by
                    #13

                    Ooops - retina screenshots!

                    Web Design https://www.evergreen.je
                    Development https://brandlight.org
                    Life https://marcusquinn.com

                    1 Reply Last reply
                    0
                    • marcusquinnM marcusquinn

                      @girish A few but kinda meaningless:

                      I'm pretty certain I have all the right settings and values in the right places, as they work with DBeaver.

                      Sequel Pro:
                      116af0f8-1495-48e0-a8d5-3017e578e2dd-image.png

                      MySQL Workbench:
                      97700caf-9eb3-4a53-9970-1652501e10f9-image.png

                      Beekeeper Studio:
                      b1f5eaea-dfcb-4fed-804a-0de3952c104e-image.png

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

                      @marcusquinn Sequel Pro seems to be crashing and it is some backtrace. MySQL workbench should work, I use it everyday on Linux. Can you give me a screenshot on how you have configured the connection ? Mine is configured something like below:

                      6353a757-f9c3-4e70-811e-dd2e3d650ef6-image.png

                      marcusquinnM 1 Reply Last reply
                      0
                      • girishG girish

                        @marcusquinn Sequel Pro seems to be crashing and it is some backtrace. MySQL workbench should work, I use it everyday on Linux. Can you give me a screenshot on how you have configured the connection ? Mine is configured something like below:

                        6353a757-f9c3-4e70-811e-dd2e3d650ef6-image.png

                        marcusquinnM Offline
                        marcusquinnM Offline
                        marcusquinn
                        wrote on last edited by
                        #15

                        @girish I think the issue with MySQL Workbench is I can't use the latest version as they don't support macOS 10.14 past a certain version, and a colleague on a later macOS can get it working on a later MySQL Workbench version but I can't update my OS at the moment until some other software I use is updated to work with the later OS. Classic catch-22 on that one.

                        I think the solution to this should just be to use DBeaver, it's free on all platforms, and seems to work on all OS versions. too.

                        Maybe better to save your time for the odd additional /phpmyadmin/ that might be useful on certain apps.

                        Certainly appreciate the help and looking, but I don't want to distract you too much given it's a software version compatibility issue and not a Cloudron issue really. Thank you all the same though!!

                        Web Design https://www.evergreen.je
                        Development https://brandlight.org
                        Life https://marcusquinn.com

                        1 Reply Last reply
                        1
                        • girishG girish referenced this topic on
                        • girishG girish referenced this topic on
                        • girishG girish referenced this topic on
                        • girishG girish referenced this topic on
                        • girishG girish referenced this topic on
                        • ChristopherMagC ChristopherMag referenced this topic on
                        • ChristopherMagC ChristopherMag referenced this topic 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