Refresh problem with IPS 4.1.17

[Nathan Explosion]

Could you pop up a screenshot of your Friendly URLs configuration? (ie the one that indicates what options you have enabled, not the list of urls)

[Jibeji]

Sure, here it is:

 

[Nathan Explosion]

Can you enable 'Rewrite URLs' and put the .htaccess file in place on the server?

Just working on a hunch at the moment.

[Jibeji]

That's done.

[Matt]

Hi,

I get "There was an error processing your login request at one of the sites in our network." which does look like an issue with your SSO.  

[Nathan Explosion]

OK - hunch didn't work out, but let's simplify the issue and take it away from that drop down not disappearing.

Go to http://ns3057235.ip-213-32-27.eu/forum/login and attempt to sign in. It accepts the credentials (ie form submits) but the user appears to not be logged in because it continues to request login credentials. But go to http://ns3057235.ip-213-32-27.eu/forum and the user is logged in.

If there is nothing coming up in the IPS logs for this then you're going to need to look at your server logs for that login action happening.

Is ns3057235.ip-213-32-27 your site's real url or not? Also do you have it linked, via ipsconnect, to another domain?

[Jibeji]

There is no SSO configured. (I'd like to but it doesn't work, it's another story)

 

 

[Jibeji]

The forum runs in standalone mode on it's real URL (it's a sandbox)

I can't see anything wrong in the log files.

Quote

86.252.15.43 - - [23/Dec/2016:11:43:16 +0100] "GET /forum//applications/core/interface/ipsconnect/ipsconnect.php?do=crossLogin&key=154ea1c792fc085fc0f598eba4d4dc37&url=http://ns3057235.ip-213-32-27.eu/forum//applications/core/interface/ipsconnect/ipsconnect.php&id=2&returnTo=http://ns3057235.ip-213-32-27.eu/forum/ HTTP/1.1" 303 20 "http://ns3057235.ip-213-32-27.eu/forum/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36"
86.252.15.43 - - [23/Dec/2016:11:43:15 +0100] "POST /forum/login/ HTTP/1.1" 301 20 "http://ns3057235.ip-213-32-27.eu/forum/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36"

 

[Adlago]

This login is IPS Connect - not Standart

Edit your IPS Connect and remove " Master IPS Connect URL and Key"

[Jibeji]

Adlago,

Not sure to understand. IPS Connect is disabled in the Login Handlers section.

I can't see how to remove  "Master IPS Connect URL and Key".

 

[Adlago]

[Jibeji]

I forgot to mention, these fields are empty.

[Adlago]

Open your SQL Toolbox and Run Query

SELECT * FROM core_login_handlers

screen this and post here

[Jibeji]

[Adlago]

Internal has to be

 	
{"auth_types":"3"} 

External

 {"sql_host":"","sql_user":"","sql_pass":"","sql_database":"","sql_port":0,"sql_socket":"","db_table":"","db_col_user":"","db_col_email":"","db_col_pass":"","db_encryption":"plaintext","db_extra":"","auth_types":"3"}
	

LDAP

{"server_protocol":"3","server_host":"","server_port":0,"opt_referrals":false,"server_user":"","server_pass":"","base_dn":"","uid_field":"","email_field":"","un_suffix":"","pw_required":true,"filter":""} 

Log in server CP phpMyAdmin

Open and edit your table "core_login_handlers"

[Jibeji]

I have changed the values, but the behavior is the same.

[Adlago]

remove cache and all file directory 'datastore'

[Jibeji]

Even after doing that.

[Jibeji]

The more surprising is that I have upgraded 5 times from IPB 3.4 to 4.1.17, on 2 different servers, and always had that issue.

On the same servers, a fresh install works well (but I can't lose 5 years of data)

There should be a mess somewhere in the database.

[Adlago]

Open SQL Toolbox

SELECT * FROM core_sys_conf_settings

find ... 18 connect_slaves  - It must have value '0'

[Jibeji]

YOU GOT IT !!!!!!!!!

Thank you so much Adlago, thank you, thank you, thank you !

I will try know to restart the upgrade from the beginning and just change the different values you mentionned in the database.

[Adlago]

Merry Christmas

[Jibeji]

Nice gift !