07-23-2013 12:18 AM - edited 03-16-2019 06:29 PM
Hi,
how can I set / update a new PIN via SQL for a enduser which is used for extension mobility?
I tried this command:
update credential set credentials='new pin' where fkenduser='pkid from enduser' and tkcredential='4'
and get this reply: No UPDATE permission for credential.
Our CUCM is LDAP integrated but enduser pin is editable via CUCM webpage.
How can I update this enduser pin via SQL?
BR
Michae
07-26-2013 04:29 AM
I do not think thats possible unless you have root access to the CUCM.
Reason: here is an ouput from CUCM DB; copy paste the below on a notepad your will understand much better..
admin:run sql select * from enduser where userid = "test"
pkid assocpc firstname middlename lastname userid manager department telephonenumber tkuserlocale mailid status facsimiletelephonenumber mobile pager homephone title building site fkdirectorypluginconfig uniqueidentifier nickname deletedtimestamp passwordreverse fkmatrix_presence tkuserprofile fkcallingsearchspace_restrict allowcticontrolflag enablemobilevoice maxdeskpickupwaittime enablemobility remotedestinationlimit ocsprimaryuseraddress enableemcc fkucserviceprofile directoryuri islocaluser fkfeaturegrouptemplate
==================================== ======= ========= ========== ======== ====== ======= ========== =============== ============ ====== ====== ======================== ====== ===== ========= ===== ======== ==== ======================= ================ ======== ================ =============== ==================================== ============= ============================= =================== ================= ===================== ============== ====================== ===================== ========== ================== ============ =========== ======================
5f7d238c-17cf-345f-fdab-f6b96532242e test test NULL 1 NULL NULL ad243d17-98b4-4118-8feb-5ff2e1b781ac 1 NULL t f 10000 f 4 f NULL t NULL
admin:
Here we do not find a column which has the field PIN.
So inconclution.. you cannot change something that does not exists..
Unless someone can correct me..
09-16-2013 05:40 AM
You not will find a field PIN in the enduser table because the password / pin is stored in the table "credential".
But when I try to update via SQL update command the "tkcredential" 4 which is the CREDENTIAL_PIN I get back the error message "No UPDATE permission for credential."
As you can see here what tkcredential means:
enum name moniker
==== ======== ===================
3 Password CREDENTIAL_PASSWORD
4 PIN CREDENTIAL_PIN
So does anybody knows how to update the field "credentials" in the table "credential"?
BR
Michael
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide