Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug: Fresh deploy have a bad connection string to the PostgreSQL database #1212

Closed
kbeaugrand opened this issue Sep 11, 2022 · 0 comments · Fixed by #1214
Closed

Bug: Fresh deploy have a bad connection string to the PostgreSQL database #1212

kbeaugrand opened this issue Sep 11, 2022 · 0 comments · Fixed by #1214
Assignees
Labels
bug Something isn't working
Milestone

Comments

@kbeaugrand
Copy link
Member

Expected Behavior

The PostgreSQL database connection string on the web app should be in the format :

Server=<serverName>.postgres.database.azure.com;Database=portaldemo;Port=5432;User Id=<userId>@<serverName>;Password=******;Pooling=true;Connection Lifetime=0;Command Timeout=0;Ssl Mode=VerifyFull;

Current Behavior

Current result is :

[concat('User ID=', parameters('pgsqlAdminLogin'), ';Password=', parameters('pgsqlAdminPassword'), ';Host=', concat(variables('pgsqlServerName'), '.postgres.database.azure.com') ,';Port=5432;Database=', variables('siteName') ,';Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;

Steps to Reproduce

  1. Click on Deploy to Azure button
  2. Validate the deployment to the Portal

Context (Environment)

Portal version: v3-dev
LoRaWAN Stack version:

Logs

Additional Information

@kbeaugrand kbeaugrand added the bug Something isn't working label Sep 11, 2022
@kbeaugrand kbeaugrand added this to the S40 milestone Sep 11, 2022
@kbeaugrand kbeaugrand self-assigned this Sep 11, 2022
@kbeaugrand kbeaugrand moved this to 🚧 In Progress in IoT Hub Portal Sep 11, 2022
kbeaugrand added a commit that referenced this issue Sep 11, 2022
@hocinehacherouf hocinehacherouf moved this from 🚧 In Progress to 🚀 Ready in IoT Hub Portal Sep 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
Status: 🚀 Ready
Development

Successfully merging a pull request may close this issue.

1 participant