View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Projeqtor 9.0.4 with php-fpm and nginx issue with postgresql 13.1 on cent os 7 - ProjeQtOr
 
 

[SOLVED] Projeqtor 9.0.4 with php-fpm and nginx issue with postgresql 13.1 on cent os 7

More
23 Feb 2021 07:15 #1 by divyesh
Projeqtor 9.0.4 with php-fpm and nginx issue with postgresql 13.1 on cent os 7 was created by divyesh
We are getting login issues from projeqtor.
Log file entries shows trail lines. Please help to resolve the same.

2021-02-23 11:08:22.341 ***** ERROR ***** [V9.0.4] Exception-[22021] SQLSTATE[22021]: Character not in repertoire: 7 ERROR:  invalid byte sequence for encoding "UTF8": 0xaa
2021-02-23 11:08:22.341 ***** ERROR ***** [V9.0.4]    For query : select * from resource where resource.name='I,ªê  ' and resource.isUser = '1'
2021-02-23 11:08:22.341 ***** ERROR ***** [V9.0.4]    Strack trace :
2021-02-23 11:08:22.342 ***** ERROR ***** [V9.0.4]    #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:2680]
2021-02-23 11:08:22.342 ***** ERROR ***** [V9.0.4]    #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor/tool/loginCheck.php:67]
2021-02-23 11:08:22.342 ===== TRACE ===== Login error for user 'I,ªê'
2021-02-23 11:08:32.609 ***** ERROR ***** [V9.0.4] Exception-[22021] SQLSTATE[22021]: Character not in repertoire: 7 ERROR:  invalid byte sequence for encoding "UTF8": 0xeb 0x0a 0x07
2021-02-23 11:08:32.610 ***** ERROR ***** [V9.0.4]    For query : select * from resource where resource.name='në

 

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

More
23 Feb 2021 09:51 #2 by babynus
Replied by babynus on topic Projeqtor 9.0.4 with php-fpm and nginx issue with postgresql 13.1 on cent os 7
You've got encoding issue.
This often happens after backup / restore, if you don't use correct encoding on both sides.

It may be due to non utf-8 setup of your stack
Babynus
Administrator of ProjeQtOr web site

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

More
23 Feb 2021 11:17 #3 by divyesh
Replied by divyesh on topic Projeqtor 9.0.4 with php-fpm and nginx issue with postgresql 13.1 on cent os 7
Both database and php-fpm we have configured utf-8.
I am trying to connect to existing database.

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

More
23 Feb 2021 12:12 #4 by babynus
Replied by babynus on topic Projeqtor 9.0.4 with php-fpm and nginx issue with postgresql 13.1 on cent os 7
Issue is clear : user name tested over DB contains non utf-8 characters.
021-02-23 11:08:22.341 ***** ERROR ***** [V9.0.4] Exception-[22021] SQLSTATE[22021]: Character not in repertoire: 7 ERROR:  invalid byte sequence for encoding "UTF8": 0xaa
Babynus
Administrator of ProjeQtOr web site

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

More
23 Feb 2021 12:29 #5 by divyesh
Replied by divyesh on topic Projeqtor 9.0.4 with php-fpm and nginx issue with postgresql 13.1 on cent os 7
I am not able to connect with admin user or any other user.
Please guide how to resolve the issue.

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

More
23 Feb 2021 12:32 #6 by babynus
Replied by babynus on topic Projeqtor 9.0.4 with php-fpm and nginx issue with postgresql 13.1 on cent os 7
Please explain clearly and completly what you did.

Fresh install ?
Migration of existing DB ?
Migration PHP server ?
 
Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynus, protion
Time to create page: 0.045 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form