I can´t see some calls in CDR.

alro

Joined
Feb 5, 2008
Messages
1
Likes
0
Points
0
#1
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?
 

MrEmbedded

Joined
Jan 15, 2009
Messages
4
Likes
0
Points
0
#2
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.
 

planetavirtual

Joined
Jul 19, 2011
Messages
54
Likes
0
Points
0
#3
Excelente aporte Mr. Embedded, gracias por ayudar. Quedó solucionado y fue muy fácil.
 

mahfuj1093ete

Joined
Jun 24, 2013
Messages
11
Likes
0
Points
0
#4
You can give the permission to a particular user.
 

Members online

No members online now.

Forum statistics

Threads
30,952
Messages
130,980
Members
17,654
Latest member
janko67
Top