I give "unserialize(): Error at offset 0 of 60 bytes" for create permission with rule

[bagtim]

 $auth = Yii::$app->authManager;

// add the rule
        $rule = new \app\rbac\AuthorRule;
        $auth->add($rule);

// add "updateOwnPost" permission and bind a rule to it
        $updateOwnPost = $auth->createPermission('updateOwnPost');
        $updateOwnPost->description = 'Update own post';
        $updateOwnPost->ruleName = $rule->name;
        $auth->add($updateOwnPost);

Without setted ruleName, permission is good created. But if set ruleName, i have error "unserialize(): Error at offset 0 of 60 bytes"

Q	A
Microsoft SQL Server	2017 (RTM) - 14.0.1000.169 (X64)
Yii version	2.0.29
PHP version	5.6.31
Operating system	win10 64

[samdark]

1. Was PHP manager used?
2. What was the name?

[bagtim]

iis 10, php manager from https://www.iis.net/downloads/community/2018/05/php-manager-150-for-iis-10, php install from iis web platform

[bagtim]

I think problem near column type varbinary, because after removed 4 auth tables, i create new tables with change column types from binary to varchar for AuthItem->ruleName and AuthRule->data. And then worked is fine. This problem has from version where columns type is varbinary.

[samdark]

Do you store RBAC rules in MSSQL?

[samdark]

Was table created from migrations or https://github.com/yiisoft/yii2/blob/b39bb71587cb4a4964238bdc6e846535588a3cfc/framework/rbac/migrations/schema-mssql.sql?

[bagtim]

Do you store RBAC rules in MSSQL?

Yes

Tables created from migrations with "yii migrate --migrationPath=@yii/rbac/migrations"

[samdark]

What was used as the rule name?

[bagtim]

What was used as the rule name?

From docs:

class AuthorRule extends Rule
{
    public $name = 'isAuthor';
...

and then from topic post:

$rule = new \app\rbac\AuthorRule;
$auth->add($rule);
...
$updateOwnPost->ruleName = $rule->name;
$auth->add($updateOwnPost);

[samdark]

OK. That's enough info to try reproducing it.

[toatall]

I had an analogical problem. I did following: 1) Change to CONVERT(VARBINARY(MAX), ...) in QueryBuilder::normalizeTableRowData because default length is 30 characters (Link MS SQL Server) 2) For VARBINARY field need add paramert in PDOStatement::bindParam driver_options "PDO::SQLSRV_ENCODING_BINARY" PDOStatement::bindParam(column, &$var, type,length,PDO::SQLSRV_ENCODING_BINARY); DbManager Or not use PDOStatement. Use PDO::exec('insert...')

[samdark]

@toatall since you're into it, would you like to prepare a pull request with a fix?

[toatall]

@samdark OK!

[samdark]

@bagtim would you please check if @toatall solution fixes the issue for you?