User Manager module clearing all linked extensions

We have any sangoma folks that can weigh in?

Three have already weighed in. What else would you like?

Seems a little more substantiated now with more specifics on this bug. Donā€™t understand the need for the rude response from a Sangoma employee.

3 people form Sangoma have replied here and none of us can replicate this. We need steps to reproduce this on a fresh install as we can not replicate it at all.

My response was not rude. It was genuine. Weā€™ve been unable to replicate the issue in any way. So the genuine question is what else would you like?

If anyone is interested here is the output of
fwconsole ma list

No repos specified, using: [commercial,standard,extended] from last GUI settings

+----------------------+--------------+-------------------------------------+------------+
| Module               | Version      | Status                              | License    |
+----------------------+--------------+-------------------------------------+------------+
| accountcodepreserve  | 13.0.2       | Enabled                             | GPLv2      |
| announcement         | 13.0.6       | Enabled                             | GPLv3+     |
| areminder            | 13.0.9       | Enabled                             | Commercial |
| arimanager           | 12.0.4       | Disabled; Pending upgrade to 13.0.4 | GPLv3+     |
| asterisk-cli         | 13.0.4       | Enabled                             | GPLv3+     |
| asteriskinfo         | 13.0.7       | Enabled                             | GPLv3+     |
| backup               | 13.0.25      | Enabled                             | GPLv3+     |
| blacklist            | 13.0.14      | Enabled                             | GPLv3+     |
| bria                 | 13.0.20      | Enabled                             | Commercial |
| broadcast            | 13.0.11      | Enabled                             | Commercial |
| builtin              |              | Enabled                             |            |
| bulkdids             | 2.11.1.4     | Enabled                             | GPLv3+     |
| bulkextensions       | 2.11.0.7     | Enabled                             | GPLv3+     |
| callback             | 13.0.5       | Enabled                             | GPLv3+     |
| callerid             | 13.0.6       | Enabled                             | Commercial |
| callforward          | 13.0.4       | Enabled                             | AGPLv3+    |
| calllimit            | 13.0.3       | Enabled                             | Commercial |
| callrecording        | 13.0.11      | Enabled                             | AGPLv3+    |
| callwaiting          | 13.0.4       | Enabled                             | GPLv3+     |
| campon               | 13.0.3       | Enabled                             | GPLv3+     |
| cdr                  | 13.0.29.8    | Enabled                             | GPLv3+     |
| cel                  | 13.0.25      | Enabled                             | GPLv3+     |
| certman              | 13.0.34      | Enabled                             | AGPLv3+    |
| cidlookup            | 13.0.11      | Enabled                             | GPLv3+     |
| conferences          | 13.0.22      | Enabled                             | GPLv3+     |
| conferencespro       | 13.0.25      | Enabled                             | Commercial |
| contactmanager       | 13.0.33      | Enabled                             | GPLv3+     |
| core                 | 13.0.113     | Enabled                             | GPLv3+     |
| cos                  | 13.0.9       | Enabled                             | Commercial |
| customappsreg        | 13.0.5       | Enabled                             | GPLv3+     |
| cxpanel              | 4.1.18       | Enabled                             | GPLv3      |
| dahdiconfig          | 13.0.33      | Enabled                             | GPLv3+     |
| dashboard            | 13.0.24      | Enabled                             | AGPLv3+    |
| daynight             | 13.0.13      | Enabled                             | GPLv3+     |
| dictate              | 13.0.5       | Enabled                             | GPLv3+     |
| digium_phones        | 13.0.3       | Enabled                             | GPLv2      |
| digiumaddoninstaller | 2.11.0.12    | Enabled                             | GPLv2      |
| directory            | 13.0.16      | Enabled                             | GPLv3+     |
| disa                 | 13.0.6       | Enabled                             | AGPLv3+    |
| donotdisturb         | 13.0.3       | Enabled                             | GPLv3+     |
| endpoint             | 13.0.84.3    | Enabled                             | Commercial |
| extensionroutes      | 13.0.9.2     | Enabled                             | Commercial |
| fax                  | 13.0.38      | Enabled                             | GPLv3+     |
| faxpro               | 13.0.34      | Enabled                             | Commercial |
| featurecodeadmin     | 13.0.6       | Enabled                             | GPLv3+     |
| findmefollow         | 13.0.37      | Enabled                             | GPLv3+     |
| framework            | 13.0.188.8   | Enabled                             | GPLv2+     |
| freepbx_ha           | 13.0.9.2     | Enabled                             | Commercial |
| fw_ari               | 12.0.7       | Enabled                             | GPLv3+     |
| fw_langpacks         | 12.0.7       | Enabled                             | GPLv3+     |
| hotelwakeup          | 13.0.16      | Enabled                             | GPLv2      |
| iaxsettings          | 13.0.5       | Enabled                             | AGPLv3     |
| infoservices         | 13.0.1       | Enabled                             | GPLv2+     |
| irc                  | 2.11.0.7     | Enabled                             | GPLv3+     |
| ivr                  | 13.0.25      | Enabled                             | GPLv3+     |
| javassh              | 2.11.2       | Enabled                             | AGPLv3+    |
| languages            | 13.0.6       | Enabled                             | GPLv3+     |
| logfiles             | 13.0.10      | Enabled                             | GPLv3+     |
| manager              | 13.0.2.5     | Enabled                             | GPLv2+     |
| miscapps             | 13.0.2.4     | Enabled                             | GPLv3+     |
| miscdests            | 13.0.4       | Enabled                             | GPLv3+     |
| music                | 13.0.22      | Enabled                             | GPLv3+     |
| outroutemsg          | 13.0.2       | Enabled                             | GPLv3+     |
| paging               | 13.0.24      | Enabled                             | GPLv3+     |
| pagingpro            | 13.0.17      | Enabled                             | Commercial |
| parking              | 13.0.18.1    | Enabled                             | GPLv3+     |
| parkpro              | 13.0.29.6    | Enabled                             | Commercial |
| pbdirectory          | 2.11.0.5     | Enabled                             | GPLv3+     |
| phonebook            | 13.0.5.5     | Enabled                             | GPLv3+     |
| phpinfo              | 13.0.2       | Enabled                             | GPLv2+     |
| pinsets              | 13.0.8       | Enabled                             | GPLv3+     |
| pinsetspro           | 13.0.8       | Enabled                             | Commercial |
| presencestate        | 13.0.7       | Enabled                             | GPLv3+     |
| printextensions      | 13.0.3       | Enabled                             | GPLv3+     |
| queueprio            | 13.0.2       | Enabled                             | GPLv3+     |
| queues               | 13.0.30      | Enabled                             | GPLv2+     |
| qxact_reports        | 13.0.14      | Enabled                             | Commercial |
| recording_report     | 12.0.6       | Disabled                            | Commercial |
| recordings           | 13.0.28      | Enabled                             | GPLv3+     |
| restapi              | 13.0.19      | Enabled                             | AGPLv3     |
| restapps             | 13.0.76      | Enabled                             | Commercial |
| restart              | 13.0.6       | Disabled                            | GPLv3+     |
| ringgroups           | 13.0.21      | Enabled                             | GPLv3+     |
| setcid               | 13.0.5       | Enabled                             | GPLv3+     |
| sipsettings          | 13.0.23.12   | Enabled                             | AGPLv3+    |
| sipstation           | 13.0.13.13   | Enabled                             | Commercial |
| sms                  | 13.0.9       | Enabled                             | Commercial |
| sng_mcu              | 13.0.5       | Enabled                             | Commercial |
| soundlang            | 13.0.17      | Enabled                             | GPLv3+     |
| speeddial            | 2.11.0.4     | Enabled                             | GPLv3+     |
| superfecta           | 13.0.3.19    | Enabled                             | GPLv2+     |
| sysadmin             | 13.0.67      | Enabled                             | Commercial |
| timeconditions       | 13.0.32      | Enabled                             | GPLv3+     |
| tts                  | 13.0.8       | Enabled                             | GPLv3+     |
| ttsengines           | 13.0.6       | Enabled                             | AGPLv3     |
| ucp                  | 13.0.41.2    | Enabled                             | AGPLv3+    |
| ucpnode              | 13.0.31      | Enabled                             | Commercial |
| userman              | 13.0.73.3    | Enabled                             | AGPLv3+    |
| vmblast              | 13.0.8       | Enabled                             | GPLv3+     |
| vmnotify             | 13.0.17      | Enabled                             | Commercial |
| voicemail            | 13.0.53      | Enabled                             | GPLv3+     |
| voicemail_report     | 13.0.12      | Enabled                             | Commercial |
| vqplus               | 13.0.24      | Enabled                             | Commercial |
| weakpasswords        | 13.0.1alpha1 | Enabled                             | GPLv3+     |
| webcallback          | 13.0.10      | Enabled                             | Commercial |
| webrtc               | 13.0.28      | Enabled                             | GPLv3+     |
| xmpp                 | 13.0.14      | Enabled                             | AGPLv3     |
+----------------------+--------------+-------------------------------------+------------+

I too am experiencing the same issue, at first i thought I might be losing my mind?!? A system I helped a guy out with remotely, had to jump through LOTS of hoops to get VPN working due to this issue. Again this was a system that was upgraded from 6.12-65 to 10.13.66-2.

This many of us canā€™t be making this up! LOL

If it would help, Tony, or Andrew, I could get the clientā€™s permission and perhaps we could get a teamviewer session going so you could take a peek under the hood and see if it helps find the solution to this rather annoying issue. Let me know.

Shoot me an email or PM and Iā€™ll get yā€™all my phone numberā€¦

-Andy

Just checked with the client, and he did in fact give permissionā€¦ so if Sangoma wants a peek at a system where this is actually reproducible, get in touch with me guys :slight_smile:

-Andy

For legal reasons we canā€™t just look at users systems that are not on a support contact where ToS and contacts lay out liability. Yes this sucks and we get it but people are way to sue happy and being a publicly traded comoany puts a bullseye on our backs.

Nobody is doubting this but we canā€™t replicate it anywhere and so far 5 people out of 25k plus systems in the latest version have reported this. Sounds like something to do with them starting as older FreePBX 12 systems. @lgaetz can you try and replicate on a upgraded system from 12 to 13.

Pretty much leaves me with no recourse but to pull a backup of the box, and have the guy completely reinstall from scratch, upload the backup, and pray the issue doesnā€™t follow the backupā€¦ā€¦ this blows, big time! LOL

To make matters worse, heā€™s about 4 states awayā€¦.doh!! :stuck_out_tongue_winking_eye:

-Andy

People who have this issue, what is the result of:

cat /etc/schmooze/pbx-version

Well let us test the theory on a upgrade from 12 to 13. It has to be something special we are not doing that is causing this. Are you extension module or device and user mode.

You would probably have suggested it if it was doable but just in case, I better askā€¦

Is there a way to have the modules log the SQL they submit (with or without bind variables) and the number of rows processed?

That should give a clue as to what is happeningā€¦

Have a nice day!

Nick

edit: looks like this could be doable at the MySQL levelā€¦

default setup, small system only 5 extensions, extensions modeā€¦ the system is up and operational at the moment so iā€™m not going to nuke it right now, itā€™s just making provisioning VPN for 2 remote phones a real hassleā€¦ have to go into UCP and link the user to the extension, which of course blows all the rest of the links away, then go to EPM and provision the phone so the config gets created, then back to UCP for the other one, etcā€¦ so found a not exactly ideal work around in the meantimeā€¦

and pbx version is 10.13.66-2 i believeā€¦ i can run it all the way up to -16 after hours if need be.

-Andy

our system has been upgraded many times over the years. we have no problems with user management. i would upgrade all the way to .16 and try it again

@bksales are you seeing this issue. We just can not replicate it for our life and I know you have lots of systems over the years and have updated them.

# cat /etc/schmooze/pbx-version
6.12.65-30
1 Like

Ok well then you are on a 12 Distro. I thought you said you upgraded your distro to 10.13.66

We are finally able to replicate this after it became clear only happened on some customer who upgraded the GUI to 13 not using our Distro scripts so your systems are in a weird state of migration when we added ability to use active directory for user man and not something on new installs. Fix is going in now for it.

We always recommend and state to use our upgrade scripts and not just upgrade models only when using the FreePBX Distro.

Dev ticket is here:

http://issues.freepbx.org/browse/FREEPBX-13386

Fix is published in User Manager 13.0.74.1 which is currently in edge, you can upgrade with:

fwconsole ma --edge upgrade userman