port for Metabase?

[stevespaw]

Hi all, We have setup a client with Matomo and also Metabase.
They are looking to connect Metabase to Matomo. I think this is possible, but it looks like we need the port# for Matomo MySQL to complete this. It is not in the config file.
Any help here would be appreciated.
BTW has anyone done this?

Thanks!

[joseph]

You have to use a ssh tunnel for this. See https://docs.cloudron.io/guides/connect-mysql/ and https://www.metabase.com/docs/latest/databases/ssh-tunnel

[joseph]

Are Matomo and Metabase on the same server? If so, ignore my earlier post. You can get the db credentials by running the env | grep CLOUDRON_MYSQL_ command from Matomo's web terminal.

Note that db credentials change when the app is restored/imported etc. But remains the same if you just do simple re-configuration.

[stevespaw]

Yes they are on the same server BTW. Great information, we will give it a try. Thank you so much. I am bookmarking this!