Skip to main content

Database error on web gui after update

Posted by steveipx on Mon, 09/29/2014

Hi I have ran an yum update on Centos server hosting Thirdlane.

When i try to access web gui now, i get an database error:

The Server returned the error status code = -1
tenantsError in 'execute' when selecting from database - Unknown column
'enduser_company_contacts' in 'field list' sql: SELECT
`id`,`tenant`,`primary_server`,`secondary_server`,`status`,`musiconhold`,`
vm_settings`,`call_forwarding`,`call_screening`,`call_blocking`,`allowrecor
ding`,`contacts`,`enduser_company_contacts`,`crm`,`vm`,`recording_listen`,`
set_musiconhold`,`call_history`,`send_faxes`,`set_officemode`,`preferences`
,`phone_password_length`,`web_password_length`,`mailbox_pin_length`,`defaul
t_web_password`,`default_mailbox_pin`,`maxcalls`,`contact_center`,`maxagent
s`,`url`,`conf_wait_marked`,`crm_cidstrip`,`conf_enable_moh`,`web_password_
option`,`mailbox_pin_option`,`lang`,`prompt_language`,`name`,`schedule`,`co
nf_other`,`conf_music`,`conf_record`,`uappend`,`mappend`,`crm_use_defaults`
,`crm_cidminlength`,`crm_url_format`,`users`,`use_custom_logo`,`panel`,`cre
ate_vm`,`conf_talker_optimization`,`conf_present_menu`,`create_conference`,
`script`,`conf_announce_count`,`conf_detect_talker`,`conf_announce_join`,`c
onf_maxusers`,`maxqueues`,`maxusers`,`maxmailboxes`,`maxphones`,`maxconfere
nces`,`maxdevices`,`model`,`allowaccountcode`,`accountcode`,`allowcallerid`
,`callerid`,`callerid_name`,`emergency_callerid`,`intalertinfo`,`tenantpref
ix`,`tag`,`officemode`,`codec`,`context`,`nat`,`canreinvite`,`call-limit`,`
callcounter`,`qualify`,`dtmfmode`,`forwardemail`,`attach`,`delete`,`usedist
inctring`,`other`,`fax_settings_station_id`,`fax_default_paper_size`,`fax_e
mail_address`,`fax_maximum_number_of_retries`,`fax_retry_time`,`fax_wait_ti
me`,`fax_notify_on_failure_and_success`,`entered_other`,`entered_other_vm`,
`RECORD`,`RECORD_INT_IN`,`RECORD_INT_OUT`,`RECORD_EXT_IN`,`RECORD_EXT_OUT`
FROM tenants ORDER BY tenant ASC

Can anyone advise.

This is in yum log

Sep 26 10:18:06 Updated: kernel-firmware-2.6.32-431.20.3.el6.noarch
Sep 26 10:18:13 Updated: thirdlane-system-updates-1.7-el6.x86_64
Sep 26 10:18:15 Updated: tzdata-2014e-1.el6.noarch
Sep 26 10:18:15 Updated: nss-softokn-freebl-3.14.3-10.el6_5.x86_64
Sep 26 10:18:24 Updated: glibc-2.12-1.132.el6_5.2.x86_64
Sep 26 10:18:33 Updated: glibc-common-2.12-1.132.el6_5.2.x86_64
Sep 26 10:18:33 Updated: audit-libs-2.2-4.el6_5.x86_64
Sep 26 10:18:34 Updated: libxml2-2.7.6-14.el6_5.2.x86_64
Sep 26 10:18:34 Updated: libtirpc-0.2.1-6.el6_5.2.x86_64
Sep 26 10:18:34 Updated: libuuid-2.17.2-12.14.el6_5.x86_64
Sep 26 10:18:34 Updated: libblkid-2.17.2-12.14.el6_5.x86_64
Sep 26 10:18:34 Updated: libcurl-7.19.7-37.el6_5.3.x86_64
Sep 26 10:18:34 Updated: libxml2-python-2.7.6-14.el6_5.2.x86_64
Sep 26 10:18:35 Updated: libtasn1-2.3-6.el6_5.x86_64
Sep 26 10:18:35 Updated: gnutls-2.8.5-14.el6_5.x86_64
Sep 26 10:18:35 Updated: corosynclib-1.4.1-17.el6_5.1.x86_64
Sep 26 10:18:35 Updated: corosync-1.4.1-17.el6_5.1.x86_64
Sep 26 10:18:35 Updated: avahi-libs-0.6.25-12.el6_5.1.x86_64
Sep 26 10:18:35 Updated: coreutils-libs-8.4-31.el6_5.2.x86_64
Sep 26 10:18:37 Updated: coreutils-8.4-31.el6_5.2.x86_64
Sep 26 10:18:43 Installed: kernel-2.6.32-431.20.3.el6.x86_64
Sep 26 10:18:44 Updated: dahdi-linux-source-2.9.1-1.x86_64
Sep 26 10:18:45 Updated: dahdi-linux-2.9.1-1.el6.x86_64
Sep 26 10:18:48 Updated:
dahdi-linux-modules-2.9.1-2.6.32.431.20.3.el6.1.x86_64
Sep 26 10:18:48 Updated: openssl-1.0.1e-16.el6_5.14.x86_64
Sep 26 10:19:39 Updated: webmin-1.690-1.noarch
Sep 26 10:19:39 Updated: util-linux-ng-2.17.2-12.14.el6_5.x86_64
Sep 26 10:19:40 Updated: kernel-headers-2.6.32-431.20.3.el6.x86_64
Sep 26 10:19:40 Updated: glibc-headers-2.12-1.132.el6_5.2.x86_64
Sep 26 10:19:41 Updated: tzdata-java-2014e-1.el6.noarch
Sep 26 10:19:48 Updated: 1:java-1.6.0-openjdk-1.6.0.0-5.1.13.3.el6_5.x86_64
Sep 26 10:19:50 Updated:
1:java-1.6.0-openjdk-devel-1.6.0.0-5.1.13.3.el6_5.x86_64
Sep 26 10:19:50 Updated: glibc-devel-2.12-1.132.el6_5.2.x86_64
Sep 26 10:19:51 Updated: 1:nfs-utils-1.2.3-39.el6_5.3.x86_64
Sep 26 10:20:07 Updated: pbxmw-mt-7.1.2.4-1.el6.noarch
Sep 26 10:20:08 Updated: openssl-devel-1.0.1e-16.el6_5.14.x86_64
Sep 26 10:20:09 Updated: dahdi-tools-2.9.1-1.el6.x86_64
Sep 26 10:20:09 Updated: 1:autofs-5.0.5-89.el6_5.2.x86_64
Sep 26 10:20:09 Updated: 2:irqbalance-1.0.4-9.el6_5.x86_64
Sep 26 10:20:09 Updated: audit-2.2-4.el6_5.x86_64
Sep 26 10:20:09 Updated: nscd-2.12-1.132.el6_5.2.x86_64
Sep 26 10:20:10 Updated: avahi-0.6.25-12.el6_5.1.x86_64
Sep 26 10:20:11 Updated: corosynclib-devel-1.4.1-17.el6_5.1.x86_64
Sep 26 10:20:11 Updated: gnutls-devel-2.8.5-14.el6_5.x86_64
Sep 26 10:20:12 Updated: sos-2.2-47.el6.centos.1.noarch
Sep 26 10:20:12 Updated: curl-7.19.7-37.el6_5.3.x86_64
Sep 26 10:20:13 Updated: libcurl-devel-7.19.7-37.el6_5.3.x86_64
Sep 26 10:20:13 Updated: libxml2-devel-2.7.6-14.el6_5.2.x86_64
Sep 26 10:20:14 Updated: perf-2.6.32-431.20.3.el6.x86_64
Sep 26 10:20:14 Updated: device-mapper-persistent-data-0.2.8-4.el6_5.x86_64
Sep 26 10:20:14 Updated: mod_wsgi-3.2-6.el6_5.x86_64
Sep 26 10:20:15 Updated: mod_perl-2.0.4-11.el6_5.x86_64
Sep 26 10:20:16 Updated: iproute-2.6.32-32.el6_5.x86_64
Sep 26 10:20:16 Updated: kpartx-0.4.9-72.el6_5.3.x86_64
Sep 26 10:20:16 Updated: pm-utils-1.2.5-10.el6_5.1.x86_64

Thank You

Steve


Submitted by eeman on Tue, 09/30/2014 Permalink

I dont see this package pbxmw-mt-7.2.1.1-2.el6.noarch in your update list, which I believe alters the database tables... try running yum update again and see if you grab the latest pbxmw package. It should take a good 5min in the timestamp to do the update.

Submitted by thirdlane on Sat, 10/18/2014 Permalink

Looks like the package is there, but something may have gone wrong. Please check if there are any errors in /etc/webmin/asterisk/install.log - it should list database updates and the final version.