Change port external database

[chaerulanam]

how to change port external database?

[jessebot]

What database are you using? You can find some info on both PostgreSQL and MariaDB here:

• https://github.com/nextcloud/helm/tree/main/charts/nextcloud#database-configurations
• https://github.com/bitnami/charts/tree/main/bitnami/postgresql#parameters
• https://github.com/bitnami/charts/tree/main/bitnami/mariadb#parameters

For mariadb, you'd want mariadb.primary.containerPorts.mysql.
For postgresql, you'd want postgresql.containerPorts.postgresql

However, when I looked further, it doesn't look like port is included here:

helm/charts/nextcloud/values.yaml

Lines 354 to 382 in 0565cdb

	##
	## External database configuration
	##
	externalDatabase:
	enabled: false
	## Supported database engines: mysql or postgresql
	type: mysql
	## Database host
	host:
	## Database user
	user: nextcloud
	## Database password
	password: ""
	## Database name
	database: nextcloud
	## Use a existing secret
	existingSecret:
	enabled: false
	# secretName: nameofsecret
	usernameKey: db-username
	passwordKey: db-password
	# hostKey: db-hostname-or-ip
	# databaseKey: db-name

it's also not included here:
https://github.com/nextcloud/helm/blob/0565cdba9843040bc7e2641b8ac6955d2feba9ae/charts/nextcloud/files/defaultConfigs/autoconfig.php.tpl

I think we need to update the chart as this should be configurable 🤔 I opened #632 to explore this further.

[jessebot]

Looks like you can just specify the port in the dbhost field in config.php, as mentioned in #632 (comment), so say your custom port is 1234, you'd do that in values.yaml like this:

 externalDatabase: 
   host: "myhostname.com:1234"

We'll look into updating our docs to reflect that as soon as we can :) (here's the merged PR for more doc: #634 now available in 6.0.2)

[jessebot]

Also if you need further help, feel free to comment and we're still happy to help out. I just closed this since we found the docs up stream to confirm it's actually possible. Still happy to provide assistance though :)