View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur 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

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

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

More
23 Fév 2021 07:15 #1 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 Connexion or Create an account to join the conversation.

More
23 Fév 2021 09:51 #2 by babynus
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 Connexion or Create an account to join the conversation.

More
23 Fév 2021 11:17 #3 by divyesh
Both database and php-fpm we have configured utf-8.
I am trying to connect to existing database.

Please Connexion or Create an account to join the conversation.

More
23 Fév 2021 12:12 #4 by babynus
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 Connexion or Create an account to join the conversation.

More
23 Fév 2021 12:29 #5 by divyesh
I am not able to connect with admin user or any other user.
Please guide how to resolve the issue.

Please Connexion or Create an account to join the conversation.

More
23 Fév 2021 12:32 #6 by babynus
Please explain clearly and completly what you did.

Fresh install ?
Migration of existing DB ?
Migration PHP server ?
 

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.041 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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