Hi I downloaded

Question

Hi I downloaded I want to use this example to learn how to deploy KVision full stack project on Heroku Or you may suggest any other cloud platform I have tried this tutorial Heroku says Build succeeded but when I open the link I get Application error Screenshot below Logs are too big for this message so I use pastebin I think that I need to change Procfile somehow but I don t understand exactly what I need to do Could you help me please

ashmelev · Answer

< Nazar Pohonchuk> I think the underlying cause is your JDBC URL The error ```IllegalArgumentException URL sslMode=REQUIRE does not start with the r2dbc scheme``` indicates you probably need to change the URL string in the database connection config

Nazar Pohonchuk · Answer

< ashmelev> I downloaded the project from GitHub and I didn t change Procfile ```web java Dserver port=$PORT Dspring r2dbc url=`echo $JDBC DATABASE URL | sed e s jdbc r2dbc | sed e s ` sslMode=REQUIRE Dspring r2dbc username=$JDBC DATABASE USERNAME Dspring r2dbc password=$JDBC DATABASE PASSWORD jar build libs kvision realworld example app fullstack 1 0 0 SNAPSHOT jar``` So what URL should I paste I think It is a really dumb question but I am a newbie So could you please explain how would I get that URL

Nazar Pohonchuk · Answer

Also in README md the <https kvision realworld fullstack herokuapp com |Demo> link deployed application on Heroku doesn t work And README md says that the app uses PostgreSQL when deployed to Heroku so I need to get the link to PostgreSQL database May use h2database when deployed to Heroku

ashmelev · Answer

Now you are beyond my knowledge base I do not use Heroku I can say that yes you will need Postgress I doubt it ll be easy for a newbie slightly smiling face to substitute H2 That said in `Profile` you will see `sslMode=REQUIRE` try to replace that with either `sslMode=false` or `sslMode=disable` If the issue is the SSL connectivity and associated keystore etc the disabling SSL may help

Robert Jaros · Answer

It seems Heroku doesn t pass JDBC DATABASE URL env variable to your app at all

Robert Jaros · Answer

Have you activated database module

Robert Jaros · Answer

I don t remember how it s named and I can t login to my heroku account anymore to check

Robert Jaros · Answer

When you add database module Heroku will pass `jdbc ` url and this procfile will convert it to start with `r2dbc ` prefix

Nazar Pohonchuk · Answer

< Robert Jaros> I tried this command `heroku pg credentials url DATABASE` and got webk fullstack has no database So I ran this command `heroku addons create heroku postgresql` and everything works now Thank you very much for your help