Hi ambroise1er,

did you copy files in the old 3.4.4 directory or a new directory? I put in the old directory and could work with my old credentials.

Regards,

Klaus

This is not an update, it is a new installation, in a new directory.

I tryed with différentes versions de XAMPP :
- Version 1.8.1
- Version 1.8.2
- Version 1.8.3

Hello,

+1

I have the same problem for a new installation.

Windows XP
XAMP 1.8.2

Regards,

Drubs2010.

Hi ambroise1er and Drubs2010,

I didn't have a solution on the quick run. Two suggestions:

1. check in database, table resource, whether there's a user named admin. If yes, you can copy a encrypted password of your known user in this record. Just copy it from your existing database to the new database. write access is mandatory
2. restore a dump of your already existing Projectorria database. This works in my test deployment.

I hope this is a workaround that helps you.

Regards,

Klaus

Hi babynus,

This is a critical bug because anyone wishing to install for the first time the version 4.0.0 could not do it ...
:ohmy:

(On Xampp and perhaps on other environnement)

Cordialy

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.

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)

Hi,

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

Regards.
Babynus

Hi,

My mistake 😳
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

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?

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".

Hi Babynus,

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

Regards,

Klaus

Hi,

I download V4.0 from svn and do a clean installation. I checked the loginCheck.php and it has

$password=AesCtr::decrypt($password, $_SESSION['sessionSalt'], 256);

But I still can't login with admin/admin, neither guest/guest.
Please help. Thanks.

Hi,

You'd better download code from Sourceforge : link is available in the download page of this site.
Try V4.0.3.
This issue you're facing was fixed on V4.0.1.