Using Auth on a different connection or database.

In your model you can define which connection to use with:

protected $connection = 'my-other-connection';

Now you just need to set it dynamically in your application based on your criteria.

I didn't tried it (dynamically) but I think this should solve your problem

Hi @pixelpeter, thanks for your reply.

So I added the connection variable to my User Model. I also wrote the following function to dynamically change the connection -

public function changeConnection($conn){
    $this->connection = $conn;
}

Now the question is how do I call this function when trying Auth::attempt ?

Please do let me know. Thank you.

Hello there, were you able to figure this out? I am actually stuck on the same part. I also created a function to change the connection dynamically.

I have the same problem! How can i pass data from auth::attempt to app/user ? I need the connection name in the app/user contructor, which is given in user database column.

I added a connection line declaration in constructor of my authcontroller. The line is: DB::setDefaultConnection('yourConnectionName'); Don't forget to add "use DB;" (without quotes ofc) at the top of the file ;).

Using Laravel 5 what would be the "AuthController"?

This post helped me to figure out how to use Passport for my API, while having different databases for subdomain accounts. In my application, each valid subdomain has its own database with a users table. I have two User models: DefaultUser and AccountUser which extend App\User. My App\User model has the changeConnection function and I call that function in a CustomUserProvider class, which is used by a CustomAuthProvider class, and in my config/auth.php I have:

    'guards' => [
        'web' => [
            'driver' => 'session',
            'provider' => 'users',
        ],

        'default_api' => [
            'driver' => 'passport',
            'provider' => 'default_users',
        ],

        'account_api' => [
            'driver' => 'passport',
            'provider' => 'account_users',
        ],
    ],

...

    'providers' => [
        'default_users' => [
            'driver' => 'custom',
            'model' => App\Models\DefaultUser::class,
        ],
        'account_users' => [
            'driver' => 'custom',
            'model' => App\Models\AccountUser::class,
        ],                        
        'users' => [
            'driver' => 'custom',
            'model' => App\User::class,
        ],

It appears to be working for me so far, so I am moving on. Hopefully this helps anyone who gets here as I did.

@matthall00 can you share what the other two models look like please? I am struggling with the same issue and everything works fine but oauth is calling the central dB instead of the tenant dB and seems to be the only thing ignoring my middleware.

This is for auth.php We need to define our custom guard when we use that guard. And provider is also created because we need to use it in our new guard

'guards' => [
        'web' => [
            'driver' => 'session',
            'provider' => 'users',
        ],

        'api' => [
            'driver' => 'token',
            'provider' => 'users',
            'hash' => false,
        ],
        'guard_one' => [
            'driver' => 'session',
            'provider' => 'connection_one_users'
        ]
],
'providers' => [
        'users' => [
            'driver' => 'eloquent',
            'model' => App\User::class,
        ],

        'connection_one_users' => [
            'driver' => 'eloquent',
            'model' => App\Admin::class,
        ],
],

You need to extends Authenticatable instead of models in your model class. The model used in new provider will be like

use Illuminate\Foundation\Auth\User as Authenticatable;

class Admin extends Authenticatable
{
    protected $connection = 'connection_one';
}

Hello sir you working now ? I need like you also can you share your source code?