Member cannot login to forum

[SIRAPHONG RITTATHAM]

it happend after upgrade to version 4.6.6 and 4.6.7

member cannot login after submit username and password it keep redirect to same page 

admin login is doing fine 

[Jim M]

It looks like you opted to go with our recent recommendation and change login from usernames to email addresses. You mentioned in your statement that they are using a username. Do they get the error when using email address? Is it giving an error of incorrect credentials or just redirecting?

[SIRAPHONG RITTATHAM]

we cannot login both email addresses and usernames after troubleshoot I found it is database error 

I try Fix it automatically  but it show [Err] 2003 - Can't connect to MySQL server 

then I try to run query manually It will trow error when run query that have " ALTER TABLE `core_applications` " in them

[Jim M]

Could you please update the access details on file in the Client Area? I can then take a further look at what is happening here.

[SIRAPHONG RITTATHAM]

how to update the access details on file in the Client Area?

for more info: I have fix all database problem but still cannot login and cannot change theme also 

[Jim M]

8 minutes ago, SIRAPHONG RITTATHAM said:

how to update the access details on file in the Client Area?

for more info: I have fix all database problem but still cannot login and cannot change theme also 

Have you recently changed from HTTP to HTTPS? I would ensure that you disable any server redirects (including CloudFlare) and ensure that your community is setup properly for HTTPS by follow this guide: https://invisioncommunity.com/4guides/advanced-options/configuration-options/using-ssl-https-r273/

You can update access details by going to the Client Area -> Manage Purchases -> click your license -> Review/Update Access Information.

[Marc]

I would say here, if you cannot run those queries manually, you need to contact your hosting company to see why. You should be able to run those queries on your database, and if you cant, then that will indeed cause you issues.

[Marc]

Have you managed to get those queries run on your server now, @SIRAPHONG RITTATHAM ?

[Jonas Erlandsson]

I'm having the same issue on my environment.

I created an account, can log in to admin (I added the account to the admin group), but I can't log in to the Front.

I've debugged the login and I can see that my user is being fetched, but it seems like it's not setting the session at all (if that's what being used).

I don't get any errors, and I see that I get a 301 to _fromLogin=1 via

\IPS\Output::i()->redirect( $ref->setQueryString( '_fromLogin', 1 ) );

Since it's processing the entire $success flow, I guess it should actually log me in and when I debug the $success variable I can find my user in there.

Might the problem be related to a faulty session?

[Marc]

Are you running any plugins on your browser at all? If so, please disable all of these first of all

[Jonas Erlandsson]

Hello Marc.

Quite a few 🙈

They're all disabled now, and none of them are enabled in private browser window, but I'm still not getting logged in.

Edited October 11, 2021 by jerlandsson

[Marc]

17 minutes ago, jerlandsson said:

Hello Marc.

Quite a few 🙈

They're all disabled now, and none of them are enabled in private browser window, but I'm still not getting logged in.

Having so many plugins will indeed cause you issues at some point. Could you please try another browser and see if you can get logged in there?

[Jonas Erlandsson]

43 minutes ago, Marc Stridgen said:

Having so many plugins will indeed cause you issues at some point. Could you please try another browser and see if you can get logged in there?

I get the same problem in Safari and Chrome where I have no plugins at all.

[Marc]

Please update your URL and access details on file. I can then take a look. This sounds more an issue than the other. Is there anyone else able to log into your front end?

[Jonas Erlandsson]

My solution is behind a corporate VPN and it's my test-install. Unfortunately you won't be able to reach it.

I've asked two collegaues to sign in, but they can't either.

[Marc]

Unfortunately, without access Im not sure what else I can really suggest. You can check your server error logs to see if anything is stored there, and also yoru browser console logs. We would not usually support development installs either

[Jonas Erlandsson]

Ok. I've gotten so far that if I dd (as in die and dump) the \IPS\Session::i()->member before the redirect in the login controller if actually gives me the proper user back.

If I dd the same thing after the redirect, the member is gone and it's just a random "browser user".

Not giving support on testinstalls isn't something I feel we should get into in public forums. We can continue that thread via the support system if you'd like 🙂

[Jonas Erlandsson]

Sorry, forgot to answer your tips too.
There is nothing in the browser console or in the backend logs. The request flow works and I end up on the 301 that redirects me to the page with the proper $_GET['_fromLogin'] in place. It's when the page redirects something happens with the Session. It happens both on localhost and our dev environment.

[Marc]

We cannot provide support for an instance we cannot access unfortunately.  There is little point in a ticket being created for that reason unfortunately

[Jonas Erlandsson]

I'll try and see if ops wants to open up so you can reach it.

If so - should I just create a ticket somewhere?

[Marc]

One can be created via your client area, by selecting your license then selecting support on that page. However if access is given within your client area, we can access it here. Unless it needs to be escalated, in which case we can create a ticket on your behalf

[Jonas Erlandsson]

The reason why I'm thinking about a support ticket is because I'm not too keen on giving out the URL publicly just yet.

I guess I could just DM you the URL too.

And sorry Siraphong for completely hijacking your thread.

[Marc]

38 minutes ago, Jonas Erlandsson said:

The reason why I'm thinking about a support ticket is because I'm not too keen on giving out the URL publicly just yet.

I guess I could just DM you the URL too.

And sorry Siraphong for completely hijacking your thread.

You can certainly add it to the notes within your access details on file when you add your access details. No need to give it out publically

 

[Jonas Erlandsson]

The test URL is registered in my client area, but I'm thinking that you probably need an account too, right?
Could you point me to where I can edit these access details?
Sorry, I'm a rookie 😬

Edited October 14, 2021 by Jonas Erlandsson
rephrasing

[Marc]

1 hour ago, Jonas Erlandsson said:

The test URL is registered in my client area, but I'm thinking that you probably need an account too, right?
Could you point me to where I can edit these access details?
Sorry, I'm a rookie 😬

In your client area, select your license and you will see "Stored Access Information. Click the button below that to update your access information