# \[v2.0.0\] That version of GPGAuth is not supported **URL:** \ **Category:** Installation Issues\ **Created:** [January 24, 2018, 9:30pm UTC](https://community.passbolt.com/t/v2-0-0-that-version-of-gpgauth-is-not-supported/314 "2018-01-24T21:30:14Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![axemann](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@axemann](https://community.passbolt.com/u/axemann)\ **Post date:** [January 24, 2018, 9:30pm UTC](https://community.passbolt.com/t/v2-0-0-that-version-of-gpgauth-is-not-supported/314/1 "2018-01-24T21:30:15Z")
**Checklist** [X] I have read intro post: [About the Installation Issues category](https://community.passbolt.com/t/about-the-installation-issues-category/12) [X] I have read the tutorials, help and searched for similar issues [X] I provide relevant information about my server (component names and versions, etc.) [X] I provide a copy of my logs and healthcheck [] I describe the steps I have taken to trouble shoot the problem [] I describe the steps on how to reproduce the issue Hi all, I’m having an odd issue upgrading from v1.6.9 to v2.0.0-rc2. It’s similar to the issue found at [[v2.0.0-rc1] That version of GPGAuth is not supported](https://community.passbolt.com/t/v2-0-0-rc1-that-version-of-gpgauth-is-not-supported/292), but the underlying cause seems to be different. System particulars: Ubuntu 16.04.3 PHP 7.0.22-0ubuntu0.16.04.1 Apache/2.4.18 (Ubuntu) Plugin version 1.6.9 (Chrome) Healthcheck is green (aside from an error about test data): user@passbolt:/var/www/passbolt$ sudo su -s /bin/bash -c “./bin/cake passbolt healthcheck” www-data Warning Error: array\_keys() expects parameter 1 to be array, null given in [/var/www/passbolt/plugins/PassboltTestData/src/Shell/Task/DataTask.php, line 41] ``` ______ ____ / __\____ _________ / /_ ____ / / /_ ``` / /_/ / \_\_ `/ / / \_\_ / \_\_ / / \_/ / **/ // (** | ) // / // / / / // \_,/_ **/** _/._\_\_/\_\ __//\__ / ## Open source password manager for teams ## Healthcheck shell Environment [PASS] PHP version 7.0.22-0ubuntu0.16.04.1 [PASS] PCRE compiled with unicode support [PASS] The temporary directory and its content are writable [PASS] The public image directory and its content are writable [PASS] The logs directory and its content are writable Config files [PASS] The application config file is present [PASS] The passbolt config file is present Core config [PASS] Debug mode is off. [PASS] Cache is working. [PASS] Unique value set for security.salt [PASS] Full base url is set to hxxps://creds.cfp.local [PASS] App.fullBaseUrl validation OK. [PASS] /healthcheck/status is reachable. SSL Certificate [PASS] SSL peer certificate validates [PASS] Hostname is matching in SSL certificate. [WARN] Using a self-signed certificate Database [PASS] The application is able to connect to the database [PASS] 19 tables found [PASS] Some default content is present [PASS] The database schema up to date. GPG Configuration [PASS] PHP GPG Module is installed and loaded. [PASS] The server gpg key is not the default one [PASS] The environment variable GNUPGHOME is set to /var/www/.gnupg. [PASS] The directory /var/www/.gnupg containing the keyring is writable by the webserver user. [PASS] The public key file is defined in config/passbolt.php and readable. [PASS] The private key file is defined in config/passbolt.php and readable. [PASS] The server key fingerprint matches the one defined in config/passbolt.php. [PASS] The server key defined in the config/passbolt.php is in the keyring. [PASS] There is a valid email id defined for the server key. [PASS] The public key can be used to encrypt and sign a message. [PASS] The private key can be used to decrypt a message. Application configuration [PASS] Using latest passbolt version (2.0.0-rc2). [PASS] Passbolt is configured to force SSL use. [PASS] App.fullBaseUrl is set to HTTPS. [PASS] Selenium API endpoints are disabled. [PASS] Search engine robots are told not to index content. [PASS] Registration is closed, only administrators can add users. [PASS] Serving the compiled version of the javascript app [PASS] All email notifications will be sent. No error found. Nice one sparky! I am receiving a repeating error in ./logs/error.log every time I load the login page: Error: [PDOException] SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4\_unicode\_ci,IMPLICIT) and (utf8mb4\_general\_ci,IMPLICIT) for operation ‘=’ Any ideas as to what might be happening? Thanks, Ben ---
**Author:** ![remy](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/remy/32/17_2.png) [@remy](https://community.passbolt.com/u/remy)\ **Post date:** [January 25, 2018, 4:58am UTC](https://community.passbolt.com/t/v2-0-0-that-version-of-gpgauth-is-not-supported/314/2 "2018-01-25T04:58:36Z")
There is an issue with your database encoding. Can you check the encoding for the database and each tables. They should be in “utf8mb4\_unicode\_ci” not “utf8mb4\_general\_ci”. ---
**Author:** ![axemann](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@axemann](https://community.passbolt.com/u/axemann)\ **Post date:** [January 25, 2018, 5:17am UTC](https://community.passbolt.com/t/v2-0-0-that-version-of-gpgauth-is-not-supported/314/3 "2018-01-25T05:17:14Z")
Thanks for responding, remy. It looks like there are 3 tables that are utf8\_general\_ci: burzum\_file\_storage\_phinxlog email\_queue\_phinxlog phinxlog I’ll get the table and column collation changed over to utf8mb4\_unicode\_ci and let you know the outcome. ---
**Author:** ![axemann](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@axemann](https://community.passbolt.com/u/axemann)\ **Post date:** [January 25, 2018, 5:21am UTC](https://community.passbolt.com/t/v2-0-0-that-version-of-gpgauth-is-not-supported/314/4 "2018-01-25T05:21:58Z")
remy, Unfortuantely that did not resolve the issue, and I’m still receiving the below in the error log: 2018-01-25 05:20:27 Error: [PDOException] SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4\_unicode\_ci,IMPLICIT) and (utf8mb4\_general\_ci,IMPLICIT) for operation '=' Request URL: /auth/verify.json ---
**Author:** ![kevin](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/kevin/32/128_2.png) [@kevin](https://community.passbolt.com/u/kevin)\ **Post date:** [January 25, 2018, 5:36am UTC](https://community.passbolt.com/t/v2-0-0-that-version-of-gpgauth-is-not-supported/314/5 "2018-01-25T05:36:29Z")
Hi @axemann Is it possible that you missed one table or column? Could you execute the following query in mysql, and see if it returns anything? (Just in case). ``` SELECT table_schema, table_name, column_name, character_set_name, collation_name FROM information_schema.columns WHERE collation_name = 'utf8mb4_general_ci' ORDER BY table_schema, table_name,ordinal_position; ``` Let us know! ---
**Author:** ![axemann](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@axemann](https://community.passbolt.com/u/axemann)\ **Post date:** [January 25, 2018, 3:04pm UTC](https://community.passbolt.com/t/v2-0-0-that-version-of-gpgauth-is-not-supported/314/6 "2018-01-25T15:04:20Z")
Hi @kevin, That query produced the following: ```auto +--------------+--------------+-------------+--------------------+--------------------+ | table_schema | table_name | column_name | character_set_name | collation_name | +--------------+--------------+-------------+--------------------+--------------------+ | passbolt_v2 | file_storage | user_id | utf8mb4 | utf8mb4_general_ci | | passbolt_v2 | file_storage | foreign_key | utf8mb4 | utf8mb4_general_ci | | passbolt_v2 | file_storage | model | utf8mb4 | utf8mb4_general_ci | | passbolt_v2 | file_storage | filename | utf8mb4 | utf8mb4_general_ci | | passbolt_v2 | file_storage | extension | utf8mb4 | utf8mb4_general_ci | | passbolt_v2 | file_storage | hash | utf8mb4 | utf8mb4_general_ci | | passbolt_v2 | file_storage | path | utf8mb4 | utf8mb4_general_ci | | passbolt_v2 | file_storage | adapter | utf8mb4 | utf8mb4_general_ci | +--------------+--------------+-------------+--------------------+--------------------+ ``` It looks like there are still a few columns I need to get sorted out. I’ll make those changes and report back. Thanks! ---
**Author:** ![axemann](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@axemann](https://community.passbolt.com/u/axemann)\ **Post date:** [January 25, 2018, 3:18pm UTC](https://community.passbolt.com/t/v2-0-0-that-version-of-gpgauth-is-not-supported/314/7 "2018-01-25T15:18:03Z")
@kevin, Looks like that did the trick. 🙂 ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex031/uploads/passbolt/original/2X/b/bee7d3f9329f668000d46e9fcb2e5db1e9d31348.svg) [@system](https://community.passbolt.com/u/system)\ **Post date:** [January 30, 2018, 3:18pm UTC](https://community.passbolt.com/t/v2-0-0-that-version-of-gpgauth-is-not-supported/314/8 "2018-01-30T15:18:07Z")
Closed on January 30, 2018, 3:18pm UTC This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.