# Missing Table Ombu\_Tenant\_Dids after update to 3.1.3 R1 **URL:** \ **Category:** Reporting an Issue\ **Created:** [November 23, 2021, 12:08pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702 "2021-11-23T12:08:58Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![SCharrua](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/scharrua/32/356_2.png) [@SCharrua](https://forums.vitalpbx.org/u/SCharrua)\ **Post date:** [November 23, 2021, 12:08pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/1 "2021-11-23T12:08:58Z")
Hello, 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 Error Trace | # | File | Function | | --- | --- | --- | | 1 | /usr/share/vitalpbx/www/index.php:0 | app\Core-\>run(…args); | | 2 | /usr/share/vitalpbx/www/includes/app/Core.php:0 | app\Core-\>\_applyAsteriskConfigurations(…args); | | 3 | /usr/share/vitalpbx/www/includes/app/Core.php:0 | vitalpbx\OmbuSystemConf-\>applyConfigUI(…args); | | 4 | /usr/share/vitalpbx/www/includes/OmbuSystemConf.php:0 | vitalpbx\OmbuSystemConf-\>\_ApplyDialPlan(…args); | | 5 | /usr/share/vitalpbx/www/includes/OmbuSystemConf.php:0 | modules\inbound\_route\inbound\_route-\>getDialPlan(…args); | | 6 | /usr/share/vitalpbx/www/modules/inbound\_route/inbound\_route.php:0 | modules\inbound\_route\Asterisk\DialPlan-\>build(…args); | | 7 | /usr/share/vitalpbx/www/modules/inbound\_route/Asterisk/DialPlan.php:0 | modules\tenants\Asterisk\DialPlan-\>buildIncoming(…args); | | 8 | /usr/share/vitalpbx/www/modules/tenants/Asterisk/DialPlan.php:0 | modules\tenants\Asterisk\DialPlan-\>modules\tenants\Asterisk{closure}(…args); | | 9 | /usr/share/vitalpbx/www/modules/tenants/Asterisk/DialPlan.php:0 | vitalpbx\tenant-\>getInboundDIDs(…args); | | 10 | /usr/share/vitalpbx/www/includes/tenant.php:0 | modules\tenants\DIDNumber-\>getAllByTenant(…args); | | 11 | /usr/share/vitalpbx/www/modules/tenants/DIDNumber.php:0 | vitalpbx\db-\>query(…args); | | 12 | /usr/share/vitalpbx/www/includes/db.php:0 | vitalpbx\db-\>\_\_construct(…args); | Steps to reproduce: - add a new extension or edit an existing extension - save - press Reload button - 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. ---
**Author:** ![miguel](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/miguel/32/415_2.png) [@miguel](https://forums.vitalpbx.org/u/miguel)\ **Post date:** [November 23, 2021, 12:55pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/2 "2021-11-23T12:55:53Z")
Try the following. - Go to the Linux Console - Execute the command below. ```auto yum reinstall vitalpbx-multi-tenant -y ``` FYI, No data is lost during the reinstall of the add-ons or any other VitalPBX package. If you get any error during the reinstall, please, post it here. ---
**Author:** ![SCharrua](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/scharrua/32/356_2.png) [@SCharrua](https://forums.vitalpbx.org/u/SCharrua)\ **Post date:** [November 23, 2021, 1:18pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/3 "2021-11-23T13:18:19Z")
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 Installed: vitalpbx-multi-tenant.x86\_64 0:3.0.4-1 Complete! So, no issues with Yum. I then connected to the Mysql/MariaDB CLI and: > show tables; > | ombu\_storage\_notifications | > | ombu\_tenant\_settings | > | ombu\_tenant\_trunks | > | ombu\_tenants | > | ombu\_tenants\_users | > | ombu\_time\_conditions | so it is still missing… ---
**Author:** ![miguel](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/miguel/32/415_2.png) [@miguel](https://forums.vitalpbx.org/u/miguel)\ **Post date:** [November 23, 2021, 1:23pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/4 "2021-11-23T13:23:27Z")
> [@SCharrua](#): > > mt.1.dids\_tb Well, for some reason is not installing the mt.1.dids\_tbl.sql migration. Are you using a password for the root user? ---
**Author:** ![SCharrua](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/scharrua/32/356_2.png) [@SCharrua](https://forums.vitalpbx.org/u/SCharrua)\ **Post date:** [November 23, 2021, 2:42pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/5 "2021-11-23T14:42:44Z")
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… ---
**Author:** ![miguel](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/miguel/32/415_2.png) [@miguel](https://forums.vitalpbx.org/u/miguel)\ **Post date:** [November 23, 2021, 2:43pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/6 "2021-11-23T14:43:42Z")
I meant, did you assign a password for the root user of the MySQL(MariaDB) database? ---
**Author:** ![SCharrua](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/scharrua/32/356_2.png) [@SCharrua](https://forums.vitalpbx.org/u/SCharrua)\ **Post date:** [November 23, 2021, 2:46pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/7 "2021-11-23T14:46:23Z")
additionally, I have just re-run the YUM reinstall command, and there is the error (which I previously missed … sorry…) > Blockquote > Running transaction > Installing : vitalpbx-multi-tenant-3.0.4-1.x86\_64 1/1 > Table `ombutel`.`ombu_patches` does not exist, assuming new installation. > Importing mt.1.dids\_tbl.sql… > PHP Fatal error: Uncaught Exception: ERROR 1044 (42000) at line 2: Access denied for user ‘’@‘localhost’ to database ‘ombutel’ > in /usr/share/vitalpbx/scripts/apply\_migrations:0 > 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 > Installed: > vitalpbx-multi-tenant.x86\_64 0:3.0.4-1 the line > Blockquote > PHP Fatal error: Uncaught Exception: ERROR 1044 (42000) at line 2: Access denied for user ‘’@‘localhost’ to database ‘ombutel’ says it all… Shouldn’t the install use the access specified in the database configuration script in VitalPBX?? ---
**Author:** ![SCharrua](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/scharrua/32/356_2.png) [@SCharrua](https://forums.vitalpbx.org/u/SCharrua)\ **Post date:** [November 23, 2021, 2:47pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/8 "2021-11-23T14:47:33Z")
No, root has no password to access DB… 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 ---
**Author:** ![miguel](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/miguel/32/415_2.png) [@miguel](https://forums.vitalpbx.org/u/miguel)\ **Post date:** [November 23, 2021, 3:09pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/9 "2021-11-23T15:09:10Z")
Your system seems broken! Check the database configurations in the file below. ```auto /etc/vitalpbx/database.conf ``` ---
**Author:** ![SCharrua](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/scharrua/32/356_2.png) [@SCharrua](https://forums.vitalpbx.org/u/SCharrua)\ **Post date:** [November 23, 2021, 3:19pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/10 "2021-11-23T15:19:19Z")
Currently it is: [app] database=ombutel port=3306 host=localhost username=ombutel password= [main] host=localhost port=3306 username=root password= I’m almost sure it is setup like this since July 2021, when the license was installed… ---
**Author:** ![SCharrua](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/scharrua/32/356_2.png) [@SCharrua](https://forums.vitalpbx.org/u/SCharrua)\ **Post date:** [November 23, 2021, 3:28pm UTC](https://forums.vitalpbx.org/t/missing-table-ombu-tenant-dids-after-update-to-3-1-3-r1/702/11 "2021-11-23T15:28:29Z")
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. Connected to MariaDB CLI and: > show tables; > | ombu\_static\_leases | > | ombu\_storage\_notifications | > **| ombu\_tenant\_dids |** > | ombu\_tenant\_settings | > | ombu\_tenant\_trunks | > | ombu\_tenants | > | ombu\_tenants\_users | Ombu\_Tenant\_DIDs table is now present! Thanks for your help (and pacience 🙃 )