Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Problem on updating...
 
Notifications
Clear all

Problem on updating Projeqtor (rollback needed)

17 Posts
3 Users
0 Reactions
5,643 Views
(@cpt_jabberwock)
Posts: 56
Active Member
Topic starter
 
[#7567]

Hello,

For some reason, we have a problem on our Projeqtor since 9.1.3
We have done absolutely nothing in changing anything file related, or something that would pose problem (in our eyes)
But when i tried to update to 9.1.4 (and today, to 9.1.5, because waiting for next update just in case can help), i get the login screen after update like usual, but when i lo with my administrator account to initialise and open the app, i get this:

 

Do you have any idea what could cause this ?

Are there specific logs we should look into ?

Thank you


 
Posted : 04 Jun 2021 11H08
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Please look at the error log.
You'll have explanation (possibly an access right error)
If you don't understand the error, post it here.


 
Posted : 04 Jun 2021 16H46
(@cpt_jabberwock)
Posts: 56
Active Member
Topic starter
 

I don't quite understand where exactly is the specific log needed on the apache server, but this is what I found for June 4th when i updated it

 

If this is not this one, which one should it be ?

Thank you


 
Posted : 07 Jun 2021 11H48
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Error will be in projeqtor log file.
Defaut location is in projeqtor/file/logs


 
Posted : 12 Jun 2021 19H34
(@cpt_jabberwock)
Posts: 56
Active Member
Topic starter
 

Thank you,

After finding it and doing a test on another Vm we made just for this, which was in 8.3.3

I updated it to 9.0.6 without any problem
Then, when i tried to update to 9.1.5, i encountered the same problem i talked about above

I then made sure it was this log by trying to connect and looking at the modification date

 

Thank you


 
Posted : 14 Jun 2021 11H43
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

You log file show migration from V8.3.4 to V9.0.6, which ran without issue.
The you have error 

2021-06-14 09:32:15.642 ** ERROR ** [V9.0.6] cause = ldap_connect(): Could not create session handle: Bad parameter to an ldap routine

It seems your PHP does not undestand new URI format for LDAP connection.
Which version of PHP are you using ?

NB : to fix the issue, just change 1356 in projeqtor/model/UserMain.php from

              if (1) { // New signature

to

              if (0) { // New signature

We searched for compatibility of new signature depending on PHP version but did not find the information.
Please tell us which version of PHP you are using so that we may improve the code.


 
Posted : 15 Jun 2021 13H29
(@cpt_jabberwock)
Posts: 56
Active Member
Topic starter
 

Thank you, it worked

Apparently, this line is added after applying the update (from 9.1.4 i suppose) so we need to change it after we get blocked in trying to connect again after

Changing it worked as advertised

The PHP version we use is 7.0.30
 


 
Posted : 28 Jun 2021 12H52
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

In V9.2.1 you'll be able to add parameter in your prameters.php file

$ldapFormatUri=false;

so that LDAP will work fine for you whatever the migration.


 
Posted : 28 Jun 2021 17H30
(@cpt_jabberwock)
Posts: 56
Active Member
Topic starter
 

A new problem occured but this time, from 9.1.5 to 9.2.2

 

We have looked into what we did the last time, but the error seems different.µ

Could you look into this please ?


 
Posted : 02 Sep 2021 13H46
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

LDAP password is encrypted on V9.2, so migration requires a connection with non-ldap admin user.


 
Posted : 07 Sep 2021 13H03
(@cpt_jabberwock)
Posts: 56
Active Member
Topic starter
 

Hello again and thanks for the reply
It worked after logging with Admin

After opening the application back to other users, i tried to log back with my account, but encountered an error.

It may be due to the parameter for parameters.php posted above not having been done, but i'm not sure yet.
I will look into it, but can you tell me regardless if you have an idea ?

Thank you


 
Posted : 07 Sep 2021 13H53
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Reconnext as Admin and update LDAP password in global parameters.


 
Posted : 07 Sep 2021 16H22
(@cpt_jabberwock)
Posts: 56
Active Member
Topic starter
 

There was no change on our side.

we rewrote the password on top on the old in authentification in Global Parameters, but the result stay the same


 
Posted : 08 Sep 2021 17H37
(@bvd)
Posts: 124
Active Member
 

Hi,

You have to write the line in parameters.php with single quote, like this :

$ldapFormatUri='false';

Writing line without single quotes simply won't work.

Regards,
 


 
Posted : 13 Sep 2021 2H44
(@cpt_jabberwock)
Posts: 56
Active Member
Topic starter
 

Hello again,

So, i opened Parameter.php and i have thousands of lines to sift thru to know where to put $ldapFormatUri='false';
Could you pinpoint me what section is should look for ?

Thank you


 
Posted : 04 Oct 2021 16H12
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

You don't have to change model/Parameter.php file which is part of community code and will be overwrfitten at each migration
You need to change you parametering file, that is stored at setup and never overwritten.
Default location is files/config/parameters.php, but may be (and should be for security reason) changed at setup.
You'll find location in tool/parametersLocation.php


 
Posted : 04 Oct 2021 16H41
(@cpt_jabberwock)
Posts: 56
Active Member
Topic starter
 

This is perfect

Thanks 😀


 
Posted : 04 Oct 2021 16H54
Share:

Scroll to Top