$resolver->reconnectDefaultConnection(); not working properly

[nettsite]

Hi,

I am having a problem changing a tenant over to the default connection; When I $resolver->reconnectDefaultConnection(); I get a "SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (SQL: select * fromtenants)" error.

Config: `connections' => [ /**

• Main database connection */ 'main_db' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'jobdesc'), 'username' => env('DB_USERNAME', 'jobdesc'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null, ], /**
• Database connection for tenants */ 'tenant_db' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => '', // The database name will be filled in dynamically upon the tenant being resolved. 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'databaseprefix' => 'jobdesc', // this can be changed and represents a database prefix e.g. 'business_acme'. 'strict' => true, 'engine' => null, ], /**
• Database connection for ONet / 'onet_db' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => 'jobdesc_onet', // The database name will be filled in dynamically upon the tenant being resolved. 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'databaseprefix' => 'jobdesc', // this can be changed and represents a database prefix e.g. 'business_acme'. 'strict' => true, 'engine' => null, ], ],`

Custom tenant model: `<?php

namespace App\Models\Admin;

use Illuminate\Database\Eloquent\Model; use Illuminate\Database\Eloquent\SoftDeletes;

//class Tenant extends \DanTheDJ\MultiTenant\Tenant { class Tenant extends AdminModel {

use \App\Traits\Uuids; use SoftDeletes;

/**

• Not using an incrementing key as primary

• @var type */ public $incrementing = FALSE;

  /**

• The connection name for the model.
• @var string */ protected $connection = 'main_db'; // Makes absolutely no difference

} Middleware called from controller constructor: <?php

namespace App\Http\Middleware;

use Closure;

class Admin {

/**

• Handle an incoming request.
• @param \Illuminate\Http\Request $request
• @param \Closure $next

• @return mixed */ public function handle($request, Closure $next) {

  $resolver = app('tenant');

  if ($resolver->isResolved()) { $tenant = $resolver->getActiveTenant(); if ("admin" == $tenant->subdomain) { $resolver->reconnectDefaultConnection(); return $next($request); } }

  return redirect('home'); }

}`