gluu: - config.configmap.cnSqlDbDialect: Does not match pattern '^(mysql)$'

By: Pradeep SP Account Admin 18 Jul 2022 at 5:14 a.m. CDT

10 Responses
Pradeep SP gravatar
Dear Team, we are encoutring error while deploying gluu v5.0.3 on EKS environment. Below is the seniro. We are doing helm based installation by generating values.yaml file to update postgres db credentails. in values.yaml below line we have modified. Helm installation is failing "Does not match pattern '^(mysql)$'". 425 # -- SQL database dialect. `mysql` or `pgsql` 426 cnSqlDbDialect: "pgsql" 427 # -- SQL database host uri. 428 cnSqlDbHost: postgres-postgresql-headless.pg-ns.svc.cluster.local 429 # -- SQL database port. 430 cnSqlDbPort: 5432 431 # -- SQL database name. 432 cnSqlDbName: gluu 433 # -- SQL database username. 434 cnSqlDbUser: gluu 435 # -- SQL database timezone. 436 cnSqlDbTimezone: UTC 437 # -- SQL password injected the secrets . 438 cnSqldbUserPassword: Password@123 Error details: root@NCL048:~/gluu# helm install gluu gluu-flex/gluu --namespace gluu --version 5.0.3 -f values.yaml Error: INSTALLATION FAILED: values don't meet the specifications of the schema(s) in the following chart(s): gluu: - config.configmap.cnSqlDbDialect: Does not match pattern '^(mysql)$' root@NCL048:~/gluu# Please requesting your input on this. Regards, Pradeep
Gluu Other Amazon Linux 2.0
closed

Answers

By Michael Schwartz Account Admin 18 Jul 2022 at 9:11 a.m. CDT

Copy
Michael Schwartz gravatar
Scott, can you take a look?

By Scott Businge staff 18 Jul 2022 at 4:23 p.m. CDT

Copy
Scott Businge gravatar
Hey Pradeep, The structure of your yaml in the question isn't really clear, but my hunch is the value you've set to `cnSqlDbDialect` which is `"pgsql"` is causing the error. Try setting it to `pgsql` without the double quotes. `cnSqlDbDialect: pgsql` Try doing that and let us know if the error persists. Thanks, Scott.

By Pradeep SP Account Admin 19 Jul 2022 at 1:22 a.m. CDT

Copy
Pradeep SP gravatar
Hello Sott, Thanks and much appreciated your quick response. Sorry to inform, Unfortunately it is persisting same error with/without quotes. Thought of sharing process followed from us. Please find the below steps we following to deploy gluu using helm. Kindly Let us know if any correction is needed. **Steps:** $ helm repo add gluu-flex https://gluufederation.github.io/flex/flex-cn-setup/pygluu/kubernetes/templates/helm $ helm show values gluu-flex/gluu --version 5.0.3 > values.yaml **Error:** root@NCL048:~/gluu# helm install gluu gluu-flex/gluu --namespace gluu --version 5.0.3 -f values.yaml Error: INSTALLATION FAILED: values don't meet the specifications of the schema(s) in the following chart(s): gluu: - config.configmap.cnSqlDbDialect: Does not match pattern '^(mysql)$' root@NCL048:~/gluu# I've attached exported values.yaml file for your reference. https://github.com/pradeepsp-ncsc/gluu/blob/main/values.yaml
Video or screenshot link

By Scott Businge staff 19 Jul 2022 at 5:33 a.m. CDT

Copy
Scott Businge gravatar
Hey Pradeep, I see. Thanks for sharing your values.yaml. I'll try replicating that by running it in my environment first then find out why you're getting that error. Will get back to you with a solution. Thanks, Scott.

By Pradeep SP Account Admin 20 Jul 2022 at 7:47 a.m. CDT

Copy
Pradeep SP gravatar
Hello Scott, Just wanted to know, if you got any chance to look into it.. thank you. Regards, Pradeep

By Scott Businge staff 21 Jul 2022 at 3:21 a.m. CDT

Copy
Scott Businge gravatar
Hey Pradeep, Apologies for the delay in response. I'm testing this out before end of day. Will quickly run it and let you know. Thanks, Scott.

By Scott Businge staff 24 Jul 2022 at 3:25 p.m. CDT

Copy
Scott Businge gravatar
Hey Pradeep, I just ran this and I didn't get the error you faced. A few questions; 1. How did you provision your database? Are you using Amazon Aurora? 2. Have you cross checked the database connection parameters like `nSqlDbHost` that you are using, not just the `cnSqlDbDialect` 3. Have you tried to use mysql also or you've only tried pgsql? I presume you are following this section - https://gluu.org/docs/openbanking/1.0.0/install-cn/#amazon-aurora Kindly let me know. Thanks, Scott.

By Scott Businge staff 03 Aug 2022 at 5:25 a.m. CDT

Copy
Scott Businge gravatar
Hey Pradeep, Kindly checking in regarding my last comment. Are you still getting the error during installation. Scott.

By Scott Businge staff 09 Aug 2022 at 4:01 a.m. CDT

Copy
Scott Businge gravatar
Hey Pradeep, We're closing this ticket due to lack of response. We haven't heard back from you in a while. Feel free to reopen it if you have any question or need further support. Thanks.

By Gustavo Valverde user 23 Feb 2023 at 7:41 a.m. CST

Copy
Gustavo Valverde gravatar
This is an issue as the Helm chart does not allow to set postgresql (pgsql) as an option: https://github.com/GluuFederation/flex/blob/ed076a94726c5469a7ddf4de6765a3b7251e4555/flex-cn-setup/pygluu/kubernetes/templates/helm/gluu/values.schema.json#L54 @Scott.Businge

Post an answer