Sonata Billing – Database error

› VitalPBX Community Support › General Discussion › Sonata Billing – Database error

  • Post
    • September 19, 2018 at 2:31 pm
    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
    • September 19, 2018 at 4:26 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

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

    0
    • September 20, 2018 at 8:15 pm
    Gary
    Participant
    Up
    0
    Down

    Still does not work after trying above.

    0
    • September 21, 2018 at 1:31 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Go to the Linux console and execute the following commands:

    cd /usr/share/sonata/billing/

    php scripts/apply_patches
    0
    • September 30, 2018 at 6:04 pm
    Gary
    Participant
    Up
    0
    Down

    Ran, php scripts/apply_patches but still getting error.

    0
    • October 1, 2018 at 12:57 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Sorry, but we cannot reproduce the issue 

    0
    • October 1, 2018 at 8:47 pm
    Gary
    Participant
    Up
    0
    Down

    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
    • October 2, 2018 at 1:25 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    We sent you an email.

    0
    • October 2, 2018 at 2:51 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Solved internally.

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