Autodeploy PRs to Heroku for immediate testing

[mariobehling]

To enable reviewers to test PRs quickly autodeployment is useful. Please implement autodeployment to Heroku for open pull requests.

[pavnesh-c]

Please assign this issue to me

[HeroicHitesh]

@mariobehling If I am not wrong, I think this can be done by a person with access to Heroku account of the org. and Heroku have easy to setup UI according to this doc. If we there is some other way in which we as contributor can contribute to this, do let me know.

[pavnesh-c]

@HeroicHitesh yes i think you are right... i just looked into it

[mariobehling]

Please use your personal account to get this running and share the access to the app with maintainers afterwards.

[HeroicHitesh]

@mariobehling In this case also, I will need the admin access to the repo.

And can you please mention which branch we want to deploy to?

[mariobehling]

Please try from your own fork first

[pavnesh-c]

@HeroicHitesh i am not working on this issue. you may work on it, if you want.

[HeroicHitesh]

@mariobehling I tried setting-up auto-deployment, but it failed on it's first build and initially it seemed like it's PHP version issue, but now I am not sure if that is the case.
Posting the relevant log from Heroku logs

> @php artisan migrate --force
       
       In Connection.php line 664:
                                                                                      
         SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_s  
         chema.tables where table_schema = orgmanager and table_name = migrations an  
         d table_type = 'BASE TABLE')                                                 
                                                                                      
       
       In Connector.php line 70:
                                                    
         SQLSTATE[HY000] [2002] Connection refused  
                                                    
       
       Script @php artisan migrate --force handling the post-install-cmd event returned with error code 1
 !     WARNING: An error occurred during a database connection or query
 !     ERROR: Dependency installation failed!
 !     
 !     The 'composer install' process failed with an error. The cause
 !     may be the download or installation of packages, or a pre- or
 !     post-install hook (e.g. a 'post-install-cmd' item in 'scripts')
 !     in your 'composer.json'.
 !     
 !     Typical error cases are out-of-date or missing parts of code,
 !     timeouts when making external connections, or memory limits.
 !     
 !     Check the above error output closely to determine the cause of
 !     the problem, ensure the code you're pushing is functioning
 !     properly, and that all local changes are committed correctly.
 !     
 !     For more information on builds for PHP on Heroku, refer to
 !     https://devcenter.heroku.com/articles/php-support
 !     
 !     REMINDER: the following warnings were emitted during the build;
 !     check the details above, as they may be related to this error:
 !     - Your app's PHP version is close to end of maintenance
 !     - An error occurred during a database connection or query
 !     Push rejected, failed to compile PHP app.
 !     Push failed

I am trying to figure out the cause. Any help would be appreciated.

@pc-beast Thanks for informing, actually I started working on this before your comment.

[HeroicHitesh]

@mariobehling The auto-deployment is setup in the Heroku, but the builds are failing because of

@php artisan migrate --force

I think it's a separate issue but I am not sure, let me know if I need to create a separate issue for this, or we already have an issue addressing it.

[HeroicHitesh]

The pipeline is ready

but the build fails

I tried updating DB_HOST in database.php to 127.0.0.1 but still didn't work. Then tried setting up the env variables in the Heroku Dashboard, as .env is ignored, but unable to find the correct APP_KEY and APP_URL.

@mariobehling @iamareebjamal
Let me know if you have any idea regarding how to resolve the build failure issue.

[iamareebjamal]

Please use postgresql

[HeroicHitesh]

I was able to set up the project in Heroku by first creating Postgres DB and then creating the build. But on viewing the deployed project I am getting this error

I am not sure if this is some other issue or due to the wrong API_KEY
I am using the API_KEY written in phpunit.xml file.

@mariobehling @iamareebjamal
Let me know if you have any idea regarding how to resolve this issue.