Forum

New installation of...
 
Notifications
Clear all

New installation of V8.0.4 fails

18 Posts
2 Users
0 Reactions
6,630 Views
(@briandlees)
Posts: 28
Active Member
Topic starter
 
[#6054]

I have tried to do a clean install of V8.0.4 but it fails when I try to log in admin/admin. The log reveals the following:

2019-06-12 13:35:20.464 ----- DEBUG ----- login for maintenance with other than 'admin' / 'admin'
2019-06-12 13:35:20.466 ** ERROR ** [] Exception-[22021] SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte sequence for encoding "UTF8": 0xba

Do you have any pointers as to what is causing the issue?


 
Posted : 12 Jun 2019 16H46
(@babynus)
Posts: 14952
Member Admin
 

Did you enter "admin" as user and "admin" as password ?


 
Posted : 12 Jun 2019 17H10
(@briandlees)
Posts: 28
Active Member
Topic starter
 

Yes. I think either the issue is that it isn't interpreting it as UTF8 for some reason, or else the database has no admin/admin user in it.


 
Posted : 12 Jun 2019 17H18
(@babynus)
Posts: 14952
Member Admin
 

I think either the issue is that it isn't interpreting it as UTF8

Possible but unlikely : we have users using very specific charsets (chinese, russion, farsi), and "admin" is coded the same in UTF8 and ANSI.

the database has no admin/admin user in it.

Of course !
At that point, the database should be completely empty.
So this is not the issue.

Please check for errors on browser console or on log file.
I would more likely thing about some encrypting issue (some missing module)


 
Posted : 12 Jun 2019 17H29
(@briandlees)
Posts: 28
Active Member
Topic starter
 

I have tried a completely new installation with 7.2.5 as I noticed from the forum you said it should work with a completely empty database. The issue is the same. The complete log file is attached.

It appears to be saying that the table resource is not defined.


 
Posted : 12 Jun 2019 17H33
(@briandlees)
Posts: 28
Active Member
Topic starter
 

I have created another V8.0.4 with new database name, new install, and it again fails. I inserted a line in the loginCheck.php to log the username and password being used. The results are nothing like the admin/admin being entered, and are different every time I try to login. It seems to me they are being encrypted by some mechanism. Two such excerpts from the log are below:

2019-06-12 16:31:50.168 ..... SCRIPT .... 192.168.0.254 Page=loginCheck.php
2019-06-12 16:31:50.169 ..... SCRIPT .... 192.168.0.254 ->/tool/loginCheck.php
2019-06-12 16:31:50.173 ----- DEBUG ----- loginCheck : current db version = ''
2019-06-12 16:31:50.173 ----- DEBUG ----- username:'L▒맨' / password:'hgE95ucaAV1SnHGQcQ=='

2019-06-12 16:31:51.408 ..... SCRIPT .... 192.168.0.254 Page=loginCheck.php
2019-06-12 16:31:51.409 ..... SCRIPT .... 192.168.0.254 ->/tool/loginCheck.php
2019-06-12 16:31:51.413 ----- DEBUG ----- loginCheck : current db version = ''
2019-06-12 16:31:51.413 ----- DEBUG ----- username:'▒]▒ ▒' / password:'dQLTHOgaAV1oFRsfEQ=='


 
Posted : 12 Jun 2019 19H38
(@babynus)
Posts: 14952
Member Admin
 

It is normal to have few logs with errors pointing out that some tables are missing : they are all missing at this point.

Sure it is an encryption issue.
Either user / password is not correctly encrypted on js side, or not correctly decrypted on php side.
It can be due to missing module, but this is difficult to identify.
It can also be the session salt that is not correctly identified on js side.

Could you open the network tab on borwser console and check what is the result for request to script "getHash.php".


 
Posted : 12 Jun 2019 19H38
(@briandlees)
Posts: 28
Active Member
Topic starter
 

Screenshot attached


 
Posted : 12 Jun 2019 19H56
(@babynus)
Posts: 14952
Member Admin
 

I would need the "response" part (tab "response", not "headers").


 
Posted : 12 Jun 2019 20H02
(@briandlees)
Posts: 28
Active Member
Topic starter
 

Response attached.


 
Posted : 13 Jun 2019 1H48
(@babynus)
Posts: 14952
Member Admin
 

Response is correct.

I don't understand issue.
Do you have extensions on yur browser ? Can you tray and disabling them ?
What is the language (locale) of your browser ?

Can you please try and remove all cookies pointing to projeqtor server ?
Can you also try with another browser ? (possibly a browser without any extension)


 
Posted : 13 Jun 2019 11H17
(@briandlees)
Posts: 28
Active Member
Topic starter
 

I have attached 3 more screenshots. Firefox screenshot was taken on a different machine from the others.


 
Posted : 13 Jun 2019 12H31
(@babynus)
Posts: 14952
Member Admin
 

Is mbstring module enabled on your server ?


 
Posted : 13 Jun 2019 12H41
(@briandlees)
Posts: 28
Active Member
Topic starter
 

Attached is a screenshot of PHP modules loaded on active Apache server.


 
Posted : 13 Jun 2019 12H51
(@babynus)
Posts: 14952
Member Admin
 

Hi,

I saw 2 miising modules that can have impact :
- calendar
- mcrypt

This last one (mcrypt) seems the best candidate for the issue.

NB : mysql_pdo is not installed, so I guess you configured with postgres...


 
Posted : 13 Jun 2019 13H20
(@briandlees)
Posts: 28
Active Member
Topic starter
 

You are correct, I am using postgresql.
Adding calendar was easy, mcrypt not so. My distro (SUSE) has no official mcrypt extension as the module is deprecated in favour of OpenSSL. I managed to find a community version but have had to downgrade PHP from 7.2.x to 7.1.x in order to resolve the conflicts. I have got ProjeQtor installed and working now but I would request that you sort out the dependency on mcrypt.

I do not know how I can keep my PHP version current if you are using a deprecated module. Do you have any plans to remove this as it's already difficult to support and can only get worse?

However, thanks very much for your patience in helping me find the source of my issue.


 
Posted : 13 Jun 2019 13H51
(@babynus)
Posts: 14952
Member Admin
 

I just checked a new server I have, runnng PHP 7.2 : mcrypt is not required.
But possibly calendar is...


 
Posted : 13 Jun 2019 16H04
(@briandlees)
Posts: 28
Active Member
Topic starter
 

Thanks for that. I have re-upgraded to PHP 7.2 and without mcrypt it seems to work. Whether it's need for the first install I don't know. I have also found out that you can use PECL (PHP Extension Community Library) to provide the mcrypt functionality if required because the module is not included in PHP 7.2 at all.


 
Posted : 13 Jun 2019 18H52
Share:

Scroll to Top