Where is the Call Center Database/Tables?

Discussion in 'General' started by vloose, Mar 18, 2009.

  1. vloose

    Joined:
    Dec 2, 2008
    Messages:
    64
    Likes Received:
    0
    I am trying to find the tables that Call Center uses to build its reports. I did some hacking to make agent login/logout simple from the phone *7### for log in *8### for logout. It appears reports don't work now so I wanted to see if the data was even getting into the database.

    I do have elastixdialer running and I verified username and password.

    Thanks for any help.

    Vaughn
     
  2. ramoncio

    Joined:
    May 12, 2010
    Messages:
    1,663
    Likes Received:
    0
    I don't use Call Center, but all Elastix databases are in /var/www/db and they are in sqlite3 format.
     
  3. vloose

    Joined:
    Dec 2, 2008
    Messages:
    64
    Likes Received:
    0
    Thank you for your post. I don't see it there, but that simple post answered a ton of questions I had about Elastix and where things are at. I think you pointed me in the right direction for finding what I am looking for as well.

    --Vaughn
     
  4. vloose

    Joined:
    Dec 2, 2008
    Messages:
    64
    Likes Received:
    0
    Easy solution. Add your queues incoming calls tab in Call Center. I feel sill posting this but it might save someone else some time. :blush:
     
  5. hzavala

    Joined:
    Mar 31, 2009
    Messages:
    8
    Likes Received:
    0
    Did you try asteriskcdrdb / cdr?
     
  6. vloose

    Joined:
    Dec 2, 2008
    Messages:
    64
    Likes Received:
    0
    Yep, found it and forgot to post.

    Thanks
     
  7. amosquera

    Joined:
    Mar 3, 2009
    Messages:
    6
    Likes Received:
    0
    all call center tables are in:
    ./var/lib/mysql/call_center
    and they are in .frm (mysql) format.
     

Share This Page