Extension Display Issue

[pbx123]

We're using FusionPBX 4.5.9 (just upgraded to see if it fixed the issue but no change). Within the FusionPBX extensions menu, none of the extensions are showing up anymore in the list (never had an issue in the past). Shows the numeric count of extensions, clicked show all and that does just doubles the extension numeric count. We can export them and everything is there. When we go to extensions, no extensions appear in the list for all three tenants we are using. Restarted freeswitch, tried the upgrade process and verified the schema, permissions, etc. and no change. Is there anything we can do to get the extension list back. Screen-cap attached.

Thanks for any help. Greatly appreciated.

 

[ad5ou]

Sounds like a permission not enabled for your user.
Advanced>Group Manager> (permissions for your user group)
Search "Extensions"

 

[pbx123]

Thanks for the reply. I'm set as the superadmin and all the group permissions are checked. Tried resetting group permissions but still can't view extensions.

 

[pbx123]

I just added a another superuser to test and the users menu is doing the same thing. It added the user and I can login with all the permission, but when I go to the users menu, and click show all, it shows the count, but none of the users show up on the list. All other menus are working, just these two won't display anything.

 

[tdcockers]

@pbx123 did you ever resolve this issue? I'm having the same problem after an update. I'm currently on 4.5.9 and have taken the same steps as you, but I can't really say what commit may have been the issue because I had been very slow on updates previously, I think we jumped from 4.4.4 to 4.5.9.

 

[jondrover]

Having the exact same issue. Anyone have a solution?

 

[tdcockers]

Reboot server after upgrade sorted it for me

 

[Andrew Perry]

I had the same problem and when I followed the above suggestion and went to:

Advanced>Group Manager> (permissions for your user group)

There were no groups listed, so I went to:

Advanced>Upgrade

and tried to Execute "Permission Defaults" it still didn't help when I went back to:

Advanced>Group Manager

So I hit the button on that page for "Restore Default" and it said it completed the restore correctly, but still isn't showing anything on that page.

I don't know if this is because the username of the admin user was changed so as not to be so obvious for hackers, but you'd expect the upgrade / restore script wouldn't be dependent on the username.

 

[Andrew Perry]

The work around we are using is that if you go to the extensions list and click on a heading like "Effective CID Name" or "Call Group" but NOT "Extension", it will then display the list. Not ideal, but it at least enabled us to see the list!

Haven't come up with a way to view the groups in Group Manager though, to enable this to be resolved using the above instructions :-/

 

[Andrew Perry]

In postgres, there is a bunch of groups in the v_groups and v_user_groups tables and interestingly there are two lines in the v_user_groups table with the group_name "superadmin" linking our admin user to the two domains but the 'group_uuid' is the same for both lines - that seems wrong as I would expect that each domain has its own v_groups but I notice that the domain_uuid column in both the v_groups table and the v_group_permissions table is empty. Is that correct or should there be a domain_uuid and two sets of groups under v_groups and/or at least a domain_uuid in the v_group_permissions table?

 

[markjcrane]

The original question on this thread is likely solved by running Upgrade -> Schema. If the SQL query refers to a field that is not there then you get an error and no data is returned.

Groups are by default global. In the past we had per domain groups as the default and this was horrible to manage and so this was changed and they are now global by default

Make sure bugs are reported at https://www.fusionpbx.com sign up for an account and submit the bugs there. I fix most of the bugs... I might not notice bugs here I'm only occasionally looking here at this unofficial forum.