@girish I use DBeaver with an SSH tunnel. I just found an option that I forgot to toggle on -- "Show all databases".
Now it shows all the databases!
On a side note, I did first try to configure an SSH tunnel and a post-command to execute "/usr/local/bin/docker exec -ti postgresql bash" and that worked as well.
But, only one tunnel is needed to the cloudron server to login as root that allows access to all databases.
I'm good to go. Thanks for the help!
@girish I use DBeaver with an SSH tunnel. I just found an option that I forgot to toggle on -- "Show all databases".
Now it shows all the databases!
On a side note, I did first try to configure an SSH tunnel and a post-command to execute "/usr/local/bin/docker exec -ti postgresql bash" and that worked as well.
But, only one tunnel is needed to the cloudron server to login as root that allows access to all databases.
I'm good to go. Thanks for the help!
@nebulon I wasn't specifying any dbname. I'm not totally used to postgres and thought it would just connect into the db instance and I can list databases, etc. from there. Also looks like I can't use a root account to access all databases. It's alright as long as I can get into the schema for directus and transfer things over to MySQL. I'll have to take a primer on postgres.
Thanks for the help!
@nebulon Thanks.
That's what I thought, too. But I get the following:
user@vt1cloud01:~$ docker exec -ti postgresql bash
root@postgresql:/# env|grep CLOUDRON_POSTGRESQL
CLOUDRON_POSTGRESQL_ROOT_PASSWORD=xxxxxx
CLOUDRON_POSTGRESQL_TOKEN=xxxxxx
root@postgresql:/# psql --host=postgresql --user=root --password
Password: (PASTED PW HERE)
psql: error: FATAL: password authentication failed for user "root"
Any other ideas?
How can I get the Postgres root password for the postgres container?
I've done it with mysql and tried with postgres, but it keeps saying incorrect password at the psql command line.
I've done a "docker inspect postgres | grep IPAddress", obtained the IP, and tried to use psql with --user and --host (password pasted in), but it doesn't accept the password. I've connected remotely from through the postgres terminal as well as through the cloudron server, but still no luck.
This is similar to the steps I've taken as well, found through this link: https://forum.cloudron.io/topic/2200/external-mysql/5
I installed a Directus RC custom container and didn't realize it was using PG as the DB driver. So, I need to dump the PG tables, convert it to use mysql, and reload the schema into mysql. 
Thanks!
-gregg
@nebulon I wound up using an SSH tunnel to connect into the MySQL server (mysql container) through the cloudron server.
I didn't know about that link you sent to me, but that's exactly what I did with the:
env | grep CLOUDRON_MYSQL_
to get the username/password.
Since I'm tunneling via SSH I don't have a need to expose the port from the cloudron server. However, if I do need to, I probably can use iptables FORWARD. I'll stay away from that in the meantime.
Thanks for the help. Let's close this thread as resolved.
Thanks,
-gregg
@atridad Thanks for the reply.
I'd like to access the tcp/3306 on the mysql container directly from the local network. I need this for such command line tools such as mysqldump & mysql (for importing) commands as well as some GUI tools.
I'm assuming you're referring to ssh'g into the cloudron server and then access mysql on the mysql container (tcp/3306) via the command line... while that would work, it wouldn't allow me to access mysql directly from the local network. I wonder if I could proxy through via SSH.
Is there any way I could configure the container image to expose this port on the host itself so I can access it directly? (even if it's on a different port)
(Hmm, I wonder if I could use iptables with FORWARD?)
How can I find the MySQL root password for the cloudron host (if I ever need it?)? I found out how to get the root password for the MySQL container host (but not yet on the main cloudron host).
Thanks!
-gregg
I would like to modify a container (e.g. MySQL) to expose a port to the host.
How can I change this configuration within Cloudron to do this?
One of the reasons for this is so I can connect into MySQL remotely (local network) for development purposes.
Thanks,
-gregg