Unable to log in (regular or AdminCP)

[Sarteck]

I recently moved servers, and took the opportunity to set up my vB on a "forums.MYDOMAIN.com" subdomain.

I had some issues with it, where I was unable to log OUT for a few days, and it ended up being something about the cookie prefix.

Now my issue is that I cannot log in, either as a normal or or an Admin, to the regular forum or to the AdminCP.

I have tried:
- tools.php
- : Reset Cookie Domain
- : Reset Cookie Path
- : Updating the various caches

- config.php
- : changing the cookie prefix
- : Disabling hooks

- webserver
- redirecting all traffic on www.MYDOMAIN.com and MYDOMAIN.com to forums.MYDOMAIN.com.


What Happens:
When I try to login from the forum index, it simply reloads the forum index.
When I try to login from the AdminCP or ModCP, it loads "login.php?do=login," and tells me I have an invalid password. If I try to log in using the quick login bit at the top, it simply reloads the forum index, but if I try to login from the form on the page, it just adds a Strike to my IP.


I'm not quite sure what it is that I screwed up, here, and could use a hand. I'm running vB 4.1.11 (I know, I do have to update, and will later on) on NGINX. Obviously, I cannot log into the AdminCP to make changes to any settings.

[ForceHSS]

have you tried disabling plugins via config

[Sarteck]

have you tried disabling plugins via config

Yeah, forgot to add that in there. I'll go edit the post, now.

[Lynne]

After changing settings, did you make sure to delete all your browser cookies for the site? You need to do that if you change anything cookie related.

[ForceHSS]

If you still cant get in after you do what lynne said either get in touch with support or ask someone here to try

[Sarteck]

@Lynne, yeah, just to make sure I even tried from two other browsers (First Chrome, then FireFox and then Safari), still the same behaviour.

@ForceHSS You mean over at the .com site? I was wondering if I should have posted there...

[ForceHSS]

No, I mean a support ticket I am sure they will say the same here as over there

[Sarteck]

@ForceHSS, I get ya. I was on my way to do that right after reading your post, but the vBulletin hiccuped on everyone. (I didn't break it, heh.)

Once I/they get the issue sorted out (here's hoping), I'll post the details and solution, in case someone else runs into the same thing.

[TheLastSuperman]

Try this method: https://vborg.vbsupport.ru/showthread.php?t=259619

If doing that does not work, while in phpmyadmin check your administrator accounts, in the user table, alternatively you can run this query in phpmyadmin (include db prefix if one is used):

SELECT * FROM `user` WHERE userid = 6;

Run the query, make sure the admins listed are indeed proper admins if not then something suspect is going on.

You can see the vb_ prefix before the tables and also in config.php

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'vb_';

[Sarteck]

@Sup, I'm not really sure what it is you're trying to get me to do, heh.

I've disabled plugins already in config.php. It's generally the first thing I used to do whenever I had a problem, because it was usually caused by my own code, heh. That doesn't seem to be the case, here.

As far as the MySQL you gave me... I think you meant a usergroupid of 6, not a userid. Using the following SQL, I did check to see if anything was wanky:SELECT * FROM user WHERE usergroupid = 6 OR FIND_IN_SET(6,membergroupids);Nothing seemed out of the ordinary--all my Admins were there, and no one was there who wasn't supposed to be.

[Elite_360_]

Maybe you have NGINX configure wrong so everyone's IP's is the same?

[Sarteck]

It actually appears that I had the wrong password.

I executed the following:
SELECT password FROM user WHERE userid=MyID;

I got the password hash, then used this to change it:
UPDATE user SET password=MD5(concat(MD5('MyPassword'),user.salt)) WHERE userid=MyID;

I then checked the password hash again, and it was different.

I don't remember changing it, but everything else seems okay. I'm still waiting on response from my users to make sure they can all log in okay.