Checklist
[x] I have read intro post: hxxps://community.passbolt.com/t/about-the-installation-issues-category/12 [link removed since you have a minor sane 2-links-per-post limit]
[y] I have read the tutorials, help and searched for similar issues
[z] I provide relevant information about my server (component names and versions, etc.)
[a] I provide a copy of my logs and healthcheck
[b] I describe the steps I have taken to trouble shoot the problem
[c] I describe the steps on how to reproduce the issue
I’m coming from https://github.com/passbolt/passbolt_api/issues/218 with an almost unchanged problem. Changes since that report: I re-ran app/Console/cake install without the recommended --no-admin (see https://www.passbolt.com/help/tech/install#toc_install), which seemed to work, I now can see a new user entry in passbolt.users.
The healthcheck passes except for
Database
[FAIL] No table found
[HELP] Run the install script to install the database tables
[HELP] sudo su -s /bin/bash -c "/var/www/passbolt/app/Console/cake install" www-data
[FAIL] No default content found
[HELP] Run the install script to set the default content such as roles and permission types
[HELP] sudo su -s /bin/bash -c "/var/www/passbolt/app/Console/cake install" www-data
while the suggestions are misleading in my eyes because the installation already finished (with no visible errors). Also, I can login and execute queries with the copy-pasted data from app/Config/database.php.
The frontend returns 500 for any action, app/tmp/logs/error.log shows
2018-01-15 22:58:36 Error: [MissingTableException] Table users for model User was not found in datasource default.
Exception Attributes: array (
'table' => 'users',
'class' => 'User',
'ds' => 'default',
)
Request URL: /auth/login
Stack Trace:
#0 /var/www/passbolt/lib/Cake/Model/Model.php(3667): Model->setSource('users')
#1 /var/www/passbolt/lib/Cake/Model/Model.php(3038): Model->getDataSource()
#2 /var/www/passbolt/lib/Cake/Model/Model.php(3010): Model->_readDataSource('first', Array)
#3 /var/www/passbolt/app/Model/User.php(402): Model->find('first', Array)
#4 /var/www/passbolt/app/Model/User.php(360): User::setActive('anonymous@passb...')
#5 /var/www/passbolt/app/Model/ControllerLog.php(176): User::get()
#6 /var/www/passbolt/app/Controller/AuthController.php(45): ControllerLog::write('error', Object(CakeRequest), 'login_failure', '')
#7 [internal function]: AuthController->login()
#8 /var/www/passbolt/lib/Cake/Controller/Controller.php(491): ReflectionMethod->invokeArgs(Object(AuthController), Array)
#9 /var/www/passbolt/lib/Cake/Routing/Dispatcher.php(193): Controller->invokeAction(Object(CakeRequest))
#10 /var/www/passbolt/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke(Object(AuthController), Object(CakeRequest))
#11 /var/www/passbolt/app/webroot/index.php(110): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))
#12 {main}
which seems to be the same issue for all three of a) register user (github/218) b) healthcheck “table/data not found” c) frontend /auth/login doesn’t find its user table.
How do you fix this?