after updating to latest release, every time we create or edit an extension, we get the following error message:
Exception : SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ombutel.ombu_tenant_dids’ doesn’t exist With Query: select did from ombu_tenant_dids where tenant_id = ? at file /usr/share/vitalpbx/www/includes/db.php on line 0
the error message appears every time you reload the settings
After checking the database, indeed table ombu_tenant_dids table does not exist.
As this error never happened before, I assume this is a bug introduced in latest release 3.1.3 R1.
This should be set as Highest Priority as all systems are unusable.
as per your suggestion, I have executed the yum reinstall command, which resulted in
Resolving Dependencies
→ Running transaction check
—> Package vitalpbx-multi-tenant.x86_64 0:3.0.4-1 will be reinstalled
→ Finished Dependency Resolution
Ending result:
Stack trace: #0 /usr/share/vitalpbx/scripts/apply_migrations(0): patcher->shellcmd(‘/bin/bash -c se…’) #1 /usr/share/vitalpbx/scripts/apply_migrations(0): patcher->import_dbscript(‘mt.1.dids_tbl.s…’, ‘/usr/share/vita…’) #2 /usr/share/vitalpbx/scripts/apply_migrations(0): patcher->apply(‘migrations/mult…’) #3 {main}
thrown in /usr/share/vitalpbx/scripts/apply_migrations on line 0
Verifying : vitalpbx-multi-tenant-3.0.4-1.x86_64 1/1
I will assume you’re referring to the Databsase root user , right? if so, yes, i am. But i can also log as vitalpbx user.
If you’re referring to Linux SSH login, then yes, I’m logged as root…
and I can access DB command line without specifying a user (just plain-old mysql cmd) but have no access to any other database besides the information_schema
ok… I managed to remotely log into MariaDB as root and update the root@localhost password, and modified /etc/vitalpbx/database.conf with the new password.
After re-running the YUM command, update ran as expected.