New install - You do not have permission to sign in to the site

n8twj

I just installed Vanilla v1.1.2 this morning. The setup process works, the database tables and data get populated, but the admin user cannot login. I get "You do not have permission to sign in to the site." I do not receive any email no matter what email address I provide. Sendmail is installed and is functioning as expected on this system. I have already tried the various cookie tricks that are listed, but nothing works (empty string, .domain.tld, nothing) I see a cookie with a PHP session id set for my vanilla domain.

Dinoboff

Check in the database that your admin role (LUM_Role) has the permission to signed it (PERMISSION_SIGN_IN = 1). The RoleID of this role should be 4; check that your user has this RoleId (LUM_User.RoleID).

n8twj

ok - thank you. However, shouldn't this automatically get set for the 'admin' user ?

n8twj

My Administrator RoleID is 33 RoleID Name Icon Description Active PERMISSION_SIGN_IN PERMISSION_HTML_ALLOWED PERMISSION_RECEIVE_APPLICATION_NOTIFICATION Permissions Priority UnAuthenticated 33 Administrator 1 1 1 1 a:34:{s:23:"PERMISSION_ADD_COMMENTS";i:1;s:27:"PER... 4 0

n8twj

Changing my LUM_User.RoleID to 33 allows me to login.

Minisweeper

33? How very strange. Have you tried installing a number of times before perhaps?

ithcy

the "admin" with whom you were trying to log in was not an admin. it was assigned to a role with no signin permissions. do you really have 32 other roles besides administrator? if i had to guess, like Mini i'd say you tried to install a few times, and the LUM_Roles table was not being cleared in between installs?

n8twj

This is a brand new install this morning. I created the database table just prior to running the install/setup process. I could not login from the very first attempt.