Giter VIP home page Giter VIP logo

Comments (8)

jnhrv avatar jnhrv commented on June 21, 2024 2

@pglombardo @jgudmundson-RETSD
Thank you both for the help!

Looks like it was truly related to the password that contained special characters.
When I previously tried to quote the password with the "double quotes", that did not work either.
I changed the pw to not contain any special chars and now the database migrated successfully, is populated with tables, the app service is running and data are retained after the app restart too! Lovely 🙂

from passwordpusher.

jgudmundson-RETSD avatar jgudmundson-RETSD commented on June 21, 2024 1

I restarted my service to see if there is an issue with the newest release build, but it seems fine.
2 questions.

  1. On your PostgreSQL server do you have "Allow public access from any Azure service within Azure to this server" checked under networking?
  2. On the Web App, under networking do you have any access restrictions defined under inbound traffic?

from passwordpusher.

jnhrv avatar jnhrv commented on June 21, 2024 1

I restarted my service to see if there is an issue with the newest release build, but it seems fine. 2 questions.

  1. On your PostgreSQL server do you have "Allow public access from any Azure service within Azure to this server" checked under networking?
  2. On the Web App, under networking do you have any access restrictions defined under inbound traffic?

Hi @jgudmundson-RETSD, thanks for helping out here.

  1. yes, first I added there only the outbound IPs of the App Service but then I also tested with the "Allow public access from any Azure service within Azure to this server" checked.
  2. No, there are no restrictions on inbound/outbound traffic of App Service. All features are Off.

Don't know what difference it makes if I use the B1 tier for App Service Plan and the Postgres is running on the following cheapest server config "Burstable, B1ms, 1 vCores, 2 GiB RAM, 32 GiB storage".

from passwordpusher.

pglombardo avatar pglombardo commented on June 21, 2024 1

That helps. The application can't parse or lookup the database connection specified in DATABASE_URL:

URI::InvalidURIError: bad URI(is not URI?)

Could it be that your real username or password have characters that conflict with the URI? Such as , :, @ or others?

If so you may need to quote those strings or replace them with their UUEncode equivalent (@ == %40, == %20).

from passwordpusher.

github-actions avatar github-actions commented on June 21, 2024

Hello @jnhrv, thanks for contributing to the Password Pusher community! We will respond as soon as possible.

from passwordpusher.

jgudmundson-RETSD avatar jgudmundson-RETSD commented on June 21, 2024

I'm also running on B1, and B1ms.
Did you check if the database is populated? on the DB site click connect, pick table, enter the password, run "\dt+".
image

from passwordpusher.

pglombardo avatar pglombardo commented on June 21, 2024

The database should automatically be migrated on container start.

In that screenshot, the line before states that the container exited which means a startup issue. The most likely culprit to this is a missing DATABASE_URL environment variable that points to your postgres database.

An example would be:

DATABASE_URL=postgresql://user:passwd@host:5432/database-name

Could you verify this?

Last point - if you get the container startup output that will tell us exactly what the problem is.

Logging is not enabled for this container. Please use https://aka.ms/linux-diagnostics to enable logging to see container logs here.

from passwordpusher.

jnhrv avatar jnhrv commented on June 21, 2024

@jgudmundson-RETSD
Looks like the database is not populated.
postgres=> \dt+ Did not find any relations.

@pglombardo I attached logs after I changed the App Service to the postgres:release image and set the DATABASE_URL again.
The DATABASE_URL has been always in place when I used the postgres image.

pwpush_azureAppService_logs.txt

from passwordpusher.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.