Passbolt broken after v4 update - intermittent login issues

API & Customization issues
41

This is not normal, we do not have seen this behavior before. There is nothing in the web application that updates the fingerprint once it’s set. I suspect this is due to your database configuration (something specific to your local language? like some right to left setting?).

  1. Do you have any replication in place?
    This could explain why it get overriden if the “master” is somewhere else.

  2. What is the charset of the database ?

SELECT @@character_set_database, @@collation_database;
  1. What is the charset of the table?
SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,        information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation   AND T.table_schema = "passboltdb"   AND T.table_name = "gpgkeys";
  1. What is the charset of the collumn fingerprint?
SELECT character_set_name FROM information_schema.`COLUMNS` 
WHERE table_schema = "passboltdb"
  AND table_name = "gpgkeys"
  AND column_name = "fingerprint";
  1. Do you have any stored procedure?
 SHOW PROCEDURE STATUS;
42

Yes you can write to contact@passbolt.com, we can have a look tomorrow morning at 10:00 CET.

43

Hello @remy

  1. No, we do not have replication in place. this is a single VM with all the dependencies on it.

  2. Database charset:

mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8mb4                  | utf8mb4_unicode_ci   |
+--------------------------+----------------------+
1 row in set (0.00 sec)
  1. table charset:
mysql> SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,        information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation   AND T.table_schema = "passbolt"   AND T.table_name = "gpgkeys";
+--------------------+
| CHARACTER_SET_NAME |
+--------------------+
| utf8mb4            |
+--------------------+
1 row in set (0.01 sec)
  1. fingerprint column charset:
mysql> SELECT character_set_name FROM information_schema.`COLUMNS`  WHERE table_schema = "passbolt"   AND table_name = "gpgkeys"   AN
D column_name = "fingerprint";
+--------------------+
| CHARACTER_SET_NAME |
+--------------------+
| utf8mb4            |
+--------------------+
1 row in set (0.00 sec)
  1. There seems to be 26 stored procedures, none of them look related to passbolt, we can go over this on our session.

And btw, sorry for the late reply, very busy week. I’m available today for a quick session.

44

Hello @remy,

I have sent an email to contact@passbolt.com, can you please double check.

45

Hello Dears, any news on this?

46

I cannot see your email in our support system, can you resend your information at contact@passbolt.com with the subject “Passbolt broken after v4 update - intermittent login issues”. Best,