Auth does not work - Base table or view not found

[MartinWeidner]

Hi, I installed a fresh laravel and followed the instructions to install and configure the package. The DomainTenantFindet seemed to working, migrations and commands also... But Auth using laravels auth facade don't work...

Steps to reproduce:

composer create-project laravel/laravel multitenancy
cd multitenancy
composer require laravel/ui\n
php artisan ui bootstrap --auth\n
npm install
npm run build
composer require "spatie/laravel-multitenancy:^3.0"
php artisan vendor:publish --provider="Spatie\Multitenancy\MultitenancyServiceProvider" --tag="multitenancy-config"
php artisan vendor:publish --provider="Spatie\Multitenancy\MultitenancyServiceProvider" --tag="multitenancy-migrations"
php artisan migrate --path=database/migrations/landlord --database=landlord
php artisan tenants:artisan "migrate --database=tenant"

I've also added Domains and Databases on my local environment

Tenant::current() returns null (on landlord domain) or the correct tenant.

If I am on a subdomain and try to register a user, i got error

http://tenant1.multitenancy.localhost/register
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'multitenancy.users' doesn't exist

The table exisits on the tenant database...

If you need further information, let me know and I will provide as possible.

Thanks in Advance
Martin

[masterix21]

Hi @MartinWeidner. Please post your User model.

Thanks

[MartinWeidner]

Hi @masterix21, thanks for your reply.

This is my user model, i only changed "UsesTenantConnection":

<?php

namespace App\Models;

// use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
use Laravel\Sanctum\HasApiTokens;
use Spatie\Multitenancy\Models\Concerns\UsesTenantConnection;

class User extends Authenticatable
{
    use HasApiTokens, HasFactory, Notifiable, UsesTenantConnection;

    /**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'name',
        'email',
        'password',
    ];

    /**
     * The attributes that should be hidden for serialization.
     *
     * @var array<int, string>
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast.
     *
     * @var array<string, string>
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];
}

best regards
Martin