User sign in-permission denied

kopna

Hi to all! Happy New Year!

One of the forum users after registration not able to login. After entering the login and password received this message:permission denied
All confirmed:

Other users do not have this problem to log in.
Where to find the bug specifically for that user?

version Vanilla 2.3
php version: 7.0
Plugins enebled

Advanced Editor Version 1.7.7
Advanced Editor Config Version 0.2
Age Gate Version 1.2.0
Avatar First Letter Version 1.2
Birthday Module Version 0.2
CategoryImageHeader Version 2.2
Contact Version 1.3
Discussants Version 1.0
Discussion Photos Version 1.2.2
Discussion Polls Version 1.3.5
Emoji Sets Version 1.1
Flagging Version 1.1.1
Friendships Version 0.1
Galleries Version 2.1
Ignore Version 1.2.1
In This Discussion Version 1
IP2Location Version 1.0.1
Latest Post List Version 1.6
Members List Enhanced Version 6.6
Multilingual Version 1.1
NillaBlog Version 1.8.2
OnlineNow Version 3.4
Profile Visitors Version 0.3.1
Q&A Version 1.2.4
Quotes Version 1.8
Rating Version 0.3
Shariff Version 0.1
Signatures Version 1.6.0
Stop Auto Draft Version 1.1
Tagging Version 1.8.12
Thankful People 2 Version 2.2.4
Universal Google Analytics Version 0.2
Uploader Version 1.4

Applications:
Conversations Version 2.3
Vanilla Version 2.3

Regards to all

kopna

I created a new account and found that user confirmation is not delivered to the specified email

Description of the problem

Receive a message to confirm the e-mail

and clicking on the confirmation page

click on the link "here" - receive a message

check e-mail - message not received.
How to fix it?
Thank you

kopna

today found that the forum is empty because other people started getting the same message-permission denied

I'm shocked ((((

Linc

Have you confirmed your user Member role has the Sign In and Email permissions?

Is this a new install or an upgrade?

kopna

Hi #Linc

Is this a new install or an upgrade?

I updated version 2.2.1 to the new version 2.3

Have you confirmed your user Member role has the Sign In and Email permissions?

All default:
screenshot

Yesterday created a new account from another IP address. When trying to enter the account receiving the same message - permission denied

kopna

I tried to find the answer on forum. But I had no success in this.

A This post is a mirror image of my post.

I understand that you have no time at all but may give you some tips on how to fix it. Any help?

R_J

You are linking to a discussion where the problem has been solved. Maybe you have a similar problem? Could you post a dump of your permission and role table (normally called "GDN_Permission" and "GDN_Role")?

kopna

@R_J said:
You are linking to a discussion where the problem has been solved. Maybe you have a similar problem? Could you post a dump of your permission and role table (normally called "GDN_Permission" and "GDN_Role")?

I looked GDN_Permission I think there is too much, because I am disabled and deleted some plugins and applications, but that's just my guess.

Thank you.

R_J

So you found the answer all by yourself: you have indeed the same problem like it is described in the discussion you have link to!

There is a column with the title "1" in your GDN_Permission. Delete that column and everything should be okay.

kopna

@R_J said:
So you found the answer all by yourself: you have indeed the same problem like it is described in the discussion you have link to!

There is a column with the title "1" in your GDN_Permission. Delete that column and everything should be okay.

@R_J Thank you for your support, it works again!

Linc

Man, if you can figure out what janky plugin did that, we should remove it from the directory.

R_J

@Linc: peregrine had find out which plugin was causing the error the last time: https://open.vanillaforums.com/discussion/comment/241001/#Comment_241001

Don't you have the possibility to unzip all the plugins on your server into a temp directory and do a grep search for "RegisterPermissions.*true"?

R_J

And if it is that easy to create a borked plugin, it might be good to change the way it is handled:

        // If setup succeeded, register any specified permissions
        $PermissionName = val('RegisterPermissions', $PluginInfo, false);
        if ($PermissionName != false) {
            $PermissionModel = Gdn::permissionModel();
            $PermissionModel->define($PermissionName);
        }

Or would be better to do some sanity checks in define()?

Linc

Yes, we should fix this at the source, not search thru addons for similar problems.

Linc

Lucky issue number 5000 https://github.com/vanilla/vanilla/issues/5000

R_J

@Linc said:
Lucky issue number 5000 https://github.com/vanilla/vanilla/issues/5000

Dang! I wish I had filed that issue

Linc

I asked in company chat if I won anything. They all ignored me.

R_J

Just ignore these ignorants...

Did you notice that there are only 2 PRs left until pull request 5000?
https://github.com/vanilla/vanilla/pulls
That cannot be a coincidence...

Linc

@R_J said:
That cannot be a coincidence...

They use the same numering key. The next PR or issue will be 5001.

R_J

Such a boring explanation for something which could have been worth a party, otherwise!

kopna

Hi, maybe it's not important

A here.

but perhaps it is also a small bug, this happened to me.
On your own