Comments (8)
@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.
I restarted my service to see if there is an issue with the newest release build, but it seems fine.
2 questions.
- On your PostgreSQL server do you have "Allow public access from any Azure service within Azure to this server" checked under networking?
- On the Web App, under networking do you have any access restrictions defined under inbound traffic?
from passwordpusher.
I restarted my service to see if there is an issue with the newest release build, but it seems fine. 2 questions.
- On your PostgreSQL server do you have "Allow public access from any Azure service within Azure to this server" checked under networking?
- On the Web App, under networking do you have any access restrictions defined under inbound traffic?
Hi @jgudmundson-RETSD, thanks for helping out here.
- 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.
- 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.
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.
Hello @jnhrv, thanks for contributing to the Password Pusher community! We will respond as soon as possible.
from passwordpusher.
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+".
from passwordpusher.
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.
@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)
- MySQL doesn't like a default value for TEXT fields (release 1.28.0) HOT 16
- copy buttons not working anymore HOT 2
- no translations for Passphrase Lockdown feature HOT 2
- Changing default value in azure HOT 4
- Show hide Header and Footer completely HOT 2
- Allow applying custom CSS by using a url in head tag HOT 1
- FR: Anonymous File & URL Pushes HOT 1
- . HOT 5
- missing private.sqlite3 on pwpush-ephemeral container image HOT 4
- FR: Add option to disable (hide) password generator
- Disable some languages. HOT 3
- QR Code, for Created URL, in Preview Page HOT 3
- Different URL for generated links HOT 2
- Kubernetes Pod replies "403 Forbiden" after a while HOT 5
- Increase Default Value for hourly throttling
- FR: Add option to show logo on preliminary page (1-click retrieval step)
- "Generate Password" creates wrong password length HOT 2
- Failing to start up container, exec format error HOT 5
- Emails are not sent in the locale that the user signed up with HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from passwordpusher.