Migrating Tenant Databases - Multi Database #27

wahyubaskara · 2020-05-29T04:05:22Z

I've been follow all steps in the documentation, from creating landlord and tenant db connection then create a couple of rows in the tenants table with correct database name. After that i ran this command php artisan tenants:artisan migrate but the result always give me error: Invalid catalog name: 1046 No database selected

Full error message:

My database config:

My tenants table in landlord database:

My local databases:

My multitenancy.php config file:

The text was updated successfully, but these errors were encountered:

martincarvalho · 2020-05-29T04:41:13Z

try updating:
'tenant_finder' => null,
to:
'tenant_finder' => Spatie\Multitenancy\TenantFinder\DomainTenantFinder::class,

wahyubaskara · 2020-05-29T04:48:59Z

Not working, same error occurred

freekmurze · 2020-05-29T15:31:23Z

What is the output of config('multitenancy') in a tinker session?

wahyubaskara · 2020-05-29T15:34:31Z

Sorry, how can i get the output?

freekmurze · 2020-05-29T15:39:42Z

Run php artisan tinker

wahyubaskara · 2020-05-29T15:45:55Z

Here is the result

freekmurze · 2020-05-29T15:52:55Z

what is the output of config('database')?

wahyubaskara · 2020-05-29T16:00:55Z

okay here is

juanparati · 2020-06-01T09:54:30Z

@wahyubaskara: try to change:

"default" => "mysql"

by

"default" => "tenant"

wahyubaskara · 2020-06-02T02:55:49Z

Solved! You saved me, thank you👍

kurucu · 2020-10-04T16:46:39Z

@wahyubaskara: try to change:

"default" => "mysql"

by

"default" => "tenant"

Oh my word, this has been tripping me up! Is this in the docs?

masterix21 · 2020-10-04T20:56:44Z

@kurucu, no, isn't in the docs because the default connection is a state of mind: depends on your project and your approach.

Saimon-git · 2021-05-03T21:30:17Z

hello spatie guys and @freekmurze
I am contacting you because I have a problem with the multitenacy package, I can not get the connection to the tenant to work, I have as default connection "tenant" this is the error that I throw

SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')

masterix21 · 2021-05-03T21:50:03Z

@Saimon-git, have you followed the documentation?

Saimon-git · 2021-05-03T21:53:32Z

@Saimon-git, have you followed the documentation?

thanks @masterix21

refaatgamal · 2021-05-31T14:22:32Z

I have the same error but all above i made it and still this problem exist

masterix21 · 2021-06-04T21:34:29Z

@refaatgamal are you using the SwitchDatabaseTask?

refaatgamal · 2021-06-04T21:37:44Z

Yes and now all tenants works well but I can't make landlord working but tenants works

masterix21 · 2021-06-05T08:37:50Z

@refaatgamal, I'm sure it's a misconfiguration issue. Please dig inside reading our documentation. Thanks.

refaatgamal · 2021-06-05T19:33:06Z

Already working as docs but landlord didn't work how can I login as landlord I make virtual domains in local host for tenants but when I go to project direct with out tenant domain it gives me no database selected issue

arslanakram1 · 2021-09-13T12:08:09Z

@refaatgamal got any solution on this issue? I'm trying to implement the laravel multitenancy and facing the same issue that you mentioned in your last comment. Thanks

masterix21 · 2021-09-23T19:43:46Z

Sorry, but I still think that is a coding problem. Please create a GitHub repository with your sample code that generates the errors: I'll try to help asap.

Azmeer-crescent · 2022-02-23T13:38:01Z

I am having the exact same problem after doing this:
"default" => "tenant"

I can login to tenants but NOT to landlord account. getting the same error as:
refaatgamal commented on May 31, 2021

But when I switch the line back to:
'default' => env('DB_CONNECTION', 'mysql'),
Both landlord and tenants started working ! My DB_CONNECTION is pointing to the landlord database

Noor600 · 2022-03-28T19:53:32Z

I got this bug

Noor600 · 2022-03-28T19:54:11Z

`'default' => 'tenant',

/*
|--------------------------------------------------------------------------
| Database Connections
|--------------------------------------------------------------------------
|
| Here are each of the database connections setup for your application.
| Of course, examples of configuring each database platform that is
| supported by Laravel is shown below to make development simple.
|
|
| All database work in Laravel is done through the PHP PDO facilities
| so make sure you have the driver for your particular database of
| choice installed on your machine before you begin development.
|
*/

'connections' => [

    'sqlite' => [
        'driver' => 'sqlite',
        'url' => env('DATABASE_URL'),
        'database' => env('DB_DATABASE', database_path('database.sqlite')),
        'prefix' => '',
        'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
    ],

    'mysql' => [
        'driver' => 'mysql',
        'url' => env('DATABASE_URL'),
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'forge'),
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'prefix_indexes' => true,
        'strict' => true,
        'engine' => null,
        'options' => extension_loaded('pdo_mysql') ? array_filter([
            PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
        ]) : [],
    ],

    'tenant' => [
        'driver' => 'mysql',
        'url' => env('DATABASE_URL'),
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '3306'),
        'database' => null,
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'prefix_indexes' => true,
        'strict' => true,
        'engine' => null,
        'options' => extension_loaded('pdo_mysql') ? array_filter([
            PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
        ]) : [],
    ],

    'landlord' => [
        'driver' => 'mysql',
        'url' => env('DATABASE_URL'),
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '3306'),
        'database' => 'landlord',
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'prefix_indexes' => true,
        'strict' => true,
        'engine' => null,
        'options' => extension_loaded('pdo_mysql') ? array_filter([
            PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
        ]) : [],
    ],`

Noor600 · 2022-03-28T20:11:53Z

@masterix21 Is there a solution to this problem ?

masterix21 · 2022-03-28T20:46:35Z

Please post your Admin model

Noor600 · 2022-03-29T06:03:09Z

class Admin extends Authenticatable {
	use Notifiable;

	protected $table = 'admins';
	protected $fillable = [
		'email',
		'name',
		'photo_profile',
		'password',
		'group_id',
		'remember_token',
	];

	protected $hidden = ['password'];

	public function group_id() {
		return $this->hasOne(\App\Models\AdminGroup::class, 'id', 'group_id');
	}

	public function role($name) {
		$exists_group_id = $this->getConnection()
			->getSchemaBuilder()
			->hasColumn($this->getTable(), 'group_id');
		if ($exists_group_id) {
			$explode_name = explode('_', $name);

			if (!empty($this->group_id()->first())) {
				$role = $this->group_id()->first()->role()->where('name', $explode_name[0])->first();
				if (!empty($role) && $role->{$explode_name[1]} == 'yes') {
					return true;
				} else {
					return false;
				}
			} else {
				return false;
			}
		} else {
			return false;
		}
	}

}

Noor600 · 2022-03-29T07:48:35Z

SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (SQL: select * from settings order by id desc limit 1) (View: D:\delivery\resources\views\admin\login.blade.php)
I think this problem not related with Admin model

Noor600 · 2022-03-29T07:54:45Z

I created two databases and two domains
php artisan serve --port=8001

in two domain I got this problem

masterix21 · 2022-03-30T13:30:17Z

Admin model is in the landlord or in the tenant database? Why you didn't prepare your model? Take a look here: https://spatie.be/docs/laravel-multitenancy/v2/installation/using-multiple-databases#content-preparing-models

All models in your project should either use the UsesLandlordConnection or UsesTenantConnection, depending on if the underlying table of the models lives in the landlord or tenant database.

Noor600 · 2022-03-30T14:54:01Z

Ok I Will prepare the models
thanks bro ❤️❤️❤️

Noor600 · 2022-03-31T09:52:01Z

@masterix21 unfortunately the same problem
:(
I need an urgent solution

masterix21 · 2022-03-31T10:06:23Z

The open-source package philosophy lies in free cooperation: if you are here to search for an urgent solution, the best way is to dig inside the code to find it yourself.

Anyway, please create a public GitHub repository with your code to help me to understand where your errors are.

Thanks.

Noor600 · 2022-03-31T10:41:32Z

ok
thanks 3>

Noor600 · 2022-03-31T12:00:54Z

@masterix21 I created new repo and I invited you

abdallah0128318 · 2022-04-19T22:09:07Z

@masterix21
here I have all things work very good but my problem is just I can`t migrate tenant database tables after the tenant is created
here is my code

protected static function booted()
    {
        static::creating(fn(User $model) => $model->createDatabase());
    }

    public function createDatabase()
    {
        // add logic to create database

        DB::connection()->statement('CREATE DATABASE tenant_' . $this->username);
        $this->database = 'tenant_' . $this->username;
        Artisan::call('tenants:artisan migrate --tenant=' . $this->id);
    }

masterix21 · 2022-05-03T08:22:58Z

How can you call $this->id if createDatabase() is called during the creating event?

freekmurze closed this as completed May 29, 2020

freekmurze reopened this May 29, 2020

wahyubaskara closed this as completed Jun 2, 2020

redonosmanollaj mentioned this issue Jun 17, 2020

Sanctum package not switching the database connection #51

Closed

rogerad mentioned this issue May 26, 2021

migration undefined contant STDIN #248

Closed

isaacdarcilla mentioned this issue Mar 28, 2022

php artisan tenants:artisan "queue:work" not working #348

Closed

sanketr43 mentioned this issue May 3, 2023

Queue Job Batching #446

Closed

MattWiseParking mentioned this issue Jan 12, 2024

base table or view not found with AWS SQS queue for job TenantAware #505

Open

Migrating Tenant Databases - Multi Database #27

Migrating Tenant Databases - Multi Database #27

Comments

wahyubaskara commented May 29, 2020 • edited Loading

martincarvalho commented May 29, 2020 • edited Loading

wahyubaskara commented May 29, 2020 • edited Loading

freekmurze commented May 29, 2020

wahyubaskara commented May 29, 2020

freekmurze commented May 29, 2020

wahyubaskara commented May 29, 2020

freekmurze commented May 29, 2020

wahyubaskara commented May 29, 2020

juanparati commented Jun 1, 2020

wahyubaskara commented Jun 2, 2020

kurucu commented Oct 4, 2020

masterix21 commented Oct 4, 2020

Saimon-git commented May 3, 2021

masterix21 commented May 3, 2021

Saimon-git commented May 3, 2021

refaatgamal commented May 31, 2021

masterix21 commented Jun 4, 2021

refaatgamal commented Jun 4, 2021

masterix21 commented Jun 5, 2021

refaatgamal commented Jun 5, 2021

arslanakram1 commented Sep 13, 2021

masterix21 commented Sep 23, 2021

Azmeer-crescent commented Feb 23, 2022 • edited Loading

Noor600 commented Mar 28, 2022

Noor600 commented Mar 28, 2022

Noor600 commented Mar 28, 2022

masterix21 commented Mar 28, 2022

Noor600 commented Mar 29, 2022 • edited by masterix21 Loading

Noor600 commented Mar 29, 2022

Noor600 commented Mar 29, 2022

masterix21 commented Mar 30, 2022

Noor600 commented Mar 30, 2022

Noor600 commented Mar 31, 2022

masterix21 commented Mar 31, 2022 • edited Loading

Noor600 commented Mar 31, 2022

Noor600 commented Mar 31, 2022

abdallah0128318 commented Apr 19, 2022 • edited by masterix21 Loading

masterix21 commented May 3, 2022

wahyubaskara commented May 29, 2020 •

edited

Loading

martincarvalho commented May 29, 2020 •

edited

Loading

wahyubaskara commented May 29, 2020 •

edited

Loading

Azmeer-crescent commented Feb 23, 2022 •

edited

Loading

Noor600 commented Mar 29, 2022 •

edited by masterix21

Loading

masterix21 commented Mar 31, 2022 •

edited

Loading

abdallah0128318 commented Apr 19, 2022 •

edited by masterix21

Loading