Spring Boot not loading system env vars into application.properties

Question

I have exported some simple db creds on my machine as ENV variables.

export MYSQL_USER=root export MYSQL_PASS=pass

I'm trying to load these dynamically into my profile into spring boot, but to no avail. I'm starting to believe this is because the application runs inside a TomCat container and therefore isolated from the machine env vars.

Development Environment Application Properties File

spring.datasource.username = ${MYSQL_USER}

However, it's still being seen as literal plain text of ${MYSQL_USER}. Does Spring Boot have the capability for readingg in system environment variables?

Could you provide a sample project? Are you sure those values are being loaded properly by the profile/user that your SpringBoot app is running under? For example, did you add those exports to a "/etc/profile.d/mysql.sh" file? — Pytry
– Pytry, Commented Dec 13, 2017 at 23:13
I simply exported these in terminal as shown above, but I have no idea how to actually load system environment variables into Spring Boot. — Ryan S
– Ryan S, Commented Dec 13, 2017 at 23:28
Ok, so if you open another terminal and echo those variables without manually exporting them, what get's shown? — Pytry
– Pytry, Commented Dec 13, 2017 at 23:30
Possible duplicate of spring - read environment variables from inside the application.properties file — bvrakvs
– bvrakvs, Commented Dec 14, 2017 at 4:38

Myth · Accepted Answer · 2017-12-14 05:00:24Z

1

I was also having same problem to get OS env variables into my application.properties/yml using the $ sign. To solve this, I defined the variables to application server(tomcat/jboss etc). Then only the application.properties/yml can get them. Hope this will help.

answered Dec 14, 2017 at 5:00

Myth

1162 silver badges11 bronze badges

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

3 Comments

Ryan S Over a year ago

Can you explain how you did this?

Myth Over a year ago

Many ways to do that depending on application server. As you are using tomcat then you can follow as below: Under Tomcat 's /bin/ create one file - setenv.sh- (touch setenv.sh) then open (sudo nano setenv.sh) and write #!/bin/sh export JAVA_OPTS="-DMYSQL_USER=myuser"

Myth Over a year ago

Make sure to restart tomcat :)

Collectives™ on Stack Overflow

Spring Boot not loading system env vars into application.properties

Development Environment Application Properties File

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Development Environment Application Properties File

1 Answer 1

3 Comments

Linked

Related