Relation model_has_roles not found error on Role deletion about laravel-permission

[parallels999]

I don't have any experience with postgres, sorry

I don't know if it will be possible to override the boot methods, try that and remove the lines that give you problems
Another option would be to use softDeletes trait (which I prefer), so those lines would never be called

[parallels999]

#2095 (comment)

[Ivan3008]

it could work if i had limited number of databases and known database names. but tenants have database names based on id in UUID format

[parallels999]

Ok, add a custom Role/Permission model, and overwrite users relation, set the real db name on the pivot tables(model_has_permissions, model_has_roles)
https://stackoverflow.com/questions/25142968/belongstomany-relationship-in-laravel-across-multiple-databases

laravel-permission/src/Models/Permission.php

Lines 71 to 80 in b6b9f4f

	public function users(): BelongsToMany
	{
	return $this->morphedByMany(
	getModelForGuard($this->attributes['guard_name'] ?? config('auth.defaults.guard')),
	'model',
	config('permission.table_names.model_has_permissions'),
	app(PermissionRegistrar::class)->pivotPermission,
	config('permission.column_names.model_morph_key')
	);
	}

laravel-permission/src/Models/Role.php

Lines 80 to 89 in b6b9f4f

	public function users(): BelongsToMany
	{
	return $this->morphedByMany(
	getModelForGuard($this->attributes['guard_name'] ?? config('auth.defaults.guard')),
	'model',
	config('permission.table_names.model_has_roles'),
	app(PermissionRegistrar::class)->pivotRole,
	config('permission.column_names.model_morph_key')
	);
	}

[Ivan3008]

unfortunately it didn't work. also, i tried method setConnection(CONNECTION_NAME) for users relationship, it didn't help either

Undefined table: 7 ERROR: relation "tenant_bcc6d892-a4db-40db-b271-fcc6eaaa1276.model_has_roles" does not exist
Connection: pgsql, SQL: delete from "tenant_bcc6d892-a4db-40db-b271-fcc6eaaa1276"."model_has_roles" where "tenant_bcc6d892-a4db-40db-b271-fcc6eaaa1276"."model_has_roles"."role_id" = 5

[parallels999]

is tenant_bcc6d892-a4db-40db-b271-fcc6eaaa1276 the connetion name or the db name??
I don't know how it works in postgres, in mysql it works without problems

[Ivan3008]

tenant_bcc6d892-a4db-40db-b271-fcc6eaaa1276 is db name.

$connection property for User is 'pgsql', $connection property for Role is 'tenant'

[parallels999]

Question:
can you use the scopes functionality?
because it uses relationships in the same way as users

https://spatie.be/laravel-permission/basic-usage#content-scopes
https://laravel.com/eloquent-relationships#defining-custom-intermediate-table-models

[Ivan3008]

i'll try to overwrite boot method of the trait, if laravel allows overwrite such type of methods

[Ivan3008]

thank you @parallels999 for help, finally i overwrote bootHasPermissions method and error's gone. other possible solutions didn't work out in my situation.

anyway, overwriting boot method is not the perfect solution, because any time i'll update app dependencies, i'll need to check if any important changes in HasPermissions boot method were added, and copy them to my boot

[Ivan3008]

also, schemas of model_has_roles and model_has_permissions tables use onDelete('cascade') method, that do the same as detach. that's why i'm not sure we really need to do the same on deletion

laravel-permission/database/migrations/create_permission_tables.php.stub

Line 86 in b6b9f4f

->onDelete('cascade');

[parallels999]

use onDelete('cascade') method, that do the same as detach

Normally softDelete is used, it's not the same

[Ivan3008]

that's right, i missed it