Helm install - Table 'passbolt.email_queue' doesn't exist

Installation Issues
1

Chart version: 1.1.1
App version: 4.7.0-1-ce

I’ve performed a fresh install of passbolt but the passbolt-cron-proc-email pod keeps failing. At the top of the logs is the error listed below. Everything else is happy. The database and redis connections seem to be working as expected. It’s just that the ‘passbolt.email_queue’ table, seemingly, isn’t getting created during install. Thoughts?

2024-05-22 12:49:23 error: [Cake\Database\Exception\DatabaseException] SQLSTATE[42S02]: Base table or view not found: 11
46 Table ‘passbolt.email_queue’ doesn’t exist in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Schema/Collect
ion.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

1 Like
2

hello @joshuarestivo Am experiencing the same error with the same chart version. did you ever get a fix for this?

3

I figured it out.

The issue was the passbolt pod could not connect to the database so that initialization could happen. So it kept displaying “Waiting for database connection” on the logs.

The problem was, database client used inside the deployment specifications is “mariadb”. yet this does not seem to be installed on the pod.

The solution was to install mysql client by adding the command below at the beginning of the initContainer called mariadb
apt update && apt install mysql-client -y

This will solve the problem of connecting to mariadb and everything else will work.

Also, make sure to setup other envrironment variables eg SMTP details so that everything works well.