Install: Table 'passbolt.users' doesn't exist

Hello,

when running app/Console/cake install on Debian Stretch I currently encounter the following error:

Table schema_migrations created Execute specific schema PermissionsSchemaError: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'passbolt.users' doesn't exist #0 /srv/passbolt/lib/Cake/Model/Datasource/DboSource.php(470): PDOStatement->execute(Array) #1 /srv/passbolt/lib/Cake/Model/Datasource/DboSource.php(436): DboSource->_execute('CREATE OR REPLA...', Array) #2 /srv/passbolt/lib/Cake/Model/Datasource/DboSource.php(673): DboSource->execute('\n\t\t\tCREATE OR R...', Array, Array) #3 /srv/passbolt/lib/Cake/Model/Datasource/DboSource.php(609): DboSource->fetchAll('\n\t\t\tCREATE OR R...', Array) #4 /srv/passbolt/lib/Cake/Model/Model.php(3470): DboSource->query('\n\t\t\tCREATE OR R...', false) #5 /srv/passbolt/app/Config/Schema/permissions.php(19): Model->query('\n\t\t\tCREATE OR R...') #6 /srv/passbolt/app/Config/Schema/schema.php(50): PermissionsSchema->init() #7 /srv/passbolt/app/Console/Command/SchemaShell.php(449): AppSchema->after(Array) #8 /srv/passbolt/app/Console/Command/SchemaShell.php(352): SchemaShell->_run(Array, 'create', Object(AppSchema)) #9 /srv/passbolt/app/Console/Command/SchemaShell.php(251): SchemaShell->_create(Object(AppSchema), 'schema_migratio...') #10 /srv/passbolt/lib/Cake/Console/Shell.php(458): SchemaShell->create() #11 /srv/passbolt/lib/Cake/Console/ShellDispatcher.php(219): Shell->runCommand('create', Array) #12 /srv/passbolt/lib/Cake/Console/Shell.php(399): ShellDispatcher->dispatch() #13 /srv/passbolt/app/Console/Command/InstallShell.php(312): Shell->dispatchShell('schema create -...') #14 /srv/passbolt/app/Console/Command/InstallShell.php(133): InstallShell->schema() #15 /srv/passbolt/lib/Cake/Console/Shell.php(461): InstallShell->main() #16 /srv/passbolt/lib/Cake/Console/ShellDispatcher.php(219): Shell->runCommand(NULL, Array) #17 /srv/passbolt/lib/Cake/Console/ShellDispatcher.php(66): ShellDispatcher->dispatch() #18 /srv/passbolt/app/Console/cake.php(52): ShellDispatcher::run(Array) #19 {main}

Any idea what’s going wrong here?

Kim Brodowski

Hello Kim,

To have a better understanding of what’s going wrong, could you execute the passbolt healthcheck :

app/Console/cake passbolt healthcheck

Best regards,
Cédric

Before resetting the database:
---------------------------------------------------------------
____ __ ____
/ __ ____ _____ / / ____ / / /
/ /
/ / __ `/ / / __ / __ / / _/
/ / // ( |
) /
/ / /
/ / / /
/
/ _
,
/
//.__/__//_/

 Open source password manager for teams
---------------------------------------------------------------
 Healthcheck shell.......Error: Table "pb_schema_migrations" already exists in database.
#0 /srv/passbolt/app/Plugin/Migrations/Lib/CakeMigration.php(240): CakeMigration->_run()
#1 /srv/passbolt/app/Plugin/Migrations/Lib/MigrationVersion.php(376): CakeMigration->run('up', Array)
#2 /srv/passbolt/app/Plugin/Migrations/Lib/MigrationVersion.php(453): MigrationVersion->run(Array)
#3 /srv/passbolt/app/Plugin/Migrations/Lib/MigrationVersion.php(128): MigrationVersion->_initMigrations()
#4 /srv/passbolt/app/Lib/Migration/Migration.php(33): MigrationVersion->__construct()
#5 /srv/passbolt/app/Lib/Healthchecks.php(221): Migration::needMigration()
#6 /srv/passbolt/app/Console/Command/Task/HealthcheckTask.php(136): Healthchecks::application()
#7 /srv/passbolt/lib/Cake/Console/Shell.php(458): HealthcheckTask->execute()
#8 /srv/passbolt/lib/Cake/Console/Shell.php(455): Shell->runCommand('execute', Array)
#9 /srv/passbolt/lib/Cake/Console/ShellDispatcher.php(219): Shell->runCommand('Healthcheck', Array)
#10 /srv/passbolt/lib/Cake/Console/ShellDispatcher.php(66): ShellDispatcher->dispatch()
#11 /srv/passbolt/app/Console/cake.php(52): ShellDispatcher::run(Array)
#12 {main}

After resetting:
---------------------------------------------------------------
____ __ ____
/ __ ____ _____ / / ____ / / /
/ /
/ / __ `/ / / __ / __ / / _/
/ / // ( |
) /
/ / /
/ / / /
/
/ _
,
/
//.__/__//_/

 Open source password manager for teams
---------------------------------------------------------------
 Healthcheck shell.......Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'passbolt.pb_schema_migrations' doesn't exist
#0 /srv/passbolt/lib/Cake/Model/Datasource/DboSource.php(470): PDOStatement->execute(Array)
#1 /srv/passbolt/lib/Cake/Model/Datasource/DboSource.php(436): DboSource->_execute('SELECT `SchemaM...', Array)
#2 /srv/passbolt/lib/Cake/Model/Datasource/DboSource.php(673): DboSource->execute('SELECT `SchemaM...', Array, Array)
#3 /srv/passbolt/lib/Cake/Model/Datasource/DboSource.php(1184): DboSource->fetchAll('SELECT `SchemaM...', Array)
#4 /srv/passbolt/lib/Cake/Model/Model.php(3038): DboSource->read(Object(SchemaMigration), Array)
#5 /srv/passbolt/lib/Cake/Model/Model.php(3010): Model->_readDataSource('all', Array)
#6 /srv/passbolt/app/Plugin/Migrations/Lib/MigrationVersion.php(228): Model->find('all', Array)
#7 /srv/passbolt/app/Plugin/Migrations/Lib/MigrationVersion.php(448): MigrationVersion->getMapping('Migrations')
#8 /srv/passbolt/app/Plugin/Migrations/Lib/MigrationVersion.php(128): MigrationVersion->_initMigrations()
#9 /srv/passbolt/app/Lib/Migration/Migration.php(33): MigrationVersion->__construct()
#10 /srv/passbolt/app/Lib/Healthchecks.php(221): Migration::needMigration()
#11 /srv/passbolt/app/Console/Command/Task/HealthcheckTask.php(136): Healthchecks::application()
#12 /srv/passbolt/lib/Cake/Console/Shell.php(458): HealthcheckTask->execute()
#13 /srv/passbolt/lib/Cake/Console/Shell.php(455): Shell->runCommand('execute', Array)
#14 /srv/passbolt/lib/Cake/Console/ShellDispatcher.php(219): Shell->runCommand('Healthcheck', Array)
#15 /srv/passbolt/lib/Cake/Console/ShellDispatcher.php(66): ShellDispatcher->dispatch()
#16 /srv/passbolt/app/Console/cake.php(52): ShellDispatcher::run(Array)
#17 {main}

I guess the later one is to be expected.

Thank you for your help on this matter.

Are you using prefixes? I can see from “pb_schema_migrations”.
Database prefixes are not supported at the moment.

That’d make sense I guess. Thank your for your help on this matter.

It’d be helpful if that’s pointed in the installation guide, since it’s pretty common to set those and the prefix variable is part of the default configuration.

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