# My setup(v2) is loosing users / PWs inserted by GUI

**URL:** <https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562>\
**Category:** Installation Issues\
**Created:** [April 13, 2018, 11:41am UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562 "2018-04-13T11:41:46Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![jay1984](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@jay1984](https://community.passbolt.com/u/jay1984)\
**Post date:** [April 13, 2018, 11:41am UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/1 "2018-04-13T11:41:46Z")

</div>

Dear team,  
our passbolt-installation is accepting neither new passwords nor users created over the webgui.

- The user / passwort is shown in gui for a few seconds. After a change of webpage / refresh the data is gone.

User creation over CLI is possible and working.

My setup:  
VM on Ubuntu 16.04.4 LTS  
mysql Ver 14.14 Distrib 5.7.21, for Linux (x86\_64) using EditLine wrapper  
PHP 7.0.28-0ubuntu0.16.04.1 (cli) ( NTS )  
Copyright © 1997-2017 The PHP Group  
Zend Engine v3.0.0, Copyright © 1998-2017 Zend Technologies  
with Zend OPcache v7.0.28-0ubuntu0.16.04.1, Copyright © 1999-2017, by Zend Technologies  
Passbolt v2.1 (updated from newest 1.x)

healthcheck:  
www-data@test:~$ /var/www/html/passbolt/bin/cake passbolt healthcheck

```
 ______  ____
/ __\____  _________ / /_ ____ / / /_

```

/ /_/ / \_\_ `/ / / \_\_ / \_\_ / / \_/  
/ **/ // (** | ) // / // / / /  
// \_,/_ **/** _/._\_\_/\_\ __//\__ /

## Open source password manager for teams

## Healthcheck shell

Environment

[PASS] PHP version 7.0.28-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.  
[PASS] GD or Imagick extension is installed.  
[PASS] Intl extension is installed.  
[PASS] Mbstring extension is installed.

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 [https://lab.XXXXX.net/passbolt](https://lab.XXXXX.net/passbolt)  
[PASS] App.fullBaseUrl validation OK.  
[PASS] /healthcheck/status is reachable.

SSL Certificate

[FAIL] SSL peer certificate does not validate  
[FAIL] Hostname does not match when validating certificates.  
[WARN] Using a self-signed certificate  
[HELP] fopen(): Peer certificate CN=`test-' did not match expected CN=`[lab.XXXXX.net](http://lab.XXXXX.net)’  
fopen(): Failed to enable crypto  
#fopen(://lab.XXXXX.net/passbolt/healthcheck/status.json): failed to open stream: operation failed

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 /home/www-data/.gnupg.  
[PASS] The directory /home/www-data/.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 public 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 a message.  
[PASS] The public key can be used to sign a message.  
[PASS] The public key can be used to encrypt and sign a message.  
[PASS] The private key can be used to decrypt a message.  
[PASS] The private key can be used to decrypt and verify a message.  
[PASS] The public key can be used to verify a signature.

Application configuration

[PASS] Using latest passbolt version (2.0.1).  
[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.

2 error(s) found. Hang in there!

- the SQL-Error-Log is empty
- email-log of passbolt is empty
- the debug-mode is enabled in config/passbolt.php, but it does not generate any output - where is the data gathered by debug stored? email.log?

Any help is highly appreciated.  
Thank you & keep up the nice work. We all like the project and are looking forward to any progress.

---

<div class="post-metadata">

**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:** [April 13, 2018, 11:46am UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/2 "2018-04-13T11:46:23Z")

</div>

Can you check the charset in your database? See. [Error 500 when try to recover account after upgrade to v2.0.1](https://community.passbolt.com/t/error-500-when-try-to-recover-account-after-upgrade-to-v2-0-1/555/3)

We’re working on a hotfix to help with the migration.

---

<div class="post-metadata">

**Author:** ![jay1984](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@jay1984](https://community.passbolt.com/u/jay1984)\
**Post date:** [April 13, 2018, 11:57am UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/3 "2018-04-13T11:57:05Z")

</div>

My mysql says  
InnoDB utf8mb4\_unicode\_ci 464 KiB 0 B

 ![grafik](https://canada1.discourse-cdn.com/flex031/uploads/passbolt/original/1X/c7105e0a60342a6c02450f94b4832a3859576a51.png)

Which would be ok?

---

<div class="post-metadata">

**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:** [April 13, 2018, 11:57am UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/4 "2018-04-13T11:57:58Z")

</div>

Can you check the individual fields for the table file\_storage?

---

<div class="post-metadata">

**Author:** ![jay1984](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@jay1984](https://community.passbolt.com/u/jay1984)\
**Post date:** [April 13, 2018, 12:01pm UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/5 "2018-04-13T12:01:19Z")

</div>

File\_storage seems to be empty:

 ![grafik](https://canada1.discourse-cdn.com/flex031/uploads/passbolt/original/1X/cc4773bc6982f9f6a1e28d13f75a2eeaf19ff68b.png)

(sorry it is german 🙂 )

---

<div class="post-metadata">

**Author:** ![jay1984](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@jay1984](https://community.passbolt.com/u/jay1984)\
**Post date:** [April 13, 2018, 12:03pm UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/6 "2018-04-13T12:03:57Z")

</div>

indizes:

 ![grafik](https://canada1.discourse-cdn.com/flex031/uploads/passbolt/original/1X/5da3e78edc2b8784cd6184a9bd7026016aab5ad3.png)

Hope I got the correct info 🙂

---

<div class="post-metadata">

**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:** [April 13, 2018, 12:15pm UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/7 "2018-04-13T12:15:20Z")

</div>

Yes so it’s the same problem, you need to change the “Koallation” following the method described in the other ticket. [Error 500 when try to recover account after upgrade to v2.0.1](https://community.passbolt.com/t/error-500-when-try-to-recover-account-after-upgrade-to-v2-0-1/555/3?u=remy)

---

<div class="post-metadata">

**Author:** ![jay1984](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@jay1984](https://community.passbolt.com/u/jay1984)\
**Post date:** [April 13, 2018, 12:22pm UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/8 "2018-04-13T12:22:18Z")

</div>

I just got it right. It was indeed solved by altering the fields to utf8. THanks for your fast support!

I have one other issue, also directly related to the update:

I can’t edit/copy password-entries over the gui. If I mark a PW-Entry the fields for edit, copy, share are still greyed out.

For entries that have been in the system prior to update to v2 edit / sharing, etc. is possible.

---

<div class="post-metadata">

**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:** [April 13, 2018, 12:28pm UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/9 "2018-04-13T12:28:00Z")

</div>

@jay1984 I think there might be some issues with the record created in the meantime, they might be corrupted. Could you try to create a new one now and see if the same error occurs? For the passwords created in the meantime you might have to delete / create them again. It’s not possible, can contact us at [contact@passbolt.com](mailto:contact@passbolt.com) could schedule a call to see if they can be recovered.

---

<div class="post-metadata">

**Author:** ![jay1984](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@jay1984](https://community.passbolt.com/u/jay1984)\
**Post date:** [April 13, 2018, 12:32pm UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/10 "2018-04-13T12:32:48Z")

</div>

I just added a new entry. Unfortunately it is still the same issue. No edit, copy, etc. is possible when I select the new entry. The fields for edit, etc. are still not accessible

---

<div class="post-metadata">

**Author:** ![cedric](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/cedric/32/3868_2.png) [@cedric](https://community.passbolt.com/u/cedric)\
**Post date:** [April 13, 2018, 12:50pm UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/11 "2018-04-13T12:50:19Z")

</div>

@jay1984  
If you have time now, we could organize a quick call.  
Send us an email to [contact@passbolt.com](mailto:contact@passbolt.com)

---

<div class="post-metadata">

**Author:** ![cedric](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/cedric/32/3868_2.png) [@cedric](https://community.passbolt.com/u/cedric)\
**Post date:** [April 13, 2018, 12:57pm UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/12 "2018-04-13T12:57:09Z")

</div>

Can you check if the permissions table or any other have this collate issue.  
We’re working on a fix right now, it would help us a lot.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex031/uploads/passbolt/original/2X/b/bee7d3f9329f668000d46e9fcb2e5db1e9d31348.svg) [@system](https://community.passbolt.com/u/system)\
**Post date:** [April 18, 2018, 12:57pm UTC](https://community.passbolt.com/t/my-setup-v2-is-loosing-users-pws-inserted-by-gui/562/13 "2018-04-18T12:57:09Z")

</div>

Closed on April 18, 2018, 12:57pm UTC

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