› VitalPBX Community Support › General Discussion › Sonata Billing – Database error
After I ran yum update the Billing module gives a error in the database.
VitalPBX 2.0.5-5 Asterisk 13.21.0-1 DAHDI 2.11.1-6
Verifying : 2:microcode_ctl-2.1-29.16.el7_5.x86_64 1/8Verifying : kexec-tools-2.0.15-13.el7_5.1.x86_64 2/8Verifying : sonata-switchboard-2.0.3-1.x86_64 3/8Verifying : sonata-billing-2.0.1-1.noarch 4/8Verifying : kexec-tools-2.0.15-13.el7.x86_64 5/8Verifying : sonata-switchboard-2.0.1-3.x86_64 6/8Verifying : sonata-billing-2.0.0-1.noarch 7/8Verifying : 2:microcode_ctl-2.1-29.10.el7_5.x86_64
Update the PBX connection info, looks like the billing doesn’t have privileges to access to the CDR.
Still does not work after trying above.
Go to the Linux console and execute the following commands:
cd /usr/share/sonata/billing/php scripts/apply_patches
Ran, php scripts/apply_patches but still getting error.
Sorry, but we cannot reproduce the issue
Part of the error says “denied to user ‘sonata_billing’@’localhost’ for table ‘cdr'” I can not connect that way, the VitalPBX server is a hosted platform and I have to connect with domain name which has always worked. could that be the issue.
We sent you an email.