Database connection [mysqlProjects] not configured.

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.

Hi I am Amit Kumar Thakur Experienced as s Software Developer with a demonstrated history of working in the information technology and services industry. Skilled in HTML, CSS, Bootstrap4, PHP, Laravel-9 , REST API,FB API,Google API, Youtube Api, Bitbucket,Github,Linux and jQuery. Strong engineering professional focused in Computer/Information Technology Administration and Management. Currently my profile is to Software Developer, analyze the requirement, creating frame for web application, coding and maintenance.

Related Posts

How to Crawl any website Meta Title and Meta Description in Laravel ?

1st step install below package. Next to create Controller First go to route and put below code Next go to controller and put below code Next go…

SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: insert into `oauth_clients` (`user_id`, `name`, `secret`

In this tutorial i’m going to solve the error SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: insert into oauth_clients (user_id, name, secret Error :-…

Top 20 Laravel Interview Question in 2024

In this tutorial im going share interview experience For laravel developer. A list of top frequently asked Laravel Interview Questions and answers are given below. Q #1) What is…

How to Get Google Analytics API key ?

In this tutorial we’re going to share how to get the google Analytics API key. I have shared in very easy way. First go enable Google analytics…

Youtube Subscriber Count in ReactJs

In this tutorial i’m going to learn how to count YouTube Subsribers count, views count as well, as define below. In order to install your app, first…

How to Disable Laravel’s Eloquent timestamps in laravel ?

In this tutorial we’re going to share how to disable the automatic created_at and updated_at timestamps in Laravel’s Eloquent models, along with explanations of different scenarios: 1st…

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x