Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

FOP2 Community Forum

  1. Home
  2. Support
  3. Asternic cdr standalone

Asternic cdr standalone

Scheduled Pinned Locked Moved Support
12 Posts 2 Posters 298 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A
    A
    AlexRS
    wrote on last edited by
    #1

    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.

    1 Reply Last reply
    0
    • N
      N
      nicolas
      wrote on last edited by
      #2

      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,

      1 Reply Last reply
      0
      • A
        A
        AlexRS
        wrote on last edited by
        #3

        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.

        1 Reply Last reply
        0
        • A
          A
          AlexRS
          wrote on last edited by
          #4

          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.

          1 Reply Last reply
          0
          • N
            N
            nicolas
            wrote on last edited by
            #5

            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.

            1 Reply Last reply
            0
            • A
              A
              AlexRS
              wrote on last edited by
              #6

              Ok, I understood. Thanks!

              1 Reply Last reply
              0
              • A
                A
                AlexRS
                wrote on last edited by
                #7

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

                1 Reply Last reply
                0
                • N
                  N
                  nicolas
                  wrote on last edited by
                  #8

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

                  1 Reply Last reply
                  0
                  • N
                    N
                    nicolas
                    wrote on last edited by
                    #9

                    that is the acdrchannels table

                    1 Reply Last reply
                    0
                    • A
                      A
                      AlexRS
                      wrote on last edited by
                      #10

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

                      1 Reply Last reply
                      0
                      • N
                        N
                        nicolas
                        wrote on last edited by
                        #11

                        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,

                        1 Reply Last reply
                        0
                        • A
                          A
                          AlexRS
                          wrote on last edited by
                          #12

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

                          1 Reply Last reply
                          0

                          Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                          Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                          With your input, this post could be even better 💗

                          Register Login
                          Reply
                          • Reply as topic
                          Log in to reply
                          • Oldest to Newest
                          • Newest to Oldest
                          • Most Votes


                          • Login

                          • Don't have an account? Register

                          • Login or register to search.
                          Powered by NodeBB Contributors
                          • First post
                            Last post
                          0
                          • Categories
                          • Recent
                          • Tags
                          • Popular
                          • World
                          • Users
                          • Groups