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ë
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
Both database and php-fpm we have configured utf-8.
I am trying to connect to existing database.
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
I am not able to connect with admin user or any other user.
Please guide how to resolve the issue.
Please explain clearly and completly what you did.
Fresh install ?
Migration of existing DB ?
Migration PHP server ?
It was fresh install and configuration on Nginx server.
Postgres 13.1 Database was already there on same server.
Php-fpm was also configured earlier for same server for Apache.
Somehow the issue was not character set but missing permission on /var/lib/php/session
I have provided 777 permission and then login was successful for all users.