Posts made by ChicagoGregg

Without a doubt...

+1 on this!

Hello,

This appears to be a bug... I've spent many hours today trying to figure out why the themes are NOT appearing within Mautic after the installation of the app.

To reproduce:

1. Cloudron - Install Mautic app
2. Login to Mautic app using admin creds
3. Go to Components -> Landing Pages
4. The only two themes that appear are "Code Mode" and "Blank"

What should happen, according to my research, are the other themes, as found in Settings -> Themes, should be displayed here.

Has anyone else experienced this? How can this be fixed?

Thanks!

@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

Hello,

I couldn't find this question posed anywhere in the forum here (which is a little surprising as I thought it would be somewhat a common query)...

Nor can I find any hints at: https://docs.cloudron.io/email/#inbound-ports

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.

A docker inspect shows no ports are exposed (obviously). I haven't dug into where this could be changed to expose it -- and whether Cloudron would just overwrite it or not when starting up the next time.

Thanks!

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

@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