search

tomolimo / processmaker

GLPI plugin that provides an interface with ProcessMaker (http://www.processmaker.com/)
30 stars 11 forks source link

Groups are imported in ProcessMaker but not the users #120

Closed khalidochi closed 3 years ago

khalidochi commented 3 years ago

Hey, I have GLPI 9.5.5 installed on a ubuntu 20 LTS. I managed to install and configure processmaker-server-3.3.0-RE-1.7 and Processmaker plugin 4.0.2 based on wiki and tutorials. The issue is: image The groups are displayed at PM server screen but do not contain any users. pmusers automatic action executes partialy mentionning PM password's length error: image Here is my configuration: image

image

Thank you, Merci beaucoup

tomolimo commented 3 years ago

Hello @khalidochi There is a new version 4.0.3 that fixes this issue :) Thank you Regards, Tomolimo

khalidochi commented 3 years ago

Sorry sir, The new version fails with stdClass Object ( ) issue. image

tomolimo commented 3 years ago

Hello @khalidochi That's probably because you have a user named admin in GLPI... And then you have corrupted the admin in PM DB... That's the reason why I proposed to name the PM admin as pm_admin, to be sure that it will not be corrupted with GLPI admin user. What I propose is to:

  1. stop pm_users automatic actions
  2. go to PM tables 'rbac_users' and 'users',
  3. Change password of the admin user (in both tables), using the following queries: 
    
REPLACE INTO `rbac_users` (`USR_UID`, `USR_USERNAME`, `USR_PASSWORD`, `USR_FIRSTNAME`, `USR_LASTNAME`, `USR_EMAIL`, `USR_DUE_DATE`, `USR_CREATE_DATE`, `USR_UPDATE_DATE`, `USR_STATUS`, `USR_AUTH_TYPE`, `UID_AUTH_SOURCE`, `USR_AUTH_USER_DN`, `USR_AUTH_SUPERVISOR_DN`) VALUES ('00000000000000000000000000000001', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Admin', 'Account', 'admin@processmaker.com', '2035-12-31', '2007-08-03 12:24:36', '2018-07-19 13:49:32', 1, 'MYSQL', '00000000000000000000000000000000', '', '');
REPLACE INTO `users` (`USR_UID`, `USR_USERNAME`, `USR_PASSWORD`, `USR_FIRSTNAME`, `USR_LASTNAME`, `USR_EMAIL`, `USR_DUE_DATE`, `USR_CREATE_DATE`, `USR_UPDATE_DATE`, `USR_STATUS`, `USR_COUNTRY`, `USR_CITY`, `USR_LOCATION`, `USR_ADDRESS`, `USR_PHONE`, `USR_FAX`, `USR_CELLULAR`, `USR_ZIP_CODE`, `DEP_UID`, `USR_POSITION`, `USR_RESUME`, `USR_BIRTHDAY`, `USR_ROLE`, `USR_REPORTS_TO`, `USR_REPLACED_BY`, `USR_UX`, `USR_COST_BY_HOUR`, `USR_UNIT_COST`, `USR_PMDRIVE_FOLDER_UID`, `USR_BOOKMARK_START_CASES`, `USR_TIME_ZONE`, `USR_DEFAULT_LANG`, `USR_LAST_LOGIN`) VALUES ('00000000000000000000000000000001', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Admin', 'Account', 'admin@processmaker.com', '2035-12-31', '1999-11-30 00:00:00', '2018-07-19 13:49:32', 'ACTIVE', 'US', 'FL', 'MMK', '', '', '1-305-402-0282', '1-305-675-1400', '', '', 'Administrator', '', '1999-02-25', 'PROCESSMAKER_ADMIN', '', '', 'NORMAL', 0.00, '', '', NULL, 'Europe/Paris', '', '2020-11-17 14:28:05');

4. go to PM with user/password admin/admin: and then add a new pm_admin user (like proposed in the wiki)
5. change the plugin settings to reflect the new user
6. restart the pm_users automatic action.

thank you
regards,
Tomolimo
khalidochi commented 3 years ago

Thank you SIR. I'll test and give my feed-back ASAP.

khalidochi commented 3 years ago

IT WORKS NOW. Merci beaucoup

tomolimo commented 3 years ago

Hello @khalidochi You're welcome Regards, Tomolimo