Question

How to connect laravel project in App Platform to Database Managed Cluster?

Posted February 3, 2021 1.7k views
DigitalOcean App Platform

Hello everyone, I try to deploy a Laravel project in Digitalocean App platform but I have problems with database connections.
My env variables are:

DB_HOST = ${db-cluster-name.DATABASE_URL}
DB_CONNECTION = mysql
DB_PORT = ${db-cluster-name.PORT}
DB_DATABASE = db_name
DB_USERNAME= db_username
DB_PASSWORD= db_password

When I try in DO console commands like:

php artisan migrate

I have the following errors:

In Connection.php line 671:

  SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known (SQL: select * from information_schema.tables where t  
  able_schema = circle_in_family and table_name = migrations and table_type = 'BASE TABLE')                                                             


In Connector.php line 70:

  SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known  


In Connector.php line 70:

  PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known 

Any ideas?

1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
2 answers

Hi there @elenaRay,

The details would usually look like this:

Database details for Laravel

I could suggest watching this video by Chris on how to deploy Laravel to the app platform:

Let me know how it goes.
Regards,
Bobby

Thanks very much bobbyiliev! I hadn’t seen the video and it was very helpful to me. My fault was that I have DBHOST and not DATABASEURL.