Ubanle to use database with @in the username

[amith.kumar.shetty]

I am connecting to postgres hosted on azure . Azure postgres requires the username to be specfied in username@hostname format. If I set the username like this, I get an error while starting the app.

com.inversoft.maintenance.db.JDBCMaintenanceModeDatabaseService - Exception caught executing [CREATE ROLE xxxxx@hostame WITH LOGIN PASSWORD xxxxxxxx]
org.postgresql.util.PSQLException: ERROR: syntax error at or near "@"
  Position: 23

Any method to fix this?

[dan]

Hi @amith-kumar-shetty !

This is a known limitation of FusionAuth. More details here: https://github.com/FusionAuth/fusionauth-issues/issues/1036

Please upvote that issue if you'd like to see this fixed.

[amith.kumar.shetty]

@dan Thank you. I had to manually run the CREATE ROLE “postgresql@hostxxxx” LOGIN PASSWORD 'yyyyyyyyyy' on my database instance before starting the app. Then everything works ok. Note the double quotes around the username

[dan]

@amith-kumar-shetty Excellent, glad you got it working!