[v2.0.0] That version of GPGAuth is not supported

Checklist
[X ] I have read intro post: About the Installation Issues category
[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, 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

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”.

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.

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

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!

Hi @kevin,

That query produced the following:

+--------------+--------------+-------------+--------------------+--------------------+
| 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!

@kevin,

Looks like that did the trick. :slight_smile:

1 Like

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.