Version 4.0.0 : installation problem. First connection with admin / admin does not work.

jstalewski
Offline
New Member

05 Nov 2013 23:49 - 06 Nov 2013 18:20 #7 by jstalewski

Replied by jstalewski on topic Version 4.0.0 : installation problem. First connection with admin / admin does not work.

The problem with this is that the tables do not get defined.

I don't know if it's because the version in the SQL file for 4.0.0 says "version 3.5.0" in the comment block, or if it's because there's an error in the last ALTER TABLE (for the table "Meeting") where the last line says:

where refType='M  eeting';

... but that's what's wrong with a clean install of 4.0.0. The database is defined but no tables get defined.

<edit>
If you install and configure projector'ria 3.4.1 first, and then upgrade to projeqtor 4.0.0, the database tables will be defined; it is only when installing projeqtor 4.0.0 as a new, clean installation, where no previous versions were installed, do you have this problem where the tables do not get defined.

This is not an XAMP issue, by the way - mine happened on CentOS 6.4 64-bit using PostgreSQL rather than MySQL. (politics warning: I avoid MySQL as much as possible now that Oracle is playing games with it... and you'll probably find that's true of a lot of folks who use FOSS extensively)
</edit>

Last edit: 06 Nov 2013 18:20 by jstalewski. Reason: Additional information

Please Log in or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

07 Nov 2013 19:13 #8 by babynus

Replied by babynus on topic Version 4.0.0 : installation problem. First connection with admin / admin does not work.

Hi,

I'll have a quick look to this blocking issue.

Regards.
Babynus

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

07 Nov 2013 19:41 - 07 Nov 2013 19:47 #9 by babynus

Replied by babynus on topic Version 4.0.0 : installation problem. First connection with admin / admin does not work.

Hi,

My mistake :oops:

Mea culpa, mea maxima culpa...
I will do penance and repent till the end of the world ...
.. or at least unti deployment of V4.0.1.

It is due to new encryption of login and password, not taken into account in clean new deployement.

The fix is to change line 24 to 29 in /tool/loginCheck.php :

if (! Sql::getDbVersion()) {
    if ($login=="admin" and $password=="admin") {
      include "../db/maintenance.php";
      exit;
    }
  }

with

if (! Sql::getDbVersion()) {
	$password=AesCtr::decrypt($password, $_SESSION['sessionSalt'], 256);
    if ($login=="admin" and $password=="admin") {
      include "../db/maintenance.php";
      exit;
    }
  }

Fixed file is also attached : unzip and put new file in /tool directory.

Sorry again for this enormous mistake :blush:

Regards.

Babynus

Babynus
Administrator of ProjeQtOr web site

Last edit: 07 Nov 2013 19:47 by babynus.

The following user(s) said Thank You: jstalewski

Please Log in or Create an account to join the conversation.

jstalewski
Offline
New Member

07 Nov 2013 20:19 #10 by jstalewski

Replied by jstalewski on topic Version 4.0.0 : installation problem. First connection with admin / admin does not work.

So the db update doesn't happen because it doesn't get past this logic block because of the encryption? Cool... Thanks for the fix!

What about the extra spaces in "M eeting" ? Won't that make the last bit in the 4.0.0 sql fail?

Please Log in or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

07 Nov 2013 20:24 - 07 Nov 2013 20:25 #11 by babynus

Replied by babynus on topic Version 4.0.0 : installation problem. First connection with admin / admin does not work.

So the db update doesn't happen because it doesn't get past this logic block because of the encryption?

Exactly

Extra space in "M eeting" has exactly no effect in a clean db.
It is just and update to position new "cancelled" tag for Meetings that would have set to default "cancelled status".

Babynus
Administrator of ProjeQtOr web site

Last edit: 07 Nov 2013 20:25 by babynus.

Please Log in or Create an account to join the conversation.

climb4fun
Offline
User is blocked

08 Nov 2013 14:34 #12 by climb4fun

Replied by climb4fun on topic Version 4.0.0 : installation problem. First connection with admin / admin does not work.

Hi Babynus,

I will take over the job of doing penance for you to free your valuable resource for developing ProjeQtOr. :lol:

Regards,

Klaus

The following user(s) said Thank You: babynus

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion

Time to create page: 0.039 seconds

Version 4.0.0 : installation problem. First connection with admin / admin does not work.

Attachments:

Cookies settings

Functional Cookies

Session

Other cookies

Version 4.0.0 : installation problem. First connection with admin / admin does not work.

Attachments:

Cookies settings

Functional Cookies

Session

Other cookies

Login Form