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


Navigation

    Cloudron Forum

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

    SOLVED Remote SQL Support on a per app basis

    Feature Requests
    mysql
    2
    4
    59
    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.
    • Lonk
      Lonk last edited by girish

      Oh, the irony. I got a VPS because my shared host didn’t allow Remote SQL-ing into the database. And lo and behold, I found out yesterday there was no way to make Sequel Pro work with Cloudron Subcontainers. I have a couple ideas. Like making an SSH user that auto-logs into an app with cloudron exec so that Sequel Pro can just use its SSH feature to remote SQL. But I don’t know if running a command automatically after logging into SSH is even possible.

      This was mainly discussed here, but I think it’s be a great addition to Cloudron to have:

      https://forum.cloudron.io/topic/3235/does-cloudron-support-remote-sql/5

      And this may have been one of the primary reasons I switched to an VPS but I fell in love with Cloudron after this week so I can make due with PHPMyAdmin as soon as I find out if I can “side-install” it into the Wordpress Unmanaged app.

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

        I haven't used Sequel Pro, but you can connect using MySQL Workbench using the "Standard TCP/IP over SSH". Most modern clients should support this since it's the standard way to connect to databases behind a bastion host.

        The MySQL hostname is gotten from output of docker inspect mysql | grep IPAddress on Cloudron. The other mysql values are gotten from cloudron exec --app myapp env | grep CLOUDRON_MYSQL.

        0ba69082-4ce6-416d-bdaa-e642a506dfa0-image.png

        4bb615ff-2dcb-44bf-bba1-7bedd415d0e2-image.png

        Lonk 1 Reply Last reply Reply Quote 3
        • Lonk
          Lonk last edited by

          @girish It worked perfectly! You are my hero rn. Sequel Pro is so much better than PHPMyAdmin ever could be. There's no way I could have figured out all of those commands to get the credentials on my own, thank you so much for telling me how you do it! ☺️

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

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

            1 Reply Last reply Reply Quote 0
            • First post
              Last post