Sonata Billing – Database error

VitalPBX Community Support General Discussion Sonata Billing – Database error

Up
0
Down
  • Post
    Gary
    Participant

    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/8
    Verifying : kexec-tools-2.0.15-13.el7_5.1.x86_64 2/8
    Verifying : sonata-switchboard-2.0.3-1.x86_64 3/8
    Verifying : sonata-billing-2.0.1-1.noarch 4/8
    Verifying : kexec-tools-2.0.15-13.el7.x86_64 5/8
    Verifying : sonata-switchboard-2.0.1-3.x86_64 6/8
    Verifying : sonata-billing-2.0.0-1.noarch 7/8
    Verifying : 2:microcode_ctl-2.1-29.10.el7_5.x86_64

     

    0
Viewing 8 replies - 1 through 8 (of 8 total)
  • Replies

    Update the PBX connection info, looks like the billing doesn’t have privileges to access to the CDR.

    0
    Gary
    Participant

    Still does not work after trying above.

    0

    Go to the Linux console and execute the following commands:

    cd /usr/share/sonata/billing/

    php scripts/apply_patches
    0
    Gary
    Participant

    Ran, php scripts/apply_patches but still getting error.

    0

    Sorry, but we cannot reproduce the issue 

    0
    Gary
    Participant

    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.

    0

    We sent you an email.

    0

    Solved internally.

    0
Viewing 8 replies - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.