If the customer reports that the extension is unable to log in to gloCOM/Communicator and is receiving the following error:
In order to resolve the issue, SSH into PBXware and check in MySQL whether this extension has a userid field in the users table.
For example:
use pbxware select * from users where ext=227 and name='userid';
and if the result is empty set, find userid value in admin_site database, for example:
select id, ext, userid from admin_site.pbxware where ref in ('sip:ext') and ext=227;You will get useid value here, like this:
mysql> select id, ext, userid from admin_site.pbxware where ref in ('sip:ext') and ext=227;
+-------+------+--------------------------------------+
| id | ext | userid |
+-------+------+--------------------------------------+
| 45717 | 227 | d208332d-29d6-4267-acef-2845378dce3e |
+-------+------+--------------------------------------+
Next, add the userid into users table:
INSERT INTO users (ext, name, value)
VALUES ('227', 'userid', 'd208332d-29d6-4267-acef-2845378dce3e');and check whether it is populated correctly.
mysql> select * from users where ext=227 and name='userid';
+------+--------+--------------------------------------+
| ext | name | value |
+------+--------+--------------------------------------+
| 227 | userid | d208332d-29d6-4267-acef-2845378dce3e |
+------+--------+--------------------------------------+
1 row in set, 4 warnings (0.01 sec)
The user should be able to login without issues.