problem with multi connection string and assignRole

[maxdiable]

hi, I followed your directives when you have multi connections, so I created 2 models (role, permission) like this:

assignRole('admin');) it gives me this error. From what I understand is that the command does not recognize the connection. the errors is: SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) (SQL: select * from `roles` where (`team_id` is null or `team_id` is null) and `name` = admin and `guard_name` = jwt limit 1) any help ? br Max

[parallels999]

That problem is with your DB user permissions, not on this package
on user forge, also you did activate teams feature, but no team is setted

[parallels999]

problem with multi connection
Access denied for user 'forge'@'localhost' (using password: NO)

user forge has no permission on connection, the problem is not PHP

[maxdiable]

I have activated team and the creation of both the user, roles and permissions works perfectly the only thing wrong is the assignRole function :(
br
Max

[fredsal]

What means "br Max"?

[maxdiable]

this is my code:

permmission model:

`<?php

namespace App\Models;

use App\Enums\OracleConn;
use Spatie\Permission\Models\Permission as SpatiePermission;

class Permission extends SpatiePermission
{
protected $connection = OracleConn::CONN_ORACLE_AUTH;
}
`

---

`<?php

namespace App\Models;

use App\Enums\OracleConn;
use Spatie\Permission\Models\Role as SpatieRole;

class Role extends SpatieRole
{
protected $connection = OracleConn::CONN_ORACLE_AUTH;
}
`

[parallels999]

Please learn to use markdown, that is impossible to read,
also keep the conversation in a single thread, you open a new one for each reply

Example:

<?php

namespace App\Models;

use App\Enums\OracleConn;
use Spatie\Permission\Models\Permission as SpatiePermission;

class Permission extends SpatiePermission
{
    protected $connection = OracleConn::CONN_ORACLE_AUTH;
}

<?php

namespace App\Models;

use App\Enums\OracleConn;
use Spatie\Permission\Models\Role as SpatieRole;

class Role extends SpatieRole
{
     protected $connection = OracleConn::CONN_ORACLE_AUTH;
}

[maxdiable]

i am sorry.. :(
I apologize for my inexperience..

[fredsal]

also keep the conversation in a single thread, you open a new one for each reply

This is a new one 😄😄😄

[maxdiable]

ok.. i show you my permission model:

namespace App\Models;

use App\Enums\OracleConn;
use Spatie\Permission\Models\Permission as SpatiePermission;

class Permission extends SpatiePermission
{
    protected $connection = OracleConn::CONN_ORACLE_AUTH;
}

[fredsal]

also keep the conversation in a single thread, you open a new one for each reply

Another new one 😄😄😄

[maxdiable]

Best regards Il lun 13 feb 2023, 18:05 fredsal ***@***.***> ha scritto:

…

What means "br Max"? — Reply to this email directly, view it on GitHub <#2327 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABTSU24HOS6QLBTYG6ERPDWXJSURANCNFSM6AAAAAAU2PRY4E> . You are receiving this because you authored the thread.Message ID: ***@***.*** com>

[erikn69]

Access denied for user 'forge'@'localhost' (using password: NO)