I can´t see some calls in CDR.

Discussion in 'General' started by alro, Dec 18, 2008.

  1. alro

    Joined:
    Feb 5, 2008
    Messages:
    1
    Likes Received:
    0
    I´m using 2 users to access to my elastix, "admin" (total access) and "reports" (only can access to CDR).
    One day the user reports can´t get some records of specific extensions, but user admin can access to all the records.
    I tried with a new user and a new users group, but fails too. Only admin can access to the CDR correctly.
    ¿What can i do?
     
  2. MrEmbedded

    Joined:
    Jan 15, 2009
    Messages:
    4
    Likes Received:
    0
    I had the same problem. It seems to be because every user is forced to have an extension except for the original admin account, so the 'Reports' user that you created is only giving reports for the associated extension.

    What I did was this:

    1. root@host# sqlite3 /var/www/db/acl.db - This is where the user information is stored for elastix

    2. sqlite> select * from acl_user; - to locate the user you want to modify. You should see something like this:

    1|admin||7a5210c173ea40c32305a5de7dcd4cb0|
    2|user1|pass|ddc542386d2f85e1b1ff763aff13ce0a|1000
    3|user2|pass|98a8d3f11b400ddc06d7343235b71a84|2000
    4|user3|pass|680561bec052fdbd2e3f98957a32228b|3000

    where user1,2,3 are your user names and pass is their passwords. Note the 1000, 2000, 3000 at the end which is the extension number, but admin has none.

    3. sqlite> .schema acl_user - optional to make certain your columns are named the same as mine

    4. sqlite> update acl_user set extension='' where name='user1'; - Change user1 to the username you wish to remove the extension from, 'Reports' in your case

    5. sqlite> select * from acl_user; - This time your output will show this:

    1|admin||7a5210c173ea40c32305a5de7dcd4cb0|
    2|user1|pass|ddc542386d2f85e1b1ff763aff13ce0a|
    3|user2|pass|98a8d3f11b400ddc06d7343235b71a84|2000
    4|user3|pass|680561bec052fdbd2e3f98957a32228b|3000

    6. sqlite> .quit

    Thats it. Then when you go into the user setup in elastix, your user will no longer have an extension there and that user will see the system wide CDR reports.

    I did have an issue where I had to do a mysql repair the main CDR table after I did this mod as the data dissappeared, but that may have been an unrelated issue.

    On another note, the CDR report generator could use more conditions and columns in it for better report generation. I find overall elastix is very nice and I prefer it to all the other equivalents but if this report was improved it would be over the top for me and others as well.
     
  3. planetavirtual

    Joined:
    Jul 19, 2011
    Messages:
    54
    Likes Received:
    0
    Excelente aporte Mr. Embedded, gracias por ayudar. Quedó solucionado y fue muy fácil.
     
  4. mahfuj1093ete

    Joined:
    Jun 24, 2013
    Messages:
    11
    Likes Received:
    0
    You can give the permission to a particular user.
     

Share This Page