Cloudron Forum

@ChicagoGregg said in Removing a domain produces an SQL error:

Low of the totem pole.

Low of the totem pole. Just use "least significant/important/crucial".

@corsacca yes, multisite can do this. The original question wanted to install 2 separate apps and share the db table. This is not possible.

@girish said in Mail server - How to expose ports for internal network:

@ChicagoGregg said in Mail server - How to expose ports for internal network:

Is it possible to expose its ports (25,465,587) to the local network so that mail can be sent (relayed) through the mail server and let it handle it going outbound? Figuring that Cloudron has this capability, and I'd only have a few emails per day requiring this, it should be able to provide this.

If I understand correctly, you want to relay mail via another mail server. If so, just sent the relay using the External SMTP relay configuration.

I am not quite following the part about exposing port 25/476/587 though. These are already exposed on the server. You have to configure your router/firewall to port forward those ports to the Cloudron internal IP.

Sorry for the tardy reply here. Thanks for both of your replies @subven and @girish .

Originally, I was simply wanting to do something like

Home Network (App sends email) -> Cloudron (on home network) accepts mail for relay from local home network 10.x.x.x -> sends to server through Internet connection (to my already-configured mail relay server, External w/ authentication)

I was looking for an unauthenticated relay on the home network.

Well, I suppose that Cloudron can't provide an unauthenticated relay point. So, I suppose the workaround is simply to configure a user and relay using authentication using a domain that is configured.

I'm fine going this route... And I get why it's for that reason with security. 🙂

Thanks for the help!

-gregg

@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!

@chicagogregg By chance did you or someone write up a step by step guide on this? I'm needing to do something similar but for whatever reason, ssh proxying and I don't seem to get along.