Task still not synchronise

[manoel-cristiano]

Hi Tomolimo, how have you been?

Unfortunately I still have the same problem that I reported days ago in the issue #36

I followed what you told me before, but when I try to synchronise nothing happen.

GLPI version. 9.1.6 Processmaker version. 3.0.1.8-community

[tomolimo]

Hello I'm not in front of my computer, but I can try to help you. When you did the PM server installation, did the install procedure asked you about one or three databases? Regards Tomolimo

[manoel-cristiano]

It just created one database.

[tomolimo]

Could you give me a screen shot of the wf_workflow database? If possible with php_mysql? I would like to have the table list. Thank you

[tomolimo]

Oups, sorry I was speaking about phpmyadmin or any application that can give a list of tables, like following:

TABLE_NAMES

Tables_in_wf_workflow
abe_configuration
abe_requests
abe_responses
additional_tables
addons_manager
addons_store
app_assign_self_service_value
app_cache_view
app_delay
app_delegation
app_document
app_event
app_folder
app_history
app_message
app_notes
app_owner
app_sequence
app_solr_queue
app_thread
app_timeout_action_executed
application
backup_dynaform
bpmn_activity
bpmn_artifact
bpmn_bound
bpmn_data
bpmn_diagram
bpmn_documentation
bpmn_event
bpmn_extension
bpmn_flow
bpmn_gateway
bpmn_lane
bpmn_laneset
bpmn_participant
bpmn_process
bpmn_project
calendar_assignments
calendar_business_hours
calendar_definition
calendar_holidays
case_consolidated
case_scheduler
case_tracker
case_tracker_object
catalog
configuration
content
dashboard
dashboard_das_ind
dashboard_indicator
dashlet
dashlet_instance
db_source
department
dim_time_complete
dim_time_delegate
dynaform
element_task_relation
email_event
email_server
event
field_condition
fields
gateway
gmail_relabeling
group_user
groupwf
holiday
input_document
iso_country
iso_location
iso_subdivision
language
lexico
license_manager
list_canceled
list_completed
list_inbox
list_my_inbox
list_participated_history
list_participated_last
list_paused
list_unassigned
list_unassigned_group
log_cases_scheduler
login_log
message_application
message_event_definition
message_event_relation
message_type
message_type_variable
notification_device
oauth_access_tokens
oauth_authorization_codes
oauth_clients
oauth_refresh_tokens
oauth_scopes
object_permission
output_document
pmoauth_user_access_tokens
pro_reporting
process
process_category
process_files
process_owner
process_user
process_variables
rbac_authentication_source
rbac_permissions
rbac_roles
rbac_roles_permissions
rbac_systems
rbac_users
rbac_users_roles
report_table
report_var
route
script_task
sequences
session
session_storage
shadow_table
stage
step
step_supervisor
step_trigger
sub_application
sub_process
swimlanes_elements
task
task_user
timer_event
translation
triggers
users
users_properties
usr_reporting
web_entry
web_entry_event

[manoel-cristiano]

Follow the screen shots.

[tomolimo]

Thank you, I think I understand the trouble. I'll give you a fix ASAP. Regards, Tomolimo

[tomolimo]

Could you remind me the processmaker plugin version?

[manoel-cristiano]

The plugin version is 3.1.6.

[tomolimo]

And you still have the same error in the logs?

[manoel-cristiano]

There is no more error in the glpi log. But anyway I still can not sync the tasks.

[tomolimo]

ok, then, this is not what I though. could you screen copy the config of the plugin in GLPI? (like here: https://github.com/tomolimo/processmaker/wiki/Plugin-configuration) thank you

[manoel-cristiano]

Follow my config.

[tomolimo]

What are the rights of your 'handson' user in mySQL?

[manoel-cristiano]

The user handson has full rights on mysql. Sorry for the delay to answer.

[tomolimo]

Hello, Happy new year,

Could you try with latest version of the plugin?

Thank you regards, Tomolimo

[sosfc]

Hi Tomolimo I have the same problem with last version of plugin (3.2.1) GLPI 9.1.2 (upgraded to 9.1.6 with same result) PHP 5.6.33 Processmaker version. 3.0.1.8-community

I followed your tuto1 and it works fine (I can see the process, the users are synchronized and so are the groups) When I click on "Synchronize tasks list", I have a blank page

No tasks are synchronized from the automated task "pmtaskactions"

Thanks for your help Regards, Fernand

[tomolimo]

Hello You may have a trouble with the Intl PHP module which can be missing. Could you check that you have this module? And that it is activated? You may do this command: "php -m" which gives the module list. Thank you regards, Tomolimo

[sosfc]

Hello, There is the result of php -m

[PHP Modules] apc apcu bcmath bz2 calendar Core ctype curl date dba dom ereg exif fileinfo filter ftp gd gettext hash iconv imagick imap intl json ldap libxml mbstring mcrypt mhash mysql mysqli openssl pcntl pcre PDO pdo_mysql pdo_pgsql pdo_sqlite pgsql Phar posix readline Reflection session shmop SimpleXML snmp soap sockets SPL sqlite3 standard sysvmsg sysvsem sysvshm tokenizer wddx xml xmlreader xmlwriter Zend OPcache zip zlib

[Zend Modules] Zend OPcache The international module seems to be activated Thanks

[tomolimo]

Hello @sosfc and @manoel-cristiano, Could you also check that GLPI server "knows" the IP address of the PM server? To check this you must try to ping PM server from the GLPI server within a terminal session open on the GLPI server. If not, you must add the IP address of ProcessMaker server in the "hosts" file of the GLPI server. Usually the hosts file is there on Linux systems: /etc/, and in C:\Windows\System32\drivers\etc\ on windows systems. Thank you, Tomolimo

[sosfc]

Hello Tomilimo The ping works for me Thanks

[tomolimo]

Hello @manoel-cristiano, @sosfc Could you test with the latest release of the server 3.0.1.8-RE-1.8 and of the plugin 3.2.3? Thank you Regards, Tomolimo

[sosfc]

Hello, I have tried new plugin I don't have any blank page, but no tasks are synchronized which log may I send you to help you ? Thanks Fernand

[tomolimo]

Hello, For GLPI, the logs are in glpi_installation_folder/files/_log/, there you should find PHP logs of GLPI, and SQL logs. For PM, it depends on how you have installed your PHP. to check, you must go to the following page in PM server and search for error_log in the php_info() 'local value' column like shown below:

Thank you, Regards, Tomolimo

[tomolimo]

Hello @sosfc

I have tried new plugin

Did you also install the new PM server version 3.0.1.8-RE-1.8? Tomolimo

[sosfc]

Hi Tomolimo, My PM version is 3.0.1.8-commutity My errror_log variable is empty (I did a standard installation with debian distro) Attached is the php-error from my glpi server Fernand Thanks php-errors.log

[tomolimo]

Hello @sosfc , As in your logs it says:

2018-01-29 08:21:04 [2@srvweb2] *** PHP Notice(8): Undefined property: stdClass::$status Backtrace : ...ns/processmaker/inc/processmaker.class.php:1116 : PluginProcessmakerProcessmaker::cronPMUsers() inc/crontask.class.php:832 call_user_func() front/crontask.form.php:50 CronTask::launch()

I fear that you are not using the right release of the PM server. You must use the one I provide: 3.0.1.8-community-RE-1.8 and no other versions! See: https://github.com/tomolimo/processmaker/wiki/Introduction

Could you check here:

Thank you, Regards, Tomolimo

[tomolimo]

Dear @sosfc ,

And regarding the error_log which is empty, I advise you to set in the PHP config this PHP setting to point to an existing folder where it must have the right to write. I advise you to use the one of GLPI (glpi_folder/files/_log/php-errors.log), so that in one log file you'll get error for GLPI and PM.

regards, Tomolimo

[sosfc]

Hi tomolimo, I reinstalled pm server with the right version (sorry for this mistake) (php intl activated, php 5.6) I tried plugin 3.2.1 and 3.2.5 with same result GLPI 9.1.6 I Have no error on the GLPI side, but some errors on the pm side Below is the content of my php error_log.log <?php /**

• $Header: /repository/pear/Log/Log/error_log.php,v 1.8 2006/06/29 07:09:21 jon Exp $
• @version $Revision: 1.8 $
• @package Log */

/**

• The Log_error_log class is a concrete implementation of the Log abstract
• class that logs messages using PHP's error_log() function.
• @author Jon Parise jon@php.net
• @since Log 1.7.0
• @package Log

• @example error_log.php Using the error_log handler. */ class Log_error_log extends Log { /**

  • The error_log() log type.
  • @var integer
  • @access private */ var $_type = PEAR_LOG_TYPE_SYSTEM;

  /**

  • The type-specific destination value.
  • @var string
  • @access private */ var $_destination = '';

  /**

  • Additional headers to pass to the mail() function when the
  • PEAR_LOG_TYPE_MAIL type is used.
  • @var string
  • @access private */ var $_extra_headers = '';

  /**

  • Constructs a new Log_error_log object.
  • @param string $name Ignored.
  • @param string $ident The identity string.
  • @param array $conf The configuration array.
  • @param int $level Log messages up to and including this level.

  • @access public */ function Log_error_log($name, $ident = '', $conf = array(), $level = PEAR_LOG_DEBUG) { if(!class_exists('G')){ $realdocuroot = str_replace( '\', '/', $_SERVER['DOCUMENT_ROOT'] ); $docuroot = explode( '/', $realdocuroot ); array_pop( $docuroot ); $pathhome = implode( '/', $docuroot ) . '/'; array_pop( $docuroot ); $pathTrunk = implode( '/', $docuroot ) . '/'; require_once($pathTrunk.'gulliver/system/class.g.php'); } $this->_id = G::encryptOld(microtime()); $this->_type = $name; $this->_ident = $ident; $this->_mask = Log::UPTO($level);

    if (!empty($conf['destination'])) { $this->_destination = $conf['destination']; } if (!empty($conf['extra_headers'])) { $this->_extra_headers = $conf['extra_headers']; } }

  /**

  • Opens the handler.
  • @access public
  • @since Log 1.9.6 */ function open() { $this->_opened = true; return true; }

  /**

  • Closes the handler.
  • @access public
  • @since Log 1.9.6 */ function close() { $this->_opened = false; return true; }

  /**

  • Logs $message using PHP's error_log() function. The message is also
  • passed along to any Log_observer instances that are observing this Log.
  • @param mixed $message String or object containing the message to log.
  • @param string $priority The priority of the message. Valid
  • values are: PEAR_LOG_EMERG, PEAR_LOG_ALERT,
  • PEAR_LOG_CRIT, PEAR_LOG_ERR, PEAR_LOG_WARNING,
  • PEAR_LOG_NOTICE, PEAR_LOG_INFO, and PEAR_LOG_DEBUG.
  • @return boolean True on success or false on failure.

  • @access public / function log($message, $priority = null) { / If a priority hasn't been specified, use the default value. */ if ($priority === null) { $priority = $this->_priority; }

    / Abort early if the priority is above the maximum logging level. / if (!$this->_isMasked($priority)) { return false; }

    / Extract the string representation of the message. / $message = $this->_extractMessage($message);

    $success = error_log($this->_ident . ': ' . $message, $this->_type, $this->_destination, $this->_extra_headers);

    $this->_announce(array('priority' => $priority, 'message' => $message));

    return $success; }

}

Hope this helps

[tomolimo]

Hello @sosfc, The so-called log error content is in fact the content of a PHP file: _pm_server_folder/gulliver/thirdparty/pear/Log/errorlog.php and not the content of a log file.

Could you check where the PM server log file is? To locate it you must look at the PHP running variables like shown here: https://github.com/tomolimo/processmaker/issues/38#issuecomment-361161953

And as you said that it is empty, then could you add in your PHP.ini file the location of the GLPI error log file? So that you'll get all error messages into the same log file. Then you should be able to clear the log files, and redo a test in order to get errors (if any) related to the test.

Thank you, Regards, Tomolimo

[tomolimo]

Hello @manoel-cristiano and @sosfc , Could you tell me the default language you have defined in GLPI and in PM server? I think this is root cause of the issue when those languages are different. Thank you, Regards, Tomolimo

[tomolimo]

Hello,

Could you copy/paste the following screencopy?

I need to know which languages are installed in PM server.

Thank you, Regards, Tomolimo

[sosfc]

Hello Tomolimo My default language is French pm_language.pdf

[sosfc]

Here is the GLPI plugin configuration screen pm_glpi.pdf

[tomolimo]

Hello The trouble is coming from the fact that you have installed "fr-FR", and not "fr", see https://github.com/tomolimo/processmaker-server/wiki/Languages

Thank you Regards, Tomolimo

[sosfc]

Hello Tomolimo Thanks for the fast reply ! The problem is that for version 3.0 there is no fr file (just fr-FR) and when I download the fr file of the "po files" repository, it says "invalid po file format" Thanks for your help Regards Fernand

[tomolimo]

Hello, You have to change it as explained here https://github.com/tomolimo/processmaker-server/wiki/Languages#localization-internationalization-languages :

1. rename of the file
2. edit of the content header

regards, Tomolimo

[sosfc]

You got it ! It works fine Thanks ! Fernand

[manoel-cristiano]

Hello, @tomolimo I gonna chanche my language configuration in GLPI, because I'm using pt-BR. But in process maker I'm using (en international).

[tomolimo]

Hello @manoel-cristiano Could you post here the screen shot of the installed languages in PM server? Like this: Thank you, Regards, Tomolimo

[tomolimo]

Hello As there has been no answer since last post, close this issue. Feel free to re-open it if you've get news. Thank you, Regards, Tomolimo

[iamaer4fa]

Hi, can we revive this thread?

Have the same error, no synchronization of PM tasks in GLPI so I cannot map the GLPI ticket with my PM processes. Here is the log error of php-errors log:

Processmaker Plugin: - User not existing in glpi_plugin_processmaker_users table. 2019-05-04 15:54:07 [7@smpc.steniel.com.ph] From PluginProcessmakerProcessmaker::login() in /var/www/glpi/plugins/processmaker/inc/processmaker.class.php line 276 Processmaker Plugin: - User not existing in glpi_plugin_processmaker_users table. 2019-05-04 15:54:07 [7@smpc.steniel.com.ph] From PluginProcessmakerProcessmaker::login() in /var/www/glpi/plugins/processmaker/inc/processmaker.class.php line 276 Processmaker Plugin: - User not existing in glpi_plugin_processmaker_users table.

I followed exactly, the tutorial and got success at the Setup -> General -> Processmaker config:

[rohit-ambre-uno]

hi @allanregistos , have you ran "pmusers" cron job from automatic actions?

from the errors it seems like you have not synced users from glpi to processmaker.

[iamaer4fa]

Hi rohit-ambre-uno, I did not for I do not know that I needed to do that. For the synchronization of users, did you mean, matching username and password for both glpi and processmaker or do I have to get a glpi function?

Thanks for responding.. Allan

[tomolimo]

Hello @allanregistos, As this issue is closed, could you open a new issue and link it to this one (using a sharp + issue id, like: #38) if you see that the behavior is the identical? Thank you Regards, Tomolimo