Skip to content

[Bug]: When using dab init with a password with special characters, it escapes them and the DB cannot login #1321

@JetterMcTedder

Description

@JetterMcTedder

What happened?

I run the following:
dab init --database-type "mssql" --connection-string "Server=localhost,1439;Database=dabDB;User ID=btspendo;Password=5E5C2kM$o&7mYU66!49#tZ1&CN9X2BUj&PCGp7CD@%y%p1x1;TrustServerCertificate=true" --host-mode "Development"
When I look in my dab-config.json file, the password is now:
5E5C2kM**\u00267mYU66!49#tZ1\u0026**CN9X2BUj**\u0026**PCGp7CD@%y%p1x1
and I cannot login to the database because the &'s are being escaped.

Version

Microsoft.DataApiBuilder 0.5.34

What database are you using?

Azure SQL

What hosting model are you using?

Local (including CLI), Custom Docker host

Which API approach are you accessing DAB through?

No response

Relevant log output

fail: Azure.DataApiBuilder.Service.Startup[0]
      Unable to complete runtime initialization operations due to:
Azure.DataApiBuilder.Service.Exceptions.DataApiBuilderException: Cannot obtain Schema for entity customers with underlying database object source: dbo.customers due to: Login failed for user 'btspendo'.

Code of Conduct

  • I agree to follow this project's Code of Conduct

Metadata

Metadata

Labels

bugSomething isn't workingtriageissues to be triaged

Type

No type

Projects

Status

Done

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions