SSH Tunnel from IDE to XOJO Cloud dbase

Targets Web
1

Is there a way to create a db connection from the IDE on my dev machine, to my XOJO Cloud hosted MariaDB?

I’m trying to debug SQL statements, but without connecting to the hosted db I’m not easily able to see errors etc.

Locally I’m running MySQL Community, and the XOJO host is running MariaDB. It’s a daunting task (for me) to setup a local MariaDB instance to test against, so I’m hoping to test against the hosted db on XOJO Cloud.

Thanks for any and all feedback! :slight_smile:

2

Maybe the last part of this blog post from @Greg_O ?

Manually Creating a Tunnel

Sometimes you need to create a tunnel outside of a management app…

1 Like
3

I can’t say anything about Xojo Cloud… but I hope the blog post that Tim linked is of any help.

However, setting up a local MariaDB instance is quite easy :wink:

Have a look at this blog post: Docker, Database Servers and Xojo – Xojo Programming Blog
While the basics are explained with “PostgreSQL Server & pgAdmin”, an example for “MariaDB & phpMyAdmin” is mentioned, too.
All the Docker Compose examples are available here: GitHub - jo-tools/docker: Docker Examples

1 Like
4

Navicat PostgresSQL with Xojo Cloud and SSH works well. I’m sure it would with MySQL as well.

2 Likes
5

Valentina Studio also does excellent work.

6

I’m using all these tools and successfully connecting to the database(s). But what I’m looking for is a way to have my Xojo IDE connect to the data source.

7

Is different than the ‘manually creating a tunnel’ blog post? If different, then it is not clear (to me) what you need.

1 Like
8

For clarity, and I hope this helps (me). This illustration is using RDBMS (MySQLWorkbench or Navicat for MariaDB):

macOS RDBMS Software —> SSH Tunneller in RDBMS Software → XOJO_Cloud → MySQL :+1:t2:

macOS XOJO_IDE —> (what goes here?) → XOJO_Cloud → MySQL :question:

9

The ‘Manually Created Tunnel’ from the Blog post that Tim mentioned above (written by Greg)

1 Like
10

Or an instance of SSH2TunnelMBS, which is what I am using to connect to my PostgreSQL instance from the IDE. Works very well.

11

For debugging database issues and tunnels I highly recommend https://tableplus.com/ The free version does everything but limits number of open windows. For each connection you can enter tunnel info. If you a particular database it can automatically setup a tunnel.

12

That clarifies your issue well and what you want to accomplish. Although I can’t offer help, I am interested in what you find as a solution because I suspect this will be a common searched thread for cloud users.

Thanks!

13

The last part of this blog post is “(what goes here?)” for Mac and Linux users, as mentioned 4 days ago in Post #2.

Manually Creating a Tunnel

Sometimes you need to create a tunnel outside of a management app…

It was. I spent 30 seconds on Google to find that blog post link.

1 Like