Post a Reply
3154 views

Asternic cdr standalone

  1. 7 years ago

    AlexRS

    5 Jan 2017
    Edited 7 years ago by AlexRS

    Hi! Im trying to setup asternic cdr on a standalone server. All works, but there zero calls in all columns. If cdr table is from transit server (for example, sip-operator < - > asterisk cdr (transit)< - > Freepbx) will it work?

    Please help me with this installation.

    Answered by admin

    See post in context

    software needs to know which devices are extensions.. for that it tries to read information from know backends, freepbx, thirdlane, or in case of vanilla/clear asterisk, filenames... You can edit the file functions-astdb.php to suit your needs. That function by default reads the sip.conf file, populates an array with channel, name and extension, and then use that to populate the acdrchannels mysql table. You can adapt that to your needs, but selecting from cdr will be expensive if you have tons of records, it is not really advisable unless you have a few cdrs only.

  2. admin

    6 Jan 2017 Administrator

    Enable debug in config.php and check logs. If the CDR table structure is correct, and you have a sip.conf file or some other file where you can extract devices for extensions, then it might work.

    Best regards,

  3. AlexRS

    6 Jan 2017
    Edited 7 years ago by AlexRS

    Yes, I already have. Its standalone, there is no asterisk and sip.conf. Its transit server - there hundreds extension pass thru it. Can I use asternic cdr in this case? I want to see all extensions exists in cdr table, but I havnt file with all of them

    Ps. Yes, cdr structure is correct. FOP2 uses it for call history.

  4. AlexRS

    6 Jan 2017
    Edited 7 years ago by AlexRS

    I can try to make file with all extension by "select"ing them from cdr table. Explain more aboute it, please. Path to file and structure of it.

  5. admin

    6 Jan 2017 Administrator Answer

    software needs to know which devices are extensions.. for that it tries to read information from know backends, freepbx, thirdlane, or in case of vanilla/clear asterisk, filenames... You can edit the file functions-astdb.php to suit your needs. That function by default reads the sip.conf file, populates an array with channel, name and extension, and then use that to populate the acdrchannels mysql table. You can adapt that to your needs, but selecting from cdr will be expensive if you have tons of records, it is not really advisable unless you have a few cdrs only.

  6. AlexRS

    6 Jan 2017

    Ok, I understood. Thanks!

  7. AlexRS

    6 Jan 2017
    Edited 7 years ago by AlexRS

    Could you show me sql dump example? I will try to fill the table by hand or script

  8. admin

    6 Jan 2017 Administrator

    +-------------+-----------+-----------+--------------------+ | channel | extension | groupname | name | +-------------+-----------+-----------+--------------------+ | -1 | | | ALL | | SIP/111 | 111 | | Nicolas Gudino |

  9. admin

    6 Jan 2017 Administrator

    that is the acdrchannels table

  10. AlexRS

    9 Jan 2017

    Could you help me to use buttons.conf from FOP2 instead sip.conf?

  11. admin

    10 Jan 2017 Administrator

    I cannot right now, I am currently abroad with lots of business meetings and I barely have time to answer email/posts. I am sure you will manage before I arrive back to normal work next week.

    Best regards,

  12. AlexRS

    10 Jan 2017

    Thanks! If I will not solve it, I will write you next week.

or Sign Up to reply!