CDR reports stop updating

› VitalPBX Community Support › General Discussion › CDR reports stop updating

  • Post
    • March 23, 2019 at 10:10 am
    Tassos
    Participant
    Up
    0
    Down

    A problem frequently occurs with CDR report stop showing updates.

    This mainly occurs when I reboot VitalPBX.

    I am currently running version 2.3.0.

    I used to fix this problem by going to Settings / PBX setting / Log Files and clicking on save.

    Now this does not work anymore.

    0
Viewing 9 replies - 1 through 9 (of 9 total)
  • Replies
    • March 23, 2019 at 12:25 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    This usually happens when Asterisk starts firsts than MySQL (MariaDB), if the CDR stop, you may execute the following command to restart:

    asterisk -rx"module reload cdr_adaptive_odbc.so"

    However, we are looking for a solution to fix this behavior.

    0
    • March 23, 2019 at 4:17 pm
    Tassos
    Participant
    Up
    0
    Down

    I ran the command but CDR is not registering new calls.

    I also ran the following to make sure CDR is running.

    vitalpbx*CLI> cdr show status

    Call Detail Record (CDR) settings
    ———————————-
    Logging: Enabled
    Mode: Simple
    Log unanswered calls: Yes
    Log congestion: Yes

    * Registered Backends
    ——————-
    Adaptive ODBC
    csv
    cdr-custom

     

    0
    • March 23, 2019 at 4:23 pm
    Tassos
    Participant
    Up
    0
    Down

    Actually, CDR is running ok because I see the logs in cdr-csv/master.csv and cdr-custom/VPBX.csv displaying the calls.

    The calls are not shown in the GUI interface Reports / Cdr

    0
    • March 23, 2019 at 4:23 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Try restarting asterisk:

    systemctl restart asterisk
    0
    • March 23, 2019 at 4:52 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    If the CDR is not saved in MySQL, then, the CDR will be not showing in the GUI.

    0
    • March 23, 2019 at 6:15 pm
    Tassos
    Participant
    Up
    0
    Down

    I checked MySQL. The records are there.

    I also saw that the field Tenant, for the records not showing, had a value “ombutel”.

    All other records, that were showing in GUI, had a value “vitalpbx”.

    I have not installed the addon Tenants.

    0
    • March 23, 2019 at 6:43 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    try yo execute the following command:

    vitalpbx --dump-conf

    We have tested several environments, but, this not happening.

    0
    • March 23, 2019 at 6:59 pm
    Tassos
    Participant
    Up
    0
    Down

    Do I have to send you a file created by this config dump?

    Where do I find such a file?

    0
    • March 23, 2019 at 7:16 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    That command is for regenerate the dialplan and other configurations. 

    You should make a core reload after execute the command.

    May you confirm if that fixes the issue. If not, please share a call log to analize it

    0
Viewing 9 replies - 1 through 9 (of 9 total)
  • The forum ‘General Discussion’ is closed to new topics and replies.