Could not verify server key. Server code: That version of GPGAuth is not supported. (undefined)

I have recently upgraded to 2.0.4 and after numerous hurdles to get the healthcheck to report back all ok I’ve now hit the below error:

‘Could not verify server key. Server code: That version of GPGAuth is not supported. (undefined)’

‘Oops Something Went Wrong’

I’ve tried to execute the query in this article:

This didn’t resolve the error. PLease can someone advise the next step to troubleshoot.

My environment detailed below:
Debain 8
PHP 7.0
MariaDB
Apache

The only observation i’ve made is that in the DB under collation_name i have some tables using utf8_general_ci, utf8mb4_unicode_ci and utf8_unicode_ci. Anyway aware of conflicts in multiple character sets?

Thanks
Daryl

To add to this I took this from the error log

2018-05-01 17:20:46 Error: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘Users.created_by’ in ‘field list’
Request URL: /auth/verify.json?api-version=v1

Hi @DarylForrester,

Users.created_by field is dropped during the v2 migration script so there should not be any request asking for it. It seems you have an issue with your database structure.

The only observation i’ve made is that in the DB under collation_name i have some tables using utf8_general_ci, utf8mb4_unicode_ci and utf8_unicode_ci. Anyway aware of conflicts in multiple character sets?

This is known to cause issue, this is why we published a fix in v2.0.2 (there is special migration script step for this).

Sorry I cannot help you further, I’d advice retrying restoring a v1 backup and running the migration script again.

Do you where I can find a copy of the script that is run on 2.0.2? I basically need some commands to tidy up the Database structure and I think i’ll be good…

Or if someone could send a copy of the output from this script so I could compare?

SELECT table_schema, table_name, column_name, character_set_name, collation_name
FROM information_schema.columns
ORDER BY table_schema, table_name,ordinal_position;

Thanks

The migrations scripts are located in config/migrations, they can be run using

./bin/cake passbolt migrate

The expected database structure is as follow:

+--------------+------------------------------+-----------------+--------------------+--------------------+
| table_schema | table_name                   | column_name     | character_set_name | collation_name     |
+--------------+------------------------------+-----------------+--------------------+--------------------+
| passbolt_ce  | authentication_tokens        | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | authentication_tokens        | token           | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | authentication_tokens        | user_id         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | authentication_tokens        | active          | NULL               | NULL               |
| passbolt_ce  | authentication_tokens        | created         | NULL               | NULL               |
| passbolt_ce  | authentication_tokens        | modified        | NULL               | NULL               |
| passbolt_ce  | burzum_file_storage_phinxlog | version         | NULL               | NULL               |
| passbolt_ce  | burzum_file_storage_phinxlog | migration_name  | utf8               | utf8_general_ci    |
| passbolt_ce  | burzum_file_storage_phinxlog | start_time      | NULL               | NULL               |
| passbolt_ce  | burzum_file_storage_phinxlog | end_time        | NULL               | NULL               |
| passbolt_ce  | burzum_file_storage_phinxlog | breakpoint      | NULL               | NULL               |
| passbolt_ce  | comments                     | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | comments                     | parent_id       | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | comments                     | foreign_key     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | comments                     | foreign_model   | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | comments                     | content         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | comments                     | created         | NULL               | NULL               |
| passbolt_ce  | comments                     | modified        | NULL               | NULL               |
| passbolt_ce  | comments                     | created_by      | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | comments                     | modified_by     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | comments                     | user_id         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | id              | NULL               | NULL               |
| passbolt_ce  | email_queue                  | email           | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | from_name       | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | from_email      | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | subject         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | config          | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | template        | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | layout          | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | theme           | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | format          | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | template_vars   | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | headers         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue                  | sent            | NULL               | NULL               |
| passbolt_ce  | email_queue                  | locked          | NULL               | NULL               |
| passbolt_ce  | email_queue                  | send_tries      | NULL               | NULL               |
| passbolt_ce  | email_queue                  | send_at         | NULL               | NULL               |
| passbolt_ce  | email_queue                  | created         | NULL               | NULL               |
| passbolt_ce  | email_queue                  | modified        | NULL               | NULL               |
| passbolt_ce  | email_queue                  | attachments     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | email_queue_phinxlog         | version         | NULL               | NULL               |
| passbolt_ce  | email_queue_phinxlog         | migration_name  | utf8               | utf8_general_ci    |
| passbolt_ce  | email_queue_phinxlog         | start_time      | NULL               | NULL               |
| passbolt_ce  | email_queue_phinxlog         | end_time        | NULL               | NULL               |
| passbolt_ce  | email_queue_phinxlog         | breakpoint      | NULL               | NULL               |
| passbolt_ce  | favorites                    | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | favorites                    | user_id         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | favorites                    | foreign_key     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | favorites                    | foreign_model   | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | favorites                    | created         | NULL               | NULL               |
| passbolt_ce  | favorites                    | modified        | NULL               | NULL               |
| passbolt_ce  | file_storage                 | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | file_storage                 | user_id         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | file_storage                 | foreign_key     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | file_storage                 | model           | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | file_storage                 | filename        | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | file_storage                 | filesize        | NULL               | NULL               |
| passbolt_ce  | file_storage                 | mime_type       | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | file_storage                 | extension       | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | file_storage                 | hash            | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | file_storage                 | path            | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | file_storage                 | adapter         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | file_storage                 | created         | NULL               | NULL               |
| passbolt_ce  | file_storage                 | modified        | NULL               | NULL               |
| passbolt_ce  | gpgkeys                      | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | gpgkeys                      | user_id         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | gpgkeys                      | armored_key     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | gpgkeys                      | bits            | NULL               | NULL               |
| passbolt_ce  | gpgkeys                      | uid             | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | gpgkeys                      | key_id          | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | gpgkeys                      | fingerprint     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | gpgkeys                      | type            | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | gpgkeys                      | expires         | NULL               | NULL               |
| passbolt_ce  | gpgkeys                      | key_created     | NULL               | NULL               |
| passbolt_ce  | gpgkeys                      | deleted         | NULL               | NULL               |
| passbolt_ce  | gpgkeys                      | created         | NULL               | NULL               |
| passbolt_ce  | gpgkeys                      | modified        | NULL               | NULL               |
| passbolt_ce  | groups                       | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | groups                       | name            | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | groups                       | deleted         | NULL               | NULL               |
| passbolt_ce  | groups                       | created         | NULL               | NULL               |
| passbolt_ce  | groups                       | modified        | NULL               | NULL               |
| passbolt_ce  | groups                       | created_by      | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | groups                       | modified_by     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | groups_users                 | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | groups_users                 | group_id        | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | groups_users                 | user_id         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | groups_users                 | is_admin        | NULL               | NULL               |
| passbolt_ce  | groups_users                 | created         | NULL               | NULL               |
| passbolt_ce  | permissions                  | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | permissions                  | aco             | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | permissions                  | aco_foreign_key | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | permissions                  | aro             | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | permissions                  | aro_foreign_key | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | permissions                  | type            | NULL               | NULL               |
| passbolt_ce  | permissions                  | created         | NULL               | NULL               |
| passbolt_ce  | permissions                  | modified        | NULL               | NULL               |
| passbolt_ce  | phinxlog                     | version         | NULL               | NULL               |
| passbolt_ce  | phinxlog                     | migration_name  | utf8               | utf8_general_ci    |
| passbolt_ce  | phinxlog                     | start_time      | NULL               | NULL               |
| passbolt_ce  | phinxlog                     | end_time        | NULL               | NULL               |
| passbolt_ce  | phinxlog                     | breakpoint      | NULL               | NULL               |
| passbolt_ce  | profiles                     | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | profiles                     | user_id         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | profiles                     | first_name      | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | profiles                     | last_name       | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | profiles                     | created         | NULL               | NULL               |
| passbolt_ce  | profiles                     | modified        | NULL               | NULL               |
| passbolt_ce  | resources                    | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | resources                    | name            | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | resources                    | username        | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | resources                    | uri             | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | resources                    | description     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | resources                    | deleted         | NULL               | NULL               |
| passbolt_ce  | resources                    | created         | NULL               | NULL               |
| passbolt_ce  | resources                    | modified        | NULL               | NULL               |
| passbolt_ce  | resources                    | created_by      | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | resources                    | modified_by     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | roles                        | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | roles                        | name            | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | roles                        | description     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | roles                        | created         | NULL               | NULL               |
| passbolt_ce  | roles                        | modified        | NULL               | NULL               |
| passbolt_ce  | secrets                      | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | secrets                      | user_id         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | secrets                      | resource_id     | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | secrets                      | data            | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | secrets                      | created         | NULL               | NULL               |
| passbolt_ce  | secrets                      | modified        | NULL               | NULL               |
| passbolt_ce  | users                        | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | users                        | role_id         | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | users                        | username        | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | users                        | active          | NULL               | NULL               |
| passbolt_ce  | users                        | deleted         | NULL               | NULL               |
| passbolt_ce  | users                        | created         | NULL               | NULL               |
| passbolt_ce  | users                        | modified        | NULL               | NULL               |
| passbolt_ce  | user_agents                  | id              | utf8mb4            | utf8mb4_unicode_ci |
| passbolt_ce  | user_agents                  | name            | utf8mb4            | utf8mb4_unicode_ci |
+--------------+------------------------------+-----------------+--------------------+--------------------+

±-------------±-------------±------------±-------------------±----------------+
| table_schema | table_name | column_name | character_set_name | collation_name |
±-------------±-------------±------------±-------------------±----------------+
| passbolt | file_storage | id | utf8 | utf8_unicode_ci |
| passbolt | file_storage | user_id | utf8 | utf8_unicode_ci |
| passbolt | file_storage | foreign_key | utf8 | utf8_unicode_ci |
| passbolt | file_storage | model | utf8 | utf8_unicode_ci |
| passbolt | file_storage | filename | utf8 | utf8_unicode_ci |
| passbolt | file_storage | mime_type | utf8 | utf8_unicode_ci |
| passbolt | file_storage | extension | utf8 | utf8_unicode_ci |
| passbolt | file_storage | hash | utf8 | utf8_unicode_ci |
| passbolt | file_storage | path | utf8 | utf8_unicode_ci |
| passbolt | file_storage | adapter | utf8 | utf8_unicode_ci |
±-------------±-------------±------------±-------------------±----------------+

I think these entries are my problem…

I’ve updated the tables now and I now longer receive any errors in the error log yet the gpgkey message still persists:

Could not verify server key. Server code: That version of GPGAuth is not supported. (undefined)

Do you think recreating the keys would resolve the issue?

Thanks

This could come from multiple factors: the keyring is not available, the secret key in not in the keyring, the user key cannot be imported in the keyring. Run the healtcheck command to see if more information is available.

I’ll publish a fix in the next release to provide more information as of why the GPGAuth is failling that should help with this kind of issues.

1 Like

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