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

Could not fetch https://api.github.com/repos/Setasign/FPDI/zipball/

When I composer update in Laravel its throwing error could not fetch issues so let’s start to finish this issues. 1st step go to GitHub setting section….

Error: error:0308010C:digital envelope routines::unsupported

In this tutorial I’m going to share how to solve Error: error:0308010C:digital envelope routines::unsupported. Just copy below code and run your terminal. After run above all code…

API calls from the server require an appsecret_proof argument

In this tutorial im going to solve this issue API calls from the server require an appsecret_proof argument. 1st step go to developer facebook advance setting and…

How to Delete All Records Older Than 30 Days in Laravel 10 ?

In Laravel, you can use the Eloquent ORM to delete records older than a certain number of days. Here’s an example of how you can delete all…

How to safely remove Laravel Debugbar ?

What is Laravel Debugbar ? Laravel Debugbar is a package for the Laravel PHP framework that provides a debug bar or toolbar for your application. It offers…

Example of __construct and __destruct in laravel ?

In Laravel, PHP classes can have a constructor and destructor like any other PHP class. The constructor is called when an object is created, and the destructor…

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