unable to use password from property file in mule 4

Question

I am not able to use the below mentioned password from property file in mule4. I am trying like ${db.password} and database connectivity is failing but hardcoded value is working fine. Is it because password contain colon and semicolon?

app.properties

db.host=test
db.port=1443
db.database=test_db
db.password=DAwrtkcz%35:\zC;

xml config not working:

    <db:config name="Database_Config" doc:name="Database Config" doc:id="af868fbb-3dc2-4392-9e8d-4195343e26d9" >
            <db:mssql-connection host="${db.host}" port="${db.port}" user="${db.user}" password="${db.password}" databaseName="${db.dbname}" />
    </db:config>

xml config working:

    <db:config name="Database_Config" doc:name="Database Config" doc:id="af868fbb-3dc2-4392-9e8d-4195343e26d9" >
            <db:mssql-connection host="${db.host}" port="${db.port}" user="${db.user}" password="DAwrtkcz%35:\zC;" databaseName="${db.dbname}" />
    </db:config>

gobal.xml

   <configuration-properties doc:name="Configuration properties" doc:id="edb2306f-8ead-4bfc-8263-d78300b26ce7" file="properties\app.properties" />

edit the question to add a minimal reproducible example. Be sure to include the Database connector configuration -as XML text, no images- and how the property file is configured. If there are any errors add them too. Use code block format for configurations, code and logs. — aled
– aled, Commented Aug 29, 2024 at 13:30
@aled I've added the xml config. Error is just connectivity failure. If i am passing hardcoded value in password it's working. — Devendra
– Devendra, Commented Aug 29, 2024 at 14:13

Nampd · Accepted Answer · 2024-09-27 04:50:19Z

1

Maybe string password need to have a escape char to escape “\”. It would be like:

DAwrtkcz%35:\\zC;

answered Sep 27, 2024 at 4:50

Nampd

597 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Terry Rise · Accepted Answer · 2024-10-01 15:39:56Z

0

Use a YAML format and wrap it with quote?

src/main/resources/properties/app-config.yaml

db:
  host: "test"
  port: "1443"
  database: "test_db"
  password: "DAwrtkcz%35:\zC;"

global.xml

<configuration-properties doc:name="Configuration properties" doc:id="edb2306f-8ead-4bfc-8263-d78300b26ce7" file="properties\app.yaml" />

answered Oct 1, 2024 at 15:39

Terry Rise

111 silver badge2 bronze badges

Collectives™ on Stack Overflow

unable to use password from property file in mule 4

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related