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

9

I download from https://github.com/luciddreamz/laravel Laravel for openshift then upload over my repository over github. This code for connect to database not work. The problem is that load variable from .env file that locate in root of project

for solve this problem change.env

# local environment only
#   for production, see .openshift/.env

APP_ENV=APPLICATION_ENV
APP_DEBUG=true
APP_URL=OPENSHIFT_APP_DNS
APP_KEY=OPENSHIFT_SECRET_TOKEN

DB_DRIVER=mysql
DB_HOST=OPENSHIFT_MYSQL_DB_HOST
DB_PORT=OPENSHIFT_MYSQL_DB_PORT
DB_DATABASE=OPENSHIFT_APP_NAME
DB_USERNAME=OPENSHIFT_MYSQL_DB_USERNAME 
DB_PASSWORD=OPENSHIFT_MYSQL_DB_PASSWORD

CACHE_DRIVER=apc
SESSION_DRIVER=file

my error :

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

createConnection('mysql:host=OPENSHIFT_MYSQL_DB_HOST;port=OPENSHIFT_MYSQL_DB_PORT;dbname=OPENSHIFT_APP_NAME', 
array('driver' => 'mysql', 
      'host' => 'OPENSHIFT_MYSQL_DB_HOST', 
      'port' => 'OPENSHIFT_MYSQL_DB_PORT', 
      'database' => 'OPENSHIFT_APP_NAME', 
      'username' => 'OPENSHIFT_MYSQL_DB_USERNAME', 
      'password' => 'OPENSHIFT_MYSQL_DB_PASSWORD', 
      'charset' => 'utf8',  
      'collation' => 'utf8_unicode_ci', 
      'prefix' => '', 
      'strict' => false, 
      'name' => 'mysql'), 
array('0', '2', '0', false, '0')) in MySqlConnector.php line 20

Related Posts:

  1. No query results for model [App\Products] Laravel
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  4. String concatenation in MySQL
  5. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  6. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  7. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  8. How do I restore a dump file from mysqldump?
  9. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  10. When to use SELECT … FOR UPDATE?
  11. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  12. 1052: Column ‘id’ in field list is ambiguous
  13. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  14. Search for all occurrences of a string in a mysql database
  15. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  16. How to convert a string to date in MySQL?
  17. MySQL COUNT DISTINCT
  18. How to update a record using sequelize for node?
  19. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  20. Convert MySQL to SQlite [closed]
  21. How to install Python MySQLdb module using pip?
  22. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  23. Convert partially non-numeric text into number in MySQL query
  24. Laravel 5 Class ‘Collective\Html\HtmlServiceProvider’ not found on AWS
  25. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  26. MySQL: What’s the difference between float and double?
  27. How can I search (case-insensitive) in a column using LIKE wildcard?
  28. Dump all tables in CSV format using ‘mysqldump’
  29. MySQL Select Multiple VALUES
  30. How to do a batch insert in MySQL
  31. If variable equals value php [duplicate]
  32. MySQL: Cloning a MySQL database on the same MySql instance
  33. mysqldump data only
  34. PHP date() format when inserting into datetime in MySQL
  35. WordPress mysqli and PDO
  36. Optimize WordPress Query that take 5 seconds to execute
  37. MySQL Replication Latency Issues in wp-admin pages
  38. Alternative to mysql_real_escape_string
  39. Same option_id=0 for 2 options in wp_options?
  40. How to let a user choose an authors and save it to the database?
  41. How to remove ‘GROUP BY’ from SQL query produced from get_posts?
  42. MySQL LIKE not working
  43. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  44. Converting mysql to $wpdb
  45. Join new table with SQL query
  46. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  47. MySQL crashed because of the large number of requests
  48. Why doesn’t this code add a table to my database?
  49. SQL database export-import
  50. add_post_meta does not respect the content
  51. Select multiple wp_postmeta keys with single select
  52. Can Someone Help Me Fix This WordPress Missing Argument Error?
  53. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  54. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  55. SQL Database, repeated tables?
  56. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  57. Code to remove authors with no posts connected to them
  58. SQL Query in WordPress – Getting Impossible WHERE error
  59. WordPress create database not working
  60. database optimization and server errors
  61. Setting up WordPress Locally on WAMP for a new site (with one already)
  62. Will reducing mysql permissions hinder WP function? [duplicate]
  63. Calling mysql_query() on another database, assumes WordPress using that database
  64. WordPress VIP realpath Alternative?
  65. querying user bookmarks from a large number of bookmarks
  66. Pull post name from value of a specific meta key
  67. PHP variables in mysql query
  68. How to fix the amount of comments displayed for each post?
  69. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  70. 504 Gateway Time-out after custom plugin inserts data into mysql database
  71. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  72. How to simulate web traffic to test performance of a website
  73. SQL query to change custom field in WordPress database
  74. What is this? MySQL array?
  75. SQL. Select category descendants
  76. MySQL Actibity without any active visitors via Google Analytics
  77. How to configure WordPress Database for CentOS 7
  78. Why should be SQL keywords, like CREATE TABLE and UPDATE, must be uppercase in WordPress?
  79. Why is local wordpress install calling live site executions?
  80. Display MySQL as part of a Page
  81. mysql query on wp_user and user_meta problem
  82. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  83. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  84. WP Meta Query – mixed AND / OR query doesn’t work
  85. get_results() query not working only when entering strings
  86. Add value to array in database
  87. Second completely independent and disposable WordPress installation in subdirectory?
  88. Making CURDATE() recognize current_time()
  89. get_results suddenly not working on a single table
  90. Internal error (500) on local & Fatal error on live when trying to access post type edit screen
  91. Query sql for truncate post_content in wp_posts table
  92. How should I troubleshoot a database serialization issue with a WordPress migration
  93. Foreach only outputs if id is 0
  94. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  95. remove wordpress post links
  96. SQL get last entry of a specific gravity form
  97. mysqldump to a tar.gz
  98. Postgres equivalent to MySQL’s \G?
  99. How to check what port mysql is running on
  100. Where is my mysql log on OS X?

Leave a Comment