In this tutorial im going to solve this Database connection [mysqlProjects] not configured. This issue is coming when you call another microservice data.
Error:-
Database connection [mysqlProjects] not configured. {"exception":"[object] (InvalidArgumentException(code: 0):
Solution:-
1st step :- go to model and paste code as per below.
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Webdata extends Model
{
protected $connection = 'mysqlProjects';
protected $table = 'projects';
}
2nd Step :- Go to config/database.php and paste below code.
'mysqlProjects' => [
'driver' => 'mysql',
'host' => env('DB_HOST_PROJECTS_COUNT', '127.0.0.1'),
'port' => env('DB_PORT_PROJECTS_COUNT', '3306'),
'database' => env('DB_DATABASE_PROJECTS_COUNT', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'strict' => false,
'engine' => null,
],
Next go to .env and paste below code.
DB_CONNECTION_PROJECTS_COUNT=mysql
DB_HOST_PROJECTS_COUNT=127.0.0.1
DB_PORT_PROJECTS_COUNT=3306
DB_DATABASE_PROJECTS_COUNT=wz-projects-ms
DB_USERNAME_USER_COUNT=root
DB_PASSWORD_ORGANISATION_TYPE_COUNT=
DB_CONNECTION_ORGANISATION_COUNT=mysql
DB_HOST_PROJECTS_COUNT=127.0.0.1
DB_PORT_PROJECTS_COUNT=3306
Next put in .env file below code.
SD_PROJECTS_MS_BASE_URL=http://wz-projects-ms
SD_PROJECTS_MS_OAUTH_TOKEN_URL=/oauth/token
SD_PROJECTS_MS_GRAND_TYPE=client_credentials
SD_PROJECTS_MS_CLIENT_ID=10
SD_PROJECTS_MS_SECRET=P0uKdreAIHfUeXUdgaHrDyCUH1MvzWynF437SLPy
SD_PROJECTS_MS_ALL_URL=/api/v1/j/project
SD_PROJECTS_MS_STORE_URL=/api/v1/j/project/store
SD_PROJECTS_MS_DELETE_URL=/api/v1/j/project/destroy
SD_PROJECTS_MS_EDIT=/api/v1/j/project/edit
SD_PROJECTS_MS_UPDATE=/api/v1/j/project/update
Now All configuration set properly and its working fine.