Helm installation issue. Table 'passbolt.email_queue' doesn't exist

Installation Issues
1

Checklist
I have read intro post: About the Installation Issues category
I have read the tutorials, help and searched for similar issues
I provide relevant information about my server (component names and versions, etc.)
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

I’ve installed RKE2 cluster via Rancher.
Rancher: v2.9.3
Provider: RKE2
Kubernetes Version: v1.30.5 +rke2r1
Architecture: Amd64

All nodes has etcd, control plane, worker roles.

I’ve added longhorn to the cluster to keep persistent data for mariadb. All three nodes are the storage nodes for Persistent Storage.

I’ve imported helm chart via Rancher.

Started installation Passbolt from Rancher using the chart.
Set params Redis password, MariaDB Password, MariaDB Username, MariaDB Replication Password, Cake Cache Password, Application connection password, Application connection username, App Full Base URL

Persistent volumes are created successfully

Pods are started: redis, mariadb.
But some pods isn’t: cron-proc-email, depl-srv

image
image1571×572 126 KB

Logs into passbolt-cron-proc-email:

Sending emails
2024-11-05 18:02:51 error: [Cake\Database\Exception\DatabaseException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'passbolt.email_queue' doesn't exist in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Schema/Collection.php on line 160
Caused by: [PDOException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'passbolt.email_queue' doesn't exist in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
<!DOCTYPE html>
<html class="passbolt no-js no-passboltplugin version" lang="en">
<head>
    <meta charset="utf-8">
    <title>Passbolt | Error</title>
    <!--
        ____                  __          ____
       / __ \____  _____ ____/ /_  ____  / / /_
      / /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
     / ____/ /_/ (__  )__  ) /_/ / /_/ / / /_
    /_/    \__,_/____/____/_.___/\____/_/\__/
...

Logs into passbolt-depl-srv:

gpg: keybox '/var/lib/passbolt/.gnupg/pubring.kbx' created
gpg: /var/lib/passbolt/.gnupg/trustdb.gpg: trustdb created
gpg: key C69B4A2B378B87C4: public key "Passbolt default user <passbolt@yourdomain.com>" imported
gpg: Total number processed: 1
gpg:               imported: 1
gpg: key C69B4A2B378B87C4: "Passbolt default user <passbolt@yourdomain.com>" not changed
gpg: key C69B4A2B378B87C4: secret key imported
gpg: Total number processed: 1
gpg:              unchanged: 1
gpg:       secret keys read: 1
gpg:   secret keys imported: 1
-----
Installing passbolt
<!DOCTYPE html>
<html class="passbolt no-js no-passboltplugin version" lang="en">
<head>
    <meta charset="utf-8">
    <title>Passbolt | Error</title>
    <!--
        ____                  __          ____
       / __ \____  _____ ____/ /_  ____  / / /_
      / /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
     / ____/ /_/ (__  )__  ) /_/ / /_/ / / /_
    /_/    \__,_/____/____/_.___/\____/_/\__/
...
</footer>
</div>
</body>
</html>
Running migrations
<!DOCTYPE html>
<html class="passbolt no-js no-passboltplugin version" lang="en">
<head>
    <meta charset="utf-8">
    <title>Passbolt | Error</title>
    <!--
        ____                  __          ____
       / __ \____  _____ ____/ /_  ____  / / /_
      / /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
     / ____/ /_/ (__  )__  ) /_/ / /_/ / / /_
    /_/    \__,_/____/____/_.___/\____/_/\__/
...

passbolt-cron-proc-email infinity restarting with error of email_queue table not found:
passbolt-depl-srv infinity crashing with 500 error.

I’ve tried to connect to the database manually and check tables if there is any table, but database is empty. Database is created, but no one table imported.

I have no name!@passbolt-mariadb-primary-0:/$ mysql -hlocalhost -upassbolt -p passbolt
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2256
Server version: 10.6.12-MariaDB-log Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [passbolt]> show tables;
Empty set (0.000 sec)

MariaDB [passbolt]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| passbolt           |
| test               |
+--------------------+
3 rows in set (0.003 sec)

I’ve checked documentation and don’t found that DB scheme need to import manually.
Maybe some problem with importer? Which process should import database or how I can manually import it, where I can find database scheme?

2

I’ve tried to setup passbolt on another server with docker.
Then dump database, copy to the rke2 node, copy to container with:

kubectl cp -n passbolt-system ./passbolt.sql passbolt-mariadb-primary-0:/tmp/

Restore from dump:

mysql -hlocalhost -upassbolt -p passbolt < /tmp/passbolt.sql

DB scheme is in MariaDB:

I have no name!@passbolt-mariadb-primary-0:/$ mysql -hlocalhost -upassbolt -p passbolt                    
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 501
Server version: 10.6.12-MariaDB-log Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [passbolt]> show tables;
+---------------------------+
| Tables_in_passbolt        |
+---------------------------+
| account_settings          |
| action_logs               |
| actions                   |
| authentication_tokens     |
| avatars                   |
| comments                  |
| email_queue               |
| entities_history          |
| favorites                 |
| folders                   |
| folders_history           |
| folders_relations         |
| folders_relations_history |
| gpgkeys                   |
| groups                    |
| groups_users              |
| organization_settings     |
| permissions               |
| permissions_history       |
| phinxlog                  |
| profiles                  |
| rbacs                     |
| resource_types            |
| resources                 |
| roles                     |
| secret_accesses           |
| secrets                   |
| secrets_history           |
| transfers                 |
| ui_actions                |
| users                     |
+---------------------------+
31 rows in set (0.001 sec)

In the cron-email-proc pod there is no an error with table passbolt.email_queue does't exist.
But passbolt-depl-srv still restarting with the same output.